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 Verbindungszeichenfolge (0); [08001] [Sybase][ODBC Driver]Ungültiges Attribut für Verbindungszeichenfolge (0); [08001] [Sybase][ODBC Driver]Ungültiges Attribut für Verbindungszeichenfolge (0); [08001] [Sybase][ODBC Driver]Ungültiges Attribut für Verbindungszeichenfolge (0); [08001] [Sybase][ODBC Driver]Ungültiges Attribut für Verbindungszeichenfolge (0)')
Maybe a problem with my Connection String? connection_string = ( "DRIVER=Adaptive Server Anywhere 7.0;" "SERVER=IP;" "PORT=Port;" "UID=ID;PWD=password;" "DATABASE=NameOfDB;" "charset=utf8;" ) connection_url = URL.create( "sybase+pyodbc", query={"odbc_connect": connection_string} ) engine = create_engine(connection_url) Gord Thompson schrieb am Mittwoch, 20. April 2022 um 17:18:08 UTC+2: > Yes, that's correct. If you are running 64-bit Python then you need to > have a 64-bit version of the ODBC driver installed. 64-bit applications > cannot use 32-bit drivers. > > On Wednesday, April 20, 2022 at 2:21:32 AM UTC-6 Trainer Go wrote: > >> Hi Gord Thompson, >> >> with print pyodbc.drivers() result = ['SQL Server', 'Microsoft Access >> Driver (*.mdb, *.accdb)', 'Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, >> *.xlsb)', 'Microsoft Access Text Driver (*.txt, *.csv)'] >> >> but i think i know why i have problems with the connection. Cause i tried >> to connect with my 64 Bit Python programm a 32 Bit driver and the 32 Bit >> driver isnt listed in my pyodbc print 64 Bit >> >> Gord Thompson schrieb am Donnerstag, 14. April 2022 um 18:30:44 UTC+2: >> >>> > 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/31f7214c-431b-4b29-a184-d22fcd8c0d7cn%40googlegroups.com.