[ODBC-315] MS Access 2016 export to odbc, mariadb 10.5.x, single/double data columns cause error: Incorrect column specifier for column Created: 2021-05-07  Updated: 2021-06-07

Status: Open
Project: MariaDB Connector/ODBC
Component/s: General
Affects Version/s: 3.1.12
Fix Version/s: 3.1

Type: Bug Priority: Major
Reporter: Bekim Shala Assignee: Lawrin Novitsky
Resolution: Unresolved Votes: 0
Labels: bug
Environment:

Windows 10 1909+ 64 bit, MS Access 2016 32 bit, MariaDB ODBC driver 32 bit 3.1.12 (same with 3.1.11), Remote Mariadb 10.5.9 linux 64 bit.

Attachments: Text File SQL_2.LOG     PNG File Table_1.PNG    

 Description   

Greetings

Exporting a table through odbc that contains single/double data type results in error "[ma-3.1.12][10.5.9-MariaDB-log]Incorrect column specifier for column 'h2'" 1063
The SQL trace log converts for both single/double to type FLOAT(255), which mariadb does not allow insertion.
Is there anything that I might have missed on configurations. Tried to remove strict all tables setting in mariadb but that does not help.
My understanding is that FLOAT, FLOAT(255,0) or alike are expected by database.

Error log attached per ODBC trace and a screenshot of simple unit test access db.

Many thanks for any feedback.


Generated at Thu Feb 08 03:27:48 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.