Re: [sqlalchemy] Support for IBM AS/400 database
On Feb 18, 2010, at 10:36 AM, Jim Steil wrote: Hi Just wondering if there is support for the IBM AS/400 database using SQLAlchemy. IBM produces a DB2 driver, dont know if that overlaps with AS/400 compatibility or not. -Jim -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] Support for IBM AS/400 database
These is definitely more one DB2 driver for the AS/400. I seem to recall seeing that there was working being done with one of them a couple years ago, but don't recall which one. And, I don't know the status. Maybe a better question would be... Is there anyone else out there using SQLAlchemy with DB2 on an AS/400? -Jim On 2/19/2010 3:13 PM, Michael Bayer wrote: On Feb 18, 2010, at 10:36 AM, Jim Steil wrote: Hi Just wondering if there is support for the IBM AS/400 database using SQLAlchemy. IBM produces a DB2 driver, dont know if that overlaps with AS/400 compatibility or not. -Jim -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups sqlalchemy group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] Support for IBM AS/400 database
http://code.google.com/p/ibm-db/wiki/README
Let us know if it worked for you.
$ python
Python 2.5.1 (r251:54863, Oct 5 2007, 13:36:32)
[GCC 4.1.3 20070929 (prerelease) (Ubuntu 4.1.2-16ubuntu2)] on linux2
Type help, copyright, credits or license for more information.
import sqlalchemy
from sqlalchemy import *
import ibm_db_sa.ibm_db_sa
db2 =
sqlalchemy.create_engine('ibm_db_sa://db2inst1:sec...@host.name.com:5/pydev')
metadata = MetaData()
users = Table('users', metadata,
Column('user_id', Integer, primary_key = True),
Column('user_name', String(16), nullable = False),
Column('email_address', String(60), key='email'),
Column('password', String(20), nullable = False)
)
metadata.bind = db2
metadata.create_all()
users_table = Table('users', metadata, autoload=True, autoload_with=db2)
users_table
IBM_DB DB-API wrapper sanity test
Question is wether IBM_DB wrapper supports your as400 version. You
could try. I never found enough time to test the read functionality.
If you get it done then that would be nice as I have some data that I
need to read from there.
Thanks,
Lucas
On Fri, Feb 19, 2010 at 4:07 PM, Jim Steil j...@qlf.com wrote:
These is definitely more one DB2 driver for the AS/400. I seem to recall
seeing that there was working being done with one of them a couple years
ago, but don't recall which one. And, I don't know the status. Maybe a
better question would be... Is there anyone else out there using SQLAlchemy
with DB2 on an AS/400?
-Jim
On 2/19/2010 3:13 PM, Michael Bayer wrote:
On Feb 18, 2010, at 10:36 AM, Jim Steil wrote:
Hi
Just wondering if there is support for the IBM AS/400 database using
SQLAlchemy.
IBM produces a DB2 driver, dont know if that overlaps with AS/400
compatibility or not.
-Jim
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
OpenLdap server for User/Client Authentication in 1min.
http://lucasmanual.com/mywiki/OpenLdap#SetupOpenLdapserver.sh
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
Re: [sqlalchemy] Support for IBM AS/400 database
Here is the traceback I get when following that recipe...
import sqlalchemy
from sqlalchemy import *
import ibm_db_sa.ibm_db_sa
Traceback (most recent call last):
File stdin, line 1, in module
File
c:\python26\lib\site-packages\ibm_db_sa-0.1.6-py2.6.egg\ibm_db_sa\ibm_db
_sa.py, line 24, in module
from sqlalchemy import sql, engine, schema, exceptions, logging
ImportError: cannot import name logging
The recipe is assuming SQLAlchemy 0.4.0. I'm using 0.5.8.
-Jim
On 2/19/2010 5:17 PM, Lukasz Szybalski wrote:
http://code.google.com/p/ibm-db/wiki/README
Let us know if it worked for you.
$ python
Python 2.5.1 (r251:54863, Oct 5 2007, 13:36:32)
[GCC 4.1.3 20070929 (prerelease) (Ubuntu 4.1.2-16ubuntu2)] on linux2
Type help, copyright, credits or license for more information.
import sqlalchemy
from sqlalchemy import *
import ibm_db_sa.ibm_db_sa
db2 =
sqlalchemy.create_engine('ibm_db_sa://db2inst1:sec...@host.name.com:5/pydev')
metadata = MetaData()
users = Table('users', metadata,
Column('user_id', Integer, primary_key = True),
Column('user_name', String(16), nullable = False),
Column('email_address', String(60), key='email'),
Column('password', String(20), nullable = False)
)
metadata.bind = db2
metadata.create_all()
users_table = Table('users', metadata, autoload=True, autoload_with=db2)
users_table
IBM_DB DB-API wrapper sanity test
Question is wether IBM_DB wrapper supports your as400 version. You
could try. I never found enough time to test the read functionality.
If you get it done then that would be nice as I have some data that I
need to read from there.
Thanks,
Lucas
On Fri, Feb 19, 2010 at 4:07 PM, Jim Steilj...@qlf.com wrote:
These is definitely more one DB2 driver for the AS/400. I seem to recall
seeing that there was working being done with one of them a couple years
ago, but don't recall which one. And, I don't know the status. Maybe a
better question would be... Is there anyone else out there using SQLAlchemy
with DB2 on an AS/400?
-Jim
On 2/19/2010 3:13 PM, Michael Bayer wrote:
On Feb 18, 2010, at 10:36 AM, Jim Steil wrote:
Hi
Just wondering if there is support for the IBM AS/400 database using
SQLAlchemy.
IBM produces a DB2 driver, dont know if that overlaps with AS/400
compatibility or not.
-Jim
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
--
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
