Re: need help setting up connect string

This is a lot easier if you install the Oracle 8i client on whichever machine you're using to connect with. Once that's installed, run the Net8 Easy Configurator (it actually runs as part of the client install). That will set up the TNSNAMES.ORA file for you. To check if your Net8 settings are correct, go to a DOS prompt and type in "tnsping <sidname>" without the quotes, where <sidname> is the service ID name you gave your database when you installed it.

If tnsping doesn't work, don't bother trying to get ODBC to work, because it won't. If it does work, then you can set up your ODBC data source the way you normally would. You should not have to actually specify a connect string. It should only prompt you for the service name, which is the sidname you used in the step above.

But at any rate, a connect string usually looks like: "hostname:port:sidname" without the quotes. The default port is 1521.

Paul

Viswanatha Thalakola <rthalakola_at_worldnet.att.net> wrote in message news:7rhtpv$dao$1_at_bgtnsc01.worldnet.att.net...
> Hello,
>
> I installed Oracle 8i Enterprise version that I got through oracle
technet
> on my Windows NT machine. I want to connect to it through odbc. What is
the
> connect string that I need to use.
> The database is local.
>
> Please help me in setting up a service name and connecting to the local
> database.
>
> Thanks in advance.
>
> Reddy
>
>
>
Received on Mon Sep 13 1999 - 18:56:14 CDT