Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
ODBC Freeze
After further testing it appears that this is a problem with the ODBC connection and its interaction with the SQL server. Either the ODBC connection or the SQL server or the SQL job is going to sleep in some way part the way through the load. Once the task has frozen if we Test the ODBC... -
ODBC Freeze
We have a sequence of calls to a SQL server via ODBC that we use to poulate an OLAP server. This generally works very well, however we occasionaly get part the way through the sequence and the OLAP server freezes. It is not the same part of the sequence each time. There are many areas for us...
