• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Connecting to oracle remotely

varadharajan

New Member
Hi I am using citrix app to connect to oracle remotely. is it possible for me to do that with excel and execute the oracle queries.


Thanks.
 
Hi Vardha,


Yes, it is possible.


The citrix server where MS-Excel is hosted should have the ODBC drivers / ADO drivers for Oracle installed.


You can then ask the system administrator to setup a System DSN to the Oracle Server and use the connection string in excel to connect.


HTH


~Vijay
 
Back
Top