|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
January 28th, 2005, 05:48 AM
|
|||
|
|||
Error '80040e10'
Hi, trying to query a SQL 2000 d-base from an asp page form on my development site and I get the wonderfully useful error '80040e10'. The live site with exactly the same code works fine. Could this be a permissions problem?
|
|
#2
January 28th, 2005, 06:04 AM
|
||||
|
||||
|
yes, it could be permissions. try writing your sql string onto the page, and executing it in query analyser using the anonomous account or one with similar priviledges and see what the actual error is.
|
|
#3
January 28th, 2005, 06:21 AM
|
|||
|
|||
|
Quote:
Thanks, I'll give that a try and check back...
|
|
#4
February 4th, 2005, 06:51 AM
|
|||
|
|||
|
OK, bit more info here... This code in the page is referencing a stored procedure. The error pinpoints line 36 (Set rs = cmd.Execute).
cnn.Open connSQL cmd.ActiveConnection = connSQL cmd.CommandText = "spRegion_Search" cmd.CommandType = 4 cmd.Parameters.refresh cmd.Parameters("@vRegion").Value = Request.Form("area") cmd.Parameters("@vLanguage").Value = Request.Form("lang") cmd.Parameters("@vEndorsement").Value = Request.Form("endorsement") cmd.Parameters("@vEndorsement2").Value = Request.Form("endorsement2") cmd.Parameters("@vEndorsement3").Value = Request.Form("endorsement3") cmd.Parameters("@vTopic").Value = Request.Form("topic") cmd.Parameters("@vTopic2").Value = Request.Form("topic2") cmd.Parameters("@vLocation").Value = Request.Form("location") cmd.Parameters("@vDriver").Value = Request.Form("driver") Set rs = cmd.Execute
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > Error '80040e10' |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
