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.

ASE 12.5 ODBC Connection Pooling

4 posts in General Discussion Last posting was on 2010-05-04 17:01:10.0Z
K R Posted on 2010-05-03 18:05:36.0Z
Reply-To: "K R" <kjr_23@yahoo.com.nospam>
From: "K R" <kjr_23@yahoo.com.nospam>
Newsgroups: sybase.public.ase.general
Subject: ASE 12.5 ODBC Connection Pooling
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bdf1070@forums-1-dub>
Date: 3 May 2010 11:05:36 -0700
X-Trace: forums-1-dub 1272909936 10.22.241.152 (3 May 2010 11:05:36 -0700)
X-Original-Trace: 3 May 2010 11:05:36 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29173
Article PK: 78409

I'm trying to setup an ASE ODBC connection pool on a Win2003 server. The
Sybase Open Client has been installed on the server, and when I go into ODBC
Administrator, System DSN, and create a new Sybase connection, I get the
ODBC Sybase Wire Protocol Driver Setup screen. I enter the parameters and
click Test Connection, where I get prompted for Login ID and Password. When
I enter these values, it connects fine. I suspect that for the connection
pool to work, you need to somehow supply these values outside of the
application (PB12 .NET assembly as a webservice). Can someone let me know
how to save these values so the pool will work?


Cory Sane [TeamSybase] Posted on 2010-05-04 04:10:05.0Z
From: "Cory Sane [TeamSybase]" <cory!=sane>
Newsgroups: sybase.public.ase.general
References: <4bdf1070@forums-1-dub>
In-Reply-To: <4bdf1070@forums-1-dub>
Subject: Re: ASE 12.5 ODBC Connection Pooling
Lines: 27
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6002.18005
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6002.18005
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4bdf9e1d$1@forums-1-dub>
Date: 3 May 2010 21:10:05 -0700
X-Trace: forums-1-dub 1272946205 10.22.241.152 (3 May 2010 21:10:05 -0700)
X-Original-Trace: 3 May 2010 21:10:05 -0700, vip152.sybase.com
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29174
Article PK: 78410

KR,
Connection pooling is done my an application middleware piece that is generally coded by developers.
Clients connect to Application middle ware servers and these servers do connection pooling into a dbms such as ASE.
Clients->AppServer>dbms.

The ODBS Administrator is just going to define the connection for simple utilites like MS-Access/Excell/MS-SQL.


Your question would better be posted in the Sybase.public.Connectivity.ODBC group or a PB.general group.


--
Cory Sane
[TeamSybase]
Certified Sybase Associate DBA for ASE 15.0

"K R" <kjr_23@yahoo.com.nospam> wrote in message news:4bdf1070@forums-1-dub...
> I'm trying to setup an ASE ODBC connection pool on a Win2003 server. The
> Sybase Open Client has been installed on the server, and when I go into ODBC
> Administrator, System DSN, and create a new Sybase connection, I get the
> ODBC Sybase Wire Protocol Driver Setup screen. I enter the parameters and
> click Test Connection, where I get prompted for Login ID and Password. When
> I enter these values, it connects fine. I suspect that for the connection
> pool to work, you need to somehow supply these values outside of the
> application (PB12 .NET assembly as a webservice). Can someone let me know
> how to save these values so the pool will work?
>
>


K R Posted on 2010-05-04 12:47:17.0Z
Reply-To: "K R" <kjr_23@yahoo.com.nospam>
From: "K R" <kjr_23@yahoo.com.nospam>
Newsgroups: sybase.public.ase.general
References: <4bdf1070@forums-1-dub> <4bdf9e1d$1@forums-1-dub>
Subject: Re: ASE 12.5 ODBC Connection Pooling
Lines: 44
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4be01755$1@forums-1-dub>
Date: 4 May 2010 05:47:17 -0700
X-Trace: forums-1-dub 1272977237 10.22.241.152 (4 May 2010 05:47:17 -0700)
X-Original-Trace: 4 May 2010 05:47:17 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29176
Article PK: 78412

Thanks Cory,
I've done quite a bit of work with EA Server, Weblogic and Websphere, so
I'm comfortable with connection pooling on the app server side. I believe
it's new in ODBC, where the driver manages the pool. I will try posting in
the other group. I thought that since the Sybase Wire Protocol Driver Setup
screen was unique to ASE that I might have better luck here.

