Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Oracle driver 64 bit issue

Posted on 2007-10-16
7
Medium Priority
?
1,378 Views
Last Modified: 2013-12-19
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.
0
Comment
Question by:razik2781
  • 2
  • 2
5 Comments
 
LVL 9

Expert Comment

by:crawfordits
ID: 20090556
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
 

Author Comment

by:razik2781
ID: 20090740
How to change the ORACLE_HOME var
0
 

Author Comment

by:razik2781
ID: 20090750
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
 
LVL 9

Accepted Solution

by:
konektor earned 1000 total points
ID: 20092019
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
 
LVL 9

Assisted Solution

by:crawfordits
crawfordits earned 1000 total points
ID: 20092456
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

Featured Post

 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question