ODBC--Insert table failed (1 Viewer)

isladogs

CID VIP
Local time
Today, 06:47
Joined
Jan 14, 2017
Messages
14,018
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

error reading drive A:
Local time
Today, 14:47
Joined
May 7, 2009
Messages
10,858
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.
 
Last edited:

Isaac

Lifelong Learner
Local time
Yesterday, 22:47
Joined
Mar 14, 2017
Messages
2,734
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

New member
Local time
Today, 01:47
Joined
Oct 13, 2020
Messages
8
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

AWF VIP
Local time
Today, 06:47
Joined
Jul 26, 2013
Messages
7,516
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.
 

Users who are viewing this thread

Top Bottom