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!

How to create a DSN for Oracle Provider for OLE DB in a web server

722846Oct 9 2012 — edited Oct 16 2012
Dear Guys,

I am a Excel VBA developer.

My requirement is from the Excel I have to call a Stored Procedure with REF CURSOR.

Normally I am using Microsoft ODBC for Oracle Driver for connecting Oracle DB, which is in the Server .
We have users using the Excel reports across the globe.
Sending Excel report is enough, the clients can connect DB from Excel via the DSN created in a web server.

But, I came to know that we can't access the REF CURSOR using Microsoft ODBC for Oracle Driver and it is possible to access by using ORA OLE DB Provider.

I have installed Oracle Client in my machine and tried using ORA OLE DB Provider like below
+con.ConnectionString = "Provider=OraOLEDB.Oracle.1;User ID=user_name;" & _+
+"Password=pwd;Data Source=Oracle;"+

The Excel worked fine in my machine but when I run the same Excel in my user machine in a different country I couldn't connect to DB.
Because the user machine doesn't have Oracle Client installed. We have n number of users across the world and we can't install Oracle client individually.

So, I have the plan of creating a DSN in a web sever as I used for Microsoft ODBC for Oracle Driver.

But, my doubt is how can I create a DSN for accessing ORA OLE DB provider? Is there any driver for ORA OLE DB provider? or is there any alternate solution for my issue?

Can anybody help me on this ASAP?

Thanks & Regards,
Satz
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 13 2012
Added on Oct 9 2012
4 comments
3,964 views