But if the error is "Application-defined or object-defined error" that isn't going to be much help. I guess 80040E14 means "it didnt work" possible causes include: a genuine syntax error attempting to insert null values into a column that doesnt allow nulls. When I press the debug button the line highlighted is - conn.Execute insertsql Here is my code Private Sub cmdOrder_Click() Dim insertsql As String insertsql = " INSERT INTO Order ( Perhaps you would care to demonstrate why you believe the facts are as you state them, rather than just stating them as you have.
Editing MSFlexGrid by users Very simple updater 63 More VB Tutorials... Try the SolarWinds Engineer's Toolset now! Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. But I don't want to do that. http://www.adopenstatic.com/faq/80040e14.asp
The error then shuts down the application which is NEVER a good thing. All times are GMT -5. The time now is 10:42 PM. Hope this helps.
sql-server asp-classic ado share|improve this question edited Oct 3 '11 at 2:01 asked Oct 3 '11 at 1:53 Control Freak 6,3421753100 add a comment| 1 Answer 1 active oldest votes up Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #4 maj3091 D.I.C Lover Reputation: 327 Posts: 1,944 Joined: 26-March 09 Re: VB6 Runtime Error -2147217900 (80040e14) Posted Error 80040E37Invalid Syntax. 0x80040e14 Ssis You will only give yourself grief.
There are a number of possible causes: Scenario 1 - Syntax error in FROM clause Scenario 2a - Syntax error in INSERT INTO statement Scenario 2b - Syntax error in UPDATE Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. © 2013 John Wiley & Sons, Inc. an argument data type text is invalid for argument a permissions error an invalid object name. Please remove it and check the code.
MS Sql Server 2008 by the way. –Control Freak Oct 3 '11 at 2:21 Do you mean inside the procedure? 80040e14 Incorrect Syntax Near Index is a reserved word in ms-acces. Attached Images Reply With Quote Oct 12th, 2011,08:40 AM #2 joshAU View Profile View Forum Posts Lively Member Join Date Dec 2008 Location Hobart, Tasmania Posts 104 Re: 80040e14 error Reply With Quote Oct 13th, 2011,03:40 AM #8 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Posts 38,273 Re: 80040e14 error We can't help
SQL 'Select' statement formatter/checker .•. http://www.vbforums.com/showthread.php?662398-RESOLVED-80040e14-error just some ideas... Ado Error Code 80040e14 Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Ado Error 2147217900 So, how would the Run-time error '-214217900(80040e14)' be trapped?
I was working today so didnt have the chance to post it was sorted until now. Results 1 to 3 of 3 Thread: ADO/SQL error -2147217900 (80040e14) Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to If you can't adjust your fieldnames you can use [ ] marks to delimit the field names, eg INSERT INTO table1 ([field], [password]) VALUES ('value1', 'value2') Scenario 2b - Syntax error Example Script 1 ' Get Domain name from RootDSE object. Error 80040e14 Incorrect Syntax Near
Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #6 maj3091 D.I.C Lover Reputation: 327 Posts: 1,944 Joined: 26-March 09 Re: VB6 Runtime Error -2147217900 (80040e14) Posted So, back to the original question: how then may this error be trapped? Tutorial: How to automate Excel from VB6 (or VB5/VBA) .•. Note: I have attached my sample VI named 'Untitled 1' .
The error message presents itself without benefit of going to ANY error handler and 'happily' shuts down the application. The user and database has been added to the system dsn AccessSQL, user and passwords works fine in query analyzer.. But I will recap. 1.
ie databasename.dbo.tablename? TIA Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #8 BobRodes Lovable Curmudgeon Reputation: 600 Posts: 3,068 Joined: 19-May 09 Re: VB6 Runtime Error -2147217900 (80040e14) Sorry I cannot provide more help at the moment... Thanks again.
string?, integer, double? Sorry, I'm about to head to bed, after 1:30 am here... Does MyTableName contain the full name to the database table? Was This Post Helpful? 0 Back to top MultiQuote Quote + Reply #13 BobRodes Lovable Curmudgeon Reputation: 600 Posts: 3,068 Joined: 19-May 09 Re: VB6 Runtime Error -2147217900 (80040e14) Posted
You haven't explained HOW you experienced what you experienced, and I would like to know. I believe that this at least makes clear why I've said you're wrong. All times are GMT -4.