Problem was solved!
I tried the same ASP code in a new IIS 7.0 server and it worked.
There may be a difference between IIS 6.0 and IIS 7.0. Thanks!!!...
nsung
Last Activity: Mar 14 '08, 03:02 PM
Joined: Feb 28 '08
Location:
-
Yes. I can. I can even connect and link the remote Oracle db tables from within MS-Access. But not from ASP :(...Leave a comment:
-
Thank you Mark!
I am able to link tables from within MS-Access at the same machine where the ASPs are, which indicates DSN and the Driver had been installed correctly.
I already posted the same message to the ORACLE forum. Thank you!Leave a comment:
-
Oracle 10g and ASP under Encryption mode
Recently we upgraded to Oracle 10g and added encryption on the server.
I used to access the database tables via Active Server Pages with the following connection string: MyConnection.op en "DSN=eisreport; Uid=eiu_sung;Pw d=xxxxx"
After upgrading to 10g it stop working with the following error message.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for... -
ASP Connection String for Oracle 10g
Recently we upgraded to Oracle 10g and added encryption on the server.
I used to access the database tables via Active Server Pages with the following connection string: MyConnection.op en "DSN=eisreport; Uid=eiu_sung;Pw d=xxxxx"
After upgrading to 10g it stop working with the following error message.
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC driver for...
No activity results to display
Leave a comment: