Re: [sqlalchemy] How to use IBM i Access ODBC Driver

[Jack W.]

Mike --

I found *sqlalchemy-ibmi  *which 
connects but doesn't work all the way because it's aimed at SQLAlchemy 
1.3.x.
I'm trying Apache Superset which wants SQLAlchemy>=1.4.49.
I've filed an issue Apache Superset requires SQLAlchemy 1.4.x 
 with IBM to see if we 
can get an update.
Noting this all for the next IBM i person running up against this problem!
Thanks again, Mike, for your help.

On Wednesday, October 11, 2023 at 10:08:56 AM UTC-6 Jack W. wrote:

> Thanks for the prompt response, Michael ...
>
> On Wednesday, October 11, 2023 at 7:01:47 AM UTC-6 Mike Bayer wrote:
>
> SQLAlchemy does not include support for this driver - the only IBM driver 
> is the ibm_db_sa you reference, so short of writing your own driver based 
> on that one, that's what's available.
>
>
> I infer there's a plugin regimen in the SQLAlchemy source to connect with 
> supported drivers ... and some technology for type conversions?
> I guess I should clone the source and see if it's possible to add a hookup 
> for the IBM i Access Client Solutions ODBC driver?
>
>

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/1ca9897d-8276-42e4-8943-9599d4366349n%40googlegroups.com.

Re: [sqlalchemy] How to use IBM i Access ODBC Driver

[Jack W.]

Thanks for the prompt response, Michael ...

On Wednesday, October 11, 2023 at 7:01:47 AM UTC-6 Mike Bayer wrote:

SQLAlchemy does not include support for this driver - the only IBM driver 
is the ibm_db_sa you reference, so short of writing your own driver based 
on that one, that's what's available.


I infer there's a plugin regimen in the SQLAlchemy source to connect with 
supported drivers ... and some technology for type conversions?
I guess I should clone the source and see if it's possible to add a hookup 
for the IBM i Access Client Solutions ODBC driver?

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/b520f2dd-0bb7-4b74-b1d6-5a145858cd6bn%40googlegroups.com.

Re: [sqlalchemy] How to use IBM i Access ODBC Driver

[Mike Bayer]

SQLAlchemy does not include support for this driver - the only IBM driver is 
the ibm_db_sa you reference, so short of writing your own driver based on that 
one, that's what's available.



On Tue, Oct 10, 2023, at 11:07 PM, Jack W. wrote:
> I have the IBM i Access ODBC Driver 
>  
> installed on Linux and I'm trying out Apache Superset.
> 
> The SQLAlchemy URIs I create don't work, e.g.,
>  • iaccess+pyodbc://x  driver not found
>  • All the "traditional" URIs, e.g., using ibm_db_sa+pyodbc:///xxx don't 
> work because I don't have that older driver 
> 
>  installed (which does seem to be supported by SQLAlchemy).
> TIA for any tips.
> 
> 
> 
> -- 
> SQLAlchemy - 
> The Python SQL Toolkit and Object Relational Mapper
>  
> http://www.sqlalchemy.org/
>  
> To post example code, please provide an MCVE: Minimal, Complete, and 
> Verifiable Example. See http://stackoverflow.com/help/mcve for a full 
> description.
> --- 
> 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 view this discussion on the web visit 
> https://groups.google.com/d/msgid/sqlalchemy/ba319cc9-ef50-4eee-b16c-989a3e4fd971n%40googlegroups.com
>  
> .

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/1c282b20-613e-4de6-9f8e-0325706d9911%40app.fastmail.com.

[sqlalchemy] How to use IBM i Access ODBC Driver

[Jack W.]

I have the IBM i Access ODBC Driver 
 
installed on Linux and I'm trying out Apache Superset.

The SQLAlchemy URIs I create don't work, e.g.,

   - iaccess+pyodbc://x  driver not found
   - All the "traditional" URIs, e.g., using ibm_db_sa+pyodbc:///xxx 
   don't work because I don't have that older driver 
   

 
   installed (which does seem to be supported by SQLAlchemy).

TIA for any tips.

-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
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 view this discussion on the web visit 
https://groups.google.com/d/msgid/sqlalchemy/ba319cc9-ef50-4eee-b16c-989a3e4fd971n%40googlegroups.com.