Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-09-03 : 08:31:52
|
| Keith writes "Good afternoon, I have some issues regarding an ODBC Connection to a SQL 7.0 DB via an NT 4.0 sp6a machine. I have an application that sends queries every 2 minutes to our ERP system, extracts data from the ERP system and puts data into a SQL Database. Our company makes our own connector for running queries like this. Within this application, it is possible to do 2 types of Sync. Changed data sync pulls down only data that has been changed since the last table sync. Full Table sync pulls down all data in that table, regardless of if it has been changed or not.If I let the syncs run on schedule, I get an error in the log file saying "Microsoft OLE DB Provider for ODBC Drivers","Errors occurred", during a changed data sync. I am no longer able to do changed data syncs until I complete a full table sync. I first thought that maybe a timeout was happening. The IT person here on site installed a 1000mb switch and we ativated the 1000mb card on the server to increase bandwidth between servers. Since I have done that, I have still ran into the error. SQL server has no errors, the log is missing an error code. How do I go about tracing this error efficiently? This error does not occure on cue. It is very random. This being said, I will need some sort of a long term trace that will be able to run for long periods of time.Any help you can give me is greatly appreciated.Thanks-Keith"Edited by - robvolk on 09/03/2002 08:32:25 |
|
|
|
|
|
ODBC Error