OraDatabase Object

[Matsul]

How can I start to use OraDatabase in excel VBA ?

Dim OraDatabase As OraDatabase

gives user type not defined.

I have no options to add in in the add-in Manager.

thanks

 

[xlbo]

I assume this is an Oracle database ??

If so, it should be under Tools>REFERENCES in the VBE - not as an add-in

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Matsul]

hI Geoff,

yes References looks more like it. I need to run select statment on an Oracle database. Would Oracle Analysis Wizard do the trick ?

thanks

 

[JerryKlmns]

If your goal is to read some tables from Oracle you could concider openning a connection to that db (

http://www.connectionstrings.com),

and execute some SELECT recordsets stuff ... and many more!

 

[xlbo]

Matsul - that sounds like it would do the trick - yes

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[vladk]

Matsul,

I would not name object as a class:

Instead of

Dim OraDatabase As OraDatabase

I would do this:

Dim mobjOraDatabase As OraDatabase

Are you using OO4O?

vladk

 

[Matsul]

Hi ,

well I should be . Have to check if server has OO4O.

Meanwhile, I tried to add Oracle Analysis Wizard and got

Error in loading DLL

Any ideas ?

thanks,

Matthew

 

[xlbo]

do you have any other Oracle options under Tools>References ??

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Matsul]

Hi there,

Yes I have

Oracle Application Desktop Intergrator
Oracle Data Control --> I tried this and it installed. I am suspecting that this is it
Oracle Image Control
Oracle InProc Server 3.0 Type Library
Oracle Language server GLDI GB
Oracle Language server GLDI PSU
Oracle Language server GLDI US

regards,

Matt

 

[Matsul]

Well with Oracle Data Control I still got

User Type not defined

on

Dim OraDatabase As OraDatabase

 

[xlbo]

try ticking all of them - should then work

then just untick 1 at a time until it breaks again - then you will know which one it is

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Matsul]

No luck as it gave me Error in loading DLL on trying any of the Oracle add ins

 

[xlbo]

you should be able to get a download from the Oracle website (down at the mo) or here:

http://www.easysoft.com/

for the odbc driver

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question