[lawboy]

hi i'm new to vb and oracle, can someone give a an example on how to connect vb with oracle??
my main task is to generate random number then connect to oracle to check if critiera are met,

i need to submit my work soon. hope u all can help me asap
thanks

[SCIROCCO]

Dim cn as ADODB.Connection
Dim rs as ADODB.Recordset

Set cn = new ADODB.Connection

'For STANDARD Security
cn.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"User Id=myUsername;" & _
"Password=myPassword"

'For Trusted Security
cn.ConnectionString = "Provider=OraOLEDB.Oracle;" & _
"Data Source=MyOracleDB;" & _
"OSAuthent=1"

cn.open

set rs = new ADODB.recordset

rs.ActiveConnection = cn

rs.Open "SELECT * FROM Table1"

rs.Close

cn.Close

Set rs=Nothing
Set cn = Nothing