
August 22nd, 2003, 06:35 AM
|
|
Junior Member
|
|
Join Date: Aug 2003
Location: Romania
Posts: 5
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Odbc .NET Data Provider problem
I use Microsoft Visual C# .NET in an Microsoft Development Enviroment 2002.
Also, I use the Odbc .NET Data Provider from http://msdn.microsoft.com/downloads.
I want to delete some records from the data source (an EXCEL sheet) but the task throws an exception:
"[Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM."
I managed to Select, Update and Insert data from/in the Excel sheet but the deletion seems to be a problem.
For deletion I used OdbcDataAdapter as well as OdbcCommand objects. In both cases it throws an exeption:
"[Microsoft][ODBC Excel Driver] Deleting data in a linked table is not supported by this ISAM."
Is this a bug of Odbc .NET DataProvider ?
Can anyone help me, please?
|