Connecting to ODBC with %LOAD about xeus-sql HOT 5 OPEN

Hi again,

I've managed to connect to ODBC on Windows. My previous attempt was through the WSL (version 1) and it did not seem to find the backend odbc library (libsoci_odbc.dll ?).

Regarding windows, the way the ODBC connection works is different to the other ones (Postgres, MySQL...), When I run %LOAD odbc with no further arguments a 'Select Data Source' GUI appears and then I can select the correct DSN. I am wondering though if there is anyway to specify the DSN to use in the Jupyter cell, as with the other SQL backends

Could be relevant: ODBC Connection String Keyword list

from xeus-sql.

Would be indeed very cool to get some more docs for ODBC -- there are a couple databases where I could see it being immediately useful :)

from xeus-sql.

Hi @marimeireles, any advice? :)

from xeus-sql.

Hey @lc5415, sorry for being non responsive here. I was in vacation. That's great you figured out a solution! :)
Unfortunately I don't own a windows machine and haven't own one for years, I'm clueless with windows, sorry I can't be much help here.
But if you want to share your founds with other folks, I'm pretty sure it will be very appreciated. If you can, feel free to edit this file https://github.com/jupyter-xeus/xeus-sql/blob/master/docs/source/ODBC.rst with your step by step.

I am wondering though if there is anyway to specify the DSN to use in the Jupyter cell, as with the other SQL backends

Regarding this... It's weird because the SOCI docs don't mention any special treatment for windows. It should work as the other stuff is working. maybe they're also lacking in docs.
Anyways, I'll keep the issue open!

from xeus-sql.

ODBC support would be much appreciated for Snowflake users!

I set up a connection using odbcinst on my Mac, I will try and report back if it works.

from xeus-sql.