ODBC ProvideX/MAS 90
lazarus / 16-Databases

----------------------------------------------------------------------
mm_coder · 2015-09-03 16:29

First post. Really exited about Lazarus.
Platform: Windows XP/7

Using Lazarus, I have a simple project which connects and displays
data from a Postgresql DB on both XP and Windows 7

Now I am trying to connect to a MAS 90 database using ODBC

Please consider the MAS 90 ODBC is a READ ONLY driver

On my project I have added:
sqlConnector
sqlTrans
sqlQuery


1. My sqlOdbc Connector is connecting, because my sqlQuery controls
display
data from my Providex database when I test run the query

However my sqlTransaction cannot be set to true/active.

Since I don't think the ProvideX database supports transactions, I
suspect
a parameter needs to be set.

Any ideas welcome

----------------------------------------------------------------------
mm_coder · 2015-09-03 18:00

Solved the problem by adding the following parameter to
the TSQLTransaction component under the parameters list:

autocommit=1

----------------------------------------------------------------------
eldonfsr · 2020-02-18 16:55

Do remember how connect to mas90 i haveing some problems with that,
can you help me please