ODBC Links

M8KWR

Registered User.
Local time
Today, 08:09
Joined
Sep 30, 2004
Messages
146
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: -
Code:
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.
 
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...
 
hmm...

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

Andrew
 
Hum... This is an option when using the ODBC Admin app...
 
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
 

Users who are viewing this thread

Back
Top Bottom