[sqlalchemy] Re: SQLALCHEMY conncection to Sybase Adaptive Server Anywhere Version 7 via TCI/IP
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.
[sqlalchemy] Re: SQLALCHEMY conncection to Sybase Adaptive Server Anywhere Version 7 via TCI/IP
> 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/9037237d-48e5-45a3-9845-7c824225189an%40googlegroups.com.
[sqlalchemy] Re: SQLALCHEMY conncection to Sybase Adaptive Server Anywhere Version 7 via TCI/IP
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.
[sqlalchemy] Re: SQLALCHEMY conncection to Sybase Adaptive Server Anywhere Version 7 via TCI/IP
I will try it today. Thank you very much for your help Jonathan Vanasco 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/0e4a5539-d567-45d0-a9c9-8fb48f01bd1fn%40googlegroups.com.