Oracle 8.1.5

[Robbo]

using the following:-

Public Sub ReportADO()
' in code, initialize the connection
Set adoConnect = New ADODB.Connection

m_Server = frmConn.txtServer.Text 'm_Server = "MERCURY"
m_UID = frmConn.txtUID.Text 'm_UID = "MERCURY"
m_UPW = frmConn.txtUPW.Text 'm_UPW = "MERCURY"

Set m_ORAcmd = New ADODB.Command

m_strSQL = _
"data source=" & m_Server & ";" & _
"user id=" & m_UID & ";" & _
"password=" & m_UPW

With adoConnect
.Provider = "MSDAORA"
.CursorLocation = adUseClient
.ConnectionTimeout = 3
.ConnectionString = m_strSQL
.Open m_strSQL, , , -1
End With

Set m_ORAcmd.ActiveConnection = adoConnect

' in code, using recordset
Set adoRecordSet = New ADODB.Recordset

' Prepare the RecordSet
adoRecordSet.CursorType = adOpenStatic
adoRecordSet.LockType = adLockOptimistic

i have had problems putting on other machines, the oracle client works fine and opened SQL Plus and that connects ok, however my application doesnt, but does on my development machine any one help????

Thanks in advance

[Graff]

are the drivers of the ODBC connection installed on the client machines?

[Robbo]

yep full oracle client 8.1.5

[brucevde]

What error do you get?

[Robbo]

on different machines different errors on mine its a TNS error

on others its couldnt connect 214** error no host found

[brucevde]

Is the tnsnames.ora file correct and on all computers?

[Robbo]

yep, ive even tryed copying it acroos from ones which work to those which dont, i have successfully installed 8.1.7 on one of the PCs so it may seem that the install CD maybe damaged, however on one machine it wont open the config assistant at all? on any of the client installations