Connection to Oracle

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fahim - 13 Aug 2004 21:06 GMT

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

Reply to this Message

'69 Camaro - 14 Aug 2004 22:50 GMT

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.

> Hi,
>
[quoted text clipped - 6 lines]
> value in Access?
> Thanks

Reply to this Message