daneshpatel / sqlalchemy-jdbcapi

SQLAlchemy dialect for JDBC supported database. (Using JDBCAPI)
Other
23 stars 25 forks source link

having trouble conneccting to a ibm iseries #8

Open sumosuzy opened 2 years ago

sumosuzy commented 2 years ago

I am having trouble connecting to an ibm iseries database

I am trying to follow your documentation for a generic JDBCConnection connection string example

I can connect through I can connect using jaydebeapi as follows

conn = jaydebeapi.connect( jclassname='com.ibm.as400.access.AS400JDBCDriver', url=host_url, driver_args=[user_name,password], jars=driver_location )

I am assuming the connection string is in this kind of format, I may be wrong create_engine("jdbcapi+jdbc:as400//username:password@HOST:1521/Database;JDBC_DRIVER_PATH =driver_location)

I keep on getting sqlalchemy.exc.ArgumentError: Could not parse rfc1738 URL from string

I am trying to create the connection string as follows engine=create_engine("jdbcapi+jdbc:as400//{}:{}@{};JDBC_DRIVER_PATH='{}'".format(username, password,host_thatworks_elsewhere,driver_location)

Any guidance would be appreciated