Re: [Lazarus] tsqlquery to excel

2024-09-11 Thread Ondrej Pokorny via lazarus
On 05.09.2024 22:23, Larry Dalton via lazarus wrote: That’s what I thought. Any Excel experts out there who use Lazarus? Check https://wiki.lazarus.freepascal.org/FPSpreadsheet Ondrej -- ___ lazarus mailing list lazarus@lists.lazarus-ide.org https:/

Re: [Lazarus] tsqlquery to excel

2024-09-05 Thread Flávio Etrusco via lazarus
Em qui., 5 de set. de 2024 às 15:16, Larry Dalton via lazarus < lazarus@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 err

Re: [Lazarus] tsqlquery to excel

2024-09-05 Thread Larry Dalton via lazarus
That’s what I thought. Any Excel experts out there who use Lazarus? Sent from my iPhone > On Sep 5, 2024, at 14:22, Michael Van Canneyt via lazarus > wrote: > >  > >> On Thu, 5 Sep 2024, Larry Dalton via lazarus wrote: >> >> I am trying to access an .xlsm workbook from lazarus free pascal, u

Re: [Lazarus] tsqlquery to excel

2024-09-05 Thread Michael Van Canneyt via lazarus
On Thu, 5 Sep 2024, Larry Dalton via lazarus wrote: 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 erro

[Lazarus] tsqlquery to excel

2024-09-05 Thread Larry Dalton via lazarus
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:HYC0