ODBC Connect String

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

FBxiii - 17 Mar 2005 17:59 GMT

Hi,

I have a DB with several ODBC linked tables.

Using Code, I am 'Executing' queries using these tables but require a
password each time.

How do I build up a connect string to use in my SQL to save me having to
re-type the password?

e.g.

strSQL = "SELECT * INTO TEMP_TABLE FROM tblODBC"

db.Execute strSQL

Many thanks,
Steve.

Reply to this Message

sparker - 17 Mar 2005 20:23 GMT

You can set the connections in your code and pass the user name and password

If you do not know how to write connection strings in code read the following:

http://support.microsoft.com/kb/q193332/

> Hi,
>
[quoted text clipped - 14 lines]
> Many thanks,
> Steve.

Reply to this Message