ODBC connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

deodev - 11 May 2005 17:26 GMT

Hello,

I have linked several tables to a database called sondb on the SQL server
called orlapp. I have used a DSN called MYAPP with userid and password of
"monthly"

Once I open the database and run my query I have to sgn on using the user id
and password.

I would like to use code to connect to the server without having to sign on
manually.

Can someone please let me know what the code should be.

Signature

deodev

Reply to this Message

Dave Patrick - 11 May 2005 18:06 GMT

Delete and recreate the links but this time check the box for 'Save
password'

Signature

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

| Hello,
|
[quoted text clipped - 9 lines]
|
| Can someone please let me know what the code should be.

Reply to this Message

deodev - 11 May 2005 18:58 GMT

Thanks. Would this work if someone else access the database from their PC?
If not, can it be coded to create the DSN and the appropriate sign on?

> Delete and recreate the links but this time check the box for 'Save
> password'
[quoted text clipped - 14 lines]
> |
> | Can someone please let me know what the code should be.

Reply to this Message

Dave Patrick - 11 May 2005 19:10 GMT

Yes because the connection string (including the username and password) is
stored in the 'Connect' column of the hidden access table 'MSysObjects'

The DSN you created to make the links is no longer needed.

Signature

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

| Thanks. Would this work if someone else access the database from their PC?
| If not, can it be coded to create the DSN and the appropriate sign on?

Reply to this Message