Connecting from Windows 2003 Server 64bit to remote Oracle DB
656299Aug 22 2008 — edited Sep 9 2008Hi,
I have been trying without (complete) success to connect to a remote Oracle server. This is the back ground:
-2003 Windows server 64bit
-Classic ASP pages that connect and work fine in a 32 bit environment
-Installed the 64 bit Oracle client: win64_11gR1_client
-I can set up and test an ODBC connection to Oracle through the ODBC Administrator successfully
-I can TNSping the database successfully
The problem comes in when I run ASP pages through IIS6 that connect to the Oracle DB ONLY ONE RECORD gets returned??
The only connection string that connects (and only return the one record) is:
"Provider=OraOLEDB.Oracle;Data Source=SOURCE.WORLD;User Id=username;Password=password;"
I have tried a myriad of variations on this connection string but with any luck. Errors include:
When trying to use the DSN ("DSN=webOracle;Provider={Oracle in OraClient11g_home1};UID=username;Password=password"
-Provider cannot be found. It may not be properly installed.
Trying the driver (ORAoConn.Open "Driver={Oracle in OraClient11g_home1};Data source=SOURCE.WORLD;User id=username;Password=password"
-Times out.
Please, any advice or different methods will be appreciated. Step by step on apps installed and settings made. I want this to run in 64bit as running 32 on 64 bit seems to defeat the point.