Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

sp_preprexec error

 
   Database Forums (Home) -> ODBC RSS
Next:  Connection Error -2147217843  
Author Message
Mark

External


Since: Mar 16, 2006
Posts: 66



(Msg. 1) Posted: Wed Jun 11, 2008 5:34 pm
Post subject: sp_preprexec error
Archived from groups: microsoft>public>sqlserver>odbc (more info?)

Hello,

I am receiving the following error when sending a paramaterized statement
from a web page to SQL Server via ODBC connection

Msg 8179, Level 16, State 2, Procedure sp_prepexec, Line 1
Could not find prepared statement with handle 1.


Here is the captured statements received by SQL server (captured by Profiler):

declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P1 nvarchar(5)',N'SELECT userid
FROM usertable
WHERE username = @P1
',N'admin'
select @p1

The odd thing is, if I copy and paste into Query Anylzer, and comment out
line 2 (set @p1=1), it works fine.....uncomment line 2 and I get the same
error.

Can anyone tell me the cause of this and a possible work around? I don't
know how to tell the CGI script on the web page not set a value of @p1 (not
sure it is even responsible for doing it).

Thanks,
Mark

 >> Stay informed about: sp_preprexec error 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
Error 23 (CRC error) - We're accessing a SQL Server database across a network from another SQL Server database using an LSN. Both installations are SQL Server 2000 sp 3a. Of the 50 or so ODBC views available from the target database, 2 fail with an error 23 CRC error messag...

10054 Error - I would like some help with error... I have test all networking and everything checks out ok. 2006/04/02 20:51:12.742/-0544:053C/WWSQL /10054: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionWrite (send()).[Microsoft][ODBC SQL Serve...

Error SQL 2005 + CRM - Whe i Install crm 3.0 send me this error Please help me The program install donīt check if SQL Server Agent are running (SQLSERVERAGENT) [DBNETLIB][ConnectionOpen (Connect()).]Doesnīt exist SQL Server or denied the access I fin in more pages the..

ODBC ERROR - We have a DTS package to upload data from SQL to PARADOX. We are using the Microsoft Paradox- treiber driver. Data is uploaded from 2 sql tables to 2 paradox tables. Upload for one table works, but for the other one, we get the following error..

Row Insertion Error - I am writing code to interface with a pre-existing and unchangeable dBase database that we access through ODBC. This database has column names of the format "NAME$0101" and "NAME$0102" etc. These column names work fine for retrie...
   Database Forums (Home) -> ODBC All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]