That is not the sytnax for oracle uris. The oracle syntax is:
DAL(''oracle://username:passw...@database' )
The oracle driver does not support connecting to a remote server. You
must be run a oracle client locally.
On Aug 27, 8:06 am, ionel <[email protected]> wrote:
> Hello,
>
> I have a problem when I try to connect to an Oracle database with this
> connection string:
>
> db = DAL("oracle://username:password@//network_server:1521/
> database_name")
>
> Traceback (most recent call last):
> File "C:\MyApps\web2py\gluon\restricted.py", line 186, in restricted
> exec ccode in environment
> File "C:/MyApps/web2py/applications/test1/models/db.py", line 16, in
> <module>
> db = DAL("oracle://username:password@//network_server:1521/
> database_name")
> File "C:\MyApps\web2py\gluon\sql.py", line 3992, in DAL
> raise RuntimeError, "%s (tried 5 times)" % exception
> RuntimeError: argument 1 must be unicode, not str (tried 5 times)
>
> 3987. except SyntaxError, exception:
> raise SyntaxError, exception
> except Exception, exception:
> if uri==uris[-1]:
> time.sleep(1)
> raise RuntimeError, "%s (tried 5 times)" % exception
>
> if __name__ == '__main__':
> import doctest
> doctest.testmod()
>
> * exception: TypeError('argument 1 must be unicode, not str',)
> * builtinRuntimeError: <type 'exceptions.RuntimeError'>
>
> Thank you.
>
> i
