[Lazarus] tsqlquery to excel

[Flávio Etrusco]

Em qui., 5 de set. de 2024 às 15:16, Larry Dalton via lazarus <
lazarus at lists.lazarus-ide.org> escreveu:

> I am trying to access an .xlsm workbook from lazarus free pascal, using
> ODBC connector and tsqlquery.
>
> The ODBC Connector shows connected, but when I try to open the tsqlquery,
> the error code I get is "_Could not start transaction! ODBC error
> details:LastReturnCode:SQL_error;Record
> 1:;SqlState:HYC00;NativeError:105;Message:[Microsoft][ODBC Excel Driver
> ]Optional feature not implemented'. I am on Windows 11, using Lazarus 3.2.
> I don't know if that is a Lazarus Error, an ODBC Error, or Excel error.
>
> Any help?
> --
>

Do you have experience with the ODBC Excel adapter? I have none, but I
assume the driver would be very limited.
Have you tried using TTable? Do you get a stack trace that points to a
specific method in TSqlQuery?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240905/aea3eca1/attachment-0001.htm>