MySQLTalk.org MYSQL discussions groups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  straight INSERT          MySQLTalk.org Forum Index -> MySQL ODBC View previous topic :: View next topic   Author Message Federico Balbi Guest Posted: Fri Jun 18, 1999 12:51 pm    Post subject: straight INSERT Hello, I am trying to send a query to MySQL using MyODBC and VC++ fro windows. the driver sends me the following error: *** [Microsoft][ODBC Driver Manager] Invalid cursor state *** i just want to send a query like "INSERT INTO TT (ID, NAME) VALUES (1,'SAM')" No parameters and no cursors, just straight SQL. Any idea?? Thanks, Fede -------------------------------------------------------------------------- Federico Balbi - University of Texas at San Antonio 6518 Spring Well, Apt. KK-1 - San Antonio, TX 78249 e-mail: [email]balbi (AT) poboxes (DOT) com[/email] - URL: http://www.poboxes.com/balbi Back to top Michael Widenius Guest Posted: Mon Jun 28, 1999 6:45 pm    Post subject: straight INSERT Quote: "Federico" == Federico Balbi <fbalbi (AT) lonestar (DOT) jpl.utsa.edu> writes: Federico> Hello, Federico> I am trying to send a query to MySQL using MyODBC and VC++ fro windows. Federico> the driver sends me the following error: Federico> *** [Microsoft][ODBC Driver Manager] Invalid cursor state *** Federico> i just want to send a query like "INSERT INTO TT (ID, NAME) VALUES (1,'SAM')" Federico> No parameters and no cursors, just straight SQL. Federico> Any idea?? Federico> Thanks, Federico> Fede Hi! Could you try to get a MYODBC trace that shows this problem and mail it to me? The MYODBC README file describes how to make a trace file! Yours, Monty *************** Warning commercial signature follows ********** If you like TCX's concept of a 'mostly free' database and free advice, you should at least CONSIDER supporting us that we can afford to keep this service up. http://www.mysql.com/ Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         MySQLTalk.org Forum Index -> MySQL ODBC All times are GMT Page 1 of 1   Jump to: Select a forum MySQL----------------MySQL and JavaMySQL AnnouncementsMySQL++MySQL and .NETMySQL ODBCMySQL and PerlDatabase BenchmarksMySQL BugsMySQL Cluster DiscussionMySQL CommunityMySQL DocumentationEventum DevelopmentEventum General DiscussionMySQL General DiscussionMySQL GUI ToolsMySQL InternalsMySQL CommitsMaxDBMySQL PackagersMySQL Replication DiscussionBrisbane MySQL Users GroupMySQL on Win32  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.