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
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
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 =
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
> 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
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
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()
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
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
>
>
> 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
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 =
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
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::
13 matches
Mail list logo