ODBC--Insert table failed

[isladogs]

Isaac was suggesting using a PassThrough insert query to insert the records (as opposed to trying to insert into a recordset from a PassThrough Select). Anything that can be done with a query on the server can be done with a PassThrough query (with the appropriate permissions).

If it can work by that method, that's fine. In that case, I stand corrected.

 

[arnelgp]

why the need of passthrough query? the tables setup is that they are LInked tables?
as advised, you need to re-Create the Linked table.
pay attention to the ODBC setup so that the resulting recordset is not read-only.

 

[Isaac]

The OP was talking about inserting records into the ODBC table.
Presumably, running an append query based on a read only passthrough query won't work. Are you suggesting it will?

There is nothing to stop the OP from coding a pass through query with Mysql syntax that works on the server
"insert into tablename (colname) values (1)"
Or executing a stored procedure, to do almost anything (if such a thing exists in Mysql)

As mentioned previously, this suggestion was just a possible workaround for now, not meant to discourage the OP from discovering the cause of their original problem, if possible.

 

[karent]

See post#1, she can insert record but only 1 table has a problem.

Well the problem ended up being 1 field in a table of 78 fields that had a default value set to 'none' and when switched to 'null' it now works. Mysql 5.7 doesn't like "none' apparently where it didn't bother 5.6

 

[Minty]

Excellent news, and thank you for posting back about it - I'm sure that little nugget of information will assist someone else further down the line.