Error 42s02 Mysql Odbc 3.51 Driver
Contents |
Replies | 1 Follower jetsetwilly Wolverhampton Since 1/25/2005 Posts 5 Reputation 70 Reply Stuart Elcocks (jetsetwilly) Posted: 7/14/2005 7:13 AM rated by 0 users error 42s02 mysql odbc 5.1 driver hi,I have just uploaded my website which uses a MYSQL database, the problem
Failed To Call Odbc Driver Connection Utility
i have is as follows.I get the error below whenever a certain page tries to access the mysql databaseERROR
Mysql Odbc 3.51 Driver Windows 7
[42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-standard]Table 'touchofglass.customers' doesn't exist The table does exist but it is 'Customers' with a capital C. ok you might think i will change the table name to 'customers'.I did this
Mysql Odbc 3.51 Driver Could Not Find Driver
but i get the error ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.1.11-standard]Table 'touchofglass.Customers' doesn't exist !!!Why is it doing this to me I have been trying everything i can think off but have not come up with any solution apart from duplicating the tables. so for example i have 'Customers' and 'customers'. This seems to work but obviously its not good practice! It does it on other mysql odbc 3.51 driver access denied for user tables i am using aswell! I dont know wether is MySQL configuration or a vb code problem?Thanks in advance for any help given Jetset | Post Points: 50 sp!ke Richmond, VA Since 9/15/2003 Posts 6,220 Reputation 35,963 Reply Scott Waletzko (sp!ke) replied on 7/14/2005 2:15 PM rated by 0 users I'm not sure if this is just because of the way you worded your post, but you said the following:1) The table is named "customers", and got an error that says "touchofglass.Customers" is not valid.2) You renamed the table to "Customers", and then got an error that says "touchofglass.customers" is not valid.Is it possible that you just changed too much at once and reversed the case of the table in the database and in your code? That would explain why it didn't work until you had a table with each name in your database. | Post Points: 5 jetsetwilly Wolverhampton Since 1/25/2005 Posts 5 Reputation 70 Reply Stuart Elcocks (jetsetwilly) replied on 7/18/2005 9:54 AM rated by 0 users I have checked the sql scrip i.e. SELECT * FROM Customers bla blahand made sure that the case was all the same but it
Reporter: zhong li Email Updates: Status: Closed Impact on me: None Category:Connector / ODBC Severity:S1 (Critical) Version:5.1.8 OS:Linux mysql odbc 3.51 driver access denied for user 'root'@'localhost' (using password yes) (centos5.3) Assigned to: Bogdan Degtyariov Tags: Dg4odbc and mysql odbc View mysql odbc 3.51 driver can't connect to mysql server on 'localhost' (10061) Add Comment Files Developer Edit Submission View Progress Log Contributions [28 Mar 2011 8:43] zhong li Description: download mysql odbc 3.51 driver Using Database Gateway for ODBC (DG4ODBC) 11.1.0.6 from Linux x86-64 to execute DBMS_HS_PASSTHROUGH against a MySQL database with the MySQL ODBC driver version 3.51.12 hangs. A DG4ODBC debug http://vbcity.com/forums/t/103146.aspx trace ends with the statements - Entered hgopdsc at 2008/10/24-13:38:24 Describing procedure username.DBMS_HS_PASSTHROUGH Output hoada hgopdsc, line 1222: NO hoada to print Exiting hgopdsc, rc=942 at 2008/10/24-13:38:24 Entered hgodtab at 2008/10/24-13:38:24 count:1 table: username.DBMS_HS_PASSTHROUGH How to repeat: please refer to oracle metalink url: https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&doctype=PROBLEM&id=748610.1 [28 Mar 2011 8:45] zhong li hgodtab, line 876: NO hoada to https://bugs.mysql.com/bug.php?id=60671 print Exiting hgodtab, rc=0 at 2011/03/28-07:25:00 Entered hgopars, cursor id 2 at 2011/03/28-07:25:00 type:0 SQL text from hgopars, id=2, len=33 ... 00: 53454C45 4354202A 2046524F 4D204442 [SELECT * FROM DB] 10: 4D535F48 535F5041 53535448 524F5547 [MS_HS_PASSTHROUG] 20: 48 [H] Entered hgopoer at 2011/03/28-07:25:00 hgopoer, line 233: got native error 1146 and sqlstate 42S02; message follows... [MySQL][ODBC 5.1 Driver][mysqld-5.1.55-webex--with-unix-socket-path=/home-log]Table 'userregistry.dbms_hs_passthrough' doesn't exist {42S02,NativeErr = 1146} Exiting hgopoer, rc=0 at 2011/03/28-07:25:00 hgopars, line 526: calling SQLNumResultCols got sqlstate 42S02 Exiting hgopars, rc=942 at 2011/03/28-07:25:00 Entered hgodtab at 2011/03/28-07:25:00 Describing procedure DUAL Output hoada hgopdsc, line 1406: NO hoada to print Exiting hgopdsc, rc=942 at 2011/03/28-07:25:00 The hoada for table DUAL follows... hgodtab, line 876: NO hoada to print Exiting hgodtab, rc=0 at 2011/03/28-07:25:00 Entered hgopars, cursor id 2 at 2011/03/28-07:25:00 type:0 SQL text from hgopars, id=2, len=18 ... 00: 53454C45 4354202A 2046524F 4D204455 [SELECT * FROM DU] 10: 414C [AL] Entered hgopoer at 2011/03/28-07:25:00 hgopoer, line 233: got native error 1096 and sqlstate HY000; message follows... [MySQL][ODBC
Oct 2013 7:48 Reporter: An R Email Updates: Status: Verified Impact on me: None Category:Connector / ODBC Severity:S1 (Critical) Version:5.2w OS:Microsoft Windows (vista 64bit) Assigned to: Bogdan Degtyariov Tags: excel 2010, ODBC, powerpivot View Add Comment Files Developer Edit Submission View Progress Log Contributions https://bugs.mysql.com/bug.php?id=69156 [6 May 2013 15:43] An R Description: Related to Bug #69154, after installing both 32 and 64 bit drivers I am able to connect to the MySql database. However when I try to fetch data, I get the error: http://community.discountasp.net/threads/problem-connecting-to-database.1109/ ERROR [HY010] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.27-log] How to repeat: 0) Windows Vista 64bit 0) Install MySql ODBC 32 and 64 bit drivers 1) Open Excel 2010 32bit's PowerPivot add-in (error happens also with 64 bit Excel) 2) Click on 'data mysql odbc from external datasources' 3) Choose ODBC 4) Click on "build ..." 5) On the first tab, choose provider "Microsoft OLE DB Provider for ODBC Drivers". Click next. 6) Chose user DSN 9) Choose catalog. Click OK. 10) Click next 11) Choose write custom query and write a valid query (I wrote 'select * from users;') 12) Click FINISH I get the error: ERROR [HY010] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.27-log] * No logged errors found in %temp%/myodbc.sql [6 May 2013 15:47] An mysql odbc 3.51 R I wish to comment, I am indeed able to 'connect' to the DB (since I can read the list of tables), but I can't fetch data... When fetching data, I get the error: ERROR [HY010] [MySQL][ODBC 5.2(w) Driver][mysqld-5.5.27-log] [6 May 2013 19:02] An R Strangely, it DOES work if one does NOT select a 'catalog' in the data link properties... I was lucky to find this out ! [6 May 2013 21:33] An R sorry, i was mislead by doing a connection in win7 32 bit... in vista 64 bits I cant get it to work... [8 May 2013 5:37] Bogdan Degtyariov Where can I find this PowerPivot addition? I see INSERT/PivotTable, but it does not fit the steps you provided. [9 Jun 2013 1:00] Bugs System No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open". [16 Sep 2013 21:37] Jeremiah Graves I'm having the same issue. However, I cannot get it to work when I don't select a catalog either. [17 Sep 2013 9:24] Bogdan Degtyariov Unfortunately, I was not able to repeat the bug. Also, I need my question answered: Where can I find this PowerPivot addition? I see INSERT/PivotTable, but it does not fit the steps y
Pete I have followed your database migration article (Q10180) and it worked perfectly. Using MySQLCC I can see all my database information on DiscountASP.NET. However, I am having problems accessing the data. I have followed your article : Q10085 - HOWTO: Query MySQL Database in ASP.net, in order to make my database connections. Very simple. However, whenever I run a page that tries to access my database, I get the following error: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-standard-log]Table '[databasename].[tablename]' doesn't exist. where [databasename] is my database in the Discount ASP control panel and [tablename] is my table. However, I see them there using MySQLCC !!! Any ideas about what I am doing wrong ? Here's my code: <%@ Import Namespace="System.Data.Odbc" %> where [username] is my username. [] Thanks ..... Pete, Jul 24, 2004 #1 Bruce DiscountASP.NET Staff Please create a support ticket. Need more sensitve information (username) and stuff to trouble shoot the problem. quote:Originally posted by Pete I have followed your database migration article (Q10180) and it worked perfectly. Using MySQLCC I can see all my database information on DiscountASP.NET. However, I am having problems accessing the data. I have followed your article : Q10085 - HOWTO: Query MySQL Database in ASP.net, in order to make my database connections. Very simple. However, whenever I run a page that tries to access my database, I get the following error: ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-4.0.18-standard-log]Table '[databasename].[tablename]' doesn't exist. where [databasename] is my database in the Discount ASP control panel and [tablename] is my table. However, I see them there using MySQLCC !!! Any ideas about what I am doing wrong ? Here's my code: <%@ Import Namespace="System.Data.Odbc" %> where [username] is my username. [] Thanks .....