All, Yo gang! Having a problem with the MySQL ODBC 3.51 driver.
I've got a MySQL volume which has a user table (tbl_usr). I'm linking this table to an Access database on my workstation (via ODBC link). The account being used for the connection has select, update, and insert rights to all tables in the database. I'm populating the linked (MySQL) table with data I've got on my workstation in an MS Access database. To do this, I'm simply executing an "insert into ... select ... from" statement. INSERT INTO tbl_usr (fst_nm, lst_nm, tle_nm, email_addr) SELECT tbl_stage.First, tbl_stage.Last, tbl_stage.Title, tbl_stage.Email FROM tbl_stage; However, each time I execute the statement I receive an error (see attached file - mysql_odbc_err.pdf). The error message provided isn't very helpful. Can anyone elaborate? Client Environment: - Windows 2000 (SP3) - MS Access 2000 Server Environment: - MacOS X 10.2.6 (Jaguar) - MySQL 4.0.13-standard Regards, Adam <<mysql_odbc_err.pdf>>
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]