Oracle driver 64 bit issue

Hi,

We have a VBS file which pulls the data from the Oracle database and loads into our local SQL Server database, and we were using the provider as OraOLEDB.Oracle and it was working fine until we moved to Windows 2003 server in 64 bit mode and aslo we have downloaded the 64bit ODBC provider for Oracle from their site but when we run the query and try to insert into our databse by looping we get only the first record eventhough the result of the select statment has more than record. I am sure is something to do with the 64 bit provider.
Please help to overcome this issue.
razik2781Asked:
Who is Participating?
 
konektorCommented:
i don't know much about odbc, vbs ... but standard oracle distribution includes both 32 and 64 bil libraries. 64 bit version ones are in $ORACLE_HOME/lib, 32 bit version ones in $ORACLE_HOME/lib32 in 10g.
64 bit version libraries are in $ORACLE_HOME/lib64 and 32 bit version ones are in $ORACLE_HOME/liv in 8i and older.
10g express edition is only 32 bit version, so $ORACLE_HOME/lib stores only 32 bit version libraries, there are no 64 bit version ones.
0
 
crawforditsCommented:
Install a x86 oracle client on the 64bit box and use that provider.. we had an issue with DTS packages using DSN's after upgrading to 64bit and the way we resolved it was by installing an x86 client on our x64 box just for that purpose just make sure after you install your client to change ure ORACLE_HOME var
0
 
razik2781Author Commented:
How to change the ORACLE_HOME var
0
 
razik2781Author Commented:
But on the same box we have our web application running which is using the 64 bit Oracle provider.. Will that be a problem then.. and also can both 32 bit Oracle Provider and 64 bit Oracle provider exist on the same machine
0
 
crawforditsCommented:
There is no issue of having an x86 home aswell as a x64 home on the same box.  After you install your x86 home the providers can be accessed from your x86 ODBC admin from "C:\WINDOWS\SysWOW64\odbcad32.exe"  After you install your new x86 home you have to to change your PATH var my computer->properties->advanced->environment variables->double click on PATH and move the x86 home to end if you dont then any programs that dont use the full path to an oracle .exe will use the x86 version.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.