Re: HELP: ODBC & SQL NET

From: Georg Kowatsch <georgi_at_m.xpoint.at>
Date: 1999/02/10
Message-ID: <36c1dbee.0_at_info.xpoint.at>#1/1


"T. Jones" <jonestl_at_netscape.net> schreibt: > I have just set up my SQL*NET client. Using the utilites, I can 'tnsping'
> my
> UNIX based Oracle 7 server with no problem. So, I'm assuming the
> PC (NT) client is communicating with the Oracle 7 server.
>
> The problem is the ODBC drivers (Microsoft). I was told to use MS's drivers
> because they actually work better than Oracles. When I go to add a system
> DSN for an Oracle DSN, I put the following:
>
> Name: ACSPUB (what I want the DSN to be)
> Description:
> User name: myusername
> Server: WHAT_DO_I_PUT_HERE?
>
> Do I put the name of the Unix Oracle server in server? Do I put the Oracle
> alias
> I created in SQL*NET? Or do I put 'tns:my_alias'? I tried all there, but
> connecting
> give the the error:
>
> TNS:..cannot resolve hostname...
>
> Any suggestions?
>
> Tony Jones
>
>

HI,
try in the services file to add sqlexec 1521/tcp Received on Wed Feb 10 1999 - 00:00:00 CET

Original text of this message