[Lazarus] Lots of access violations with TSQLConnection TSQLQuery on Linux

Sven Barth pascaldragon at googlemail.com
Thu Apr 4 07:57:29 CEST 2019


Anthony Walter via lazarus <lazarus at lists.lazarus-ide.org> schrieb am Do.,
4. Apr. 2019, 02:15:

> I don't normally use the Lazarus MS SQL components, but tried using them
> today on Ubuntu Linux and keep experiencing lots of random access
> violations. I wanted to know if this is a normal thing, or if perhaps the
> state of these components is fragile on Linux.
>
> Here is what is happening.
>
> I can place the TSQLConnection, TSQLTransaction, TSQLQuery, TDataSource
> and  data aware controls on a form and connect to the database at design
> time. It works fine. I can run my program and I can view and edit records
> just fine. But if I change any part of TSQLQuery down to TSQLConnection
> setting Active to False, then I get access violations.
>
> This is particularly problematic because certain changes to component
> properties require Active to be set to False, such as editing SQL. And very
> often, though not always, changing the Active property results in access
> violations. And after an AV happens then things start misbehaving in the
> IDE.
>
> Is this a common problem for some people on Linux using the MS SQL
> components? Am I doing something wrong? Are there people her who have
> worked with MS SQL components on Linux much and is familiar with this
> problem?
>

Just to be sure: do you have the necessary library installed on your
system? See here: http://wiki.freepascal.org/mssqlconn#Installation

Regards,
Sven

>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20190404/ee0aa8c7/attachment.html>


More information about the lazarus mailing list