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