MySQL Forums
Forum List  »  Newbie

MySQL 5.0.1 alpha - Table mysql.t1 doesn't exist
Posted by: Paul Powell
Date: August 25, 2004 05:03PM

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.

Options: ReplyQuote


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.