G
Guest
I currently have an .mdb that links to a SQL Server database. That database
is being moved to Oracle and I would like to keep the DSN-less connection to
the Oracle Db.
I have found the connection string from
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracleFromOracle that sounds like it should work:
Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword
I am using the Oracle ODBC Driver and am able to successfully create a DSN &
test the connection (so the tnsnames.ora appears to be correct).
Unfortunately when I run my code to set the tabledef.connect property using
the above syntax, I receive an ODBC--call failed error.
Any ideas on what might cause this?
Thank you in advance for any help!
I have tried different
is being moved to Oracle and I would like to keep the DSN-less connection to
the Oracle Db.
I have found the connection string from
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracleFromOracle that sounds like it should work:
Driver={Oracle ODBC Driver};Dbq=myDBName;Uid=myUsername;Pwd=myPassword
I am using the Oracle ODBC Driver and am able to successfully create a DSN &
test the connection (so the tnsnames.ora appears to be correct).
Unfortunately when I run my code to set the tabledef.connect property using
the above syntax, I receive an ODBC--call failed error.
Any ideas on what might cause this?
Thank you in advance for any help!
I have tried different