Sql Server ODBC connection error Table access error

Question

TSystem.Data.Odbc.OdbcException was unhandled
Message: ERROR [42S00] [SmartWare Software][SmartWare ODBC Driver][ISAM]Table access error

Just curious as to what usually causes this error, or how better to find out what is causing my error. Thank you

score 1 · Accepted Answer · answered Feb 12 '10 at 16:34

1

Turn on Tracing via the tracing tab of the ODBC Data Source Administrator, and you'll get a log of every action and be potentially able to see at what point the error is generated.

answered Feb 12 '10 at 16:34

MartW

1,305
10
15

Wish I could, it is in an ssis package. – george9170 Feb 12 '10 at 21:02
Shouldn't make a difference, assuming the package is using a DSN on the server. – MartW Feb 13 '10 at 11:51

Sql Server ODBC connection error Table access error

1 Answers1