Skip to Content

Connecting to Advantage DB in Python 3.6

I'm running into a problem trying to connect to an Advantage Database using Python. The existing python library doesn't work for me since I'm using Python 3.6. I've downloaded the v 11 ODBC driver & ACE. I'm using pyodbc and was able to get it to use the driver with with the connection string. I was able to fumble my way through to get it to no longer error when connecting, but now I'm getting a 1500 error whenever I try to execute a command. Checking the documentation, it says to check that aicu.so/aicu.dlland icudt40l.dat are both deployed. I've verified both the client and server have them installed. Has anybody run into a similar issue? Or know of a better way to connect to the database using python 3.6 on linux?

Client: Ubuntu 18.04, Python version 3.6, pyodbc, Advantage ODBC driver 11.10.0.26, ACE 11.10.0.24

Server: Windows Server 2012 R2, Advantage DB 11.10.0.1

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 28, 2019 at 06:16 PM

    Have you checked your ads_err.adt and ads_err.dbf files to see where the server is expecting to find these files?

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.