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.

SQL Anywhere 5 connection cache

5 posts in General Discussion (old) Last posting was on 2000-03-13 19:49:14.0Z
Vladimir Delgado Posted on 2000-03-10 16:07:08.0Z
Newsgroups: sybase.public.easerver
Date: Fri, 10 Mar 2000 12:07:08 -0400
From: Vladimir Delgado <vdelgadop@telcel.net.ve>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: SQL Anywhere 5 connection cache
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
NNTP-Posting-Host: val1-ppp095.t-net.net.ve 200.35.112.97
Message-ID: <347_38C91DAC.53A248EB@telcel.net.ve>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26678
Article PK: 157675

I'm having problems configuring and connection cache for Sql anywhere
5.0. Odbc DSN refers to a server using netbios protocol. When i try to
ping the connection cache i received the "conection refused" error so i
looked into the serv.log and i found this error: 2000 invalid con_lib.

If anybody can help i would appreciate it,

thanks in advance,

Vladimir


Jim O'Neil [Sybase] Posted on 2000-03-13 19:49:14.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 13 Mar 2000 14:49:14 -0500
From: "Jim O'Neil [Sybase]" <joneil@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en]C-CCK-MCD (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: SQL Anywhere 5 connection cache
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 26
NNTP-Posting-Host: joneil-nt.sybase.com 204.167.42.111
Message-ID: <347_38CD463A.87538B1F@sybase.com>
References: <347_38C91DAC.53A248EB@telcel.net.ve>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26500
Article PK: 157514


Vladimir Delgado wrote:

> I'm having problems configuring and connection cache for Sql anywhere
> 5.0. Odbc DSN refers to a server using netbios protocol. When i try to
> ping the connection cache i received the "conection refused" error so i
> looked into the serv.log and i found this error: 2000 invalid con_lib.
>
> If anybody can help i would appreciate it,
>
> thanks in advance,
>
> Vladimir

Invalid con_lib would result from specifying the wrong DLL name on the
Connection Cache information. Can you confirm that you specified ODBC32.DLL
in the single-line edit and that you specified the ODBC radio button? Your
cache information is located in your afconfig.dat file, which is encrypted,
but if you want to post it here or e-mail it to me, I can take a look at it
for you. I've seen these cache definitions being corrupted in that file -
even to the point that the server crashes upon start up.
--
Jim O'Neil
Senior Technical Support Engineer
Sybase, Inc


Dean Jones [Team Sybase] Posted on 2000-03-10 16:29:25.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: SQL Anywhere 5 connection cache
Date: Fri, 10 Mar 2000 10:29:25 -0600
Lines: 36
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: modem7.outtech.com 216.207.144.237
Message-ID: <347_hJJcF5qi$GA.74@forums.sybase.com>
References: <347_38C91DAC.53A248EB@telcel.net.ve>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26674
Article PK: 157668

You are defining an System DSN for your ODBC?

After setting up the System DSN can you test the ODBC connection?

What values are you using to setup your Jaguar connection cache?

Are you restarting Jaguar after installing the connection cache?

Sorry for so many questions.
--

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.

Seminar on April 26 and 27, Don't Miss it!
www.powerobjects.com/seminar

http://www.powerobjects.com

Vladimir Delgado <vdelgadop@telcel.net.ve> wrote in message
news:38C91DAC.53A248EB@telcel.net.ve...
> I'm having problems configuring and connection cache for Sql anywhere
> 5.0. Odbc DSN refers to a server using netbios protocol. When i try to
> ping the connection cache i received the "conection refused" error so i
> looked into the serv.log and i found this error: 2000 invalid con_lib.
>
> If anybody can help i would appreciate it,
>
> thanks in advance,
>
> Vladimir
>


Vladimir Delgado Posted on 2000-03-13 14:26:58.0Z
Newsgroups: sybase.public.easerver
Date: Mon, 13 Mar 2000 10:26:58 -0400
From: Vladimir Delgado <vdelgadop@telcel.net.ve>
X-Mailer: Mozilla 4.72 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: SQL Anywhere 5 connection cache
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Lines: 36
NNTP-Posting-Host: val3-ppp075.t-net.net.ve 200.35.113.77
Message-ID: <347_38CCFAB2.EAE6ACAE@telcel.net.ve>
References: <347_38C91DAC.53A248EB@telcel.net.ve> <347_hJJcF5qi$GA.74@forums.sybase.com>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26560
Article PK: 157575

Well i'm defining a system odbc.

I have tested the connection from PB and Sybase Central and it worked
perfectly.

I'm setting the connection cache using the standard values to an odbc
connection defining server name, uesrid, password and using th odbc32.dll
library.

I didn´t restart Jaguar I just refreshed the connection cache folder.

Vladimir

"Dean Jones [Team Sybase]" wrote:

> You are defining an System DSN for your ODBC?
>
> After setting up the System DSN can you test the ODBC connection?
>
> What values are you using to setup your Jaguar connection cache?
>
> Are you restarting Jaguar after installing the connection cache?
>
> Sorry for so many questions.
> --
>
> Dean Jones, CPD Professional
> Team Sybase
> PowerTeam, Inc.
>
> Seminar on April 26 and 27, Don't Miss it!
> www.powerobjects.com/seminar
>
> http://www.powerobjects.com
>
> Vladimir Delgado <vdelgadop@telcel.net.ve> wrote in message
> news:38C91DAC.53A248EB@telcel.net.ve...
> > I'm having problems configuring and connection cache for Sql anywhere
> > 5.0. Odbc DSN refers to a server using netbios protocol. When i try to
> > ping the connection cache i received the "conection refused" error so i
> > looked into the serv.log and i found this error: 2000 invalid con_lib.
> >
> > If anybody can help i would appreciate it,
> >
> > thanks in advance,
> >
> > Vladimir
> >


Dean Jones [Team Sybase] Posted on 2000-03-13 19:10:46.0Z
Newsgroups: sybase.public.easerver
From: "Dean Jones [Team Sybase]" <dean_no_spam_@powerobjects.com>
Subject: Re: SQL Anywhere 5 connection cache
Date: Mon, 13 Mar 2000 13:10:46 -0600
Lines: 72
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: 146.217.145.124
Message-ID: <347_19hx4ASj$GA.202@forums.sybase.com>
References: <347_38C91DAC.53A248EB@telcel.net.ve> <347_hJJcF5qi$GA.74@forums.sybase.com> <347_38CCFAB2.EAE6ACAE@telcel.net.ve>
Path: forums-1-dub!forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.easerver:26513
Article PK: 157528

Restart Jaguar.

You are using the System ODBC for the server name?

--

Dean Jones, CPD Professional
Team Sybase
PowerTeam, Inc.

Seminar on April 26 and 27, Don't Miss it!
www.powerobjects.com/seminar

http://www.powerobjects.com

Vladimir Delgado <vdelgadop@telcel.net.ve> wrote in message
news:38CCFAB2.EAE6ACAE@telcel.net.ve...
> Well i'm defining a system odbc.
>
> I have tested the connection from PB and Sybase Central and it worked
> perfectly.
>
> I'm setting the connection cache using the standard values to an odbc
> connection defining server name, uesrid, password and using th odbc32.dll
> library.
>
> I didn´t restart Jaguar I just refreshed the connection cache folder.
>
> Vladimir
>
>
> "Dean Jones [Team Sybase]" wrote:
>
> > You are defining an System DSN for your ODBC?
> >
> > After setting up the System DSN can you test the ODBC connection?
> >
> > What values are you using to setup your Jaguar connection cache?
> >
> > Are you restarting Jaguar after installing the connection cache?
> >
> > Sorry for so many questions.
> > --
> >
> > Dean Jones, CPD Professional
> > Team Sybase
> > PowerTeam, Inc.
> >
> > Seminar on April 26 and 27, Don't Miss it!
> > www.powerobjects.com/seminar
> >
> > http://www.powerobjects.com
> >
> > Vladimir Delgado <vdelgadop@telcel.net.ve> wrote in message
> > news:38C91DAC.53A248EB@telcel.net.ve...
> > > I'm having problems configuring and connection cache for Sql anywhere
> > > 5.0. Odbc DSN refers to a server using netbios protocol. When i try
to
> > > ping the connection cache i received the "conection refused" error so
i
> > > looked into the serv.log and i found this error: 2000 invalid con_lib.
> > >
> > > If anybody can help i would appreciate it,
> > >
> > > thanks in advance,
> > >
> > > Vladimir
> > >
>