ODBC Links

[M8KWR]

I have a way of changing what database i am looking at within a SQL server.

The issue that i am having is that everytime i load up the access file it keep on asking me for a username / password.

Is there anyway of stopping it doing this.

When i have done the original link, i asked it to save the password, which is does for this one, but not for anything else.

I hope this makes sense.

The code i am using to change the database that i am looking at is the following: -

ODBC;DRIVER=SQL Server;SERVER=DATASERVER;APP=Microsoft Open Database Connectivity;WSID=SERVER;DATABASE=" & DBNAME & ";Network=DBMSSOCN;Address=SERVER,1433;Trusted_Connection=Yes"

DBNAME is the name of the database that the user wishes to connect to.

thanks for help inadvance.

 

[KenHigg]

The way I do this is to connect to the db and do a 'save' password. Then open the sysObjects table where you can copy the entire connection string. It should have the user name / password stuff in it...

 

[mtairhead]

hmm...

How? I haven't found a "save password" feature. The only checkbox on the login screen is "Use Trusted Connection"

Andrew

 

[KenHigg]

Hum... This is an option when using the ODBC Admin app...

 

[WayneRyan]

M8,

If you're using "Trusted_Connection=Yes", then the Windows username must
be a valid user of the intended SQL Server database. Otherwise, use
Uid & Pwd.

Wayne