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.

Connecting to ASE CE from Visual Studio 2010

2 posts in Cluster Last posting was on 2011-08-15 21:32:29.0Z
Mark Posted on 2011-08-15 20:03:38.0Z
From: Mark <mlibner@yahoo.com>
Reply-To: mlibner@yahoo.com
Organization: Security Finance
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.cluster
Subject: Connecting to ASE CE from Visual Studio 2010
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4e497b9a@forums-1-dub>
Date: 15 Aug 2011 13:03:38 -0700
X-Trace: forums-1-dub 1313438618 10.22.241.152 (15 Aug 2011 13:03:38 -0700)
X-Original-Trace: 15 Aug 2011 13:03:38 -0700, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:233
Article PK: 48511

Hi All,

I want to make sure we are using the optimal method/driver for
connecting to our new ase cluster. I am connecting just fine using the
ado driver and the syntax below. No that they science experiment is over
I wanted to ping the pros to get your thoughts before going much further.

Is the file
%sybase%\dataaccess64\adonet\dll\sybase.ado4net.aseclient.dll the best
assembly to bring in to my visual studio project?

Are there any glaring problems with the connection string below?

myConnection.ConnectionString = "Data
Source=myPrimary:5000;uid='myUID';pwd='myPWD';HASession=1;Secondary Data
Source=my2nd:5000,my3rd:5000,myNth:5000;Database=myDB";

Recommendations or lessons learned appreciated.

Thanks,
Mark


J Posted on 2011-08-15 21:32:29.0Z
From: jtotally_bogus@sbcglobal.net (J)
Newsgroups: sybase.public.ase.cluster
Subject: Re: Connecting to ASE CE from Visual Studio 2010
Reply-To: J@bogusemailAddress.com
Message-ID: <4e498f37.13752968@forums.sybase.com>
References: <4e497b9a@forums-1-dub>
X-Newsreader: Forte Free Agent 1.21/32.243
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 15 Aug 2011 14:32:29 -0700
X-Trace: forums-1-dub 1313443949 10.22.241.152 (15 Aug 2011 14:32:29 -0700)
X-Original-Trace: 15 Aug 2011 14:32:29 -0700, vip152.sybase.com
Lines: 53
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.cluster:234
Article PK: 48516

On 15 Aug 2011 13:03:38 -0700, Mark <mlibner@yahoo.com> wrote:

Use AlternateServers for the additional instances. Test this by making
the server and port something where ASE is not listening. e.g.

Say I have instances running on host1:2345
and host2:2345. Make the Server, host1 and port 11111 (assuming no
ASE listening at 111110. Now make the AlternateServers the proper
host:port combinations. After you connect and "select
@@instancename", switch the host:port pair and you should connect to
the second instance.

e.g. of a DataSource.

[sampledsn]
Description = Sybase ODBC Data Source
UserID = sa
Driver =
/work/ocs155.64/DataAccess64/ODBC/lib/libsybdrvodb.so
Server = paisley1
Port = 11103
Database = testdb
UseCursor = 0
HASession = 1
AlternateServers = paisley2:11102,paisley3:11101

Jay

>Hi All,
>
>I want to make sure we are using the optimal method/driver for
>connecting to our new ase cluster. I am connecting just fine using the
>ado driver and the syntax below. No that they science experiment is over
>I wanted to ping the pros to get your thoughts before going much further.
>
>Is the file
>%sybase%\dataaccess64\adonet\dll\sybase.ado4net.aseclient.dll the best
>assembly to bring in to my visual studio project?
>
>Are there any glaring problems with the connection string below?
>
>myConnection.ConnectionString = "Data
>Source=myPrimary:5000;uid='myUID';pwd='myPWD';HASession=1;Secondary Data
>Source=my2nd:5000,my3rd:5000,myNth:5000;Database=myDB";
>
>Recommendations or lessons learned appreciated.
>
>Thanks,
>Mark
>
>
>