ADO is a high-level wrapper for OLE-DB MS strategic technology for accessing enterprize data OLE-DB needs specific provider for each back-end it can use, to ensure backward compatibility the first (if I am not mistaken) provider that was build was for ODBC if you are accessing an ODBC data source via ADO it is most probably a little slower than using ODBC directly (the ODBC provider name is MSDASQL) however as more and more specific providers available you would have better perfomance with ADO/OLE DB OLEDB delivers on Univeral Data Access - that is not just Rational data or rational implementation of non-rational data- that is , you can also access multi-dimentional data (OLEDB for OLAP) etc. Arnon >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