Specifying a port in the connection string leads to an error

[merhovon]

Hello everyone,

I use the following connection parameter which leads to the problem:

connection_string = f"ibmi://{user}:{password}@{host}:{port}/{database}?current_schema={schema}"

The error is then thrown here:

def create_connect_args(self, url):
    opts = url.translate_connect_args(username="user", host="system")
    opts.update(url.query)

    # Allow both our specific keywords and the SQLAlchemy base keywords
    allowed_opts = (
        set(self.DRIVER_KEYWORD_MAP.keys())
        | self.DRIVER_KEYWORDS_SPECIAL
        | {"autocommit", "readonly", "timeout"}
    )

    if not allowed_opts.issuperset(opts.keys()):
        raise ValueError("Option entered not valid for IBM i Access ODBC Driver")

How can I specify a port and is SSL not supported for the connection string?