Thank you Gord Thompson,
its working. Now i have to check how i can make a select with better
performance.
cause the select im using in my python programm needs i think 80 seconds
and in the database its self only 13 seconds but it tested it with
pd.read_sql() . Maybe the performance with sqlalchemy is much better.
Greetings
Manuel
Gord Thompson schrieb am Freitag, 22. April 2022 um 01:20:46 UTC+2:
> 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 Thursday, April 21, 2022 at 7:04:18 AM UTC-6 Trainer Go wrote:
>
>>
>> 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 = pyodbc.connect('DRIVER={Adaptive Server Anywhere
>> 7.0};Commlinks=tcpip{ip=*MyIpAdresse*;Port=*MyPort*};ENG=*MyDBName*;UID=
>> *MyUserID*;PWD=*MyPassword*')
>>
>> this works fine but atm cant handle to connect my db with sqlalchemy:
>>
>> engine = create_engine('DRIVER={Adaptive Server Anywhere
>> 7.0};Commlinks=tcpip{ip=*IP*;Port=*Port*};ENG=*Database*;UID=*ID*;PWD=
>> *Password*')
>> cnxn = engine.connect()
>>
>> Error:
>> Traceback (most recent call last):
>> File "<string>", line 2, in create_engine
>> File
>> "C:\Users\User\AppData\Local\Programs\Python\Python39-32\lib\site-packages\sqlalchemy\util\deprecations.py",
>>
>> line 309, in warned
>> return fn(*args, **kwargs)
>> File
>> "C:\Users\User\AppData\Local\Programs\Python\Python39-32\lib\site-packages\sqlalchemy\engine\create.py",
>>
>> line 530, in create_engine
>> u = _url.make_url(url)
>> File
>> "C:\Users\User\AppData\Local\Programs\Python\Python39-32\lib\site-packages\sqlalchemy\engine\url.py",
>>
>> line 731, in make_url
>> return _parse_rfc1738_args(name_or_url)
>> File
>> "C:\Users\User\AppData\Local\Programs\Python\Python39-32\lib\site-packages\sqlalchemy\engine\url.py",
>>
>> line 792, in _parse_rfc1738_args
>> raise exc.ArgumentError(
>> sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string
>> 'DRIVER={Adaptive Server Anywhere 7.0};Commlinks=tcpip{ip=*IP*;Port=
>> *Port*};ENG=*Database*;UID=*ID*;PWD=*Password*'
>>
>> Thanks in advance
>>
>> Gord Thompson schrieb am Donnerstag, 21. April 2022 um 14:37:00 UTC+2:
>>
>>> 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 Thursday, April 21, 2022 at 6:29:19 AM UTC-6 Gord Thompson wrote:
>>>
>>>> > 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 you are
>>>> using the correct attribute names in your connection string.
>>>>
>>>> On Thursday, April 21, 2022 at 2:21:36 AM UTC-6 Trainer Go wrote:
>>>>
>>>>> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/sqlalchemy/e7c77859-3a74-4df6-9e1e-e4ba0d7da438n%40googlegroups.com.
