Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• mysql openssl Question
• mysql:it 's a db not a dbms how it 's possible?!
• Does the binary log enabling affect the MySQL performances?
• Strange behavior, Table Level Permission
• FULLTEXT query format question
• Preventing Duplicate Entries
• Comparing and writing out BLOBS
• Executing MySQL Commands From Within C Program
• Can 't access mysql after kernel upgrade
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Downgrade Mysql from 4 to 3 23
• MySQL Cluster Software
• mysql test 4 1 fails with the gis test
• ERROR 2002: Can 't connect to local MySQL server through socket
• Getting Identity after INSERT
• Update one field with more fields from another table
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• mysql have same function mthod as Oracle decode()
 
myODBC issue - changed table name

myODBC issue - changed table name

2006-07-20       - By Al McNicoll

 Back
Dear all,

Any clarity on this problem would be appreciated.

The setup:
-- ---- --
I've got a client program running MS Access 2003 (on Win XP), connecting to
a linux server (running Fedora 5) running MySQL 5.0 Community Edition. At
the moment, there's only the one client connecting - later there will be
many more. Connection is made using myODBC 3.51.12

The problem:
-- ---- ----
Halfway through a data-entry process the other day, Access threw up an ODBC
error. After much debugging, it turns out it couldn't find a certain table,
called textbank_account_name00000152. I know that this table had existed in
the past, so I deleted the link from Access's database window, then tried to
relink the table. The table bank_account_name00000152 appeared when I
selected my DSN from the list, but when I then tried to link it, it said
that the Jet Database engine couldn't find table bank_account_name00000152.
Further investigation in MySQL administrator revealed that the table
bank_account_name00000152 was not present in the database, but one called
bank_account_name00000144 *was* present. Slightly confused, I then tried to
rename this table to bank_acount_name00000152 using the built-in MySQL Table
Editor. Error: "table bank_account_name00000152 already exists"
To further these problems, I'm currently doing all this querying "blind"
over the phone to a fairly non-technical user, while I wait for a VPN to be
set up. So for the moment, I don't have printouts of the information_schema,
etc.

The questions:
-- ---- ------
1. Has anyone else had this issue using myODBC?
2. Is there any way that I can change the table name without issuing a ALTER
TABLE statement (I can't see one in my code)?
3. Although this may be an issue for a separate list, does anyone have any
experience of this internal inconsistency within MySQL server - ie a table
which appears to have one name but "actually" has another?
4. The user I speak to over the phone has limited abilities and limited
patience. Can you suggest any information that would be really useful to
get? I think an information_schema readout is probably going to be pretty
high on that list, but are there any other things I haven't thought of?

Any help you can offer would be gratefully appreciated, and might save me
from further hair loss...

Thanks!

Al McNicoll
Integritec Ltd


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql@(protected)