ODBC/connection string question

From: Mark Harris <mark.harris_at_ukonline.co.uk>
Date: Thu, 14 Dec 2000 13:18:37 -0000
Message-ID: <IN3_5.27414$bp4.697092@monolith.news.easynet.net>

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 Received on Thu Dec 14 2000 - 07:18:37 CST