Question Re: how to create a multiple connection at same time? in Technology Q&A

how to create a multiple connection at same time?

Former Member — Sat, 03 Feb 2024 18:03:36 GMT

I am trying to integrate alongside an existing application that uses ADS as its database.

When i connect my integration app using the code below it connects fine until i try and run the original application at the same time. It seems to only allow one connection, my application seems to hold the connection and block all others. Yet i can have multiple instances of the original application running conncurrently with no issue. Which leads me to believe that its the way in which i am trying to correct from my c# app. The error im getting when the original app is open and i then try to connect with my integration app is "The Advantage Data Dictionary cannot be opened. axServerConnect" .

Error 7077: The Advantage Data Dictionary cannot be opened. axServerConnect

Anyone any suggestions ??

how to create a multiple connection at same time.

python code

conn = adsdb.connect(DataSource=str(dbpath[0]), ServerType='local', UserID=config.ADS_USERNAME,<br>                     password=config.ADS_PASS)

Re: how to create a multiple connection at same time?

michael_loop — Fri, 17 Jan 2020 21:15:15 GMT

ServerType='local' means that you are not using the Advantage Database Server, just opening files directly. Try changing this to ServerType='remote'.

Also make sure you have installed the server, adswin_x86_64.exe or adswin_x86_32.exe from the installation image, and that the Advantage Database Server service is running. You can manage this from the Advantage Configuration Utility (ads_cfg.exe).

If any users connects remotely to a table or dictionary, no one can connect locally, and vice-versa.

Re: how to create a multiple connection at same time?

michael_loop — Fri, 17 Jan 2020 21:16:41 GMT

I have removed the tag "SAP Advanced Data Migration by BackOffice Associates", as this product is unrelated to Advantage Database Server.

Re: how to create a multiple connection at same time?

Former Member — Mon, 20 Jan 2020 09:42:13 GMT

michael.loop thank you.It's working.