Unanswered: ODBC-error when trying to connect to Oracle in vbscript
I am slowly going mad...
Here is the situation:
I am quite new to Oracle (say 5 months of professional experience)
I have made a vbscript to automate the daily exports on the Windows servers.
Out of our 10 Windows servers, the script works flawlessly on 7 of them.
But on 3 of the Windows servers, I get the following ODBC-error when running the script in a DOS-prompt:
E:\Oracle\admin\vbs\expfull.vbs(130, 1) Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
I use the Oracle ODBC-driver "Oracle in Orahome 9.02.00.54"
Also, when I try to test a connection to the database In Windows itself with the "test connection" button in the ODBC-screen, I get an similar error as displayed in the attached file. (see file)
As the script works fine on most servers, I am pretty certain that this is not a vbscript problem, nor a database problem.
But what could it be then?
I've already lost hours and hours in trying to find what it is, so any help would be greatly appreciated.