Need help with SQL error. Driver related I think.

<i><b>Originally posted by : Michael (mtm@houston.rr.com)</b></i><br />I've got a problem with an ASP based website that was written by somebody else. The owners want a new feature added so I'm trying to figure out this guy's code. (fun, fun, fun!) I've got PWS and SQL 7.0 installed and running on my Win8 PC. I've got their database running and I can connect to it. However, one page is giving me the following error:<br /><br />"nable to retrieve results for the criteria that you have entered.<br />-2147217900<br />[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@P1ORDER'.<br />Microsoft OLE DB Provider for ODBC Drivers"<br /><br />I can't find a reference to the variable '@P1ORDER' anywhere in any file, whether its an ASP file or an include file. I'm fairly new at ASP and SQL so I'm kinda stumped. Any help would be great.<br /><br />Thanks,<br />Michael<br /><br />

<i><b>Originally posted by : Jerry (techsearch@abusinessresource.com)</b></i><br />Michael,<br /><br />I'm curious if you are using any stored procedures (command objects) to reference the database? If so, could the var @P1ORDER be in your stored procedure?<br /><br />------------<br />Michael at 11/30/2000 4:17:30 PM<br /><br />I've got a problem with an ASP based website that was written by somebody else. The owners want a new feature added so I'm trying to figure out this guy's code. (fun, fun, fun!) I've got PWS and SQL 7.0 installed and running on my Win8 PC. I've got their database running and I can connect to it. However, one page is giving me the following error:<br /><br />"nable to retrieve results for the criteria that you have entered.<br />-2147217900<br />[Microsoft][ODBC SQL Server Driver][SQL Server]Must declare the variable '@P1ORDER'.<br />Microsoft OLE DB Provider for ODBC Drivers"<br /><br />I can't find a reference to the variable '@P1ORDER' anywhere in any file, whether its an ASP file or an include file. I'm fairly new at ASP and SQL so I'm kinda stumped. Any help would be great.<br /><br />Thanks,<br />Michael<br /><br />