Connect to Sybase database from Django

Sybase is no longer maintained and it's not supported by Django. I recommend using one of the supported databases:

• PostgreSQL
• MariaDB
• MySQL
• Oracle
• SQLite

Personally, I would recommend using PostgreSQL - I think it's the most advanced database. If you use it, I would recommend using version 13, since version 14 is still new and I think it's not officially supported by Django yet. It's always a good practice to use the previous major release. Also with Django, I recommend upgrading to the latest major release only about 4 to 6 months after its initial release. So for today, this means using Django 3.2 (latest minor release, currently 3.2.11).

You can use django-environ to define the database you are using in settings.

You could use the freetds module. GitHub repository was active 5 days ago, it aims to provide support for sybase and MSQL Server.

I used it with MSQL

You can download it from there, and installing with the instruction on this link (Sybase python module website)

Then you can test your installation using these steps

You can also try different Django version.

If this doesn't show anything wrong, and Django still won't connect to your DB, you can try to edit Django's source files so the ImproperlyConfigured exception doesn't raise (REALLY REALLY RISKY, DO A BACK UP OF YOUR DB) or migrate your Sybase to a supported database.

You can use pyodbc. To install this.

Pip install pyodbc

import pyodbc
cnxn = pyodbc.connect(‘DRIVER={Devart ODBC Driver for ASE};Server=myserver;Port=myport;Database=mydatabase;User ID=myuserid;Password=mypassword;String Types=Unicode’)

For reference:- https://medium.com/@sharma.jayant1992/best-way-to-connect-python-with-sybase-database-76445713efaf