Connection to Oracle Database ...

[jcrchristy]

I want to connect to a remote Oracle Database.
I created the odbc DSN and used Oracle odbc driver.
The code is like this...

Set ws = DBEngine.Workspaces(0)
Set daodatabase = ws.OpenDatabase("", False, False, "ODBC;DSN=odbc_dsn;uid=ora95;pwd=oraadmin;")
Set daorecordset = daodatabase.OpenRecordset("select * from user_table")

I am getting this error "The Microsoft Jet database engine cannot find the input table or query ora95.user_table. Make sure it exists and that its name is spelled correctly. (Error 3078)"

This table is in the database...
what could be wrong? Please help...

 

[CasperTFG]

You need a listenenr set up on oracle to allow for a connection. From the command line, you should be able to enter the command.

TNSPING <DBName>.<ServerName>.World

If this returns back that it does not know what TNSPING is, then you ahve to install the oracle client software. If it returns no listener found then your Oracle DB is not set up to allow connections.

Casper

There is room for all of gods creatures, "Right Beside the Mashed Potatoes".