The last problem I know of is in the Oracle client itself, it seems that a connection will never work with the instant client, so always use the full client. Because of this, connecting to Oracle from BIDS on a 64 bit machine will never work when you install the 64 bit Oracle client.Īnother problem is the “Microsoft Provider for Oracle”, this driver only exists in a 32 bit version and Microsoft has no plans to create a 64 bit one in the near future. Provider is unable to function until these components are installed.Īfter a lot of searching, trying and debugging I think I found the right way to do it! Problemsīecause BIDS is a 32 bit application, as well on 32 as on 64 bit machines, it cannot see the 64 bit driver for Oracle. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Oracle client and networking components were not found. Test connection failed because of an error in initializing provider. A lot of developers will recognize the following error message: I found all kind of blog and forum posts of developers complaining about this. A quick search on the internet showed that this could be a big problem. You should now see OraOLEDB.We recently had a few customers where a connection to Oracle on a 64 bit machine was necessary.Create or copy a new tnsnames.ora in C:\Oracle\product\11.2.0\client_ 64\network\admin.Create or copy a new tnsnames.ora in C:\Oracle\product\11.2.0\client_ 32\network\admin.Make same registry changes to HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\MSDTC\MTxOCI.
Make registry changes to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSDTC\MTxOCI.Now that the install is done, just need to tweak a few things. Ignore the error "OracleMTSRecoveryService already exists".I got a memory error at this point, but chose to ignore it since I know there is enough.HOWEVER, change the "Software Location" to C:\Oracle\product\11.2.0\client_ 64 Repeat above steps with the 64-bit installer.Oracle Administration Assistant for Windows.Oracle Services for Microsoft Transaction Server.For "Software Location", change to C:\Oracle\product\11.2.0\client_ 32.Your downloads should be about 600 meg each) Download 32 and 64-bit clients from (click "see all" to see different versions, otherwise, you'll be downloading the complete Oracle program.I may have installed more Oracle components than I needed, but here's what worked for me: As it turns out, you will likely need both the 32 and 64 bit clients installed to have things working in BIDS/Visual Studio/SSMS. After hours of research, I managed to cobble together some working instructions for Oracle 11g R2.
0 kommentar(er)
