Hi, > -----Original Message----- > From: Devore, Jacob [mailto:[EMAIL PROTECTED]] > Sent: Thursday, December 20, 2001 10:01 AM > To: '[EMAIL PROTECTED]' > Subject: odbc connection problem > > > When I connect through odbc I get a succes with info, when I look at the > info I have a sql state of s1000, native error 0. If I try to query the > database I get an error and the sql state is s1000 with native error code of > 1142. Everything I read on the internet says it's some kind of permissions > thing. I have tried the mysql commands
What is the (warning) message ? Regards, Venu -- For technical support contracts, go to https://order.mysql.com __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Mr. Venu <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Developer /_/ /_/\_, /___/\___\_\___/ California, USA <___/ www.mysql.com > > GRANT ALL PRIVILEGES ON fr6 TO "Devore"@"jdevore-02"; > > INSERT INTO user (Host, User, Password, Select_priv, Insert_priv, > Update_priv, Delete_priv, Create_priv, Drop_priv, Reload_priv, > Shutdown_priv, Process_priv, File_priv, Grant_priv, References_priv, > Index_priv, Alter_priv) VALUES ("jdevore-02", "Devore@jdevore-02", "", "Y", > "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y", "Y"); > > GRANT ALL PRIVILEGES ON fr6 TO "%"@"%"; > > And when I used these it let me connect but I got all those errors. Before > I started adding people to the user table I couldn't even connect. Does > anyone know what I'm doing wrong or is the odbc driver not recommended? > > Thanks, > > jake > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php