远程Sybase数据库技术支持,联系手机:13811580958,QQ:289965371!

 

随着Sybase被完全整合到SAP下,Sybase原来的支持网站被SAP Support Portal取代。
只有购买了SAP服务的用户才能使用账号登录SAP Support Portal进行介质下载、补丁升级、报Incident等。
考虑到Sybase数据库的初学者或者没有购买原厂服务的Sybase客户情况,现提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息。
在SAP Support Portal网站或者google上搜索Targeted CR List for ASE,可以看到针对不同版本的CR(CR表示Change Request)简单描述信息列表。
需要注意的是:Targeted CR List for ASE列出的CR虽然绝大多数是BUG,但有一些是更改需求。
以下提供SAP ASE/IQ/RS/SDK/SQL Anywhere/PB等产品的BUG信息!

如有问题,请联系我!

QQ :289965371 点击这里给我发消息
Email:
不仅仅包括BUG的详细描述信息,还包括首次报告BUG的平台、数据库版本以及BUG修复历史过程;有些BUG还提供了Workaround来临时解决该BUG带来问题。

 

CR:551627
CR Number:   551627
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1 ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.1.2 05 Mar 2009 Fixed
2.1.2 19 Apr 2009 Fixed
2.1.2 03 Jun 2009 Fixed
05 Mar 2009 Fixed
Description
Problem: Debugger shows the wrong current line.

Workaround: While loading the source of ASE compiled objects, the content retrieved from 'sp_helptext' should not be trimmed. The trimmed blank line leading to break point toggling error. Fixed to NOT trim the content retrieved from 'sp_helptext' while loading the source of ASE compiled objects.



CR:551942
CR Number:   551942
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Jun 2009 Fixed
Description
OLE DB Provider by Sybase: The property DBPROP_MAXROWS is not supported.



CR:552097
CR Number:   552097
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2009 Fixed
22 Jan 2009 Fixed
28 Jan 2009 Fixed
Description
jConnect: SybSQLException with "Arithmetic overflow" error encountered for NUMERIC and DECIMAL stored procedure output parameters.



CR:552434
CR Number:   552434
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2009 Fixed
Description
Create and include debugging information into the OpenSwitch and RCM executable. No separate .pdb (program database) files are required now for debugging either OpenSwitch or RCM.



CR:552582
CR Number:   552582
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Organic ODBC:



Opening a connection to the database using Microsoft DAO DBEngine.OpenConnection and a configurable ODBC datasource DSN:



After the connect, the Connect property of the Connection does not contain the

Database and Server name copied from the DSN as DataDirect drivers did.



CR:552667
CR Number:   552667
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows 2000
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 May 2009 Fixed
Description
Problem: IQ: Need to set a temporary data_order option for event creation.

Workaround: This is an I18N issue. When user uses Sybase WorkSpace in some locales, the date_order may not use US format, which is MDY. Consequently, Event-wizard-generated DDL may fail. Scheduled events require that the database option be set correctly according to the specified date. Added fix to set the correct date_order option in Event-wizard-generated DDL. Also when modifying a scheduled event, you can add a set db option SQL when needed.



CR:552796
CR Number:   552796
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1 ESD#25
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
If CS_CURSOR_IMPLICIT is used and no rows are returned then when attempting to close the connection one will see error: "trying to write when connection is expecting a read".



CR:552863
CR Number:   552863
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Can't select data from some system tables from a Microsoft SQL Server Linked Server connection to ASE.



CR:552873
CR Number:   552873
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Feb 2009 Duplicate
Description
Clients hang during failover for Mutual Aware OpenSwitch



CR:552905
CR Number:   552905
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.5 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Fixed
18 Dec 2008 Fixed
Description
jConnect: When using ENABLE_BULD_LOAD, if a batch encounters an error, updates in subsequent batch do not take place.



CR:553039
CR Number:   553039
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#17 08 Dec 2013 Fixed
1.1 ESD#26 08 Dec 2013 Fixed
Description
ADO.NET: MissingPrimaryKeyException when using ASECommandBuilder on proxy tables.



CR:553734
CR Number:   553734
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Feb 2009 Fixed
22 Feb 2009 Fixed
Description
CTLIB: Reopening an implicit cursor may crash at ct__tds_read_coldata() while processing the command results.



CR:553773
CR Number:   553773
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: SQL Server Integration Services (SSIS) transfer from integer source column to decimal target ASE column fails with invalid conversion error.
Workaround Description
 You can perform a workaround - in the connection object add the

