Re: ODBC/connection string question

What are you using to start your ODBC Session? I'd suggest passing the password when you connect to ODBC.

I always allocate my ODBC connection dynamically with a dynamic connect string (no DSN definition required):

mydsn="ODBC;DRIVER=Oracle ODBC
Driver;SERVER=mySID;uid=sys;pwd=change_on_install"

You can also use the DSN that you have set up here, something like: "DSN=mySystemDSN;uid=sys;pwd=change_on_install"

I am not exactly sure of the second syntax (you may not be able to specify the user name as different from what you put in the DSN definition).

Hope this helps.

Rob

Mark Harris <mark.harris_at_ukonline.co.uk> wrote in message news:IN3_5.27414$bp4.697092_at_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 - 12:12:31 CST