Re: Oracle 8i and ODBC connection problem

Niall, thanks for reply! I'm a bit confused. The server that has the Oracle DB has ASP's working perfectly. The ASP on that server shows the connection string of:

set my_conn=Server.CreateObject("ADODB.Connection") my_conn.Open "psystem", "username", "password"

Thus, on second server, I set up psystem for the ODBC and setup the tnsnames.ora the same way. Now, I copied and pasted the same ASP from working server to second server. I did not change a thing to that ASP, but I receive the forementioned error that a DNS was not found. So, I believe that I set up the DSN properly, but I'm probably missing something very simple. Thanks for your help.

On Mon, 26 Feb 2001 13:18:58 -0000, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>The error message posted is an ODBC error message. It suggests that here is
>no DSN set up on the second machine which connects to the oracle database.
>line14 of detail.asp should contain an ODBC connection string with a Data
>source name in there. If you can read this file, find out what the data
>source should be called and then setup an ODBC system datasource with
>exactly that name.
Received on Mon Feb 26 2001 - 11:56:04 CST