Recent

Author Topic: ODBC ProvideX/MAS 90  (Read 2274 times)

mm_coder

  • Jr. Member
  • **
  • Posts: 50
ODBC ProvideX/MAS 90
« on: September 03, 2015, 06:29:53 pm »
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

  • Jr. Member
  • **
  • Posts: 50
Re: ODBC ProvideX/MAS 90
« Reply #1 on: September 03, 2015, 08:00:09 pm »

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

eldonfsr

  • Hero Member
  • *****
  • Posts: 543
Re: ODBC ProvideX/MAS 90
« Reply #2 on: February 18, 2020, 05:55:01 pm »
Do remember how connect to mas90 i haveing some problems with that, can you help me please

 

TinyPortal © 2005-2018