Oracle driver 64 bit issue
Posted on 2007-10-16
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.