"readwriteunknown"= 1 property to the Extended Properties field of

evloader.sisdnlder.sybase. Next modify the query for the evloader object:



SELECT

--inst_id, dir_rssd_num

inst_id, convert(int, dir_rssd_num) as dir_rssd_num /* read write unknown? */

/*dir_rssd_num*/

FROM dbo.test_tqtrly_inst



We're converting the field to integer type since the SSIS calls a

SELECT statement on the ASE object with a "where 1=2" clause, so it

can collect the metadata.



Once it has this information, the SSIS will "think" the field is int.

Also we provide an alias of the same name as the column name. This

is why we need to use the readwriteunknown=1 property, so we can update

this field. This works fine. Unknown if customer will use at this time

<12-15-08>.



CR:553886
CR Number:   553886
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#17 08 Dec 2013 Fixed
Description
ADO.NET: When performing failover between ASE Cluster Edition nodes, Internal Error received under certain situations.



CR:553893
CR Number:   553893
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Dec 2008 Not a Bug
Description
Secondary RCM does not shutdown after rp_shutdown in Mutual Aware environment.



CR:554068
CR Number:   554068
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Using "INSERT INTO OPENQUERY()" statement fails from Microsoft SQL Server Linked Server connection to ASE.



CR:554280
CR Number:   554280
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 EOL'd version. Not to be Fixed.
Description
SYBTRUE listener start up message is not correct.



CR:554294
CR Number:   554294
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Queries from Microsoft SQL Server to a linked ASE Server always start a Distributed Transaction.
Workaround Description
 WorkAround:

-------------



In order to avoid the problem with sp_who in the

distributed transaction I've created a procedure to

return similar results as sp_who returns.



First try this with SELECT statement:



drop table #temp2

create table #temp2

(

spid int,

status varchar(128),

loginame varchar(128),

hostname varchar(128),

blk_spid int,

dbname varchar(128),

cmd varchar(255)

)

insert into #temp2

--**/

