Ignore spaces in column names on ODBC export
See my other post for more detail:
http://forums.mysql.com/read.php?10,233347,233347#msg-233347
Basically I am exporting from a piece of software to a MySQL database. I don't have any options on how the program actually exports other then what ODBC driver to use. When I try to export using the MySQL 5.1 driver it exports a few tables and then ends in the error
[HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community-nt]Incorrect column name 'Floor Volume ' (1166)
[HY000] [MySQL][ODBC 5.1 Driver][mysqld-5.0.67-community-nt]Incorrect column name 'Floor Volume ' (1166)
The answer I got from my previous post was that the problem was with it trying to create a column name with a space.
Is there anything simple I can do either with the ODBC connector or at the actual server to force it to ignore/omit the spaces?
Eric
Subject
Written By
Posted
Ignore spaces in column names on ODBC export
November 07, 2008 07:51PM
December 04, 2008 11:20AM
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.