vb with oracle

[vijaykolli]

Can you help me how to connect vb through oracle. Any body posted odbc code.

Thanks

[honeybee]

Use ADODC or RDC on your form, connect it to the Oracle database and copy its ConnectionString or equivalent properties into your code.

If you still have problems, be specific and we shall try to answer you.

Hope it helps. Don't shy from asking. Remember everyone has to start somewhere.

[efrat]

Hust change the connection string
its simple ..

[FrancisC]

Here is what I always use in my programs:

You need to reference msado20.tlb (Microsoft ActiveX Data Objects 2.0 Library).


Dim db As New Connection
Dim adoRS As New Recordset


Dim ConnectionString As String
ConnectionString = "Provider=MSDASQL;dsn=YourDSN;uid=UserID;pwd=Password;"

db.Open ConnectionString


Dim strSQL As String
strSQL = "select something from wherevever"
adoRS.Open strSQL, db, adOpenStatic, adLockOptimistic

'You now can access the recordset adoRS like this:
Dim Temp As Variant
Temp = adoRS.Fields("something")


I hope this helps