I did as suggested and cut my script back. It still hangs while trying to connect, or errors out if I try different ports (no surprise there). Below I'll paste the message I just sent to the ibm_db email list. At least, if this is identical to what ibm_db_sa is doing, it means that fixing it here should let SA suddenly start working properly.
I've cut back to a very, very basic script, using only ibm_db and nothing else. I'm running into exactly what I did when trying to use sqlalchemy: one of two errors, or an endless waiting period as I wait in vain for an answer from the server or a timeout. My script: import ibm_db dbConnection = ibm_db.pconnect("DATABASE=myLibraryName;HOSTNAME=1.2.3.4;PORT="+port+";PROTOCOL=TCPIP;UID=username;PWD=password", "", "") print ibm_db.conn_errormsg() I got the connection string from http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.1.0/com.ibm.swg.im.dbclient.python.doc/doc/t0054368.html I made the port number a variable because it is the thing that keeps giving me different results. The docs say to use 8471 or 9471 for database access (the latter for SSL), but those are when I get no response whatsoever. I've also tried 50000, 60000, and 446, all of which return errors immediately. The high numbers give me SQLCode-30081, and 446 gives me -30020. I even tried a DSN, but I got an error claiming it couldn't locate the specified DSN even though said DSN is right in the list when I open up ODBC Manager. The thing is, we have at least five computers that talk to this 400 for hours every day, so I know it can accept incoming connections. The computer on which I'm running this stuff can even do it, using the same software the other stations use, so I know my machine has the right drivers. Is there anything else I could try? I don't know much about the 400 itself, and it definitely works with all our current stations with no problems at all. That said, is there something on it that I should check? Anything anyone can think of will help. Thanks. On 2/17/16, Michal Petrucha <michal.petru...@koniiiik.org> wrote: > On Tue, Feb 16, 2016 at 04:02:08PM -0500, Alex Hall wrote: >> Great; I was hoping you wouldn't say that. :) I've been through them >> many, many times, trying to get the connection working. I've gone from >> error to error, and thought I had it all working when I finally got >> the create_engine line to run with no problem. Apparently I'm not as >> far along as I thought I was. Back to the drawing board. > > Hi Alex, > > I just want to reiterate my earlier suggestion – before you try to use > any SQLAlchemy machinery at all, first try to create a connection from > your Python runtime directly, using whichever DBAPI driver you want to > use (most likely you want to create a ibm_db connection object -- do > not import anything related to SQLAlchemy at this point, neither > sqlalchemy, nor ibm_db_sa), make sure you are able to execute SQL > statements using that, and only once you get this to work correctly, > try to figure out how to make it work with SQLAlchemy. > > And, of course, you shouldn't try to get SQLAlchemy to work all at > once either. First, create an Engine with a connection string, but do > not try to run any fancy introspection or anything before you make > sure that you can execute raw SQL queries using that engine. After you > get *that* out of the way, you can start trying out more advanced > features of SQLAlchemy. > > Baby steps, you know. Divide and conquer. Do not try to solve this > entire huge problem all at once. (And yes, as you are probably aware > by now, successfully connecting to an enterprise database server *is* > a huge problem.) That way you'll avoid false leads like this one. > > Good luck! > > Michal > > -- > 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.