Home » Infrastructure » Windows » No OLE DB (11GR2)
No OLE DB [message #647311] Tue, 26 January 2016 09:42 Go to next message
jmltinc
Messages: 14
Registered: January 2016
Junior Member
Hi Folks, Newbie here (in all ways Oracle).

I installed 11GR2, 64-bit, SQL Developer, and a Listener on a Windows 7 64-bit machine without problem. SQL Dev plays well with the sample database I created in the install.

I am writing a 32-bit LabVIEW application to access this database via a UDL (it works with an Access database). I have downloaded and 'installed' the ODAC 11.2 Release 4 (11.2.0.3.0) to a folder called odac32 in the base directory which Oracle and the database reside (C:\Oracle).

If I create a text file, rename it to a UDL and open it using Data Link Properties, Oracle is listed as a provider and a configured connection tests successful inside the Data Link set-up. However, the UDL fails when connected to LabVIEW. Additionally, if I open obdcad32 in System32 or SysWOW64, the provider is not listed.

If copy OraOledbIC11.dll to SysWOW64 and try to register OraOledbIC11.dll in an elevated Command Prompt, it fails returning it "...was loaded but the entry-point DllRegisterServer was not found.

I am running in circles and getting nowhere. Any help to resolve this is greatly appreciated.

Thanks,
John
Re: No OLE DB [message #647312 is a reply to message #647311] Tue, 26 January 2016 10:24 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Since Labview is a 32 bit application, you need an 32 bit Oracle Client and the 32 bit ODAC components.

A 32 bit Instant Client should suffice.
Re: No OLE DB [message #647451 is a reply to message #647312] Thu, 28 January 2016 07:48 Go to previous messageGo to next message
jmltinc
Messages: 14
Registered: January 2016
Junior Member
Thank you Thomas for the quick reply.

I had previously tried the Instant Client and it did not work. I tried it again with the same results. The cure was to download the full version of the 32-bit 11g Client and select the Full Administrator mode.

Thanks again.
-John
Re: No OLE DB [message #647480 is a reply to message #647451] Fri, 29 January 2016 06:28 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
jmltinc wrote on Thu, 28 January 2016 07:48
Thank you Thomas for the quick reply.

I had previously tried the Instant Client and it did not work. I tried it again with the same results. The cure was to download the full version of the 32-bit 11g Client and select the Full Administrator mode.

Thanks again.
-John


Did you donwload the 32-bit or the 64-bit client?
To the degree that the fix might have had to do with "full" client vs. "instant" client, I'd be willing to be that the 'run time' option would have worked as well as the 'full admin' option.
Re: No OLE DB [message #647493 is a reply to message #647480] Fri, 29 January 2016 10:12 Go to previous message
jmltinc
Messages: 14
Registered: January 2016
Junior Member
I downloaded the 32-bit client. You are probably right about the Runtime Client. I am just happy that it works!

Thanks, again.
-J
Previous Topic: Load data of multiple files from dynamic
Next Topic: Create DB Script
Goto Forum:
  


Current Time: Thu Mar 28 11:10:27 CDT 2024