Moving a script from Server 2008 to Server 2012.

[Rowlen Wilson]

I have a script that runs on Windows Server 2008 that will not work on Windows 2012. It is connecting to an Oracle database that can connect on both servers. The line that fails is the connection string below.


Const sConnectionString = "DRIVER={Microsoft ODBC for Oracle};SERVER=xxxxxx;User Id=xxxxxx;Password=xxxxxx;"


I am trying to run it from C:\windows\syswow64 because the Oracle client is a 32-bit client. But it fails with connection string errors.

Continue reading...