I have written some perl code that reads web log files, loads them into a MSSQL 7.0 database for processing on a WINNT server.
I use the DBI module for my connection and SQL code.
I have been running my perl script for over a year now without any problems.
Last week I updated the DBI and DBD-ODBC modules and now I have a problem.
With the old modules using the same environment, there would be 24000 records loaded into a table. With the new modules, I either get 292 or ~5500.
I know it is not stopping partially through because the data loaded proves that as follows:
A) There is data loaded from all parts of the data file.
B) The primary key is auto incremented and there are wholes in the sequence.
Does anyone have any idea of what the problem could be or where to start looking to fix the problem.
The perl script has not changed in case you are wondering.
Your help is appreciated.
Thank you.
I use the DBI module for my connection and SQL code.
I have been running my perl script for over a year now without any problems.
Last week I updated the DBI and DBD-ODBC modules and now I have a problem.
With the old modules using the same environment, there would be 24000 records loaded into a table. With the new modules, I either get 292 or ~5500.
I know it is not stopping partially through because the data loaded proves that as follows:
A) There is data loaded from all parts of the data file.
B) The primary key is auto incremented and there are wholes in the sequence.
Does anyone have any idea of what the problem could be or where to start looking to fix the problem.
The perl script has not changed in case you are wondering.
Your help is appreciated.
Thank you.