VB 5 and Oracle

[Quoted] Oke Guy's, If someone can tell me what is wrong with this ...

Public Function OracleConnect() As Integer

Dim sConnect_Orcl As String
Dim sQueryStr_Orcl As String
Dim sQueryNm_Orcl As String

sConnect_Orcl = "DSN=ENGSERVER;uid=ENGSERVER;pwd=ENGSERVER;" sQueryStr_Orcl = "Select * from common_item_detail" sQueryNm_Orcl = "Oracle1"

gRDO_Connect_Orcl.Connect = sConnect_Orcl
gRDO_Connect_Orcl.CursorDriver = rdUseOdbc
gRDO_Connect_Orcl.EstablishConnection rdDriverComplete

Set gRDO_Query_Orcl = gRDO_Connect_Orcl.CreateQuery(sQueryNm_Orcl, sQueryStr_Orcl)
Set gRDO_Result_Orcl = gRDO_Query_Orcl.OpenResultset(rdOpenForwardOnly) gRDO_Result_Orcl.MoveLast: gRDO_Result_Orcl.MoveFirst

End Function

I keep getting errors like :

runtime error 40002 - drivers SQLSetConnectAttr failed

Thanks for your time and advise...

Email : walterd_at_glo.be Received on Tue Mar 24 1998 - 00:00:00 CET