DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = DB Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 2

SELECT * FROM `user` the_table WHERE the_table.userid = why is the MS sql server driver telling me "too many parameters specified"? - iTechForums
Login
Search
Welcome to the iTechForums.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 2
Members:
Number of Users Online:
Welcome to our newest member,
iTechForums » Databases » MS SQL »

why is the MS sql server driver telling me "too many parameters specified"?

Reply
 
Thread Tools Display Modes
  #1  
Old 05-06-2008, 06:20 PM
GeneWeen GeneWeen is offline
Junior Member
  
Join Date: May 2008
Posts: 1
Default

why is the MS sql server driver telling me "too many parameters specified"?
I wrote an application that allows me to swap drivers on the fly, and I tried this new MS driver for SQL server and one stored procedure is erroring. The error is telling me that there are too many parameters, but when I take one away it complains about not enough parameters. So I hard coded the values to make sure the issues wasn't the data, and I got the same error. My thinking right now is MS had to limit the number of parameters on the driver itself, but I don't know that for a fact. I do know the jTDS driver works flawlessly, but this MS driver is starting to piss me off. I just want to know wtf is wrong with this POS. The thing that is really confusing me is that the other stored procedure(done in the same manner) run without complaint.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2  
Old 05-06-2008, 06:21 PM
Chief Chief is offline
Junior Member
  
Join Date: May 2008
Posts: 1
Default
Wish I could help. Freaking MS
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply

« Previous Thread | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Your Ad Here

All times are GMT. The time now is 06:53 AM.
Contact Us - Archive - Top