Cache connect to Oracle
A poster asked for help with an Oracle TimesTen "Cache Connect" error ("DSN not found or default DSN not specified") and wondered about version compatibility between TimesTen and Oracle 10.1/10.2. The thread is off-topic for an Informix group, and responses were mostly jokes ("Have you tried UPDATE STATISTICS") plus a suggestion to ask in comp.databases.oracle and a plug for migrating to Informix 11.1. No actual diagnosis or resolution of the DSN problem is recorded.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi friends i am facing a severe problem in cache connect to Oracle.i tried much but i got an error that DSN not found or default dsn not specified Please help anybody. i have a doubt that is'nt there any mismatch between the versions of timesten and oracle 10g i am using Oracle version 10.1...... is'nt it compatible with 10.2.............. Help!...........
gaurav wrote: > Hi friends > i am facing a severe problem in cache connect to Oracle.i tried > much but i got an error > that DSN not found or default dsn not specified > Please help anybody. > i have a doubt that is'nt there any mismatch between the versions of > timesten and oracle 10g > i am using Oracle version 10.1...... > is'nt it compatible with 10.2.............. > Help!........... > Have you tried UPDATE STATISTICS -- Clive
On May 30, 1:39 pm, Clive Eisen <c...@serendipita.com> wrote: > gaurav wrote: > > Hi friends > > i am facing a severe problem in cache connect to Oracle.i tried > > much but i got an error > > that DSN not found or default dsn not specified > > Please help anybody. > > i have a doubt that is'nt there any mismatch between the versions of > > timesten and oracle 10g > > i am using Oracle version 10.1...... > > is'nt it compatible with 10.2.............. > > Help!........... > > Have you tried UPDATE STATISTICS > > -- > Clive what will update statistics do?
gaurav <gsmart15@gmail.com> schrieb: >> > i am using Oracle version 10.1...... >> > is'nt it compatible with 10.2.............. >> > Help!........... >> >> Have you tried UPDATE STATISTICS >> Clive > >what will update statistics do? Nothing. Clive's answer was just a smartass way of trying to tell you that you are probably in the wrong newsgroup. Try comp.databases.oracle instead. HTH, Richard
gaurav said: > Hi friends > i am facing a severe problem in cache connect to Oracle.i tried > much but i got an error > that DSN not found or default dsn not specified > Please help anybody. > i have a doubt that is'nt there any mismatch between the versions of > timesten and oracle 10g > i am using Oracle version 10.1...... > is'nt it compatible with 10.2.............. > Help!........... Have you tried UPDATE STATISTICS? -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.
The best suggestion I can give you is that Informix 11.1 (Cheetah) will be released for general availability shortly. You should start planning your Oracle to Informix migration now. FYI: all Informix database servers are backward compatible by default. Online 5, and IDS 7,9,10 and 11 can all live happily together. --EEM > -----Original Message----- > From: informix-list-bounces@iiug.org [mailto:informix-list- > bounces@iiug.org] On Behalf Of gaurav > Sent: Wednesday, May 30, 2007 1:17 AM > To: informix-list@iiug.org > Subject: Cache connect to Oracle > > Hi friends > i am facing a severe problem in cache connect to Oracle.i tried > much but i got an error > that DSN not found or default dsn not specified > Please help anybody. > i have a doubt that is'nt there any mismatch between the versions of > timesten and oracle 10g > i am using Oracle version 10.1...... > is'nt it compatible with 10.2.............. > Help!........... > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list
On 29 May 2007 23:16:58 -0700, gaurav <gsmart15@gmail.com> wrote: > Hi friends > i am facing a severe problem in cache connect to Oracle.i tried > much but i got an error > that DSN not found or default dsn not specified > Please help anybody. > i have a doubt that is'nt there any mismatch between the versions of > timesten and oracle 10g > i am using Oracle version 10.1...... > is'nt it compatible with 10.2.............. > Help!........... > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > Try:- EXPORT INFORMIXDIR=/usr/informix cd $INFORMIXDIR ./installserver Keith
Clive Eisen said: > gaurav wrote: >> Hi friends >> i am facing a severe problem in cache connect to Oracle.i tried >> much but i got an error >> that DSN not found or default dsn not specified >> Please help anybody. >> i have a doubt that is'nt there any mismatch between the versions of >> timesten and oracle 10g >> i am using Oracle version 10.1...... >> is'nt it compatible with 10.2.............. >> Help!........... >> > Have you tried UPDATE STATISTICS Beat you to it! :op -- Bye now, Obnoxio "I'm astonished anyone pays real money for this crap." -- Cosmo -- This message has been scanned for viruses and dangerous content by OpenProtect(http://www.openprotect.com), and is believed to be clean.