[web2py] Re: TNS error on Oracle

Just spent 2 days on this error. Using instant client I needed to point ORACLE_HOME and TNS_ADMIN to the instanclient folder and make sure the tnsnames.ora file was inside. On Tuesday, March 6, 2012 8:21:52 AM UTC-6, rochacbruno wrote: > > Does anybody knows something about this? > > it connects

[web2py] Re: TNS error on Oracle

I have had success with the following connection string: db = DAL('oracle://user/password@sid') I tried out the alternate form you used: db = DAL('oracle://user/password@server:port/service_name') And it worked successfully. When I used a bad password or a bad service_name I saw a similar error

[web2py] Re: TNS error on Oracle

Hi! Are you sure that 3. db = DAL("oracle://ricardo/rica...@10.10.1.84:1521/XE") and not 3. db = DAL("oracle://ricardo/password@XE") On Mar 6, 6:21 pm, Bruno Rocha wrote: > Does anybody knows something about this? > > it connects with cx_oracle and raw queries, but gives this error