Re: ODBC/connection string question

It's probably issue with SQL Net, check your tnsnames.ora file and probably want to ping your server and make sure it works.

If it doesn't work, try to use JDBC connection instead. There is a free tool JSync. www.idera.com

In article <IN3_5.27414$bp4.697092_at_monolith.news.easynet.net>,   "Mark Harris" <mark.harris_at_ukonline.co.uk> wrote:
> Hello,
>
> I'm trying to connect to an Oracle database using ODBC.
>
> I'm using the Oracle 8 ODBC driver (version 8.1.5.0.0), but
> whilst it allows me to specify a username in the ODBC
> administrator, there's nowhere for me to specify the
> password which goes with this name.
>
> I've tried username/password and username/password_at_instance,
> but neither of these work. I've also tried to specify the username
> & password in the definition of the connection upon the ASP
> page which will access the database, but that doesn't work either.
>
> The database isn't on the webserver, but on a different one. I'm
> using the tnsnames.ora with IP addresses to get to the database.
>
> Any suggestions as to what I'm doing wrong? Any help'd be
> gratefully appreciated...
>
> Thanks
>
> Mark
>
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 14 2000 - 10:12:24 CST