Get 20% discount on our Yearly Subscription and save €118/$137. The offer expires on 31st of August!
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
March 26, 2001 by George Petrov

Question:


I have noticed several people have been receiving this error as well as myself. I'm using an Access 2000 DB & I've tried it on SQL 7.0.

I receive this error on BOTH types of DBs:

Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Invalid SQL statement; expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT', or 'UPDATE'.

Any resolution to this so far?

Answer:


Identity works with Access 2000 ONLY if you use the "Jet OLEDB Provider 4.0"!

So define your ODBC connection not with "Microsoft Access Driver" but with "Jet OLEDB Provider 4.0". So your connection string should look like:

"Provider=Microsoft.Jet.OLEDB.4.0;Data source="C":\Backup\OBS\Development\Db\obs2k.mdb;Persist Security info="False""

If you use a DSN-Less connection. Otherwise its in the ODBC Settings.

Read more about this in the following ASPWATCH article

George Petrov

George PetrovGeorge Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. His expertise in countless languages and technologies gives inspiration and teach valuable lessons on his website – DMXzone.com which is most popular for its over high-quality Dreamweaver extensions and templates.

See All Postings From George Petrov >>

Place your comment about Microsoft OLE DB Provider for ODBC Drivers error '80040e14'




You must me logged in to write a comment
Comments
Never did get this working.
November 15, 2004 by G Ether

Dreamweaver MX, I did also get the js error but got the path fixed but no matter what I did I got error messages and IIS 5 error loading the page.

I use a redirect page that gives me the session NewID then go to the form page and have a hidden field for the NewID to insert into the database using the standard MX insert code..

I used this code http://www.drdev.net/article06.htm and they helped with  modification and replaced intNewID = rsNewID(0) with this. Session(“NewID”) = rsNewID(0) 

Reserved words
March 1, 2004 by Johan Arvidsson

The error message can also be shown if the name of one or more fields in the database is a MS Jet reserved word or includes a reserved sign like '-', ie 'ID-person'. A list of reserved words can be found on microsofts webpage, http://support.microsoft.com/default.aspx?scid=kb;EN-US;321266

Best regards,

Johan

RE: RE: RE: RE: Microsoft JET Database Engine error '80040e14'
December 4, 2003 by Simone Berretti
Thank you very much for the help
RE: RE: RE: Microsoft JET Database Engine error '80040e14'
December 4, 2003 by ben dykes

Yes, DWMX had written the SQL statement incorrectly there were two ' ' missing from the code:

insertCustID.CommandText = "INSERT INTO tblCustID (cust) VALUES (" + Replace(insertCustID__varCust, "'", "''") + ")"

Should be:

insertCustID.CommandText = "INSERT INTO tblCustID (cust) VALUES ('" + Replace(insertCustID__varCust, "'", "''") + "')"

See all 15 Comments