Excel ODBC driver created table/data not persistent

  • Follow

I connect to an Excel spreadsheet using Microsoft Excel Driver (*.xls) 
4.00.6305.00 successfully and I am able to create a new table and insert data 
into the the new table and retrieve the inserted new data successfully.

On closing the application however, the new table and its data are gone and 
the spreadsheet is never updated. Seems like everything is done in memory.

I am using autocommit mode and issuing an ODBC SQLEndTran/SQL_COMMIT after 
both creating the table and inserting the data, as usaul and that works fine 
with all other ODBC data sources but not the Excel ODBC data source.

What am I missing?
Reply Utf 4/23/2010 3:14:01 AM

Correction: I am actually not calling SQLEndTran because the driver reports 
it does not support transactions
Reply Utf 4/23/2010 4:09:01 AM

OK. I found out the cause of this issue was a code path that skipped calling 
::SQLDisconnect before freeing connection handle. Now it all works
Reply Utf 5/19/2010 4:14:01 PM

2 Replies

(page loaded in 0.002 seconds)