Hi Mike!
I think there's a misunderstanding. Im trying to connect to a *InterSystem
Cache Database thru ODBC* (Datasource) but my *MS SQL Server Management
Studio* has this version (12.0.5207.0)
I render the code in pyodbc.py and add the pass to the except clause but it
doesnt help getting the same error message with the str and int like before.
Am Donnerstag, 29. März 2018 15:01:46 UTC+2 schrieb Mike Bayer:
>
> Hi -
>
> unfortunately the stack trace indicates a bug in SQLAlchemy in that it
> is not interpreting your database's version string correctly.
>
> can you please provide me with the output of:
>
> SELECT CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)
>
>
> Additionally, the likely cause of your issue can be worked around at
> the moment with this patch:
>
> diff --git a/lib/sqlalchemy/dialects/mssql/pyodbc.py
> b/lib/sqlalchemy/dialects/mssql/pyodbc.py
> index 14e8ae838..30b8b8b50 100644
> --- a/lib/sqlalchemy/dialects/mssql/pyodbc.py
> +++ b/lib/sqlalchemy/dialects/mssql/pyodbc.py
> @@ -291,7 +291,7 @@ class MSDialect_pyodbc(PyODBCConnector, MSDialect):
> try:
> version.append(int(n))
> except ValueError:
> - version.append(n)
> + pass
> return tuple(version)
>
> def is_disconnect(self, e, connection, cursor):
>
>
>
> https://bitbucket.org/zzzeek/sqlalchemy/issues/4227/sql-server-pyodbc-allows-non-int-tokens-in
>
> is added.
>
> I need to see your version string so I can understand what tokens I
> need to weed out, thanks!
>
>
>
> On Thu, Mar 29, 2018 at 7:03 AM, Maki <[email protected] <javascript:>>
> wrote:
> > Im on a Windows OS and Python 3.6.4 and im stucked with a problem trying
> to
> > connect to a DSN Datasource using SQLAlchemy 1.2.5
> >
> > Using pyodbc to connect to the DSN Datasource works great but using
> > SQLAlchemy create_engine method:
> >
> > engine = create_engine("mssql+pyodbc://user:pass@mydsn", echo=True)
> >
> > get me the following error:
> >
> > File "mentrix.py", line 28, in <module>
> > cnxn = engine.connect()
> > TypeError: '<' not supported between instances of 'str' and 'int'
> >
> > Can anyone point me on the right direction. Like ive said im trying to
> use
> > SQLAlchemy to connect to a InterSystem ODBC35 DSN Datasource.
> >
> > Thanks in advanced!
> >
> > Code:
> >
> > from sqlalchemy import create_engine
> > import pyodbc
> >
> > engine = create_engine("mssql+pyodbc://user:pass@mydsn", echo=True)
> > cnxn = engine.connect()
> > rows = cnxn.execute("SELECT name FROM sys.tables").fetchall()
> > print(rows)
> >
> > Full traceback:
> >
> > 2018-03-29 11:33:44,631 INFO sqlalchemy.engine.base.Engine SELECT
> > CAST(SERVERPROPERTY('ProductVersion') AS VARCHAR)
> > 2018-03-29 11:33:44,631 INFO sqlalchemy.engine.base.Engine ()
> > Traceback (most recent call last):
> > File "mentrix.py", line 28, in <module>
> > cnxn = engine.connect()
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\base.py",
> > line 2102, in connect
> > return self._connection_cls(self, **kwargs)
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\base.py",
> > line 90, in __init__
> > if connection is not None else engine.raw_connection()
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\base.py",
> > line 2188, in raw_connection
> > self.pool.unique_connection, _connection)
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\base.py",
> > line 2158, in _wrap_pool_connect
> > return fn()
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 345, in unique_connection
> > return _ConnectionFairy._checkout(self)
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 784, in _checkout
> > fairy = _ConnectionRecord.checkout(pool)
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 532, in checkout
> > rec = pool._do_get()
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 1189, in _do_get
> > self._dec_overflow()
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\util\langhelpers.py",
>
> > line 66, in __exit__
> > compat.reraise(exc_type, exc_value, exc_tb)
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\util\compat.py",
> > line 187, in reraise
> > raise value
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 1186, in _do_get
> > return self._create_connection()
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 350, in _create_connection
> > return _ConnectionRecord(self)
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 477, in __init__
> > self.__connect(first_connect_check=True)
> > File "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\pool.py",
> > line 677, in __connect
> > exec_once(self.connection, self)
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\event\attr.py",
> line
> > 274, in exec_once
> > self(*args, **kw)
> > File
> > "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\event\attr.py",
> line
> > 284, in __call__
> > fn(*args, **kw)
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\util\langhelpers.py",
>
> > line 1334, in go
> > return once_fn(*arg, **kw)
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\strategies.py",
>
>
> > line 183, in first_connect
> > dialect.initialize(c)
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\dialects\mssql\base.py",
>
>
> > line 1931, in initialize
> > super(MSDialect, self).initialize(connection)
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\engine\default.py",
> > line 267, in initialize
> > self._get_default_schema_name(connection)
> > File
> >
> "C:\Users\m.m\Envs\mentrix\lib\site-packages\sqlalchemy\dialects\mssql\base.py",
>
>
> > line 1958, in _get_default_schema_name
> > if self.server_version_info < MS_2005_VERSION:
> > TypeError: '<' not supported between instances of 'str' and 'int'
> >
> > --
> > 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] <javascript:>.
> > To post to this group, send email to [email protected]
> <javascript:>.
> > Visit this group at https://groups.google.com/group/sqlalchemy.
> > For more options, visit https://groups.google.com/d/optout.
>
--
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 post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
