MySQL Forums
Forum List  »  Newbie

Simple Select using ASP/IIS
Posted by: Mark McCartney
Date: June 03, 2005 11:02AM

Trying to run a simple select (my first!) using my local host machine.

FYI:
connection string = "Driver=MySQL; Server=localhost; Port=3306; Option=0; Socket=; Stmt=; Database=DATABASENAME; Uid=USERNAME; Pwd=USERPASS;"

(databasename, uID, Pwd have been changed to protect the innocent) - the connection works.

When I try to run my select i get the following error

Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
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 '{ call SELECT gg_user.* FROM gg_user }' at line 1

My actual text is "SELECT gg_user.* FROM gg_user" - why does it append "{ call }" to my statement? Is there a setting to stop that?

I know, this is probably a 1,2,3 fix sort of thing - but i just cant figure it out.

Options: ReplyQuote


Subject
Written By
Posted
Simple Select using ASP/IIS
June 03, 2005 11:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.