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/14644b11-44bb-41a3-8e2e-0f5d320a26e5n%40googlegroups.com.