Thanks anyway
Kevin

"Cory Sane [TeamSybase]" <cory!=sane> wrote in message
news:4bdf9e1d$1@forums-1-dub...
> KR,
> Connection pooling is done my an application middleware piece that is
> generally coded by developers.
> Clients connect to Application middle ware servers and these servers do
> connection pooling into a dbms such as ASE.
> Clients->AppServer>dbms.
>
> The ODBS Administrator is just going to define the connection for simple
> utilites like MS-Access/Excell/MS-SQL.
>
>
> Your question would better be posted in the
> Sybase.public.Connectivity.ODBC group or a PB.general group.
>
>
> --
> Cory Sane
> [TeamSybase]
> Certified Sybase Associate DBA for ASE 15.0
> "K R" <kjr_23@yahoo.com.nospam> wrote in message
> news:4bdf1070@forums-1-dub...
>> I'm trying to setup an ASE ODBC connection pool on a Win2003 server. The
>> Sybase Open Client has been installed on the server, and when I go into
>> ODBC Administrator, System DSN, and create a new Sybase connection, I get
>> the ODBC Sybase Wire Protocol Driver Setup screen. I enter the
>> parameters and click Test Connection, where I get prompted for Login ID
>> and Password. When I enter these values, it connects fine. I suspect
>> that for the connection pool to work, you need to somehow supply these
>> values outside of the application (PB12 .NET assembly as a webservice).
>> Can someone let me know how to save these values so the pool will work?


ET Posted on 2010-05-04 17:01:10.0Z
From: ET <dbccjob@gmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; fr; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: ASE 12.5 ODBC Connection Pooling
References: <4bdf1070@forums-1-dub> <4bdf9e1d$1@forums-1-dub> <4be01755$1@forums-1-dub>
In-Reply-To: <4be01755$1@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4be052d6$1@forums-1-dub>
Date: 4 May 2010 10:01:10 -0700
X-Trace: forums-1-dub 1272992470 10.22.241.152 (4 May 2010 10:01:10 -0700)
X-Original-Trace: 4 May 2010 10:01:10 -0700, vip152.sybase.com
Lines: 49
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:29177
Article PK: 78414

Le 04/05/2010 14:47, K R a écrit :

> Thanks Cory,
> I've done quite a bit of work with EA Server, Weblogic and Websphere, so
> I'm comfortable with connection pooling on the app server side. I believe
> it's new in ODBC, where the driver manages the pool. I will try posting in
> the other group. I thought that since the Sybase Wire Protocol Driver Setup
> screen was unique to ASE that I might have better luck here.
>
> Thanks anyway
> Kevin
>
> "Cory Sane [TeamSybase]"<cory!=sane> wrote in message
> news:4bdf9e1d$1@forums-1-dub...
>> KR,
>> Connection pooling is done my an application middleware piece that is
>> generally coded by developers.
>> Clients connect to Application middle ware servers and these servers do
>> connection pooling into a dbms such as ASE.
>> Clients->AppServer>dbms.
>>
>> The ODBS Administrator is just going to define the connection for simple
>> utilites like MS-Access/Excell/MS-SQL.
>>
>>
>> Your question would better be posted in the
>> Sybase.public.Connectivity.ODBC group or a PB.general group.
>>
>>
>> --
>> Cory Sane
>> [TeamSybase]
>> Certified Sybase Associate DBA for ASE 15.0
>> "K R"<kjr_23@yahoo.com.nospam> wrote in message
>> news:4bdf1070@forums-1-dub...
>>> I'm trying to setup an ASE ODBC connection pool on a Win2003 server. The
>>> Sybase Open Client has been installed on the server, and when I go into
>>> ODBC Administrator, System DSN, and create a new Sybase connection, I get
>>> the ODBC Sybase Wire Protocol Driver Setup screen. I enter the
>>> parameters and click Test Connection, where I get prompted for Login ID
>>> and Password. When I enter these values, it connects fine. I suspect
>>> that for the connection pool to work, you need to somehow supply these
>>> values outside of the application (PB12 .NET assembly as a webservice).
>>> Can someone let me know how to save these values so the pool will work?
>
>

As far as I know, this driver is developed by Data Direct. You should
try to get support from them.

Emmanuel