ActivityPub Viewer

A small tool to view real-world ActivityPub objects as JSON! Enter a URL or username from Mastodon or a similar service below, and we'll send a request with the right Accept header to the server to view the underlying object.

Open in browser →
{ "@context": [ "https://join-lemmy.org/context.json", "https://www.w3.org/ns/activitystreams" ], "type": "Page", "id": "https://discuss.online/post/18325956", "attributedTo": "https://discuss.online/u/peterg75", "to": [ "https://programming.dev/c/python", "https://www.w3.org/ns/activitystreams#Public" ], "name": "Help! Connecting to IBM Informix DB", "cc": [], "content": "<p>Hello, Python Community!</p>\n<p>Has someone been able to successfully connect to an IBM Informix DB with a Python app? I have the following environment:\nDEV:\nWindows 11\nPython 3.13.3 64-bit\nVS Code</p>\n<p>DB:\nIBM Informix 12.10 hosted in Azure\nI’m able to connect to it usind DBeaver (JDBC)</p>\n<p>I have tried the following libraries to try to establish the connection:\nibm_db:\n<code> Traceback (most recent call last): File “c:\\Users\\peterg\\source\\python\\dbApp\\ibm_db_test.py”, line 1, in &lt;module&gt; import ibm_db as db ImportError: DLL load failed while importing ibm_db: The specified module could not be found._</code></p>\n<p>pyodbc:\nI have an ODBC DSN connection established\n<code>Traceback (most recent call last): File “c:\\Users\\peterg\\source\\python\\dbApp\\pyodbc_test.py”, line 3, in &lt;module&gt; conn = db.connect(“Dsn=‘DSN_NAME’”) pyodbc.InterfaceError: (‘IM002’, ‘[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)’)</code></p>\n<p>JayDeBeAPI:\nI have downloaded the same JAR files as DBeaver uses and copied them to a dir local to the project and added the CLASSPATH variable: set “CLASSPATH=%PROJECT_ROOT%\\Java\\jbc-4.50.10.1.jar:%PROJECT_ROOT%\\Java\\bson-3.8.0.jar”</p>\n<p><code>File “c:\\Users\\peterg\\source\\python\\dbApp\\JayDeBeApi_test.py”, line 3, in &lt;module&gt; dbConn = db.connect(“com.informix.jdbc.IfxDriver”, “jdbc:informix-sqli://hostname:port/db_name:INFORMIXSERVER=server_name”, [‘user’, ‘pass’]) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py”, line 412, in connect jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py”, line 221, in _jdbc_connect_jpype jpype.JClass(jclassname) ~~~~~~~~~~~~^^^^^^^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jpype\\_jclass.py”, line 99, in __new__ return _jpype._getClass(jc) ~~~~~~~~~~~~~~~~^^^^ TypeError: Class com.informix.jdbc.IfxDriver is not found</code></p>\n<p>PyInformix:\n<code>SADeprecationWarning: The dbapi() classmethod on dialect classes has been renamed to import_dbapi(). Implement an import_dbapi() classmethod directly on class &lt;class ‘pyinformix.ifx_jdbc.InformixJDBCDialect’&gt; to remove this warning; the old .dbapi() classmethod may be maintained for backwards compatibility. engine = create_engine(‘informix+ifx_jdbc://hostname:port/db_name;INFORMIXSERVER=server_name;delimident=y;user=user;password=pass’) Traceback (most recent call last): File “c:\\Users\\peterg\\source\\python\\dbApp\\PyInformix_test.py”, line 5, in &lt;module&gt; conn = engine.connect() File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py”, line 3274, in connect return self._connection_cls(self) ~~~~~~~~~~~~~~~~~~~~^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py”, line 146, in __init__ self._dbapi_connection = engine.raw_connection() ~~~~~~~~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py”, line 3298, in raw_connection return self.pool.connect() ~~~~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 449, in connect return _ConnectionFairy._checkout(self) ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 1264, in _checkout fairy = _ConnectionRecord.checkout(pool) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 713, in checkout rec = pool._do_get() File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\impl.py”, line 179, in _do_get with util.safe_reraise(): ~~~~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\util\\langhelpers.py”, line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\impl.py”, line 177, in _do_get return self._create_connection() ~~~~~~~~~~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 390, in _create_connection return _ConnectionRecord(self) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 675, in __init__ self.__connect() ~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 901, in __connect with util.safe_reraise(): ~~~~~~~~~~~~~~~~~^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\util\\langhelpers.py”, line 146, in __exit__ raise exc_value.with_traceback(exc_tb) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py”, line 897, in __connect self.dbapi_connection = connection = pool._invoke_creator(self) ~~~~~~~~~~~~~~~~~~~~^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\create.py”, line 646, in connect return dialect.connect(*cargs, **cparams) ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\default.py”, line 625, in connect return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501 ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py”, line 412, in connect jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs) File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py”, line 221, in _jdbc_connect_jpype jpype.JClass(jclassname) ~~~~~~~~~~~~^^^^^^^^^^^^ File “C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jpype\\_jclass.py”, line 99, in __new__ return _jpype._getClass(jc) ~~~~~~~~~~~~~~~~^^^^ TypeError: Class com.informix.jdbc.IfxDriver is not found</code></p>\n<p>IfxPy:</p>\n<p>Uanble to install, seems that it does not support the latest Python 3 version.</p>\n<p>Any help would be appreciated. I can attach the sample code of every method I tried if that would help.</p>\n", "mediaType": "text/html", "source": { "content": "Hello, Python Community!\n\nHas someone been able to successfully connect to an IBM Informix DB with a Python app? I have the following environment:\nDEV:\nWindows 11\nPython 3.13.3 64-bit\nVS Code\n\nDB:\nIBM Informix 12.10 hosted in Azure\nI'm able to connect to it usind DBeaver (JDBC)\n\nI have tried the following libraries to try to establish the connection:\nibm_db:\n` \nTraceback (most recent call last):\n File \"c:\\Users\\peterg\\source\\python\\dbApp\\ibm_db_test.py\", line 1, in <module>\n import ibm_db as db\nImportError: DLL load failed while importing ibm_db: The specified module could not be found._\n`\n\npyodbc:\nI have an ODBC DSN connection established\n`\nTraceback (most recent call last):\n File \"c:\\Users\\peterg\\source\\python\\dbApp\\pyodbc_test.py\", line 3, in <module>\n conn = db.connect(\"Dsn='DSN_NAME'\")\npyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')\n`\n\nJayDeBeAPI:\nI have downloaded the same JAR files as DBeaver uses and copied them to a dir local to the project and added the CLASSPATH variable: set \"CLASSPATH=%PROJECT_ROOT%\\Java\\jbc-4.50.10.1.jar:%PROJECT_ROOT%\\Java\\bson-3.8.0.jar\"\n\n`\nFile \"c:\\Users\\peterg\\source\\python\\dbApp\\JayDeBeApi_test.py\", line 3, in <module>\n dbConn = db.connect(\"com.informix.jdbc.IfxDriver\",\n \"jdbc:informix-sqli://hostname:port/db_name:INFORMIXSERVER=server_name\",\n ['user', 'pass'])\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py\", line 412, in connect\n jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py\", line 221, in _jdbc_connect_jpype\n jpype.JClass(jclassname)\n ~~~~~~~~~~~~^^^^^^^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jpype\\_jclass.py\", line 99, in __new__\n return _jpype._getClass(jc)\n ~~~~~~~~~~~~~~~~^^^^\nTypeError: Class com.informix.jdbc.IfxDriver is not found\n`\n\nPyInformix:\n`\nSADeprecationWarning: The dbapi() classmethod on dialect classes has been renamed to import_dbapi(). Implement an import_dbapi() classmethod directly on class <class 'pyinformix.ifx_jdbc.InformixJDBCDialect'> to remove this warning; the old .dbapi() classmethod may be maintained for backwards compatibility.\n engine = create_engine('informix+ifx_jdbc://hostname:port/db_name;INFORMIXSERVER=server_name;delimident=y;user=user;password=pass')\nTraceback (most recent call last):\n File \"c:\\Users\\peterg\\source\\python\\dbApp\\PyInformix_test.py\", line 5, in <module>\n conn = engine.connect()\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 3274, in connect\n return self._connection_cls(self)\n ~~~~~~~~~~~~~~~~~~~~^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 146, in __init__\n self._dbapi_connection = engine.raw_connection()\n ~~~~~~~~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\base.py\", line 3298, in raw_connection\n return self.pool.connect()\n ~~~~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 449, in connect\n return _ConnectionFairy._checkout(self)\n ~~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 1264, in _checkout\n fairy = _ConnectionRecord.checkout(pool)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 713, in checkout\n rec = pool._do_get()\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\impl.py\", line 179, in _do_get\n with util.safe_reraise():\n ~~~~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\util\\langhelpers.py\", line 146, in __exit__\n raise exc_value.with_traceback(exc_tb)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\impl.py\", line 177, in _do_get\n return self._create_connection()\n ~~~~~~~~~~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 390, in _create_connection\n return _ConnectionRecord(self)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 675, in __init__\n self.__connect()\n ~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 901, in __connect\n with util.safe_reraise():\n ~~~~~~~~~~~~~~~~~^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\util\\langhelpers.py\", line 146, in __exit__\n raise exc_value.with_traceback(exc_tb)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\pool\\base.py\", line 897, in __connect\n self.dbapi_connection = connection = pool._invoke_creator(self)\n ~~~~~~~~~~~~~~~~~~~~^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\create.py\", line 646, in connect\n return dialect.connect(*cargs, **cparams)\n ~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\sqlalchemy\\engine\\default.py\", line 625, in connect\n return self.loaded_dbapi.connect(*cargs, **cparams) # type: ignore[no-any-return] # NOQA: E501\n ~~~~~~~~~~~~~~~~~~~~~~~~~^^^^^^^^^^^^^^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py\", line 412, in connect\n jconn = _jdbc_connect(jclassname, url, driver_args, jars, libs)\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jaydebeapi\\__init__.py\", line 221, in _jdbc_connect_jpype\n jpype.JClass(jclassname)\n ~~~~~~~~~~~~^^^^^^^^^^^^\n File \"C:\\Users\\peterg\\AppData\\Local\\Programs\\Python\\Python313\\Lib\\site-packages\\jpype\\_jclass.py\", line 99, in __new__\n return _jpype._getClass(jc)\n ~~~~~~~~~~~~~~~~^^^^\nTypeError: Class com.informix.jdbc.IfxDriver is not found\n`\n\nIfxPy:\n\nUanble to install, seems that it does not support the latest Python 3 version.\n\nAny help would be appreciated. I can attach the sample code of every method I tried if that would help.", "mediaType": "text/markdown" }, "attachment": [], "sensitive": false, "published": "2025-04-11T12:56:55.248581Z", "audience": "https://programming.dev/c/python", "tag": [ { "href": "https://discuss.online/post/18325956", "name": "#python", "type": "Hashtag" } ] }