<div dir="ltr"><p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif"><span style="font-family:Roboto;color:rgb(17,17,17);background-image:initial;background-position:initial;background-size:initial;background-repeat:initial;background-origin:initial;background-clip:initial">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</span></p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">I am using Microsoft365 Excel, on a Windows11 os, and Lazarus
3.2. I am using a TODBCconnection with the following settings:</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Name:OdbcConnection1;</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Driver: Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, .xlsb)</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Params: DBQ=C:\Programs\InventoryData\inventory.xlsm</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Connected=true</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Transaction= SqlTransaction1</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">I am connecting this with TSQLQuery with following settings:</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">AutoCalcFields= true 
(I’ve tried both true and false with this one and doesn’t matter)</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Database=ODBCConnection1</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">ParseSQL=true</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">SQL=Select * from [Cadillacs$]</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">Transaction=SQLTransaction1</p>

<p class="MsoNormal" style="margin:0in 0in 8pt;line-height:107%;font-size:11pt;font-family:Aptos,sans-serif">UsePrimaryKeyAsKey=false (tried both ways)</p></div>