Link to Oracle using DSN-less connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dale Fye - 17 Feb 2005 16:11 GMT

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!

Reply to this Message

Douglas J. Steele - 17 Feb 2005 22:53 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> 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!

Reply to this Message

blueinc - 29 Apr 2005 15:50 GMT

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

> See whether the sample strings Carl Prothman has at
> http://www.able-consulting.com/ado_conn.htm help
[quoted text clipped - 5 lines]
> >
> > Thanks!

Reply to this Message

Douglas J. Steele - 29 Apr 2005 23:18 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> The ado_conn.htm link is broken. Seems to have moved here:
> http://www.carlprothman.net/Default.aspx?tabid=81
[quoted text clipped - 10 lines]
>> >
>> > Thanks!

Reply to this Message