Re: Microsoft Access or Microsoft Excel >>>>>> Oracle PRO

From: Gary England <gengland_at_hiwaay.net>
Date: 1997/12/10
Message-ID: <348E7E3F.564F_at_hiwaay.net>#1/1

Excel can connect directly to an ORACLE ODBC driver or go through Access. The difference is in the OpenDatabase. Below are commands to connect to Access, Sybase or ORACLE from any VBA application.

'Establish connection to an Access database that links to the desired
database
Set db = OpenDatabase("C:\My Documents\TEST2.mdb")
'Connect to Sybase, Not exclusive, Read-Only
Set db = OpenDatabase("", False, True,
"ODBC;DATABASE=prod_live;UID=gengland;PWD=welcome;DSN=TEST")
'Connect to ORACLE, Not exclusive, Read-Only
Set db = OpenDatabase("", False, True,
"ODBC;UID=gengland;PWD=welcome;DSN=TEST2")

The ODBC configuration points to the appropriate drivers and database alias names. Received on Wed Dec 10 1997 - 00:00:00 CET

This message: [ Message body ]
Next message: Tina Tran: "Re: Forms questions.. Help please"
Previous message: Dr. Memory: "Re: Version control for stored procedures"
Maybe in reply to: PATRIK BERNTSSON: "Microsoft Access or Microsoft Excel >>>>>> Oracle PRO"
Next in thread: Tina Tran: "Re: Forms questions.. Help please"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message