23 days ago
I'm trying to migrate a pre-existing MS SQL server to a Railway Postgres server. I've been using a python command to copy the SQL server into a pandas dataframe and then writing to the new database. When I tried to use the same function on Railway, I got the following error message : libodbc.so.2: cannot open shared object file: No such file or directory.
I'm wondering if there is a way to connect to the MS SQL database from railway. The MS SQL database is still in use, and I would like to be able to check the railway database against it.
2 Replies
23 days ago
Having looked into this, the issue appears to be in your application code or configuration rather than the Railway platform itself, which puts it outside what Railway support can resolve directly.
This is exactly the kind of problem the Railway community is good at, so we'd like to open your thread as a community bounty. Railway pays a bounty to the community member who solves it, and threads like this usually get picked up quickly.
Opening it makes this entire thread public, including everything already posted. Nothing becomes public until you decide. Use the buttons below.
- Open to the community - Before you click, take a moment to edit or remove anything you'd rather not share. The thread becomes publicly visible right away.
- Keep it private and close the thread - Nothing becomes public. The thread closes, since this isn't something Railway support can take further.
Status changed to Awaiting User Response Railway • 23 days ago
23 days ago
This thread has been opened as a public bounty so the community can help solve it. The thread and any further activity are now visible to everyone.
Status changed to Open Railway • 23 days ago
23 days ago
If you want to connect to an external MS SQL Server, pyodbc requires:
- unixodbc and unixodbc-dev (the core ODBC driver manager for Linux).
- The proprietary Microsoft ODBC Driver for SQL Server (msodbcsql17 or msodbcsql18).