I am able to get cx_Oracle to connect just fine using the wallet alias:
import cx_Oracle
db = cx_Oracle.connect("/@PROD")
print db.version
db.close()
I just need to know how to put "/@PROD" in a URI format for sqlalchemy..
On Friday, May 27, 2016 at 9:31:35 AM UTC-5, Mike Bayer wrote:
>
> get it working with regular cx_oracle first. I'm not familiar with
> external password store so you should ask on the cx_oracle mailing list
> (https://sourceforge.net/p/cx-oracle/mailman/cx-oracle-users/)
>
>
>
> On 05/27/2016 10:18 AM, Matt Vasquez wrote:
> >
> > down votefavorite
> > <
> https://stackoverflow.com/questions/37471892/using-sqlalchemy-dburi-with-oracle-using-external-password-store#>
>
>
> >
> >
> > I am trying to get a oracle sqlalchemy dburi working with an external
> > password store (Oracle Wallet)
> >
> > I have tried using the standard sqlplus syntax for a external password
> > store with no luck..
> >
> > |sqlalchemy.dburi="oracle:///@PROD"|
> >
> > I can connect successfully using sqlplus as follows:
> >
> > |sqlplus /@PROD|
> >
> > I can't find any information on how to use external password stores with
> > sqlalchemy or turbogears?
> >
> > --
> > 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 [email protected] <javascript:>
> > <mailto:[email protected] <javascript:>>.
> > To post to this group, send email to [email protected]
> <javascript:>
> > <mailto:[email protected] <javascript:>>.
> > Visit this group at https://groups.google.com/group/sqlalchemy.
> > For more options, visit https://groups.google.com/d/optout.
>
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
