DSNless Connection String 1

[lbunch]

I am using a standard connection like this for DSNless connection is SQL Server. I am still always prompted for Username and password. When I look at the table and connection string - it does reference ODBC; driver....etc. I believe if I took ODBC off of the string I received a diferent type of error.

Right now I am getting a 2800 error - I believe...

oConn.Open "Driver={SQL Server};" & _
"Server=MyServerName;" & _
"Database=myDatabaseName;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

 

[PHV]

Havea look here:

http://www.connectionstrings.com/

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[lbunch]

My connection string is OK - I and I have check everything
I do not understand why I am being prompted for Trusted and needing me to input username and password when it is in my string...