Home » SQL & PL/SQL » Client Tools » Not able to make ora connection through macro in excel (windows 7)
Not able to make ora connection through macro in excel [message #547602] Thu, 15 March 2012 00:25 Go to next message
agrawalp
Messages: 2
Registered: March 2012
Junior Member
Hello all,

This is my first post and i need help badly.

i have windows 7 on machine. When i am trying to connect to oracle client using macros from excel like

OraSession = CreateObject("OracleInProcServer.XOraSession")

its giving me error saying "activex component cant create the object."
post me reply asap if you know.

Thanks in advance
Pavan
Re: Not able to make ora connection through macro in excel [message #547610 is a reply to message #547602] Thu, 15 March 2012 01:47 Go to previous messageGo to next message
Michel Cadot
Messages: 60063
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you install an Oracle client?
If yes, which one?

Regards
Michel
Re: Not able to make ora connection through macro in excel [message #548580 is a reply to message #547610] Fri, 23 March 2012 03:19 Go to previous messageGo to next message
agrawalp
Messages: 2
Registered: March 2012
Junior Member
I got the answer.. it works only with windows 7 and excel 32 bit and oracle client 32 bit. i have tried this and it works properly.
Re: Not able to make ora connection through macro in excel [message #548671 is a reply to message #547610] Sat, 24 March 2012 02:02 Go to previous message
june green
Messages: 2
Registered: March 2012
Junior Member
Michel Cadot wrote on Thu, 15 March 2012 01:47
Did you install an Oracle client?
If yes, which one?

Regards
Michel


yes,you should install an oracle client.
Previous Topic: How to configure SQL DEVELOPER Via Virtual Machine oracle database
Next Topic: Unicode conversion
Goto Forum:
  


Current Time: Sun Dec 28 09:13:48 CST 2014

Total time taken to generate the page: 0.08472 seconds