thanks, gord! On Thursday, April 14, 2022 at 12:30:44 PM UTC-4 Gord Thompson wrote:
> > Der Datenquellenname wurde nicht gefunden, und es wurde kein > Standardtreiber angegeben > > "The data source name was not found and no default driver was specified" > > Use > > import pyodbc > > print(pyodbc.drivers()) > > to view the names of the ODBC drivers that are available to your > application. > > On Thursday, April 14, 2022 at 3:35:52 AM UTC-6 Trainer Go wrote: > >> 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/43542499-65df-4afd-b052-5a6517bd9b16n%40googlegroups.com.