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.

connection cache for SQL server 2005

2 posts in Appeon (partner product) Last posting was on 2007-12-06 03:02:10.0Z
shen shu ming Posted on 2007-12-05 15:37:57.0Z
From: "shen shu ming" <shensm@douyee.com.sg>
Newsgroups: sybase.public.appeon
Subject: connection cache for SQL server 2005
Lines: 28
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: cm202.gamma169.maxonline.com.sg
X-Original-NNTP-Posting-Host: cm202.gamma169.maxonline.com.sg
Message-ID: <4756c5d5@forums-1-dub>
Date: 5 Dec 2007 07:37:57 -0800
X-Trace: forums-1-dub 1196869077 202.156.169.202 (5 Dec 2007 07:37:57 -0800)
X-Original-Trace: 5 Dec 2007 07:37:57 -0800, cm202.gamma169.maxonline.com.sg
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2045
Article PK: 13260

Hi Support Team,

how to set the connection cache for SQL server 2005 for Appeon used?

my DLL or class
com.microsoft.sqlserver.jdbc.SQLServerDriver

Serve Name:

jdbc:sqlserver://myservername:1433; databaseName= mydatabasename;

when ping, get Main Exception Error error.


the sqljdbc.jar have been save to folder sybase\EAServer\java\lib


but if i use following as DLL or Class

com.microsoft.jdbc.sqlserver.SQLServerDriver

ping sucessfully. but my application get following Datawindow error,

[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The incoming tabular
data streem(TDS)remote procedure call(PRC) protocal stream is in correct.
Parameter 1(""): data type 0X38 is unknown


Yang yongqing Posted on 2007-12-06 03:02:10.0Z
Sender: 4eca.47576183.1804289383@sybase.com
From: yang yongqing
Newsgroups: sybase.public.appeon
Subject: Re: connection cache for SQL server 2005
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <47576632.4f38.1681692777@sybase.com>
References: <4756c5d5@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Dec 2007 19:02:10 -0800
X-Trace: forums-1-dub 1196910130 10.22.241.41 (5 Dec 2007 19:02:10 -0800)
X-Original-Trace: 5 Dec 2007 19:02:10 -0800, 10.22.241.41
Lines: 41
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.appeon:2046
Article PK: 21497

Hi shen shu ming,

Please download the SQL Server 2005 JDBC Driver 1.2 from the
following url:
http://www.microsoft.com/downloads/details.aspx?familyid=c47053eb-3b64-4794-950d-81e1ec91c1ba&displaylang=en&tm

This problem may be occurinig due to 'cursor' select method.
If you have not added the cursor type in ur Connection URL
than add this 'SelectMethod=cursor' in Server Name.
If you load both the Microsoft SQL Server 2000 JDBC Driver
and the Microsoft SQL Server 2005 JDBC Driver in the same
process, in some
cases the 2000 version of the JDBC driver will incorrectly
accept a DriverManager.getConnection method call that is
targeted for the
2005 version of the JDBC driver.

The problem is caused by the 2000 version of the JDBC driver
incorrectly accepting the "jdbc:sqlserver://" URL prefix if
it is
loaded first.
To work around this issue, load the 2005 version of the JDBC
driver class first, as follows:
Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
// 2005 version
Class.forName("com.microsoft.jdbc.sqlserver.SQLServerDriver");
// 2000 version
This will ensure that the "jdbc:sqlserver://" URL prefix is
handled by the 2005 version of the JDBC driver and the
"jdbc:microsoft:sqlserver://" URL prefix is handled by the
2000 version of the JDBC driver.

Syntax:
jdbc:microsoft:sqlserver://hostname:port;DatabaseName=DBName;
SelectMethod=cursor

e.g.
jdbc:microsoft:sqlserver://192.0.0.94:1433;DatabaseName=sqltest;
SelectMethod=cursor

Regards