INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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.

Jobs

ISAM Table Not Found

ISAM Table Not Found

(OP)
Hi,
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

Hi!

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.

Regards
 

RE: ISAM Table Not Found

(OP)
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
 GOTO PW2
 END TRY
 TRY PW2
 CATCH EXCEPTION
 GOTO PW3
 END TRY
 TRY PW3
 CATCH EXCEPTION
 REPORT NO DRIVER WORKED
 END TRY.
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.
Thanks

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!

Resources

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