cx_Oracle.DatabaseError: ORA-24315: illegal attribute type

[Michelle Lermon]

I am trying to connect to an Oracle database using cx_Oracle.

my code is the following:

import cx_Oracle
connection=cx_Oracle('user','pwd','host')

and I get the following error.
cx_Oracle.DatabaseError: ORA-24315: illegal attribute type

I can connect to the same database using SQL+ with all the same user, pwd, and host. I can not figure out what I am doing wrong.

thanks

[bvdet]

Try using a single string argument in the format "user/password@dsn".

[Michelle Lermon]

I get the same error if I use "user,password@host" or 'user','password','host'

[bvdet]

Oops! To create a connection object, you must call Connection() or connect() as in

import cx_Oracle
connection=cx_Oracle.Connection('user','pwd','host')

I wasn't paying attention.

[Michelle Lermon]

I actually mis-typed the code I was using and had cx_Oracle.connect('user/pwd@host') and it doesn't work. Though I am wondering if there is something with the path or environ var that I am missing.

[Dang]

I just had this problem, getting error: ORA-24315 no matter how I tried to connect.

I searched the web for hours, but didn't find the answer.
I figured it out, and will share, though it's a bit embarassing.

I originally downloaded/installed the Ora11g version, but the database is 10g.
I installed the 10g version of cx_Oracle, and the connection worked the first time.

--dang