Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
Tobias Wimmer |
| Subject: |
MyODBC tries to create tables without names |
| Date: |
03-25-2000 11:04AM |
Hi...
I have installed MySQL on my Linux Box and MySQL for use with MS ACCESS 2000 on Windows 98. Reading Tables from the MySQL server works for me without any problems so far.
But when trying to export data to the server I get ODBC error reports from Access.
Looking at the SQL log files I found the following:
[code]
MSACCESS ff046133:ff0467b3 EXIT SQLExecDirectW with return code -1 (SQL_ERROR)
HSTMT 0x086a1190
WCHAR * 0x0244bb14 [ -3] "CREATE TABLE ( mediumint, mediumint, varchar(50)) 0"
SDWORD -3
DIAG [42000] [TCX][MyODBC]You have an error in your SQL syntax near '( mediumint, mediumint, varchar(50))' at line 1 (1064)
[/code]
It seems that Access is trying to create tables without names! Does anyone know what could be the problem and how it can be resolved... Thanks for any hints...!
Tobias Wimmer
|
Other posts in this thread:
| Top | | • MyODBC tries to create tables without names | Tobias Wimmer | 03-25-2000 11:04AM |
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
