[AccessD] slightly OT: Oracle and ADO

Jack,

Here's a snippet of what I ended up using:

'begin
Dim conn As ADODB.Connection

Set conn = New ADODB.Connection
conn.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
                        "Data Source=my.server.address.com;" & _
			"User ID=username;Password=password;"
conn.Open
'end

Once you have that connection open, you can use it for any other action
until you close it.  Note the "Data source" parameter can be an IP
address, and possibly even a NetBIOS name if you are confident in the
ability for your workstations to resolve those consistently.

Seth

On Thu, 2003-04-24 at 16:11, Drawbridge.Jack at ic.gc.ca wrote:
> Seth: Did you ever get this resolved? We are seeking info on 
> ODBCDirect with DAO (access 2000) talking to Oracle 9i. We're trying to get
> to Oracle without the ODBC prompt. Can we do this with code (hopefully with
> some code and logic you have discovered)?
> 
> Thanks.
> 
> jack
> 

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University