ISAM Table Not Found 1

[Vijay7475]

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

 

[ShankarJ]

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

 

[Vijay7475]

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