Tuesday, March 20, 2012

ConnectionString

Hi
I'm using Sql Server (SQLOLEDB.1) and I want to connect it by Sqlconnection.
those are the details:
user Id: sa
Password: *****
database: ServiceManagement
server name: KLXPE002\KULMOS
What should be the Connection String?
Thats what i did:

"Persist Security Info=True;Integrated Security=SSPI;server=SQLOLEDB.1;database=ServiceManagement;Data Source=KLXPE002\KULMOS;User ID=sa;password=****"
It doesn't work.
thnx
Itai

Hi,
Your connection string should look like
"Data Source=KLXPE002\KULMOS;Initial Catalog=ServiceManagement;User Id=sa;Password=asdasd;"

Regards,
Venkatarajan A|||You can visit this site:www.connectionStrings.com|||thank you Venkatarajan its working

No comments:

Post a Comment