Hi all,
Having made only one real application using VB two years ago (using ODBC connection to VFP data) i now thought that i should change it to use VFP's OLE DB driver. But i am getting an error on the last of the following three lines:
sqlString = "select index from isolator where article = ''" && works
DataEnv.Recordsets("rdsIndex").Open (sqlString) && works
DataEnv.Recordsets("rdsIsolator").Open && does not work
Error message: Run-time error: '-2147352567 (80020009)': Method 'Item' of object 'Recordsets' failed.
And if i look at the Err object in debug window in VB the error number for LastDllError is 6 (to many files open) ??
All other record sets in the application works and is "SQL-select statements", but this one is "Table".
Any ideas ?
/Torgny