v-wywang
3/11/2008 10:43:00 AM
Hello Norman,
Thanks for your reply.
I have reproduced the issue. As far as I know, Jet database engine could
not read data from a file where file name contains ".". Thereby, the
OleDBAdapter failed to fill data into datatable, and thrown "file not
existing" error.
Actually, the FillSchema method failed, either. But it doesn't throw any
exception. Thus, we misunderstood it works fine. If you check ColumnCount
after you filled the schema, you will notice there is no any column in that
table. This means OleDBAdapter failed on filling schema.
dataAdapter.FillSchema(dataTable, SchemaType.Source);
DataColumnCollection dataColumns = dataTable.Columns;
int fileColumnCount = dataColumns.Count;// I believe the value is Zero.
I didn't test with file which contains dot in it name before. I think this
is the root cause why issue only occur on this file. :)
Hope this helps. Let me know if there is anything unclear. We are glad to
assist you.
Best regards,
Wen Yuan
Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
msdnmg@microsoft.com.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.