software

Dear All,

I am trying to access/connect oracle database to insert and select data
from
tables. I don't know what to use like ADO? ADOX? ADODB? or others?

I was trying to connect using the following code:

Dim db As ADODB.Connection

Set db = New ADODB.Connection

db.ConnectionString = quot;Data Source='cis2';quot; amp; _
quot;User ID='cis2view';Password='viewcis2@hkdb';quot;
db.Open

db.ConnectionTimeout = 30db.Close
Set db = NothingFrom Data Source which mean I need to setup a Name from ODBC call Cis2
right?

Does anyone have any idea what is the code look like and how to write it?

Thanks for your helf

David
Personally, I would attempt to extract the data through MSQuery (Data gt;
GetExternalDate gt; CreateNewQuery......), although you would need permission
for the access by virtue of a driver.

hth
Vaya con Dios,
Chuck, CABGx3
quot;David Willisquot; wrote:

gt; Dear All,
gt;
gt; I am trying to access/connect oracle database to insert and select data
gt; from
gt; tables. I don't know what to use like ADO? ADOX? ADODB? or others?
gt;
gt; I was trying to connect using the following code:
gt;
gt; Dim db As ADODB.Connection
gt;
gt; Set db = New ADODB.Connection
gt;
gt; db.ConnectionString = quot;Data Source='cis2';quot; amp; _
gt; quot;User ID='cis2view';Password='viewcis2@hkdb';quot;
gt; db.Open
gt;
gt; db.ConnectionTimeout = 30
gt;
gt;
gt; db.Close
gt; Set db = Nothing
gt;
gt;
gt; From Data Source which mean I need to setup a Name from ODBC call Cis2
gt; right?
gt;
gt; Does anyone have any idea what is the code look like and how to write it?
gt;
gt; Thanks for your helf
gt;
gt; David
gt;
gt;
gt;