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.
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.
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
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…