ADO connect not using UID in connect string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following connect string for an ado open:
Driver={Microsoft Access Driver (*.mdb)};Dbq=my.mdb;Uid=robert;Pwd=xyz;
When I try to execute the open it says there are no read permissions. I
have given read permissions to everthing except user Admin. User admin has
no permissions. How can I get the ADO to use the user in the connect string?
 
Try this connection string. It eliminates the need for UID and PWD in the
string:

Conn="Provider=sqloledb;Data Source=YourServer;Initial
catalog=YourDBName;Integrated Security=SSPI;"

HTH,
Sam
 
Back
Top