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