Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / lazarus / 2024-09

tsqlquery to excel

5 messages · 4 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Larry Dalton

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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20240905/749348cb/attachment.htm>

Reply by email

Michael Van Canneyt
to Larry Dalton
Larry Dalton wrote 9 lines
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.

ODBC or Excel.

Michael.

Reply by email

Larry Dalton
to Michael Van Canneyt

That?s what I thought. Any Excel experts out there who use Lazarus? Sent from my iPhone

Show quoted text 24 lines
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, 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. ODBC or Excel. Michael. -- _______________________________________________ lazarus mailing list https://lists.lazarus-ide.org/listinfo/lazarus

Reply by email

Flávio Etrusco
to Larry Dalton: I am trying to access an .xlsm workbook from lazarus free pascal, using ODBC connector…

Em qui., 5 de set. de 2024 ?s 15:16, Larry Dalton via lazarus <

Show quoted text 15 lines
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>

Reply by email