[Squirrel-sql-users] Setting up Oracle alias - Timezone not found error

[jkl_sal <jk...@ho...>]

Hello I am trying to setup a connection to an Oracle db using squirrel
Snapshot-20100905_1342.

The oracle client is OraClient11g_home1

I have created thin client drivers setting in extra class path ojdbc6_g.jar.

I create the alias set url
jdbc:oracle:thin:@150.45.91.98:1521:TLMSO1

and when i try to connect i get: 

ORA-00604: error occurred at recursive SQL level 1
ORA-01882: timezone region  not found

I have seen in some forums that this is a kind of common problem when
setting up oracle connections and the suggestion was to set manualy the time
zone using realative commands to change the connection settings.


How can i do that in squirrel? I saw that you can add commands to the url to
be executed on connection.

Thanks in advance for the help!!



--
View this message in context: http://squirrel-sql-client.10976.n7.nabble.com/Setting-up-Oracle-alias-Timezone-not-found-error-tp3248.html
Sent from the Users mailing list archive at Nabble.com.