#StackBounty: #python #sql-server #sqlalchemy #pyodbc #presto Connecting to jTDS Microsoft server with SQLalchemy and Presto

Bounty: 50

I’m trying to connect to an oldschool jTDS ms server for a variety of different analysis tasks. Firstly just using Python with SQL alchemy, as well as using Tableau and Presto.

Focusing on SQL Alchemy first at the moment I’m getting an error of:

Data source name not found and no default driver specified

With this, based on this thread here Connecting to SQL Server 2012 using sqlalchemy and pyodbc

i.e,

import urllib
params = urllib.parse.quote_plus("DRIVER={FreeTDS};"
                                 "SERVER=x-y.x.com;"
                                 "DATABASE=;"
                                 "UID=user;"
                                 "PWD=password")

engine = sa.create_engine("mssql+pyodbc:///?odbc_connect={FreeTDS}".format(params))

Connecting works fine through Dbeaver, using a jTDS SQL Server (MSSQL) driver (which is labelled as legacy).

Curious as to how to resolve this issue, I’ll keep researching away, but would appreciate any help.

I imagine there is an old drive on the internet I need to integrate into SQL Alchemy to begin with, and then perhaps migrating this data to something newer.

Appreciate your time


Get this bounty!!!

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.