Home » Infrastructure » Windows » Please need Help VB6 and Oracle 9i db COnnection
Please need Help VB6 and Oracle 9i db COnnection [message #165198] Tue, 28 March 2006 22:13 Go to next message
Messages: 1
Registered: March 2006
Location: Philippines
Junior Member

this is my code in VB when i connect to Oracle... in the local machine where my oracle database is installed it works well but when my application is deployed in other workstation it doesnt work it display TNS Adapter Error.

this is my code:

Private Sub cmdQuery_Click()
Dim dbConn As Connection
Dim dbRecordset As Recordset


Set dbConn = New Connection
dbConn.Open "Provider=OraOLEDB.Oracle; User ID=intrapsrg; Password=intrapsrg2k5; Database=orajosef; Persist Security Info=Tue"

With dbConn

End With

Set dbRecordset = New Recordset
dbRecordset.Open "select * from books", dbConn, adOpenForwardOnly, adLockReadOnly

Do Until dbRecordset.EOF
lstResult.AddItem dbRecordset(0) & " **** " & dbRecordset(1)

Set dbRecordset = Nothing
Set dbConn = Nothing
End Sub

please help thanks!
Re: Please need Help VB6 and Oracle 9i db COnnection [message #169521 is a reply to message #165198] Thu, 27 April 2006 07:46 Go to previous message
Messages: 112
Registered: June 2005
Senior Member

Has the other machine got an Oracle client installed?

Previous Topic: Microsoft KB912812 update and Jinitiator
Next Topic: Sharepoint Server
Goto Forum:

Current Time: Sun Oct 24 02:16:42 CDT 2021