Re: ODBC/connection string question

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.

That's actually a conscious design decision-- it was thought that storing passwords as plain text on a machine was a general no-no. If you really want to do so, you can add a key 'PWD' to your registry (HKey_Local_Machine/Software/ODBC/<DSN>) and we'll honor it.

Note that you'll want to download the latest version of the driver (8.1.5.6) from OTN <http://otn.oracle.com> to make sure this works.

>
> 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 Sat Dec 16 2000 - 22:34:21 CST