Converting ReportScript to VBA for BCA

Hi Alls,
We are upgrading BO from version 415 to 5. In version 415, we used SQLOpen, SQLExecQuery, SQLRetrieve, and SQLClose to retrieve some data in Report Script.

Is there anybody out there know what similar command(s) we can used in VBA (Macro) for those SQL commands.

Many thanks
Isix


Listserv Archives (BOB member since 2002-06-25)

At 04:18 PM 2/18/2000 +1000, you wrote:

Hi Alls,
We are upgrading BO from version 415 to 5. In version 415, we used SQLOpen, SQLExecQuery, SQLRetrieve, and SQLClose to retrieve some data in Report Script.
Is there anybody out there know what similar command(s) we can used in VBA (Macro) for those SQL commands.
Isix

Isix

You will need to do some downloading to get this done. There is a document available from BO that is called 'How to Access to a database from VBA". This is a word document that outlines how to use ADO (Activex Data Objects). You will need to get the ADO libraries from Microsoft and install them on your machine. Then you will need to add the libraries as references in VBA (Choose TOOLS - REFERENCES) and select the ADO libraries.

I have an Oracle example I can dig out an post if you need. I found the documentation in the BO white paper to be less than expansive on the subject. But I did manage to figure it out from there.

Mike McErlain
McErlain Consulting
MikeMcErlain@Netscape.net


Listserv Archives (BOB member since 2002-06-25)

At 04:18 PM 2/18/2000 +1000, you wrote:

Hi Alls,
We are upgrading BO from version 415 to 5. In version 415, we used
SQLOpen,
SQLExecQuery, SQLRetrieve, and SQLClose to retrieve some data in Report Script.
Is there anybody out there know what similar command(s) we can used in
VBA
(Macro) for those SQL commands.
Isix

Isix

You will need to do some downloading to get this done. There is a document available from BO that is called 'How to Access to a database from VBA". This
is a word document that outlines how to use ADO (Activex Data Objects).

Exactly where did you find this document? I have searched the website with no luck :frowning:

Thanks

Tania

Tania Mason
Executive Computing Group


Listserv Archives (BOB member since 2002-06-25)

Maybe check out microsoft for ADO examples? Also, there are a lot of 3rd party products out there, maybe this is a good opportunity to roll some into your environment

I used VB / MSSql in my previous life, and ADO is the way to go…

Brent


Listserv Archives (BOB member since 2002-06-25)