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
josefIT
Messages: 1
Registered: March 2006
Location: Philippines
Junior Member
Hi!

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

lstResult.Clear

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)
dbRecordset.MoveNext
Loop

dbRecordset.Close
dbConn.Close
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
Penfold
Messages: 112
Registered: June 2005
Senior Member
Hi,

Has the other machine got an Oracle client installed?

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


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