Engine Error 80040e07
JET Database Engine error '80040e07' The SitePoint Forums have moved. You can now find them here. This forum is now closed to new posts, but you can browse existing content. You can find out more information about the move and how to open a new account (if necessary) here. If you get stuck you can get support by emailing forums@sitepoint.com If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. SitePoint Sponsor User Tag List Page 1 of 3 123 Last Jump to page: Results 1 to 25 of 56 Thread: Microsoft JET Database Engine error '80040e07' Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 14, 2013,17:26 #1 DoomedVash View Profile View Forum Posts SitePoint Enthusiast Join Date Feb 2013 Posts 26 Mentioned 0 Post(s) Tagged 0 Thread(s) Microsoft JET Database Engine error '80040e07' Hello all! I hope you guys can help me. I have an old ASP-based gaming event system running on my Windows Server 2008 R2 with ASPClassic enabled. Everything works fine so. Until I try to calculate the statistics for an event. Then I get this error: Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /wargames/includes/include.asp, line 3815 This is my code: Code: function RecalcGameRC(iGameID) ' Set up variables and structures dim sDebugResults dim SQL, rsMatches, rsPlayer, rsPoints, iMaxClubPlayers, iMaxGamesPlayed, iMinGamesHosted, iMaxAttritionRt dim iGames, vWarsList, index, iWarID, sMatchList, sPlayerName, iUniquePlayersIndex, vPlayerMatches, iMaxUPP, iMaxhrp, iMaxVictoryRt dim iRanking, iMaxPP, iAveragePlayerRanking, iPlayerID, iPoints, iKills, iDeaths, iMaxTotBases, iMaxTeamBases, iMaxAIBonus, iMaxAITeamBonus dim iVictoryRT, iAttritionRT, iMaxTeamPlayers, hostedrankingtemp, hostedrankingtemp1, iMatchBonus, iLMatchBonus, iPlayerMatchBonus, iTotAIRT, iTotBaseRT dim hrp set rsMatches = server.createobject("ADODB.Recordset") set rsPlayer = server.createobject("ADODB.Recordset") set rsPoints = server.createobject("ADODB.Recordset") application.lock dbConnection.execute "delete from war_playergamerankings where gam
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ASP Error - Microsoft JET Database Engine error '80040e07' up vote 1 down vote favorite im having trouble with a registration form connecting to a database and storing the data, below http://www.sitepoint.com/forums/showthread.php?975855-Microsoft-JET-Database-Engine-error-80040e07 is the error im getting. Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /mus0280/coursework2/storefuncs.asp, line 330 This is the code snipet, i have have checked if the data types are the same in the database and the whole website. ' Add New User to Database sqlString = "INSERT INTO users ( " &_ "user_username, " &_ "user_password, " &_ "user_email," &_ "user_address, " &_ "user_city," &_ "user_postcode," &_ "user_cardnumber, " &_ "user_cardtype, " &_ "user_cardexpiremonth," http://stackoverflow.com/questions/8810959/asp-error-microsoft-jet-database-engine-error-80040e07 &_ "user_cardexpireyear," &_ "user_cardname," &_ "user_HTML" &_ ") VALUES ( " &_ " '" & fixQuotes( newusername ) & "', " &_ " '" & fixQuotes( newpassword ) & "', " &_ " '" & fixQuotes( email ) & "', " &_ " '" & fixQuotes( address ) & "', " &_ " '" & fixQuotes( city ) & "', " &_ " '" & fixQuotes( postcode ) & "', " &_ " '" & fixQuotes( cardnumber ) & "', " &_ " '" & cardtype & "', " &_ " '" & cardexpiremonth & "', " &_ " '" & cardexpireyear & "', " &_ " '" & fixQuotes( cardname ) & "', " &_ " " & html & " " &_ ")" Con.Execute sqlString - this is line 330 database asp-classic jet share|improve this question edited Jan 10 '12 at 22:06 Glenn Slaven 19.7k2287149 asked Jan 10 '12 at 21:46 mussi89 3229 1 can you print out the string so we can see it's final outcome ? –Jordan Jan 10 '12 at 21:48 hi sorry for the unedited code, new here, anyway i figured out that the problem was with the write permissions on the folder. –mussi89 Jan 10 '12 at 22:10 Wow, what an obtuse error message for that problem eh? –Jordan Jan 10 '12 at 22:35 2 @mussi89 please explain your fix as
your SELECT engine error SQL query statement. The following table illustrates the delimiters required for each type of field: Field Type (Access) Field engine error 80040e07 Type (SQL Server) Delimiter Text Char, varChar ' Numeric Any numeric type
a Question Need help? Post your question and get tips & solutions from a community of 418,502 IT Pros & Developers. It's quick & easy. error '80040e07' wrong syntax in Date expression P: n/a Aloof Using Access 2000 Windows Server 2003 The following code worked fine until we moved hosting companies StartDate = Request.Form("StartDateMonth") & "/" & Request.Form ("StartDateDay") & "/" & Request.Form("StartDateYear") EndDate = Request.Form("EndDateMonth") & "/" & Request.Form ("EndDateDay") & "/" & Request.Form("EndDateYear") sql = "SELECT DISTINCT tblSessions.VisitorID FROM tblSessions WHERE tblSessions.DateTimeEntrance Between #" & StartDate & " 0:0:1# And #" & EndDate & " 23:59:59#;" set RSVisitors = cn.execute("sql") Response.write sql gives: SELECT DISTINCT tblSessions.VisitorID FROM tblSessions WHERE tblSessions.DateTimeEntrance Between #06/01/2005 0:0:1# And #06/31/2005 23:59:59#; Now the same code gives an error message: Microsoft JET Database Engine error '80040e07' Syntax error in date in query expression 'tblSessions.DateTimeEntrance Between #06/01/2005 0:0:1# And #06/31/2005 23:59:59#'. /stats/stats_detail.asp, line 33 The old hosting company was Win2003, as is the new company. I've tried changing the order of the date parts (YYYY/MM/DD, MM/DD/YYYY, YYYY/DD/MM) but nonoe of the formats make a difference. Any ideas? TIA Jul 22 '05 #1 Post Reply Share this Question 2 Replies P: n/a Bob Barrows [MVP] Aloof wrote: Using Access 2000 Windows Server 2003 The following code worked fine until we moved hosting companies StartDate = Request.Form("StartDateMonth") & "/" & Request.Form ("StartDateDay") & "/" & Request.Form("StartDateYear") EndDate = Request.Form("EndDateMonth") & "/" & Request.Form ("EndDateDay") & "/" & Request.Form("EndDateYear") sql = "SELECT DISTINCT tblSessions.VisitorID FROM tblSessions WHERE tblSessions.DateTimeEntrance Between #" & StartDate & " 0:0:1# And #" & EndDate & " 23:59:59#;" set RSVisitors = cn.execute("sql") Response.write sql gives: SELECT DISTINCT tblSessions.VisitorID FROM tblSessions WHERE tblSes