Re: ora-01843 client problem

On 28 Jan 2004 14:34:05 -0800, strepxe_at_yahoo.co.uk (championsleeper) wrote:

>We are installing an application using the oracle 9i database.
>
>When we try to connect the client to the application we get the error
>ora-01834 - date format not valid.
>
>The client communicates with the application/database using microsoft
>odbc and the oracle client.
>
>I'm not sure where to look to start the investigation as I'm not sure
>where the dependancies are on the client and server. The client pc is
>windows 2000. The server is UNIX.
>
>- do the environment settings on the pc impact the flow of data
>between client and server ?

Yes

>- if so, how ? is it the case that the environment settings on your pc
>client affect the odbc settings ?

Which odbc settings?
>- should i concern myself with the environment variable settings in
>control panel or the ones in the registry ? there are enviromnent
>settings relating to the oracle client in the registry. is that
>somwhere to look ?

Enviroment variables will override the variables in the registry
>- can i operate odbc in some sort of debug mode to see what data is
>being transferred when it is used as a communication medium ?
>

You can make the odbc client log, by using the appropiate options in the odbc administrator applet in Control Panel.

>I need to solve this problem pretty urgently but am also genuinely
>interested in understanding the process involved (not the best time to
>start learning). any help/advice or pointers towards documentation
>would be most appreciated!
>
>Thanks,
>
>G

--
Sybrand Bakker, Senior Oracle DBA