Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

URGENT !! Connection Caches and Oracle ODBC

3 posts in General Discussion (old) Last posting was on 2000-03-24 14:25:37.0Z
Rune Okstad Posted on 2000-03-24 13:43:22.0Z
Newsgroups: sybase.public.easerver
From: "Rune Okstad" <roks@online.no>
Subject: URGENT !! Connection Caches and Oracle ODBC
Date: Fri, 24 Mar 2000 14:43:22 +0100
Lines: 37
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: ti29a63-0024.dialup.online.no 130.67.135.152
Message-ID: <347_5eF$ddZl$GA.34@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25756
Article PK: 155806

Hello!

We're having trouble making Oracle ODBC work with Jaguar Connection Caches.

System:

EAServer Jaguar CTS 3.5
Database Oracle 8i 8.1.5
ODBC Oracle driver
OS Win NT SP 6


We have set up the ODBC connection and tested it with the Oracle ODBC test
tool and this works fine.
When trying to set up the connection cache in Jaguar, the system responds
with a ...the ODBC connect call failed.

We have tried to restart the Jaguar, but with no success.

When trying to refresh the cache, we get the following error in srvlog:
cm__odbc_alloc:alloc connection MEMORY_ERROR
Except from this, there are no error messages in none of the log files.

The strange thing is that we have the same connection working on other
computers.

Does anybody have a clue how to test/solve this?

I'd appreciate all answers.



Best Regards

Rune Okstad


Turk Vojan Posted on 2000-03-24 13:46:07.0Z
Newsgroups: sybase.public.easerver
From: "Turk Vojan" <turk.vojan@mobitel.si>
Subject: Re: URGENT !! Connection Caches and Oracle ODBC
Date: Fri, 24 Mar 2000 14:46:07 +0100
Lines: 46
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 193.189.186.50
Message-ID: <347_KV70ofZl$GA.201@forums.sybase.com>
References: <347_5eF$ddZl$GA.34@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25755
Article PK: 155807

I had a similar problem with MS SqlServer. Then I discovered that I was
using User DSN instead of System DSN. When I changed that, everything worked
fine.

Rune Okstad <roks@online.no> wrote in message
news:5eF$ddZl$GA.34@forums.sybase.com...
> Hello!
>
> We're having trouble making Oracle ODBC work with Jaguar Connection
Caches.
>
> System:
>
> EAServer Jaguar CTS 3.5
> Database Oracle 8i 8.1.5
> ODBC Oracle driver
> OS Win NT SP 6
>
>
> We have set up the ODBC connection and tested it with the Oracle ODBC test
> tool and this works fine.
> When trying to set up the connection cache in Jaguar, the system responds
> with a ...the ODBC connect call failed.
>
> We have tried to restart the Jaguar, but with no success.
>
> When trying to refresh the cache, we get the following error in srvlog:
> cm__odbc_alloc:alloc connection MEMORY_ERROR
> Except from this, there are no error messages in none of the log files.
>
> The strange thing is that we have the same connection working on other
> computers.
>
> Does anybody have a clue how to test/solve this?
>
> I'd appreciate all answers.
>
>
>
> Best Regards
>
> Rune Okstad
>
>


Rune Okstad Posted on 2000-03-24 14:25:37.0Z
Newsgroups: sybase.public.easerver
From: "Rune Okstad" <roks@online.no>
Subject: SV: URGENT !! Connection Caches and Oracle ODBC
Date: Fri, 24 Mar 2000 15:25:37 +0100
Lines: 63
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: ti29a63-0024.dialup.online.no 130.67.135.152
Message-ID: <347_N$AiF1Zl$GA.202@forums.sybase.com>
References: <347_5eF$ddZl$GA.34@forums.sybase.com> <347_KV70ofZl$GA.201@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:25752
Article PK: 155801

Thanks for answering!

Im already using System DSN.

Do you have any other suggestions?

Best Regards

Rune Okstad

Turk Vojan <turk.vojan@mobitel.si> skrev i
meldingsnyheter:KV70ofZl$GA.201@forums.sybase.com...

> I had a similar problem with MS SqlServer. Then I discovered that I was
> using User DSN instead of System DSN. When I changed that, everything
worked
> fine.
>
> Rune Okstad <roks@online.no> wrote in message
> news:5eF$ddZl$GA.34@forums.sybase.com...
> > Hello!
> >
> > We're having trouble making Oracle ODBC work with Jaguar Connection
> Caches.
> >
> > System:
> >
> > EAServer Jaguar CTS 3.5
> > Database Oracle 8i 8.1.5
> > ODBC Oracle driver
> > OS Win NT SP 6
> >
> >
> > We have set up the ODBC connection and tested it with the Oracle ODBC
test
> > tool and this works fine.
> > When trying to set up the connection cache in Jaguar, the system
responds
> > with a ...the ODBC connect call failed.
> >
> > We have tried to restart the Jaguar, but with no success.
> >
> > When trying to refresh the cache, we get the following error in srvlog:
> > cm__odbc_alloc:alloc connection MEMORY_ERROR
> > Except from this, there are no error messages in none of the log files.
> >
> > The strange thing is that we have the same connection working on other
> > computers.
> >
> > Does anybody have a clue how to test/solve this?
> >
> > I'd appreciate all answers.
> >
> >
> >
> > Best Regards
> >
> > Rune Okstad
> >
> >
>
>