Hi guys!

Im trying to link a dbf file using adodb. please see my code below:

Set cn = New ADODB.Connection
Set rs = new ADODB.recordset
    If cn.State = adStateOpen Then cn.Close
        cn.Open "Driver={Microsoft Visual Foxpro Driver};" & _
               "SourceType=DBF;" & _
               "SourceDB=c:\payroll\Paydata\attenda.dbf;" & _
               "Exclusive=No;"
        cn.CursorLocation = adUseClient


strSQL = "select * from attenda"
' attenda is table name

rs.Open strSQL, cn, adOpenKeyset, adLockOptimistic, adCmdText

i encountered ERROR MSG "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another"

when i checked cn it was empty.

i really need your knowledge with this. please help me guys!

thanks in advance

Hi x

I tried your code and it worked up to the rs.open where i didn't have your foxpro table , so thats no surprise. Which version of ado are you using?



Steve  

im using ADO Data Control 6.0

Try to use te reference to MS ADO 2.5 or higher libraries first, in order to handle the connection trough code and not use the FoxPro drivers, try to use the "DRIVER={Microsoft dBase Driver (*.dbf)}", because not all the machines can have installed the VFP driver and setup´d.
Set the default directory to the path of .DBF also. Depending the SQL syntax the DBF driver can not support the command.


____________________________
Aleks