Hello, I am getting error message below connecting...
# ingestion
d
Hello, I am getting error message below connecting to MS SQL Server. The error is coming from SQLAlchemy. Anyone encountered the same and know the fix for this issue? /sqlalchemy/dialects/mssql/base.py: could not fetch transaction isolation level, tried views. I could reproduce the error writhing a python script using SqlAlchemy URI. But when I added the engine in sqlalchemy session, I was able to make a connection. I don’t know the parameters in recipe file to add the engine in the session. Appreciate your response. Thanks, Mahbub
h
Hi @dry-zoo-35797 could you please share the python script before adding the engine (that gives error) and after adding the engine (which works)? Please remove the sensitive info from script. Also it would help if you can share the recipe and ingestion log (especially complete stack trace of error).
d
Hi Mayuri,
Thank for your response. I got it working. Appreciate your response. -Mahbub
h
Hey @dry-zoo-35797 glad to hear its working! Can you share what you had to do to get it working ? It could be of use to someone, who stumbles upon same error some day.