Error Number 40002
360 games PC games Windows games Windows phone games Entertainment All Entertainment Movies & TV Music Business & Education Business Students & educators Developers Sale Sale Find a store Gift cards Products Software & services Windows Office Free downloads & security Internet Explorer Microsoft Edge Skype OneNote OneDrive Microsoft Health MSN Bing Microsoft Groove Microsoft Movies & TV Devices & Xbox All Microsoft devices Microsoft Surface All Windows PCs & tablets PC accessories Xbox & games Microsoft Lumia All Windows phones Microsoft HoloLens For business Cloud Platform Microsoft Azure Microsoft Dynamics Windows for business Office for business Skype for business Surface for business Enterprise solutions Small business solutions Find a solutions provider Volume Licensing For developers & IT pros Develop Windows apps Microsoft Azure MSDN TechNet Visual Studio For students & educators Office for students OneNote in classroom Shop PCs & tablets perfect for students Microsoft in Education Support Sign in Cart Cart Javascript is disabled Please enable javascript and refresh the page Cookies are disabled Please enable cookies and refresh the page CV: {{ getCv() }} English (United States) Terms of use Privacy & cookies Trademarks © 2016 Microsoft
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Run-time error '40002' S1T00:[Microsoft][ODBC SQL Server Driver] Timeout Expired Want to Advertise https://support.microsoft.com/en-us/kb/963953 Here? Solved Run-time error '40002' S1T00:[Microsoft][ODBC SQL Server Driver] Timeout Expired Posted on 2006-10-17 MS SQL Server 2 Verified Solutions 2 Comments 7,256 Views Last Modified: 2009-05-15 Hi, I am testing some applications which are written in VB with backend as SQL Server 2000. This applications runs for hours since the applications has to https://www.experts-exchange.com/questions/22027108/Run-time-error-'40002'-S1T00-Microsoft-ODBC-SQL-Server-Driver-Timeout-Expired.html deal with huge text files (in GBs). they usually bulk insert these huge files into Database and then does some operations on the DB. While testing these applications i am recieving three types of Errors (Each from different application): Error 1: Run-time error '40002' S1T00:[Microsoft][ODBC SQL Server Driver]Timeout Expired Error 2: Bulk Insert Fails. Column too long. Make sure field terminator and row terminator are specified correctly. Run-time error -21472117900(80040e14) Error 3: Could not bulk insert because file 'e:\code\abc.txt' could not be opened. Operating system error code 32 (The process cannot use this file because it is being used by another process.) These two errors are generated from two different Applications. please send me an appropraite cause of these errors. Regards, CCSE 0 Question by:ccsenet Facebook Twitter LinkedIn Google LVL 142 Active today Best Solution byGuy Hengel [angelIII / a3] >Error 1: >Run-time error '40002' S1T00:[Microsoft][ODBC SQL Server Driver]Timeout Expired well, the query you tried to execute simply took longer than the
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today https://www.experts-exchange.com/questions/10101247/Urgent-Run-time-error-'40002'.html Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Urgent !!!! - Run-time error '40002' Want to Advertise Here? Solved Urgent !!!! - Run-time error '40002' Posted on 1998-11-23 MS SQL Server http://www.dreamincode.net/forums/topic/289070-run-time-error40002/ 1 Verified Solution 14 Comments 2,014 Views Last Modified: 2008-03-17 The GUI of my application is developed using Visual Basic 5.0 and it talks to the SQL Server 6.5 DB. While executing on of the menu option, I encountered error number this error message: Run-time error '40002' 01000:[Microsoft][ODBC SQL Server Driver][DBNMPNTW]. 0 Question by:chuatj Facebook Twitter LinkedIn Google LVL 3 Best Solution byStefaan I will simply post the answer again. Chuatj, I'm almost sure the problem lies with one of the client DLL's. Try to reinstall the client files on that PC, and also make sure you applied the same Go to Solution 14 Comments LVL 3 Overall: Level 3 MS SQL Server 1 Message Expert Comment by:Stefaan1998-11-23 The DBNMPNTW.DLL error number 40002 is net Net-Library for Named Pipes, so I guess there is something wrong whit the Net-Library of the Client (or the Server). Check if the Network Libraries are installed on the Client PC. If they are installed on the client PC, check if there is a PATH reference to the directory in which the DLL's are stored. 0 Message Expert Comment by:idswizzard1998-11-25 I would check the ODBC driver for the SQL database in either the user or the system DSN area of ODBC32. This can happen when the system can not open the database using the ODBC call using named pipes. The second would be to check permissions on the database table you are trying to access. This can also trip it up. However, if you can go to the ODBC control panel and successfully attach to the server, then the ODBC driver should work in the code. Just make sure your attach string is correct. 0 Message Author Comment by:chuatj1998-11-26 The ODBC driver are OK, as we are able to connect to the database. And it is also not the problem of permission to access certain table, because such problem would not cause run time error. In fact, we are trying the proposal put up by Stefaan, as the problem only happened to one of the clients. 0 LVL 3 Overall: Level 3 MS SQL Server 1 Message Expert Comment by:Stefaan1998-11-26 Chuatj, I'm al
3 Replies - 7709 Views - Last Post: 17 August 2012 - 08:09 AM Rate Topic: #1 TFPTECH New D.I.C Head Reputation: 0 Posts: 6 Joined: 15-August 12 Run-time error'40002' Posted 16 August 2012 - 09:04 AM 'THE 3 LINES OF BELOW SHOW THE KIND OF MESSAGE I AM GETTING WHEN I TRY TO SEND DATA TO THE DATABASE ' I HAVE LEBELED THE 1, 2, 3 '1. Run-time error'40002' '2. s1000: [MySQL][ODBC 3.51 Driver][mysqld-5.5.24]Incorect '3. value: 'Text2' for age at row 1 Option Explicit Dim cnMySql As New rdoConnection Dim rdoQry As New rdoQuery Dim rdoRS As rdoResultset Dim Text2 As String Dim age As Integer Private Sub Form_Load() cnMySql.CursorDriver = rdUseOdbc cnMySql.Connect = "uid=root;pwd=moses12;server=localhost;driver={MySQL ODBC 3.51 Driver};database=SRMS;dsn=SRMS;" End Sub Private Sub cmdSave_Click() Text2 = age If age >= 6 Then 'Text4(1).Text = Text4(1).Text + 1 cnMySql.EstablishConnection With rdoQry .Name = "root" .SQL = "insert into regstudent (n_Student,age,sex,nationality,p_birth,d_birth,religion,f_name,tel,occupation,w_place,F_address,m_name,tel2,occupation2,w_place2,F2_address,prev_school,Location,grade_attained,aggregates,code) values ('Text1','Text2','Text3','Text4','Text5','Text6','Text7','Text8','Text9','Text10','Text11','Text12','Text13','Text14','Text15','Text16','Text17','Text18','Text19','Text20','Text21','Text22')" '.SQL = "Insert into regstudent (admin,tester,user2,user3,user4) VALUES ('101','202','303','404','505')" Set .ActiveConnection = cnMySql 'THIS LINE IS HIGHLIGHTED YOLEW Set rdoRS = .OpenResultset(rdOpenKeyset, rdConcurRowVer) End With rdoRS.Close cnMySql.Close 'End If End Sub Is This A Good Question/Topic? 0 Back to top MultiQuote Quote + Reply Replies To: Run-time error'40002' #2 maj3091 D.I.C Lover Reputation: 327 Posts: 1,945 Joined: 26-March 09 Re: Run-time error'40002' Posted 17 August 2012 - 07:33 AM The first question, is what is the DataType of Age in your database? Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #3 TFPTECH New D.I.C Head Reputation: 0 Posts: 6 Joined: 15-August 12 Re: Run-time error'40002' Posted 17 August 2012 - 07:52 AM maj3091, on 17 August 2012 - 07:33 AM, said:its an integer in the MYSQL table Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #4 maj3091 D.I.C Lover Reputation: 327 Posts: 1,945 Joined: 26-March 09