Hello;
I have a scripting question to ask. Before we upgraded to BO5, I can use function SQLREQUEST to run a query against ODBC to Oracle and return the result. But now in VBA of BO5, this function sqlrequest doesn’t exist. Can someone tell me how can I get it work or there is some other way to do it? Thank you!
Naijie
Listserv Archives (BOB member since 2002-06-25)
In BO5 you have to use VBA supported data access methods. Look at ADO documentation.
Vasan
LINNA@DWD.STATE.WI.US on 04/05/2000 12:06:20 PM
Hello;
I have a scripting question to ask. Before we upgraded to BO5, I can use function SQLREQUEST to run a query against ODBC to Oracle and return the result. But now in VBA of BO5, this function sqlrequest doesn’t exist. Can someone tell me how can I get it work or there is some other way to do it? Thank you!
Naijie
******************************************************************************* Note: The information contained in this message may be privileged and confidential and protected from disclosure. If the reader of this message is not the intended recipient, or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by replying to the message and deleting it from your computer. Thank you. Ernst & Young LLP
Listserv Archives (BOB member since 2002-06-25)
Naijie
There is a white paper available through Business Objects tech support that explains how to access databases using VBA. The paper is titled “How to access to a database with VBA”. I opened a case at BusObj’s Tech Support web site and they emailed me the paper. Using that as a starting point I was able to access an Oracle database and execute any kind of sql statement…
Mike McErlain
McErlain Consulting
MikeMcErlain@Netscape.net
At 10:06 AM 4/5/2000 -0500, you wrote:
Hello;
I have a scripting question to ask. Before we upgraded to BO5, I can use function SQLREQUEST to run a query against ODBC to Oracle and return the result. But now in VBA of BO5, this function sqlrequest doesn’t exist. Can someone tell me how can I get it work or there is some other way to do it? Thank you!
Naijie
Listserv Archives (BOB member since 2002-06-25)
Dear Mike,
I’m not able to see any White paper(“How to access to a database with VBA”) on BO tech support.
Can u explain how to get it.I tried using search, but it says no match found.
Arun
Listserv Archives (BOB member since 2002-06-25)
Arun
Open a case and request the document by title. That’s how I got it.
Mike
At 11:47 AM 4/5/2000 -0500, you wrote:
Dear Mike,
I’m not able to see any White paper(“How to access to a database with VBA”) on BO tech support.
Can u explain how to get it.I tried using search, but it says no match found.
Arun
Listserv Archives (BOB member since 2002-06-25)