Connection to Oracle

  • Thread starter Thread starter Fahim
  • Start date Start date
F

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
 
Hi, Fahim.
Is there a way to connect to oracle using odbc through
VBA code?
Click to expand...

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?
Click to expand...

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.
 
Back
Top