I need help with this EXCEL Error code: "Could not start transaction! ODBC error details: LastReturnCode:SQL_ERROR;Record 1:SqlStat:HYC00; NativeError:106;Message:[Microsot][ODBC Excel Driver]Optional feature not implemented;" I am trying to acces an Excel Workbook from a Lazarus pascal application using TSQLQuery
I am using Microsoft365 Excel, on a Windows11 os, and Lazarus 3.2. I am using a TODBCconnection with the following settings: Name:OdbcConnection1; Driver: Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, .xlsb) Params: DBQ=C:\Programs\InventoryData\inventory.xlsm Connected=true Transaction= SqlTransaction1 I am connecting this with TSQLQuery with following settings: AutoCalcFields= true (I’ve tried both true and false with this one and doesn’t matter) Database=ODBCConnection1 ParseSQL=true SQL=Select * from [Cadillacs$] Transaction=SQLTransaction1 UsePrimaryKeyAsKey=false (tried both ways)
-- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
