hello friend
how to connect to oracle using ado connection code.. how to access data from oracle sql tables....
if u'r sending..me this reply within a day..it's great pleasure for me
thank u friend
sreedhar
Printable View
hello friend
how to connect to oracle using ado connection code.. how to access data from oracle sql tables....
if u'r sending..me this reply within a day..it's great pleasure for me
thank u friend
sreedhar
Helo,
Connect to an oracle database:
DNS-less connection
adoconnection.ConnectionString = "uid=;pwd=;server=;" _
& "driver={Microsoft ODBC for Oracle};"
Open a SQL Table:
adoRecordset.Open "Select * FROM tablename", adoconnection
For more information you can always look in the help files under "Connection Object (ADO)" in the msdn library.
HTH,
Preeti