Thank you, Arnon.
But it does not work also. I got the same error.
I have latest ODBC for VFP but I am not sure about ADO DB.
I know that Pass Through SQL works. It also use the same ODBC driver.
What the difference between using ODBC id SQLCONNECT and ADO ?
Thanks. Alex

>I don't have a problem connection to a DSN here
>
>Maybe you should try specifying a connection String:
>e.g. :
>
>

>    loConnection=createobject("ADODB.Connection")
>    lcConnStr="PROVIDER=MSDASQL;dsn=NELSDATA;uid=;pwd=")
>    loConnection.open(lcConnstr)
>

>
>Also make sure you have the latest ODBC for VFP (and/or whatever backend you
>use)
>and lastly get the latest ADO DB (for example from the public beta of VJ or
>VID)
>
>Arnon
>
>
>
>>
>>Hi All!
>>I am trying to play with ADO inside VFP5.
>>Before i tested Pass Through SQL with one of the datasources. It worked
>fine.
>>I put these lines:
>>STORE SQLCONNECT('NELSDATA') TO gnConnHandle
>>= SQLSETPROP(gnConnHandle, 'asynchronous', .F.)
>>= SQLEXEC(gnConnHandle, 'SELECT * FROM nelslist', 'MyCursor')
>>and get cursor "Mycursor" with all records.
>>'NELSDATA' is ODBC data Source.
>>Than I put in command window line by line following code :
>>oConn = CreateObject("adodb.connection")
>>ors = CreateObject("adodb.recordset")
>>These 2 lines run OK.
>>But line oconn.Open("NELSDATA") gave me error:
>>"OLE IDispatch exception code 0 from ADODB.Connection: ?"
>>I have latest Personal Web server Installed on my win95,which i assume
>>should have ADO.
>>Any thoughts?
>>Thanks. Alex