Link to Oracle using DSN-less connection

[Guest]

I currently have an Access 2K application that links to Oracle 9i tables,
but requires a DSN connection. I cannot seem to get the syntax correct to
get the Transferdatabase method to perform this link with a dsn-less
connection. Anybody got an example of the right syntax for this?

Thanks!

 

[Douglas J. Steele]

See whether the sample strings Carl Prothman has at
http://www.able-consulting.com/ado_conn.htm help

 

[Guest]

The ado_conn.htm link is broken. Seems to have moved here:
http://www.carlprothman.net/Default.aspx?tabid=81

 

[Douglas J. Steele]

You're right: Carl's moved his site. However, that link was valid in
February, when I posted the reply!