[AccessD] slightly OT: Oracle and ADO

---- London Borough of Bromley E-Mail Disclaimer ---- 
"For information about Bromley Council visit our web site
www.bromley.gov.uk" 

"The information contained in this message (including any attachments) is
confidential in that it is intended solely for the use of the recipient to
which it is addressed. If you are not the intended recipient, the use of the
information by disclosure, copying or distribution is prohibited and may be
unlawful." 
---- End of Disclaimer ---- 

Seth/Jack,

This is slightly OT, but reading below it looks like you two have done
something similar to what I am attempting.  

Once the connection has been established in code, is it possible to create a
recordset from that Oracle connection and then create a table in Access
based on those records?

TIA
RyanS

 -----Original Message-----
From: 	Seth Galitzer [mailto:sgsax at ksu.edu] 
Sent:	24 April 2003 22:48
To:	accessd
Subject:	RE: [AccessD] slightly OT: Oracle and ADO

---- London Borough of Bromley Security Notice ---- 
"Please treat all e-mail with caution. Only open attachments from trusted
business sources whose material you are sure is safe. Refer to the Council's
e-mail and internet users Code of Conduct for further guidance on the
correct use of the e-mail system."

---- End of Notice ----

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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030425/b9147117/attachment-0001.html>