Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

mmchenney

Technical User
May 16, 2001
16
0
0
US
Getting the following error:

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

[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.

/regions/webpages/HHSC_Voice_Consolidation/UpdateDelete.asp, line 15

My Code:

<%@LANGUAGE=&quot;VBSCRIPT&quot;%>
<!--#include virtual=&quot;/regions/Connections/regional_personnel1.asp&quot; -->
<%
Dim Recordset1__MMColParam
Recordset1__MMColParam = &quot;1&quot;
if (Request.QueryString(&quot;Select&quot;) <> &quot;&quot;) then Recordset1__MMColParam = Request.QueryString(&quot;Select&quot;)
%>
<%
set Recordset1 = Server.CreateObject(&quot;ADODB.Recordset&quot;)
Recordset1.ActiveConnection = MM_regional_personnel1_STRING
Recordset1.Source = &quot;SELECT * FROM HHSC_VoiceInventory WHERE region = '&quot; & Session(&quot;region&quot;)& &quot;' ORDER BY city ASC&quot;
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open()
Recordset1_numRows = 0
%>
<%
Dim Repeat1__numRows
Repeat1__numRows = -1
Dim Repeat1__index
Repeat1__index = 0
Recordset1_numRows = Recordset1_numRows + Repeat1__numRows
%>
 
Have you had the system debug print out the resulting SQL? The error suggests that you have a datatype mismatch in your WHERE clause when the SQL is hitting the database. If you are pulling region from the session cookie, then it may need to be cast to a string or number depending on your table design. The quickest way to verify this is to output the SQL and then run it within the Database petersdaniel@hotmail.com
&quot;If A equals success, then the formula is: A=X+Y+Z. X is work. Y is play. Z is keep your mouth shut.&quot; --Albert Einstein

 
petersdaniel:
The suggestion is great and sure to work out
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top