Oracle ODBC from VBA

[FrankX]

Hi,
I've been asked to see if I can fire off some oracle reports from within a VBA application. I understand that this will require me to send instructions using ODBC, but I have not got a clue as to how to do this. does anyone know a good site to goto for a tutorial / articles on how to use ODBC.
Kind regards
Paul

 

[Klopper]

Hi Paul

Have a look around

http://www.merant.com

for their white papers on ODBC.

I have used ODBC connections to access and manipulate data residing in Sybase tables from MS Access (using linked tables and pass through queries).
But I am not sure how to use VBA to run reports / trigger stored procedures etc. contained within Oracle/Sybase/SQLServer databases - does anyone out there know how to do this?

HTH
Klopper

 

[nath]

Hi,

You first need to reference the ActiveX Data Objects 2.1.
Then you can find information on how to use ADO in MSDN documentation. There is some sample code for example in

msdn.microsoft.com/library/en-us/ado270/htm/mdmthexecutex.asp?frame=true

I have never done it with an Oracle database, but you can find details on how to set up the connection string on the following site:

http://www.winscripter.com/wsh/database/dbconinfo.asp

Hope this helps

Nath