SQL server database connection error with SDK

[aksverman]

Hi,
I'm using MOSTLYAI Python SDK to generate synthetic data. I added sqlserver connector support while installing SDK.
I ran into below issue while connecting to SQL server database.

ignoring unrecognized fields for ConnectorConfig: testConnection
Database connection failed with error: (pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
(Background on this error at: https://sqlalche.me/e/20/rvf5)

Below is python code I’m using to connect to SQL server database:
_from mostlyai.sdk import MostlyAI

mostly = MostlyAI(local=True)
mssql_source = mostly.connect({
"name": "MS SQL Server Connector",
"type": "MSSQL",
"access_type": "SOURCE",
"config": {
"host": "localhsot",
"port": "1433",
"username": "test"
},
"secrets": {
"password": "****"
},
"test_connection": True
})_

Please note I have tested the connection with pyodbc directly and it works.

[mplatzer]

@shuangwu5 any guess what could be the issue here?

[shuangwu5]

@aksverman
What version of ODBC driver do you have?
Could you please run pyodbc.drivers() to see what are available on your machine?
Thanks.

[aksverman]

@shuangwu5
Available drivers:
['SQL Server', 'ODBC Driver 17 for SQL Server', 'Microsoft Access Driver (*.mdb, .accdb)', 'Microsoft Excel Driver (.xls, *.xlsx, *.xlsm, .xlsb)', 'Microsoft Access Text Driver (.txt, *.csv)']

I don't see configuration options to mention driver with MostlyAI SDK.
Does mostly.connect(.) figure out drivers automatically? I checked api.py & connectors.py in SDK, didn't find any configuration related to driver.

[shuangwu5]

Hi @aksverman,

Does mostly.connect(.) figure out drivers automatically?

Unfortunately not. Currently our code requires ODBC Driver 18 for SQL Server explicitly.
If possible, please install and try out this driver instead.
And in the mean time, we will consider adding detection of available ODBC drivers.
Thanks for reporting this!

[aksverman]

sure, will check with driver 18 and thanks for helping out.

[aksverman]

It works! Thanks for all the support.