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 - 2005-02-01 : 07:57:30
|
| g3 writes "Hi allI had developped a vc++ application using SQL server 2000 as back end.I am dumpping 140 MB file to the table using BULK INSERT statement with 500 batch size.Even then sometimes I am getting timeout expired error.So i changed the ODBC Connection Polling retry wait time from 120 to 520.then sometimes i am not getting timeout.worst thing is sometimes application is terminating successfully without dumpping the entire file.can any one help me out to solve this problemit is very very urgentthanx in advance,g3." |
|
|
|
|
|
Timeout expired while using Bulk Insert from vc++ application