Querying Linked ODBC tables.

[FBxiii]

Hi,

I need the code that will enable me to run numerous Queries against linked
ODBC tables (Oracle 7.3) without having to enter a password each time.

I understand I need a connect string, but I cant figure out where it should
go.

My code looks like this:

strSQL = "SELECT * INTO RESULTS FROM ODBC_TABLE WHERE REFERENCE=1234;"

db.Execute strsql

Can somebody please let me know how to do this in simple steps.

Many Thanks,
Steve.