Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

hi there - please direct these requests to the IBM list at: https://groups.google.com/forum/#!forum/ibm_db On Tue, Nov 21, 2017 at 2:25 PM, nahumcastro wrote: > Hello all. > > I have the same problem with db2 for as400, seems to be very different from > db2 in windows,

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

Hello all. I have the same problem with db2 for as400, seems to be very different from db2 in windows, linux. Here is what I have found: this string dont apply for as400 as documented: ibm_db_sa://user:pass@server:port/database because when you connect to an as400 there is only one database

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

On Thu, Feb 11, 2016 at 01:16:03PM -0500, Alex Hall wrote: > I've done more research on this topic. There's a lot out there about > using MSSQL with SA, but next to nothing about using ibm_db_sa or > specifying drivers. > > I have pyodbc installed. I downloaded IBM's ODBC zip file, and I've > put

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

Thanks so much for your reply--this really helps! I asked the people at work, and was told that my machine does, in fact, have some sort of IBM manager installed. (Can you tell I'm new to this technology and this job?) Using it, I was able to create a DSN to the test database and, it seems,

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

I think I'm confused. Isn't Pyodbc an alternative to SQLAlchemy? If not, how would the two work together? I just looked through the 'Getting Started' and 'API' docs for Pyodbc, and I don't see any examples. I found some samples online of people using the two together, but I don't quite follow how

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

I've done more research on this topic. There's a lot out there about using MSSQL with SA, but next to nothing about using ibm_db_sa or specifying drivers. I have pyodbc installed. I downloaded IBM's ODBC zip file, and I've put db2odbc64.dll in my project folder, but don't know how to point SA or

[sqlalchemy] Connecting to AS400 with SQLAlchemy fails

Hello list, I sent this to the ibm_db list yesterday, but no one has responded yet. Since it's as much ibm_db as SA, I thought I'd try here as well in case any of you have used an AS400 before. I have ibm_db, ibm_db_sa, the latest sqlalchemy, and Python 2.7 (latest) installed. I can talk to SQLite

Re: [sqlalchemy] Connecting to AS400 with SQLAlchemy fails

Connecting to AS400 from native ibm_db_dbi driver would need db2 connect which is a separated product from IBM. Use the ibm_db_sa pyodbc driver instead, or jdbc (jython) if you don't have db2 connect installed on your machine. Salam, -Jaimy On Feb 11, 2016 01:50, "Alex Hall"