Connection to Oracle

[Fahim]

Hi,

I have moved Access XP tables to Oracle 9i.
1.)Is there a way to connect to oracle using odbc through
VBA code, Can I use one connection variable for opening
and closing various recordsets? Any example will be
greatly appreciated.
2.)How can I call a function from oracle and get a return
value in Access?
Thanks

 

['69 Camaro]

Hi, Fahim.

Is there a way to connect to oracle using odbc through
VBA code?

Yes. Use the ADODB class for connections and RecordSets. You can find
plenty of examples at the following Web page for Oracle and just about any
other popular DBMS you can think of:

http://www.able-consulting.com/ado_conn.htm

Can I use one connection variable for opening
and closing various recordsets?
Yes.

How can I call a function from oracle and get a return
value in Access?

You need to use a SQL Pass-Through Query, which can return RecordSets or
scalar values from the database server.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.