Can you help me how to connect vb through oracle. Any body posted odbc code.
Thanks
Printable View
Can you help me how to connect vb through oracle. Any body posted odbc code.
Thanks
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.
Hust change the connection string
its simple ..
Here is what I always use in my programs:
You need to reference msado20.tlb (Microsoft ActiveX Data Objects 2.0 Library).
I hope this helpsCode: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")