TransferDatabase, Database Name ODBC connection string format

B

bmalak_98

I have a table in Access that I want to regularly export to an Oracle
database.

I have tried to create a macro for this using the TransferDatabase action.

However, I cannot seem to get the ODBC connection string in the correct
format.

I have tried a DSN file for the Oracle source using MS ODBC and Oracle native.

ODBC;DRIVER={Microsoft ODBC for
Oracle};UID=john;PWD=hook123;SERVER=bidev.server_name.com;

Frustrated beyond belief...I can do it manually with the menu system, which
works...but I will be doing this for multiple tables and want the automation.

Thanks for any ideas!!!

Brent
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Programmatically set UID & PWD in existing ODBC DSN connection string. 1
DSN Less Links & Transfer Database 0
transferdatabase 2
Oracle Connection 3
DAO & ADO within the Same Application? 1
DSN-Less connections with MS Oracle Driver 4
ODBC Connection 0

Top