EXEC ('select spid, status, loginname=suser_name(suid),

hostname, blk_spid=blocked, dbname=db_name(dbid), cmd

from master..sysprocesses where suid=(select suid from

master..syslogins where name="sa")') AT ASE1502





/* Error: Msg 7411, Level 16, State 1, Line 122

Server 'ASE1502' is not configured for DATA ACCESS.*/

/*********

select * from OPENQUERY(ASE1502,'select spid, status, loginname=suser_name(suid),

hostname, blk_spid=blocked, dbname=db_name(dbid), cmd

from master..sysprocesses where suid=(select suid from

master..syslogins where name="sa")')

*****/

select * from #temp2



The EXEC works okay, but calling the same SQL fails with OPENQUERY

and not sure why.



You can replace the SELECT with sproc:



create proc sp_whotemp (@p1 varchar(128))

as

select spid, status, loginname=suser_name(suid),

hostname, blk_spid=blocked, dbname=db_name(dbid), cmd

from master..sysprocesses where suid=(select suid from

master..syslogins where name=@p1)



drop table #temp1

create table #temp1

(

spid int,

status varchar(128),

loginame varchar(128),

hostname varchar(128),

blk_spid int,

dbname varchar(128),

cmd varchar(255)

)

insert into #temp1

EXEC ('sp_whotemp sa') AT ASE1502

select * from #temp1



CR:554363
CR Number:   554363
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Queries from Microsoft SQL Server to a linked ASE table fail when ASE database name is given in capital case even though ASE is configured as case insensitive.



CR:554366
CR Number:   554366
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Executing OpenQuery on an ASE table linked from Microsoft SQL Server with dynamic prepare gives inconsistent metadata error on binary column



CR:554419
CR Number:   554419
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Jan 2009 Fixed
Description
BLKLIB: Calling blk_alloc() may core dump at intl_fopen() when application is localized to use the Korean language.



CR:554625
CR Number:   554625
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2009 Fixed
Description
Starting from SDK15 ESD13 and SDK12.5.1 ESD23, a new Sybase ODBC property was introduced -

"CommandTimeOut". The property was designed to fix the issue on CR488255. It had been

verified that the problem was fixed on those ESDs and after.

However, there is no official document description for the ODBC "CommandTimeOut"



CR:554887
CR Number:   554887
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Socket style listener needs to use the new zOS 1.9 parameter, RTYTIME.



CR:555001
CR Number:   555001
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Jan 2009 Fixed
13 Jan 2009 Fixed
Description
jConnect: Request to optimize sp_jdbc_getprocedurecolumns meta-data stored procedure for better performance.



CR:555032
CR Number:   555032
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2009 Fixed
23 Feb 2009 Fixed
Description
Clients establishing their connections after the primary ASE dataserver and/or its host goes down might not change the primary ASE dataserver status to DOWN. This might happen where there are no client connections connected to the primary ASE dataserver before the ASE dataserver goes down.



CR:555231
CR Number:   555231
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2010 Fixed
Description
Debug message coord__notif_check_osw succeeded fills log



CR:555233
CR Number:   555233
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Fixed
Description
Debug message 20089 does not report the actual number of spids affected



CR:555299
CR Number:   555299
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   2.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.1.2 08 Apr 2009 Fixed
Description
Problem: While loading the source of ASE compiled objects, the content retrieved from 'sp_helptext' should not be trimmed. The trimmed blank line leads to a break point toggling error.

Workaround: Fixed to NOT trim the content retrieved from 'sp_helptext' while loading the source of ASE compiled objects.



CR:555399
CR Number:   555399
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2009 Fixed
Description
The client connections might hang in OpenSwitch in case of a response time out when fetching the results from the backend ASE dataserver.
Workaround Description
 Manuall call rp_set_srv to set the hung spids to the correct server.



CR:555430
CR Number:   555430
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Feb 2009 Fixed
Description
CM applications might not receive notifications from the clients establishing their connections when the primary ASE dataserver and/or its host is not reachable. These clients might hang in OpenSwitch in their LOGIN state.



CR:555496
CR Number:   555496
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#14 13 Jan 2009 Fixed
13 Jan 2009 Fixed
Description
jConnect: The bulk copy option (ENABLE_BULK_LOAD) inserts empty strings as NULL values.



CR:555546
CR Number:   555546
Product Name:   Other - Docs: Connectivity
Product Component:   Other - Docs: Connectivity
Status:   Closed
OS:   UNIX
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Jun 2009 Fixed
Description
An ODBC property - "connectiontimeout" has been widely used.

However, customer point out that there is not much document on ODBC side and the property is not covered.



CR:555839
CR Number:   555839
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#17 20 Jan 2009 Fixed
12.5.1 ESD#26 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Connection pooling does not work due to missing CPTimeout property in the registry.
Workaround Description
 You can workaround the issue before ESD#17 is released. In the ODBC Driver admin tool (odbcad32.exe) open it and click on the Connection Pooling tab, select and double click the "Adaptive Server Enterprise" ODBC Driver. In the "Set Connection Pooling Attributes", select "Pool Connections to this driver". You should be all set - restart your application and the connection pooling will work.



CR:555993
CR Number:   555993
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Open
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
RCM crashes during shutdown in ct_exit



CR:556554
CR Number:   556554
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Mar 2009 Fixed
Description
Bus errors leading to crash might happen in OpenSwitch when "rp_dump thread" is issued by an OpenSwitch administrator while certain large queries are running
Workaround Description
 Do not issue "rp_dump thread"



CR:556744
CR Number:   556744
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Unknown
Original Version:   15.0 ESD#10
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 May 2009 Fixed
12 Aug 2009 Fixed
Description
CPRE: ESQL/C application drops connection when it receives ASE 4023 error message which is a password expiration warning message.
Workaround Description
 Edit sybtesql.c to check for error 4023, however the customer is not very happy about this.



CR:556808
CR Number:   556808
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Jan 2009 Fixed
Description
Login retry clients might connect to the secondary ASE server before OpenSwitch and CM application handles the failover processing of primary ASE server status upon failure of primary ASE server. This behaviour might possibly cause corruption of user data.



CR:556899
CR Number:   556899
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Nov 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
Application becomes unstable after diconnecting.



CR:557347
CR Number:   557347
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2009 Fixed
24 Jun 2009 Fixed
Description
CTLIB: ribo.jar is unable to decode a tds file capture by using CS_DBG_PROTOCOL.
Workaround Description
 use tds-linux to decode.



CR:557463
CR Number:   557463
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1 ESD#25
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#27 04 May 2010 Fixed
04 May 2010 Fixed
Description
ODBC Driver by Sybase: ODBC driver (12.5.1ESD#24 and 12.5.1ESD#25) cannot save the password of a link table in MS-Access 2003. This issue is also reproduced when the Default Login ID is set in the ODBC DataSource.
Workaround Description
 Login ID is not set to DSN.



CR:557558
CR Number:   557558
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: SQLGetDiagField reports incorrect message length.



CR:557698
CR Number:   557698
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Feb 2009 Fixed
Description
In a Mutual Aware OpenSwitch environment, when a client's spid is killed in ASE(using isql kill),

the client might hang inside OpenSwitch.



CR:557805
CR Number:   557805
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2010 Fixed
Description
ANSI SQL reserved key words were used when creating

database tables in the Mutual Aware OpenSwitch server.



CR:557944
CR Number:   557944
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
jConnect: Need new metadata stored procedures for ASE 12.5.1 to ASE 12.5.4 to support the use of multiple tempdb functionality.
Workaround Description
 Probably can easily edit the scripts.



CR:557954
CR Number:   557954
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   15.0 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Kerberos-enabled Active Directory authentication and single sign-on for ASE and OCS.



CR:557956
CR Number:   557956
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 26 Mar 2009 Fixed
Description
ODBC Driver by Sybase: Request to support SRVR connection string property to specify ASE Server connection information.



CR:558197
CR Number:   558197
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Executing OpenQuery on an ASE table linked from Microsoft SQL Server with dynamic prepare gives inconsistent metadata error on binary column



CR:558247
CR Number:   558247
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2010 Consult Complete
Description
Sybase.AdoNet2.AseClient.dll 1.15.325.0

Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006

OS: Windows 2003 Server SP2



Eng Consult: Our customer changed locales.dat at [NT] section - default - from iso_1 to cp850



After that, whenever he inserted data from within SQL Advantage or ISQL, the international characters can only be correctly displayed via SELECT if client session has cp850 set in its options.



We could not find how to do the same within ADO.NET Provider sections. Is there a way to change charset in ADO.NET Provider in order to behave just like SQL Advantage?



Please refer to repro steps for further details.



CR:558308
CR Number:   558308
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Open
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature: Customer would like a linux GUI ODBC installer



CR:558309
CR Number:   558309
Product Name:   Organic ODBC Driver
Product Component:   Install
Status:   Open
OS:   Red Hat Enterprise Linux
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Feature: Change template to match install location



CR:558316
CR Number:   558316
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2009 Fixed
27 Feb 2009 Fixed
Description
In a Mutual Aware environment, both primary and companion OpenSwitch servers might perform the ASE failure actions when an ASE server is down. This failure action changes the ASE server status to SUSPENDED within OpenSwitch thereby any new client connections won't be connected to OpenSwitch then after.



CR:558375
CR Number:   558375
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   2.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Mar 2009 Fixed
Description
Problem: Need to support LOCK TABLE syntax.

Workaround: Added functions to support LOCK TABLE syntax.



CR:558543
CR Number:   558543
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Operating System Windows all versions

Open Cleint SDK 15.0 ESD#16 and above

Microsoft Visual Studio 2005 2008 and above.

32 bit and 64 bit developemnt

Visual Basic Dot Net and C#





Issue:

When creating a vb .net windows application you add a Data Grig to the project.

The Microsoft OLEDB driver is selected the Visual studio atomaticly add

select

insert

update

delect

statment to the data grid propertys.



There for the developer does not have to write all the statment out manualy.

THe customers complaint is the Sybase OLEDB driver does not do this.

We do get a select statment when this is done but nothing else.

As I explained to the customer this may be due to the way the Microsoft Wizards

works and not all providers would be eaual when creating Data Grids.



The customer has requested for Sybase to look in to the issues and provide a seemless

way of creating a data base grid in visual studio and when the OLEDB providers is

selected the insert,update select and deletes statmens get created automaticly,
Target Version
 15.5
Review Status
 The intergrating will take place in 15.5 Release.



CR:558563
CR Number:   558563
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: The ADO connection property "Mode" is not supported.



CR:558573
CR Number:   558573
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2009 Fixed
Description
Request to support Statement.isClosed()



CR:558727
CR Number:   558727
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Apr 2009 Fixed
07 May 2009 Fixed
15 Apr 2009 Fixed
26 May 2009 Fixed
Description
Client should signal server not to send meta-data when describing row data information (TDS_ROWFMT2)



CR:558924
CR Number:   558924
Product Name:   OpenSwitch
Product Component:   OpenSwitch Manager
Status:   Closed
OS:   Windows 2000
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Dec 2010 Fixed
Description
Need an OpenSwitch Manager plug-in compatible with Sybase Central 6



CR:558960
CR Number:   558960
Product Name:   Open Client-Doc
Product Component:   Client-Library Release Bulletin
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2012 Added to user documentation
Description
Environment:

ASE 15.0.3 for HP-Itanium and Open Client 15.0 that comes with same ASE bundle



Description:

We'd like to ask you to document the following change detected in ASE 15.0.3 installation for locales directory:



In previous ASE 15.0.2, the following directories are found inside /locales subdirectory:



/remote/releases2/hpit/rel1502_ebfs/ebf15657/locales

> >> sunspot% ls

> >> chinese japanese message spanish us_english

> >> french korean polish thai

> >> german locales.dat portuguese unicode

> >> sunspot%

> >>





In 15.0.3 GA directory structure, under /remote/releases2/hpit/rel1503/locales, we have the following structure:



> >> --> checking the directory tree of ASE v 15.03 ga, in special for

> >> $sybase/locales we have :

> >>

> >>

> >> sunspot% pwd

> >> /remote/releases2/hpit/rel1503/locales

> >> sunspot% ls

> >> locales.dat message unicode

> >> sunspot%

> >>

> >>



So, all language directories (e.g: us_english) are missing. This is not documented anywhere, neither in ASE nor OCS manuals.

We'd like to request this change to be properly documented, because customers call CS&S with such doubt and no official documentation is found.
Workaround Description
 Customer needs to copy all language directories under 15.0.2/locales into 15.0.3/locales in order to continue having applications working on same box.



CR:558978
CR Number:   558978
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   2.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
2.0 ESD#18 30 Mar 2009 Fixed
Description
ADO.NET: Table columns in ASE of char() type supporting null values are padded to the full length of the column.



CR:559066
CR Number:   559066
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#15 02 Mar 2009 Fixed
6.5 ESD#15 06 Mar 2009 Fixed
Description
jConnect: Request to implement DatabaseMetadata.getSuperTypes() method.



CR:559470
CR Number:   559470
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2009 Fixed
Description
ODBC Driver by Sybase: Request for implementing some performance improvements in sp_odbc_datatype_info meta-data stored procedure.



CR:559651
CR Number:   559651
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#17 08 Jul 2009 Fixed
24 Jul 2009 Fixed
Description
jConnect: CallableStatement.getParameterMetadata() returns metadata for all the parameters of the stored procedure instead of only registered ones.



CR:559688
CR Number:   559688
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Microsoft Win32s
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Trying to ct_cancel(CS_CANCEL_ATTN) ct_cursor (CS_CURSOR_OPEN) results, receives an assertion if the debug libs are used.



CR:559817
CR Number:   559817
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Oct 2009 Diagnostic Provided
Description
During failback to primary ASE, new client connections get connected to the standby ASE while it's status is LOCKED.
Workaround Description
 Change NOWAIT_ON_LOCKED=1 in the configuration files, than OpenSwitch will reject client

applications attempting to connect to a server that is LOCKED:

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc20191.1510/html/oswadmin/BABCDGBE.htm



Customers will see this message in the log file:

OSW2: ERROR: spid 29: thrd_connect: Login attempt failed because the target pool or server is locked.



The client application will see this message:

% isql -Usa -P -S OSW2

Msg 20103, Level 14, State 0:

Server 'OSW2':

The pool or server which your application is trying to connect to is currently

locked. Please try again at a later time.

CT-LIBRARY error:

ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.



CR:559883
CR Number:   559883
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
ODBC Driver by Sybase: When issuing meta-data calls, the command uses the Login Timeout instead of Query Timeout.



CR:560039
CR Number:   560039
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
JNDI SybSqlIniParserver getValue() java.lang.ClassCastException exception is raised if SQL.ini file entry includes a "win3_query=..." line.



CR:560066
CR Number:   560066
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 12 May 2009 Fixed
Description
ODBC Driver by Sybase: Accessing ASE data from MS Access fails after reconnecting to the database.
Workaround Description
 Blank out the LOGON ID Property value in the DSN.



CR:560161
CR Number:   560161
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
25 Mar 2009 Fixed
21 May 2009 Fixed
Description
ESQL/COBOL: On Little Endian platforms, applications can not fetch multiple rows into the SQLDA structure.



CR:560299
CR Number:   560299
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Fixed
Description
Request OpenSwitch to leave Standby ASE status always as UP in a Mutual Aware environment



CR:560533
CR Number:   560533
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add Help button to ODBC configuration GUI
Workaround Description
 PSE providing word doc with property descriptions.



CR:560765
CR Number:   560765
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 14 Apr 2009 Fixed
12.5.1 ESD#27 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Data Truncation of varchar fields with Linked Server using Insert into OpenQuery construct.



CR:560858
CR Number:   560858
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Mar 2009 Fixed
05 Mar 2009 Fixed
26 Feb 2009 Fixed
10 Mar 2009 Fixed
10 Mar 2009 Fixed
19 Mar 2009 Fixed
21 Mar 2010 Fixed
08 Feb 2010 Fixed
18 Mar 2010 Fixed
Description
CTLIB: With IQ as the backend, Open Client ctlib applications may encounter an error "ct_results(): protocol specific layer: external error: There is a tds protocol error. An illegal token was received." after ct_cancel() is called to cancel the results of a command.



CR:561070
CR Number:   561070
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#17
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Jun 2010 Fixed
16 Jun 2010 Fixed
14 Jul 2010 Fixed
02 Aug 2010 Fixed
Description
SRVLIB: srv_descfmt() fails to retrieve a description of a language parameter when the specified parameter number is greater than 1024.



CR:561149
CR Number:   561149
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 17 Apr 2009 Fixed
12.5.1 ESD#27 17 Apr 2009 Fixed
Description
ODBC Driver by Sybase: ADO GetChunk method fails on Image (binary) data.
Workaround Description
 Works okay with OEM DDTEK ODBC Driver and also with our ASE OLE DB Provider.



CR:561299
CR Number:   561299
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Win32s
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Jan 2013 EOL'd version. Not to be Fixed.
Description
The script %SYBASE%\%SYBASE_OCS%\scripts\copylibs.bat does not support long filenames which contain white-space. The script can be edited to 'cd %DLLDIR%' and perform the copy without using the pathname.
Workaround Description
 Alternative script:

@ECHO OFF

REM As of SDK 15.0 and Open Server 15.0, Sybase library names have

REM changed from lib<name> to libsyb<name> to avoid name clashes

REM with other libraries.

REM

REM To allow pre-15.0 applications to continue to work with the

REM renamed shared libraries, this script is provided to copy the

REM new library names to the old ones in %SYBASE%\%SYBASE_OCS%\dll.

REM Usage of the script:

REM

REM copylibs.bat { create / remove }

REM

REM where 'create' copies the old-named files in $SYBASE/$SYBASE_OCS/dll

REM and 'remove' can be used to delete these files again.



SET DLLDIR=%SYBASE%\%SYBASE_OCS%\dll



IF "%SYBASE%"=="" (

ECHO %%SYBASE%% is not set.

GOTO end

)



IF "%SYBASE_OCS%"=="" (

ECHO %%SYBASE_OCS%% is not set.

GOTO end

)



IF "%1"=="create" GOTO create

IF "%1"=="remove" GOTO remove

GOTO usage



:create

cd %DLLDIR%

copy libsybblk.dll libblk.dll

copy libsybcobct.dll libcobct.dll

copy libsybcs.dll libcs.dll

copy libsybct.dll libct.dll

copy libsybdb.dll libdb.dll

copy libsybsrv.dll libsrv.dll

copy libsybxadtm.dll libxadtm.dll

GOTO end



:remove

cd %DLLDIR%

del libblk.dll

del libcobct.dll

del libcs.dll

del libct.dll

del libdb.dll

del libsrv.dll

del libxadtm.dll

GOTO end



:usage

ECHO Usage: %0 { create / remove }



:end



CR:561317
CR Number:   561317
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2010 Fixed
Description
ODBC Driver by Sybase: Unable to execute SSIS package that contains ADO.NET Source component and uses Microsoft ADO.Net Provider for ODBC in combination with the Sybase ODBC driver.



CR:561339
CR Number:   561339
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Mar 2009 Fixed
24 Mar 2009 Fixed
23 Mar 2009 Fixed
Description
DRIVERS: When using Kerberos for authentication, the 3rd party errors are only displayed as error numbers which are not human readable. Actual text corresponding to the numbers should also be displayed.



CR:561547
CR Number:   561547
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 30 Mar 2009 Fixed
Description
ODBC Driver by Sybase: Inserting data into a #temp table results in an error.



CR:561549
CR Number:   561549
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   15.0 ESD#12
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Jul 2009 Fixed
09 Jul 2009 Not reproducible with latest version of the product available as of Resolution Date
Description
CTLIB: ct_poll() may hang when results are cancelled.
Workaround Description
 None.



CR:561632
CR Number:   561632
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 13 Apr 2009 Fixed
Description
ODBC Driver by Sybase: In a VB Application using ADODB, specifying a cursor location of UseClient and a lock type of LockBatchOptimistic is causing a performance degradation.
Target Version
 15.0 ESD#3



CR:561654
CR Number:   561654
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 04 May 2009 Fixed
Description
ODBC Driver by Sybase: Memory leak occurs in a VB application using a large select statement with bound parameters.



CR:561702
CR Number:   561702
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows XP
Original Version:   2.1.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Apr 2009 Fixed
Description
Problem: PERF: It's very slow when typing where clause in SQL Scrapbook.

Workaround: Batchload all tables/procedural objects before listing in content assist. Since the default schema may not match the table's owner, need to widely search all schemas of this database. Side effect is that a table with the same name would be loaded. The best way is input table is using owner name.



CR:561826
CR Number:   561826
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 25 Mar 2009 Fixed
20 Oct 2009 Fixed
Description
ODBC Driver by Sybase: When using MS Excel/MS Query, login attempts subsequent to the initial login attempt fail.
Workaround Description
 Don't set the Logon property in the DSN.



CR:561908
CR Number:   561908
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#15 31 Mar 2009 Fixed
03 Jun 2009 Fixed
Description
jConnect: Request to implement DatabaseMetadata.getSuperTables() method.



CR:562199
CR Number:   562199
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Apr 2009 Fixed
Description
OpenSwitch -h output has a mistake for k debug flag. It says it is for the "Death thread" but it is actually for the "timer thread state".



CR:562476
CR Number:   562476
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 13 Apr 2009 Fixed
12.5.1 ESD#27 17 Apr 2009 Fixed
Description
ODBC Driver by Sybase: "Invalid attribute or option identifier" is returned from the SQLSetConnectAttr(SQL_ATTR_MAX_ROWS) call.
Workaround Description
 Works with ASE OLEDB



CR:562615
CR Number:   562615
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1 ESD#24
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2012 Not a Bug
Description
PROBLEM: all 12.5 15.0.x and 15.5 are affected by this

The problem is customer installes EBF16012 64 bit.

It does over lay the original isql 64 bit and that is fine the isql is now

32 bit and that is fine we understand the 64 bit isql for this O/S is not

availablem. The issue here is the version out put does not match the EBF numbers

installed.There for the customer think the isql was not only bit version down graded

but EBF down graded even thou the 32 bit isql is from ESD # 24 EBF EBF16010
Target Version
 15.5
Review Status
 Issue would be address in 15.5



CR:562664
CR Number:   562664
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 20 May 2009 Fixed
Description
ODBC Driver by Sybase: Column names get trunacated in OpenSchema call if the name contains an underscore character.



CR:562771
CR Number:   562771
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Apr 2009 Fixed
09 Mar 2009 Fixed
17 Apr 2009 Fixed
Description
Companion OpenSwitch might execute ASE failure actions thereby suspending the ASE status even though ASE server is UP and can be contacted.



CR:562960
CR Number:   562960
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Nov 2009 Fixed
12 Nov 2009 Fixed
Description
jConnect: Optimize sp_jdbc_stored_procedures stored procedure for better performance.
Workaround Description
 DBAs can re-code there own stored procedures.



CR:562963
CR Number:   562963
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 Mar 2009 Fixed
31 Mar 2009 Fixed
Description
Libraries: References to the name 'SQL Server' should be replaced in error messages and header files.



CR:563010
CR Number:   563010
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#15
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 08 Dec 2013 Fixed
12.5.1 ESD#26 01 May 2013 Fixed
Description
Sybase OLEDB: An error is returned when calling IDBSchemaRowset.GetIndexInfo() due to syntax error in sp_oledb_getindexinfo. This error only occurs when connecting to an ASE server older than ASE 15.0; there is no problem with ASE 15.0 and above.



CR:563052
CR Number:   563052
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Windows 2000
Original Version:   Tonga
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Mar 2009 Fixed
Description
Problem: Temp table cannot be shown during SP debugging.

Workaround: Fixed. When a temp table is created in default schema of TempDB. It cannot be found with default user name. Now find the table in all schemas of TempDB.



CR:563487
CR Number:   563487
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.5 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 ESD#15 23 Mar 2009 Fixed
25 Mar 2009 Fixed
Description
jConnect: Request to remove round trip performed to the server whenever Connection.getAutoCommit()is called to improve performance.



CR:563747
CR Number:   563747
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer using Crystal Reports 8.5 - when retrieving table list it's empty.

ODBC 15.0 affected.

Description: Crystal Reports 8.X displays empty table list



Detail: Problem derives from the following:

- Crystal Reports 8.X issues SQLSetConnectAttr(SQL_ATTR_TXN_ISOLATION, SQL_TXN_READ_UNCOMMITTED)

- This causes an optimizer scan failure on ASE with the 2 static tables used to contain ASE datatype information





Observations:

--------------

We resolved the error by creating unique index for:

create unique index spt_dt_idx on spt_datatype_info(ss_dtype,type_name)

create unique index spt_dt_ext_idx on spt_datatype_info_ext(user_type, create_params)
Target Version
 aries
Review Status
 Observations:

--------------

We resolved the error by creating unique index for:

create unique index spt_dt_idx on spt_datatype_info(ss_dtype,type_name)

create unique index spt_dt_ext_idx on spt_datatype_info_ext(user_type, create_params)



CR:564282
CR Number:   564282
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#18
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 14 Apr 2009 Fixed
Description
OLE DB Provider by Sybase: Adding Oledb Driver Compatibility with DDTEK driver



CR:564378
CR Number:   564378
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#16
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#18 23 Apr 2009 Fixed
Description
ODBC Driver by Sybase: ODBC application crashes at SQLFreeHandle(SQL_HANDLE_DBC) when ASE is abnormally terminated.



CR:564728
CR Number:   564728
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When a Statement or PreparedStatement query starts with 'exec' and you run the query thru executeBatch() for ASE 15.x, a BatchUpdateException occurs.
Workaround Description
 Use "execute" instead of "exec".



CR:564847
CR Number:   564847
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#19 10 Apr 2009 Duplicate
Description
OLE DB Provider by Sybase: Request for Help button in Sybase ASE Data Source Administrator
Workaround Description
 PSE (pvero - Paul Vero) is providing a Word document to provide property descriptions and panel screen shots of the Admin tool.



CR:564875
CR Number:   564875
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   7.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Currently(through JConnect 6.0.5), the return status of a stored procedure can only be accessed through an ordinal position or by naming a parameter when using a callableStatement. This CR is for a feature request to allow using a pre-defined name, such as @return_value, to be used when using ordinals. The pre-defined name won't work if output parameters are specified by name. In that case the specified name will need to be used to retrieve the return status. This feature request is targeted for JConnect 7.
Target Version
 7.0





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从Sybase SQL Anywhere的DB文件中恢复数据的工具:ReadASADB。
此工具支持ASA v5.0,v6.0,v7.0,v8.0,v9.0,v10.0,v11.0,v12.0等版本。
恢复Sybase SQL Anywhere的工具在国内应该算首创。

ReadASADB功能
能够从损坏的SQL Anywhere数据文件(.db)和UltraLite数据文件(.udb)上提取数据的非常规恢复工具

  1. 适用于所有的SQL Anywhere版本    包括:5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x
  2. 适用于所有的UltraLite版本
  3. 能够恢复出来表结构和数据
  4. 能够恢复自定义数据类型
  5. 能够恢复存储过程等对象的语法
  6. 能够导出到目标数据库
  7. 能够导出到SQL文件并生成导入脚本
  8. 支持多种字符集  包括:cp850、cp936、gb18030、utf8等
  9. 能够恢复未加密或者简单加密类型的数据
  10. 简单易用
  11. 限制:不支持AES加密的数据文件
请参考:研发成功了从Sybase SQL Anywhere的DB文件上恢复数据的工具
            SQL Anywhere数据库非常规恢复工具ReadASADB使用介绍

ReadASADB适用场景

各种误操作:

  1. 误截断表(truncate table)
  2. 误删除表(drop table)
  3. 错误的where条件误删数据
  4. 误删除db或log文件
  5. 误删除表中的字段

本工具的应用场景:

1.因为物理磁盘故障、操作系统、系统软件方面或者掉电等等原因导致的Sybase SQL Anywhere数据库无法打开的情况;
2.误操作,包括truncate table,drop table,不正确的where条件导致的误删除等;
Sybase SQL Anywhere无法打开时,比较常见的错误是:Assertion failed。
如:
1、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Checkpoint log: invalid bitmap page -- transaction rolled back
2、Internal database error *** ERROR *** Assertion failed:201819 (8.0.1.2600) Page number on page does not match page requested -- transaction rolled back
3、Internal database error *** ERROR *** Assertion failed:200502 (9.0.2.2451) Checksum failure on page 23 -- transaction rolled back
4、File is shorter than expected
5、Internal database error *** ERROR *** Assertion failed: 201116 Invalid free list index page found while processing checkpoint log -- transaction rolled back
6、*** ERROR *** Assertion failed: 51901 Page for requested record not a table page or record not present on page等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------