create_engine() does not directly accept a raw ODBC connection string. You
need to use the URL.create(…, query={"odbc_connect": …) approach that you
were using in your earlier examples, except that now you will be supplying
a valid connection string for the ODBC driver that you are using.
On
Hello Gord Thompson,
Yeah i found this dialect documentation and its working with the pyodbc
connection. and my query works with pd.read_sql() but i want to test it
with sqlalchemy cause im getting an warning that i should use sqlalchemy.
But thats what i wanted to do.
cnxn =
Perhaps this might help:
https://www.connectionstrings.com/asa-odbc/
Note also that the sqlalchemy-sybase dialect has not been tested with the
"Adaptive Server Anywhere" driver. If its behaviour differs significantly
from the "SAP ASE ODBC driver" then you may have issues with that.
On
> Verbindung mit dem Datenbankserver unmöglich: Datenbankserver läuft nicht
"Unable to connect to database server: Database server is not running"
> Ungültiges Attribut für Verbindungszeichenfolge
"Invalid connection string attribute"
Check the documentation for your ODBC driver to verify that
Now im getting this error:
pyodbc.OperationalError: ('08001', '[08001] [Sybase][ODBC Driver][Adaptive
Server Anywhere]Verbindung mit dem Datenbankserver unmöglich:
Datenbankserver läuft nicht (-100) (SQLDriverConnect); [08001]
[Sybase][ODBC Driver]Ungültiges Attribut für