MySQL 5.0.1 alpha - Table mysql.t1 doesn't exist
I am working with a development tool called AllFusion Plex and am testing for compatibility with MySQL. I am using the MySQL ODBC 3.51 driver and have created a table using this syntax:
#BEGIN TABLE AAbT
CREATE TABLE AAbT (
AAxA %numeric%(4, 0)
#OPTION CK
NOT NULL
#END_OPTION
,
AAyA %char%(20)
#OPTION PK
,
#OPTION CN
CONSTRAINT AAbT_PK
#END_OPTION
PRIMARY KEY (
AAxA
)
#END_OPTION
)
#END
and an update view using this syntax:
#BEGIN VIEW AAnV
CREATE VIEW AAnV AS
SELECT
T1.AAxA,
T1.AAyA
FROM AAbT T1
#END
When I try to update a records I get:
Action = SQLSetPos UPDATE
REturn Code = -1 Date = ... Time =...
State = S1000
Error Msg = [MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-nt]Table 'mysql.t1' doesn't exist
I can insert records fine. Is this an alpha isse? An ODBC driver issue? Anyone seen this? This works fine for insert and update on a MS SQL database using MS ODBC drivers.
Subject
Written By
Posted
MySQL 5.0.1 alpha - Table mysql.t1 doesn't exist
August 25, 2004 05:03PM
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.