Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connecting to remote Oracle via DSN(ODBC)
Well, I reckon that installing the Oracle client, setting up TNSNAMES.ORA
(use Net8 EasyConfig, I'm just assuming oracle version here...) and using
the connection string set up there as the server name in the DSN would
help...
Radu
"slycat" <slow_at_slycat.net> wrote in message
news:63053de4.0110111130.1d3fe4ec_at_posting.google.com...
> I had a question, and I was wondering if someone might know the
> answer. I need to set up a System DSN on a Windows machine that will
> reference an Oracle database. I was able to set it up with Oracle
> running on the same machine that I set the DSN on. My question is,
> with Oracle running on a remote machine, do you know the syntax for
> the server name? Since it will no longer be local? The DSN type is
> MS ODBC for Oracle. This is driving me nuts!
Received on Thu Oct 11 2001 - 23:02:58 CDT