>> 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