Passing password data for chain of ODBC databases

[acidkewpie]

Hi, i'm connecting to an Access ODBC datasource to use some queries in it, but this database itself uses a much larger Oracle installation down the line. Accessing these queries in a normal application will prompt for the password for the oracle server automatically, however as it is just a webpage, it just fails the connection instantly. how can i get this password to be passed down from the asp page to the end database?

Cheers

Chris

 

[GWINTO]

Try this

conn.Open "DSN='odbc name';UID='username';PWD='password';"

Alternativley, on the configuration for the odbc connection their is an advanced button which allows you to specify a user name and password.

The more you know, the more you realise there is to know....
CCNA MCP

 

[acidkewpie]

opening a direct connection doesn't appear to follow on with the indirect connection coming through the database. And entering a password into the DSN ODBC connection for windows does not remember anything.

thanks

chris