I need a connection string to connect to SQLServer DB.
It uses Windows Authentication to authenticate the user. Name of the server is SQLTEst
Name of DB is BIOM
and the login is windows authentication
I tried this con.open "provider=sqloledb.1;server=sqltest; uid=Myserid; password=password; database=BIOM"
Its giving me an error "Login failed for user"
Please provide me witha solution for this
Have a look at the following
If you do a search on this forum I think you will find the answer
Have you got the relevent SQL drivers installed to connect to the SQL server and check the version of SQL server.
Winds of Change
Visit www.connectionstrings.com for any kind of connection string.