the behavior here is exactly that which I described at http://groups.google.com/group/sqlalchemy/msg/ab479d4762c24c65 . The presence of the slash invokes the usage of cx_oracle makedsn(), in this case with a blank dsn, whereas when not, sends the hostname "localhost" as the DSN argument directly to cx_oracle.connect().
On Jun 2, 2010, at 10:43 AM, dhanil anupurath wrote: > Hi > > I am using Oracle with SQLalchemy in my application. > 1. The SQLalchemy documentation gives the following as the connect > string for Oracle > > sqlalchemy.url=oracle://user:passw...@localhost:1521/ > SID_name > > 2. The above connect string does not seem to work in my > application. > I get the following error: > sqlalchemy.exc.DatabaseError: (DatabaseError) ORA-12505: > TNS:listener does not currently > know of SID given in connect descriptor > > 3. However, my application works without the SID_name as shown > below: > > sqlalchemy.url=oracle://user:passw...@localhost:1521 > > 4. I created the database schema in Oracle DBManager using the > "Create User" menu option > > Could someone please tell me what I am doing wrong? > I would appreciate any help. > > Thanks > > > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to sqlalch...@googlegroups.com. > To unsubscribe from this group, send email to > sqlalchemy+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
