Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Connection with Oracle 64 Bit in vb.net

Suresh BansalDec 16 2014 — edited Jan 7 2015

Dear Sir

We installed Oracle 11g 64 Bit on Windows 2008 Server OS 64 Bit.

We installed  .Net Frame work on the Windows 2008 64 Bit server and we are able to connect to Oracle 11g 64 Bit thru vb.net application

using the following connection string.

Provider=OraOLEDB.Oracle.1;Data Source=kcp3;Persist Security Info=True;User ID=kcperp; Password=kcperp

Now we wish to access the Oracle 11g at Windows 2008 64 Bit server thru Windows XP Client (32 Bit) thru vb.net using the same connection string. But it says OraOLEDB.Oracle.1provider is not found on the client. Althugh we have Oracle 10g Oracle Client installed and we are able to create netwervice to Oracle 11g 64 Bit on Windows 2008 Server and connect thru Sql* Plus using that netservice say kcp5

We also installed ODTwithODAC1120320_32bit  data access components at the Client (windows xp) machine assuming that it may provide

OraOLEDB.Oracle.1provider   but still we are not able to connect to  Oracle 11g 64 Bit using OraOLEDB.Oracle.1provider thru Windows xp 32 Bit client ->vb.net application.

Pl advise , as to how we can connect to Oracle 11g 64 Bit on Windows 2008 64 Bit server  from Client (Windows xp 32 Bit) using OraOLEDB.Oracle.1provider

Thanks in advance

Suresh Bansal

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 4 2015
Added on Dec 16 2014
4 comments
6,453 views