Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

ISAM Table Not Found

ISAM Table Not Found

ISAM Table Not Found

We have been using Clarion SV Top Speed Drivers to load data into SQL server for a while now. Client is migrating to SQL, and have 147 tps files that need to be moved to SQL server each month. Three unique passwords for these files, so we code in vb.net to try catch each driver for each file. They have been working good, but occasionally it fails with ISAM ERROR Table not found. Any idea why?
Any help would be great
Please and Thank You  

RE: ISAM Table Not Found


What version of SV TPS ODBC Driver are you using?

If you are using DSN's for access, you need to define separate DSN's for each of the password protected files.

Also, the TPS ODBC driver is known to have issues and quite an elementary driver in terms of performance/features.


RE: ISAM Table Not Found

Thanks Shankar,
 The version is 5.00. I am coding in VB.net in SSIS with Try Catch block for each of the three seperate DSN's. For Example,
 TRY for PW1
 CATCH Exception
This has been working fine most of the time. But occasionaly fails with the ISAM TABLE NOT FOUND Error. I can not repeat this error and it is not always on the same table. Some times I also get system out of memory error in the .net application. I have tried increasing the virtual memory still same issue.
Though one thing is consistent, it never happens on the local machines, this happens only on the server.

Thank again for your time,
Hope you can help me resolve this issue.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close