Connecting to Oracle Database - macro fail.

[jamiee]

Hi All

I have a macro on an MS Access database that uses the TransferDatabase
command. The macro connects to an oracle database and worked when I
copied the connection string from a linked table to the oracle db.
However, once the linked table is removed the macro no longer works. I
get an error message saying that the ODBC driver can't connect.

Obviously removing the linked table to the oracle database is having
an effect on the TransferDatabse macro, so does anyone know I can
alter this so I do not need to have a linked table to use the macro. I
suspect I need to alter the connection string in sameway. At the
moment it reads as

ODBC;DRIVER={Microsoft ODBC for Oracle};SERVER=***;;TABLE=***

What fields do I need to add to the connection string, and where do I
need to place them?

Also, is there anyway to read the properties of a macro in VBA format?

Many thanks in advance.

J

 

[gandalf]

probably your userid & password

I use an oracle connection-string like this

"ODBC;DRIVER={Microsoft ODBC for
Oracle};UID=Myuser;PWD=Mypassword;SERVER=Myserver.WORLD;"

 

[jamiee]

I still get the same message. Could it have anything to do with the
Trusted Resoureces Parameter? What does this do exactly? and where
does it go in connection string?