Re: [sqlalchemy] Pyodbc.Connection has no attribute 'dbms_ver'?

2016-02-15 Thread Simon King 
What does the traceback say? That exact line would trigger an error much like 
the one you are seeing, if the object in “connection.connection” is a 
pyodbc.Connection and doesn’t have a “dbms_ver” attribute.

Note that there are at least 3 packages that could be involved here:

pyodbc (https://pypi.python.org/pypi/pyodbc)

ibm_db (https://pypi.python.org/pypi/ibm_db/)

ibm_db_sa (https://pypi.python.org/pypi/ibm_db_sa)

What versions do you have of each of them? Note that 
https://github.com/ibmdb/python-ibmdbsa/tree/master/ibm_db_sa says that pyodbc 
support is experimental.

Simon

> On 15 Feb 2016, at 21:07, Alex Hall  wrote:
> 
> I just downloaded a fresh copy of 0.3.2, just in case I had somehow
> gotten an old version from Pip. I looked in base.py, and found:
> 
> def initialize(self, connection):
>   super(DB2Dialect, self).initialize(connection)
>self.dbms_ver = connection.connection.dbms_ver
> 
> While I'm not sure what I can do about it, it looks like this dbms_ver
> property is definitely in the latest ibm_db_sa version. Am I getting
> this from the wrong place, or confusing this with a different package
> somehow? I *must* be missing something obvious.
> 
> On 2/15/16, Alex Hall  wrote:
>> An interesting development. I noticed that in site-packages\ibm_db_sa
>> was pyodbc.py. Thinking that might be an older version, I renamed it,
>> trying to force the import to use my installed version instead. It now
>> says "cannot import name pyodbc". I thought Python searched the
>> current directory, then the site-packages one, for modules? If so, and
>> if I can import pyodbc with no errors in the shell, why would
>> ibm_db_sa fail to import? This may be the problem--it was using an
>> older version of pyodbc and can't find the newer one for some reason.
>> Any ideas, or am I completely off track with this?
>> 
>> On 2/15/16, Alex Hall  wrote:
>>> Thanks guys. I've checked the version I'm using, and it reports that
>>> ibm_db_sa.__version__ is '0.3.2'. I have both ibm_db_sa and ibm_db
>>> installed. Should I remove ibm_db and rely only on ibm_db_sa instead?
>>> Is the former package causing a conflict somehow?
>>> 
>>> On 2/15/16, Jaimy Azle  wrote:
 Try to use ibm_db_sa 0.3.2 instead, apparently you are using the
 previous
 version. dbms_ver is a feature specific of native ibm_db version of
 which
 not available in pyodbc.
 
 https://pypi.python.org/pypi/ibm_db_sa/0.3.2
 
 
 Salam,
 
 -Jaimy.
 
 
 On Feb 12, 2016 22:05, "Alex Hall"  wrote:
 
> Hello list,
> I've configured a DSN to a test version of my work's AS400 and I seem
> to be able to connect just fine (Yes!) I'm now running into a problem
> when I try to ask for a list of all tables. The line is:
> 
> dbInspector = inspect(dbEngine)
> 
> The traceback is very long, and I can paste it if you want, but it
> ends with this:
> 
> AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver'
> 
> I'm unable to find anything about this online, so thought I'd check
> with this list. Here's my connection:
> 
> dbEngine = create_engine("ibm_db_sa+pyodbc://user:pwd@myDSN")
> 
> If anyone knows what is causing this, I'd appreciate your thoughts.
> I've installed pyodbc, ibm_db, and ibm_db_sa through pip, so I should
> have all the latest versions of everything. I'm on Windows 7x64,
> Python 2.7 (latest).
> 
> --
> 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 post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
> 
 
 --
 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 post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at https://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/d/optout.
 
>>> 
>> 
> 
> -- 
> 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 post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.

-- 
You

[sqlalchemy] Fwd: Us congress hearing of maan alsaan Money laundry قضية الكونغجرس لغسيل الأموال للمليادير معن الصانع

2016-02-15 Thread kamal a 
YouTube videos of



 U.S. Congress money laundering hearing


of

Saudi Billionaire  " Maan  Al sanea"

 with *bank of America*


and  The  owner of Saad Hospital and  Schools

 in the Eastern Province in *Saudi Arabia*



and the Chairman of the Board of Directors of Awal Bank  in *Bahrain*


With Arabic Subtitles





*موقع اليوتيوب الذي عرض جلسة استماع الكونجرس الأمريكي *

* لمتابعة نشاطات غسل الأموال ونشاطات*



*السعودي معن عبدالواحد الصانع*



*مالك مستشفى  وشركة سعد  ومدارس سعد بالمنطقة الشرقية بالسعودية   ورئيس مجلس
ادارة بنك اوال البحريني*



*مترجم باللغة العربية*



http://www.youtube.com/watch?v=mIBNnQvhU8s

-- 
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Re: [sqlalchemy] Pyodbc.Connection has no attribute 'dbms_ver'?

2016-02-15 Thread Alex Hall 
I just downloaded a fresh copy of 0.3.2, just in case I had somehow
gotten an old version from Pip. I looked in base.py, and found:

def initialize(self, connection):
   super(DB2Dialect, self).initialize(connection)
self.dbms_ver = connection.connection.dbms_ver

While I'm not sure what I can do about it, it looks like this dbms_ver
property is definitely in the latest ibm_db_sa version. Am I getting
this from the wrong place, or confusing this with a different package
somehow? I *must* be missing something obvious.

On 2/15/16, Alex Hall  wrote:
> An interesting development. I noticed that in site-packages\ibm_db_sa
> was pyodbc.py. Thinking that might be an older version, I renamed it,
> trying to force the import to use my installed version instead. It now
> says "cannot import name pyodbc". I thought Python searched the
> current directory, then the site-packages one, for modules? If so, and
> if I can import pyodbc with no errors in the shell, why would
> ibm_db_sa fail to import? This may be the problem--it was using an
> older version of pyodbc and can't find the newer one for some reason.
> Any ideas, or am I completely off track with this?
>
> On 2/15/16, Alex Hall  wrote:
>> Thanks guys. I've checked the version I'm using, and it reports that
>> ibm_db_sa.__version__ is '0.3.2'. I have both ibm_db_sa and ibm_db
>> installed. Should I remove ibm_db and rely only on ibm_db_sa instead?
>> Is the former package causing a conflict somehow?
>>
>> On 2/15/16, Jaimy Azle  wrote:
>>> Try to use ibm_db_sa 0.3.2 instead, apparently you are using the
>>> previous
>>> version. dbms_ver is a feature specific of native ibm_db version of
>>> which
>>> not available in pyodbc.
>>>
>>> https://pypi.python.org/pypi/ibm_db_sa/0.3.2
>>>
>>>
>>> Salam,
>>>
>>> -Jaimy.
>>>
>>>
>>> On Feb 12, 2016 22:05, "Alex Hall"  wrote:
>>>
 Hello list,
 I've configured a DSN to a test version of my work's AS400 and I seem
 to be able to connect just fine (Yes!) I'm now running into a problem
 when I try to ask for a list of all tables. The line is:

  dbInspector = inspect(dbEngine)

 The traceback is very long, and I can paste it if you want, but it
 ends with this:

 AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver'

 I'm unable to find anything about this online, so thought I'd check
 with this list. Here's my connection:

 dbEngine = create_engine("ibm_db_sa+pyodbc://user:pwd@myDSN")

 If anyone knows what is causing this, I'd appreciate your thoughts.
 I've installed pyodbc, ibm_db, and ibm_db_sa through pip, so I should
 have all the latest versions of everything. I'm on Windows 7x64,
 Python 2.7 (latest).

 --
 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 post to this group, send email to sqlalchemy@googlegroups.com.
 Visit this group at https://groups.google.com/group/sqlalchemy.
 For more options, visit https://groups.google.com/d/optout.

>>>
>>> --
>>> 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 post to this group, send email to sqlalchemy@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>

-- 
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

[sqlalchemy] SQLAlchemy 1.0.12 Released

2016-02-15 Thread Mike Bayer 



SQLAlchemy release 1.0.12 is now available.

Release 1.0.12 is a bug fix release resolving a handful of issues 
reported in the past few weeks. Primary development continues on the 1.1 
series which is slated for initial releases in the spring.


1.0.12 includes relatively minor fixes, including a revision to a fix 
made for version 1.0.10 where we're attempting to report on the "cause" 
of an error that is interrupted by a later failure to emit a ROLLBACK on 
the MySQL platform. While Python 3 solves this problem using exception 
chaining and cause reporting, on Python 2 we emit a warning so that the 
cause isn't totally concealed. The condition has been expanded to emit 
this warning in a much wider range of scenarios.


Changelog for 1.0.12 is at: 
http://www.sqlalchemy.org/changelog/CHANGES_1_0_12



SQLAlchemy 1.0.12 is available on the Download Page at 
http://www.sqlalchemy.org/download.html.



--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

SQLAlchemy 1.0.12 Released

2016-02-15 Thread Mike Bayer 



SQLAlchemy release 1.0.12 is now available.

Release 1.0.12 is a bug fix release resolving a handful of issues 
reported in the past few weeks. Primary development continues on the 1.1 
series which is slated for initial releases in the spring.


1.0.12 includes relatively minor fixes, including a revision to a fix 
made for version 1.0.10 where we're attempting to report on the "cause" 
of an error that is interrupted by a later failure to emit a ROLLBACK on 
the MySQL platform. While Python 3 solves this problem using exception 
chaining and cause reporting, on Python 2 we emit a warning so that the 
cause isn't totally concealed. The condition has been expanded to emit 
this warning in a much wider range of scenarios.


Changelog for 1.0.12 is at: 
http://www.sqlalchemy.org/changelog/CHANGES_1_0_12



SQLAlchemy 1.0.12 is available on the Download Page at 
http://www.sqlalchemy.org/download.html.



--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [sqlalchemy] Pyodbc.Connection has no attribute 'dbms_ver'?

2016-02-15 Thread Alex Hall 
An interesting development. I noticed that in site-packages\ibm_db_sa
was pyodbc.py. Thinking that might be an older version, I renamed it,
trying to force the import to use my installed version instead. It now
says "cannot import name pyodbc". I thought Python searched the
current directory, then the site-packages one, for modules? If so, and
if I can import pyodbc with no errors in the shell, why would
ibm_db_sa fail to import? This may be the problem--it was using an
older version of pyodbc and can't find the newer one for some reason.
Any ideas, or am I completely off track with this?

On 2/15/16, Alex Hall  wrote:
> Thanks guys. I've checked the version I'm using, and it reports that
> ibm_db_sa.__version__ is '0.3.2'. I have both ibm_db_sa and ibm_db
> installed. Should I remove ibm_db and rely only on ibm_db_sa instead?
> Is the former package causing a conflict somehow?
>
> On 2/15/16, Jaimy Azle  wrote:
>> Try to use ibm_db_sa 0.3.2 instead, apparently you are using the previous
>> version. dbms_ver is a feature specific of native ibm_db version of which
>> not available in pyodbc.
>>
>> https://pypi.python.org/pypi/ibm_db_sa/0.3.2
>>
>>
>> Salam,
>>
>> -Jaimy.
>>
>>
>> On Feb 12, 2016 22:05, "Alex Hall"  wrote:
>>
>>> Hello list,
>>> I've configured a DSN to a test version of my work's AS400 and I seem
>>> to be able to connect just fine (Yes!) I'm now running into a problem
>>> when I try to ask for a list of all tables. The line is:
>>>
>>>  dbInspector = inspect(dbEngine)
>>>
>>> The traceback is very long, and I can paste it if you want, but it
>>> ends with this:
>>>
>>> AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver'
>>>
>>> I'm unable to find anything about this online, so thought I'd check
>>> with this list. Here's my connection:
>>>
>>> dbEngine = create_engine("ibm_db_sa+pyodbc://user:pwd@myDSN")
>>>
>>> If anyone knows what is causing this, I'd appreciate your thoughts.
>>> I've installed pyodbc, ibm_db, and ibm_db_sa through pip, so I should
>>> have all the latest versions of everything. I'm on Windows 7x64,
>>> Python 2.7 (latest).
>>>
>>> --
>>> 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 post to this group, send email to sqlalchemy@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/sqlalchemy.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 post to this group, send email to sqlalchemy@googlegroups.com.
>> Visit this group at https://groups.google.com/group/sqlalchemy.
>> For more options, visit https://groups.google.com/d/optout.
>>
>

-- 
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

[sqlalchemy] test message, please ignore

2016-02-15 Thread Mike Bayer 

test

--
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

test message, please ignore

2016-02-15 Thread Mike Bayer 

test

--
You received this message because you are subscribed to the Google Groups 
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Re: [sqlalchemy] Pyodbc.Connection has no attribute 'dbms_ver'?

2016-02-15 Thread Alex Hall 
Thanks guys. I've checked the version I'm using, and it reports that
ibm_db_sa.__version__ is '0.3.2'. I have both ibm_db_sa and ibm_db
installed. Should I remove ibm_db and rely only on ibm_db_sa instead?
Is the former package causing a conflict somehow?

On 2/15/16, Jaimy Azle  wrote:
> Try to use ibm_db_sa 0.3.2 instead, apparently you are using the previous
> version. dbms_ver is a feature specific of native ibm_db version of which
> not available in pyodbc.
>
> https://pypi.python.org/pypi/ibm_db_sa/0.3.2
>
>
> Salam,
>
> -Jaimy.
>
>
> On Feb 12, 2016 22:05, "Alex Hall"  wrote:
>
>> Hello list,
>> I've configured a DSN to a test version of my work's AS400 and I seem
>> to be able to connect just fine (Yes!) I'm now running into a problem
>> when I try to ask for a list of all tables. The line is:
>>
>>  dbInspector = inspect(dbEngine)
>>
>> The traceback is very long, and I can paste it if you want, but it
>> ends with this:
>>
>> AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver'
>>
>> I'm unable to find anything about this online, so thought I'd check
>> with this list. Here's my connection:
>>
>> dbEngine = create_engine("ibm_db_sa+pyodbc://user:pwd@myDSN")
>>
>> If anyone knows what is causing this, I'd appreciate your thoughts.
>> I've installed pyodbc, ibm_db, and ibm_db_sa through pip, so I should
>> have all the latest versions of everything. I'm on Windows 7x64,
>> Python 2.7 (latest).
>>
>> --
>> 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 post to this group, send email to sqlalchemy@googlegroups.com.
>> Visit this group at https://groups.google.com/group/sqlalchemy.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 post to this group, send email to sqlalchemy@googlegroups.com.
> Visit this group at https://groups.google.com/group/sqlalchemy.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.