Unrecognized Dialect when trying to connect to SQL server

[george_markaria]

I am trying to run an initdb command using dap and connecting to an existing SQL server DB and Table but receiving an "unrecognized dialect" error.

Can someone point out if this is the correct way of setting the connection string in the environment variables:

set DAP_CONNECTION_STRING='mssql://<user>:<password>@<server>/<table>'

I am guessing that the error is due to this being malformed or incorrect unless there is another reason on dap version 2.0.1

[george_markaria · Accepted solution]

I don't think SQL is a supported dialect. Somehow managed to install and configure MySQL successfully.

[Pete5484]

Perhaps retry without the single quotes and add the port.

See Work with databases > Store connection string on the CLI developerdocs page.

set postgresql://user:password@host:5432/mydatabase
set mysql://user:password@host:3306/mydatabase
set mssql://user:password@host:1433/mydatabase