Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

having trouble conneccting to a ibm iseries #8

Open
sumosuzy opened this issue May 3, 2022 · 0 comments
Open

having trouble conneccting to a ibm iseries #8

sumosuzy opened this issue May 3, 2022 · 0 comments

Comments

@sumosuzy
Copy link

sumosuzy commented May 3, 2022

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant