Skip to Main Content

Oracle Database Express Edition (XE)

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!

Excel-VBA Macro Connectivity to XE

arnelcSep 21 2007 — edited Sep 28 2007
I have an excel-macro which accesses data from Oracle9i database with the connection code;

Set oOraSession = CreateObject("OracleInProcServer.XOraSession")
Set oOraDatabase = oOraSession.OpenDatabase("iois", "bacc/password", 0&)

It runs smoothly with no problems. When I test the same application to my newly installed XE database, using the connection code;

Set oOraSession = CreateObject("OracleInProcServer.XOraSession")
Set oOraDatabase = oOraSession.OpenDatabase("XE.world", "bacc/password", 0&)

it didnt run and broadcasts an error msg.;

Runtime error '429'
ActiveX component can't create object


I know there's a way to solve this but how?

Arnel
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 26 2007
Added on Sep 21 2007
14 comments
2,424 views