Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-02-07 : 17:54:00
|
Paul writes "I keep getting the following message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e07'
[Microsoft][ODBC Microsoft Access Driver] Data type mismatch in criteria expression.
for the 3rd line of code below:
set connclient = server.createobject("ADODB.Connection")
connclient.open "revlight"
connclient.execute(SQLCLIENT) <<<<<
This code has worded once on a test, but now stalls with this error and it looks perfectly ok to me........ any ideas??
I am using Win95 with PWS to display my asp pages, and the page in question has no html, is just used to insert 19 records into an Access database before ReDirecting to a final page." |
|
|
|
|
|
INSERT via SQL