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 |
|
taylo
Yak Posting Veteran
82 Posts |
 Posted - 2001-01-29 : 12:01:10
|
| I am using SQL Server 7. While I am using ASP to draw from the dB, I believe the following error has something to do with the table.This is the querySelect FirstName,LastName from SiteMembers Where ParentNumber = 1 This is the errorADODB.Connection error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /test2.asp, line 5 A stored proc with this same code checks fine for syntax.I also have no problems in the SQL Pane on the SQL Server.But hwne I try to run this from my ASP it gives this error. Please not I am using this table in another place using INNER JOINS with no troubles.But I still think something is wrong with the table.If anyone has any suggestions, please tell me. The syntax is 100% correct in the ASP code. So please do not write in with formatting options or suggestions to check the data type. All of this is correct.Thanks,Rob |
|
|
|
|
|
Has anyone seen this odd SQL Error