Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread MySQL ODBC Connection
Sat, Apr 26 2014 9:20 PMPermanent Link

Douglas Lyman

I have successfully tested an ODBC MySQL connection in the IDE.  However, when I try to post to a table (also in the IDE), I receive the message:  

"Database commit response error:  Underlying database engine does not appear to support discoverable parameter types."

Is anyone else seeing this?
Mon, Apr 28 2014 10:51 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Doug,

<< "Database commit response error:  Underlying database engine does not
appear to support discoverable parameter types." >>

This occurs when the dataset functionality encounters an ADO parameter that
doesn't have a data type.  The data type should be populated if the ODBC
driver supports auto-populating of parameters/parameter types.  For example,
DBISAM doesn't support this, but ElevateDB does, so the ElevateDB ODBC
driver would work with the ADO database support, but DBISAM would not.

Does it only occur for certain parameter usage, or for any parameter ?  IOW,
is there something odd about the data type of the parameter that you're
using, such as it being a BLOB ?

Tim Young
Elevate Software
www.elevatesoft.com


Image