This content has been marked as final. Show 4 replies
Normally I wouldn't answer a question with another question, but in this case I don't understand what you're doing.
user8831681 wrote:How are you doing that? I've never heard of sharing a DSN on a web server before.
Sending Excel report is enough, the clients can connect DB from Excel via the DSN created in a web server.
I have created a DSN in a web server (a Public IP machine) that is mapped to a Oracle DB.
In my Excel using VBA coding, with the help of RDO object I will call the DSN in the Web server using the connection string like "DSN=ORS;UID=SDATA;PWD=SDATA;"
This is working fine and in this case the client machine doesn't need Oracle client to be installed or any TNS entry.
The user can run the Excel report by clicking a button and the click event connects the DSN in the web server (through its URL) and routes to the mapped DB and fetches the quried data.
Please note that the above DSN is created based on Microsoft ODBC for Oracle driver.
But the issue is using the Microsoft ODBC for Oracle driver I couldnt call the SP with Ref Cursor.
When I searched in Internet I came to know using the provider oraoledb.oracle we can call SP that uses REF CURSOR.
Now my question is what is the driver name that I can use to create a DSN to make use of the provider oraoledb.oracle for calling the SP with REF CURSOR from Excel VBA coding ?
Appreciate your prompt reply.
Thanks & Regards,
Ah. That's pretty creative. :)
Unfortunately I don't know of a way to create an ODBC connection for an OLE DB datasource. The two are fundamentally different, and at one point MS was touting OLE DB as a replacement for ODBC. (It didn't work out that way.)
You could try creating an ODBC data source using Oracle's provider rather then Microsoft's. It's included in the same client package that has the OLE DB provider.