i tried to connect my database but im getting an InterfaceError and i dont
know how so solve it.
connection_string = (
"DRIVER=Adaptive Server Anywhere 7.0;"
"SERVER=IP;"
"PORT=Port;"
"UID=ID;PWD=PASSWORD;"
"DATABASE=NameOfDatabase;"
"charset=utf8;"
)
connection_url = URL.create(
"sybase+pyodbc",
query={"odbc_connect": connection_string}
)
engine = create_engine(connection_url)
conn = engine.connect()
InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Der
Datenquellenname wurde nicht gefunden, und es wurde kein Standardtreiber
angegeben (0) (SQLDriverConnect)')
InterfaceError: (pyodbc.InterfaceError) ('IM002', '[IM002] [Microsoft][ODBC
Driver Manager] Der Datenquellenname wurde nicht gefunden, und es wurde
kein Standardtreiber angegeben (0) (SQLDriverConnect)')
(Background on this error at: http://sqlalche.me/e/14/rvf5)
i have installed the driver on my computer and its called Adaptive Server
Anywhere 7.0 so i dont know where the problem is...
Jonathan Vanasco schrieb am Donnerstag, 14. April 2022 um 00:07:06 UTC+2:
> The Sybase dialect was deprecated from first-party support by SQLAlchemy
> and is currently unsupported.
>
> Gord Thompson, who is a frequent contributor to the core SQLAlchemy
> project, and has generously taken over responsibility for the original
> dialect as a third-party dialect::
>
> https://github.com/gordthompson/sqlalchemy-sybase
>
> In addition to offering some excellent code, his repo offers a wiki and
> some documentation - both of which should help.
>
>
> On Tuesday, April 12, 2022 at 11:10:40 AM UTC-4 Trainer Go wrote:
>
>> im a bit lost and need some help.
>>
>> im trying to set up a database connection with sqlalchemy to a Sybase
>> Adaptive Server Anywhere Version 7 and i dont know how.
>>
>> I would be really happy if somebody could help me.
>>
>> Thanks in advace.
>>
>>
>> Greetings Mae
>>
>
--
SQLAlchemy -
The Python SQL Toolkit and Object Relational Mapper
http://www.sqlalchemy.org/
To post example code, please provide an MCVE: Minimal, Complete, and Verifiable
Example. See http://stackoverflow.com/help/mcve for a full description.
---
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/fa256e85-e137-4b17-9244-e7b9e337c561n%40googlegroups.com.
