C
Colin Steadman
I've just had a problem with an ASP page not connecting to
one of our Oracle databases. It turns out that the web
server has Oracle 8.1 and Oracle 9.2 installed and that my
ASP page was trying to connect with Oracle 8.2. The
TNSNAMES.ORA file for this version of Oracle is not
maintained and did not have the correct entry I need.
Is it possible to force my ASP pages to use Oracle 9.2
until the migration is complete and Oracle 8.1 is removed?
My connection string looks like this:
Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data
Source=ht;User Id=" + Request.form("username")
+ ";Password=" + Request.form("password")
TIA,
Colin
one of our Oracle databases. It turns out that the web
server has Oracle 8.1 and Oracle 9.2 installed and that my
ASP page was trying to connect with Oracle 8.2. The
TNSNAMES.ORA file for this version of Oracle is not
maintained and did not have the correct entry I need.
Is it possible to force my ASP pages to use Oracle 9.2
until the migration is complete and Oracle 8.1 is removed?
My connection string looks like this:
Session("PROVIDER") = "Provider=OraOLEDB.Oracle;Data
Source=ht;User Id=" + Request.form("username")
+ ";Password=" + Request.form("password")
TIA,
Colin