Re: Visual Basic using Oracle

I use ADO as well; it is quite easy.

Dim connDB as New ADODB.Connection
Dim rsRecords as New ADODB.Recordset

connDB.ConnectionString =
"Provider=MSDAORA.1;Password=PASSWD;User ID=USERID;Data Source=DATABASENAME;Persist Security Info=True"

connDB.Open

rsRecords.Open "SELECT * FROM tablename", connDB

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!