F
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.
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.