sql-odbc | Open Distro for Elasticsearch ODBC Driver | SQL Database library

I am assuming that your running each docker container separately. In this case in order for your C++ application container to be able to connect to the Mysql container they will need to be on same network.

1. Create Docker network docker network create mysql-network
2. Run C++ application container like so: docker run -it --network mysql-network xxxxxrun:localbase (xxxxxrun should be name of image and localbase should be image tag that you want to run)
3. Run Mysql database with command similar to docker run --network mysql-network -e MYSQL_ROOT_PASSWORD=password -d mysql:5.7

In this situation the two containers should be able to communicate freely with each other across the network.

Error 1918. Error installing ODBC Driver MySQL ODBC 5.3 ANSI Driver

When you run an external command (or any command), the output of that command can be piped into a PowerShell command. Since your command outputs single lines containing a package name, that output can be piped into Foreach-Object where each package (object in PowerShell terms) can be processed.

SQLConfigDataSource doesn't take a connection string. It takes a driver name, and attributes.

Let's dissect the connection string:

ODBC; : DAO-specific prefix indicating an ODBC connection string. Never needed outside of Access/DAO.

DSN=Postgres_Test: DSN name

Driver=PostgreSQL Unicode: Driver name, should never be combined with DSN name in a connection string as the DSN specifies the driver name

Server=************.*********.***.****;Port=*****;Database=example;Uid=********;Pwd=****************;: Driver-specific attributes.

If we look at the documentation, the driver attributes should be null-separated, not separated by ;, and the string should end with a double null separator.

So, the final call would need to look like this: