Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Connecting to remote Oracle via DSN(ODBC)

Re: Connecting to remote Oracle via DSN(ODBC)

From: Radu Lascae <r.nospam.lascae_at_wanadoo.nl>
Date: Fri, 12 Oct 2001 04:02:58 GMT
Message-ID: <SXtx7.10$uw6.40@pollux.casema.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US