You're onto something, I think. When I use a connection string of "ibm_db_sa://user:pwd@AS400IP:DBAccessPort/DBName" I get no errors. I don't actually get anything, though; my command prompt is unresponsive, as though waiting for a script to finish, but that's all. This seems to be the 400, though, because if I try to telnet into it with the same address and port, I get the same (lack of) response. This is progress, at least. Thanks for the help, and hopefully I'll have it from here! Here's to my next question being about doing things once I'm IN the database, rather than still knocking on its door.
On 2/16/16, Michal Petrucha <michal.petru...@koniiiik.org> wrote: > On Tue, Feb 16, 2016 at 10:27:40AM -0500, Alex Hall wrote: >> I have pyodbc 3.0.10, ibm_db_sa 0.3.2, and ibm_db 2.0.6. I'm also >> talking to people on the ibm_db list, and they suggested I re-install >> ibm_db and ibm_db_sa according to the official tutorial, which uses >> easy_install. I did so, but there was no change. >> >> As to pyodbc, I'm fine with not using it. Thus far, from the two lists >> I'm on and more research, I thought I *had to* use it to get things >> working right. Indeed, when I remove "+pyodbc" from my SA connection >> string, the dbms_ver error goes away. However, it's replaced by an >> error that the driver can't find the DSN name I give it, even though I >> can see that DSN right in the IBM ODBC manager on this computer. >> Someone mentioned 64-bit versus 32-bit; I'm using the 64-bit version >> of the ODBC manager, and 64-bit Python. I'm not sure how else to tell >> if the name of the DSN itself is in the correct format. >> >> The traceback is very long, but here it is in full: >> >> c:\python27\python.exe DBInterface2.py >> Traceback (most recent call last): > [...] >> File >> "c:\python27\lib\site-packages\ibm_db_sa-0.3.2-py2.7.egg\ibm_db_sa\base.p >> y", line 666, in initialize >> self.dbms_ver = connection.connection.dbms_ver >> AttributeError: 'pyodbc.Connection' object has no attribute 'dbms_ver' > > This traceback is still the dbms_ver thing, did you mean to post the > other one? > > In any case, when you're using a URI in the form of > "ibm_db_sa://user:pass@host/db_name", at least based on the example in > the IBM docs [1], I'm guessing that you shouldn't use the ODBC DSN you > have defined, but rather the server hostname or IP address directly. > In this case it should be using the IBM DBAPI driver directly, without > going through ODBC. > > Cheers, > > Michal > > > [1]: > https://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.swg.im.dbclient.python.doc/doc/t0060891.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. > -- 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.
