Re: Connecting to remote Oracle via DSN(ODBC)

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 11 Oct 2001 22:10:28 +0200
Message-ID: <72vbstslejmlormhhp97ube4vfq4dkb6k9@4ax.com>

On 11 Oct 2001 12:30:05 -0700, slow_at_slycat.net (slycat) wrote:

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

You need the sqlnet/net8 service name.
The service name shouldn't differ on server and clients or you should be prepared for an administration nightmare. So I'm not sure where your problem is, unless you have a peculiar -and most likely incorrect- server setup.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Thu Oct 11 2001 - 15:10:28 CDT