远程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:431774
CR Number:   431774
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jun 2006 Fixed
12 Jun 2006 Fixed
Description
jConnect: Feature request to implement a connection property that will return column alias name rather than the real column name when ResultSetMetaData.getColumnName() is called. This behaviour is compatible with older versions of jConnect and some other DBMS JDBC Drivers.



CR:431944
CR Number:   431944
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 03 25 Oct 2006 Fixed
Description
Program SYBLSTNR display the Message below is a non sybase application connects to the new ESD2 IBM Listener.

MSG13 DC CL50'SYBTP13 - CONNECTION FROM UNKNOWN HOST'



This message has customers confused on what is going on.

Would like the message to be more specfic like " A non Sybase client try to connect"



CR:432073
CR Number:   432073
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
30 May 2007 Fixed
Description
Modified cm_rp_get_help to return results in a structure such that the data can be used in the CM in other APIs.



CR:432187
CR Number:   432187
Product Name:   Organic ODBC Driver
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 16 Jan 2007 Fixed
12.5.1 ESD#15 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Call to SQLConfigDataSource() creates DSN with last character of property value truncated.



CR:432346
CR Number:   432346
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2006 Fixed
30 May 2006 Fixed
31 May 2006 Fixed
Description
cm_get_prop fails to retrieve CM_P_USERDATA



CR:432500
CR Number:   432500
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 16 Jan 2007 Fixed
15.0 ESD#5 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: When using SQLDriverConnect with SQL_DRIVER_PROMPT Option, changes made to the connect string in the prompt dialog are not reflected in the OutConnectString.



CR:432549
CR Number:   432549
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)
08 May 2014 Insufficient priority to fix
Description
Request for Named Pipes network support



CR:432666
CR Number:   432666
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2007 Fixed
26 Feb 2007 Fixed
01 Mar 2007 Fixed
02 May 2007 Fixed
07 Mar 2007 Fixed
29 Mar 2007 Fixed
25 Apr 2007 Fixed
22 Mar 2007 Fixed
05 Apr 2007 Fixed
17 Apr 2007 Fixed
16 May 2007 Fixed
25 Jun 2007 Fixed
27 Jul 2007 Fixed
Description
jConnect: Unsatisfactory performance when inserting large batches of records using addBatch() method. Extremely large batches caused client program to hang.



CR:432683
CR Number:   432683
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 Sep 2008 Not a Bug
Description
SQLFetch() returns SQL_ERROR, not SQL_NO_MORE_DATA when SelectMethod is set to Cursor, and the application uses SQLFetch and SQLGetData to retrieve a result set if there is at least one row.



CR:433319
CR Number:   433319
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
12.5.1 ESD#15 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Request to provide support to distinguish a zero length binary column value from a null column value.



CR:433323
CR Number:   433323
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 01 05 Oct 2006 Fixed
Description
The CSA/RSP stub load modules are missing from

the load library.



CR:433440
CR Number:   433440
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
27 Jul 2006 Fixed
17 Aug 2006 Fixed
Description
SRVLIB: Open server with DBLIB API crashes when connecting to another server in open server start handler.
Workaround Description
 1) cd /remote/cases/11261000s/11261348/pseinfo/Repro

2) source SYBASE.csh

3) cd /remote/cases/11261000s/11261348/pseinfo/Repro/OCS-12_5/sample/srvlibrary

4) make intlchar

5) Add an entry to $SYBASE/interfaces for your Open Server

6) ./intlchar your_open_server



CR:433444
CR Number:   433444
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Tonga 22 Aug 2006 Fixed
Kon-Tiki 22 Aug 2006 Fixed
Description
Problem: Temp table wizard considers any object name prefixed with '#' as a temp table.



Details:

Temp table wizard considers any object name prefixed with '#' as a temp table. For example, with the following statement referencing a stored procedure 'pbcatcol', temp table wizard still popped up:

create index #abc on pbcatcol (pbcatcol.pbc_case)
Target Version
 1.6 ESD1



CR:433481
CR Number:   433481
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Jun 2006 Fixed
21 Jun 2006 Fixed
Description
CTLIB: ct_setparam call can cause valid data inserts to be NULL if the null indicator variable was set to NULL before the ct_setparam call.
Workaround Description
 set null indicator variable to 0 before ct_setparam call and then set it appropriately before each ct_send()



CR:433578
CR Number:   433578
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#4 22 Dec 2006 Fixed
12.5.1 ESD#15 16 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: The OLE DB Provider fails to retrieve data with DELPHI ADO Provider when the value of a string parameter is larger than 13 byes.



CR:433810
CR Number:   433810
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2007 Fixed
Description
Customer needs documentation on new CM_CB_ASEFAIL cm_callback



CR:433862
CR Number:   433862
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Samoa - Official 22 Aug 2006 Fixed
23 Oct 2007 Workaround
Description
Problem: SQL Debugger should prevent the user from setting breakpoints for long-named procedural objects in ASE.



Problem Details:



The user failed setting a breakpoint in an ASE stored procedure with long name, the breakpoint would not be adjusted to the nearest valid SQL statement, stack tracke were displayed in ASE's error log file, and the user will not able to debug any ASE stored procedures from that point on until they perform the following steps:

1. Delete all the breakpoints from the Breakpoint view of SQL Debugger.

2. Shut down WorkSpace

3. Shut down and reboot ASE Server.

4. Restart WorkSpace

5. Do not set breakpoint in stored procedures or trigger with name longer than ~22 bytes.



The problem is caused by a debugging related ASE server problem.



Solutions:

1. Database Development Tooling adds a safeguard mechanism that prevents the user from setting breakpoint for ASE long-named procedural object (SPs and triggers). In additon, there's a new debugger preference for the user to turn off the safeguard so that when the user installed ASE debugger patches in the future, we don't need to take out the safeguard mechanism, and the user only need to disable the safeguard from the preference page.

2. The user is advised to install ASE patch 12.5.3 ESD #7 to fix the root cause.
Target Version
 1.6 ESD1



CR:434139
CR Number:   434139
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 02 13 Oct 2006 Fixed
Description
CICSPING does not work with the socket interface.



CR:434177
CR Number:   434177
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 98
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Sep 2006 Fixed
Description
OLEDB: Cannot run query through MS 2005 linked server due to asynchronous setting forced by linked server. Added the "Async" connection option to the provider. Setting this option (Async) to FALSE allows the provider to function correctly with some applications. In the configurator this option is a check box, and unchecked is default, meaning FALSE.



CR:434186
CR Number:   434186
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 May 2007 Fixed
Description
OLEDB: Cannot update with IS NOT NULL on datetime column through MS linked server. Fixed conversion from a textual timestamp to a Sybase TDS timestamp to round fractional seconds in the same way as the Sybase server.



CR:434189
CR Number:   434189
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2003
Original Version:   12.5.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to update datetime columns defined as "IS NOT NULL" from Microsoft SQL Server using a Sybase ASE linked server.



CR:434517
CR Number:   434517
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2006 Fixed
18 Aug 2006 Fixed
Description
NETLIB: Open Server hangs when accept() returns ECONNRESET.



CR:434545
CR Number:   434545
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Nov 2006 Fixed
05 Dec 2006 Fixed
29 Jan 2007 Fixed
26 Feb 2007 Fixed
06 Mar 2007 Fixed
21 Mar 2007 Fixed
Description
ESQL/C: A new feature allowing structs and arrays as indicator variables has been added to the cpre pre-processor. This is to allow application programmers to use the array name or the struct name for SELECT or UPDATE lists instead of coding individual indicator variables per query.



CR:434558
CR Number:   434558
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.05 04 Oct 2006 Fixed
5.5 ESD#22 05 Oct 2006 Fixed
Description
jConnect: Receive unexpected update counts / result sets when query calls nested stored procedures and IGNORE_DONE_IN_PROC connection property is set to true.



CR:434567
CR Number:   434567
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Sep 2006 Fixed
26 Sep 2006 Fixed
Description
ESQL products: this CR allows ANSI style binds to be turned off by using a new command line flag named '-u'. This allows for application migration projects to disable ANSI binds for that application without having to resort to the ocs.cfg file which would disable this for all applications running in this particular installation.



CR:434599
CR Number:   434599
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jul 2006 Fixed
27 Aug 2006 Fixed
Description
CTLIB, DBLIB and SRVLIB: Open Client and Open Server report incorrect program version in TDS login record.



CR:434766
CR Number:   434766
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 22 Dec 2006 Fixed
12.5.1 ESD#15 22 Dec 2006 Fixed
Description
OLE DB Provider by Sybase: The informational message callback handler installed is not called on events generated by "print" statements in stored procedures and queiries.
Workaround Description
 Use the ADODB.Error found from ADODB.Connection.Errors.



CR:434771
CR Number:   434771
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#7 08 Dec 2013 Fixed
12.5.1 ESD#17 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: Slower performance experienced using Sybase OLE DB Provider in a application using recordsets.



CR:434774
CR Number:   434774
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2003
Original Version:   1.15 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
When creating connection in new Project, under Server Explorer there is no listing for the ASE ADO.NET Data Provider.



CR:434920
CR Number:   434920
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#14
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#15 15 Jan 2007 Fixed
15.0 ESD#4 15 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Unable to use Text and Image datatypes with OpenSwitch backends, since the ODBC Driver sends these as TDS_BLOB which is not supported by OpenSwitch.
Workaround Description
 The only workaround I could devise is to change the ODBC code such that

it defines the parameter with a datatype that the ODBC driver will map

to a datatype that OpenSwitch (and Open Server) supports. The workaround

would look something like this.



/* Original call to SQLBindParameter using SQL_LONGVARBINARY causing the

ODBC driver to map to the TDS_BLOB datatype */

retcode = SQLBindParameter(stmt, 1, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_LONGVARBINARY, paramSize, decimalDigits, img, 0, &bufSize1);



/* SQLBindParameter statement modified to use SQL_VARBINARY which maps to

the TDS_VARBINARY datatype. */

retcode = SQLBindParameter(stmt, 1, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_VARBINARY, paramSize, decimalDigits, img, 0, &bufSize1);



CR:435118
CR Number:   435118
Product Name:   Organic OLE DB Provider
Product Component:   Configuration UI
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: The 揟est Connect option in the Sybase Data Source Administrator application displays password in clear-text.



CR:435127
CR Number:   435127
Product Name:   Open Client-Doc
Product Component:   Supplement
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 02 Jul 2007 Fixed
Description
You may encounter errors if you compile SDK 12.5.1 applications with Visual C++ 5.0.

Programmer's Supplement Open Client and Open Server 12.5.1 for Microsoft Windows explains that Sybase has certified Microsoft's Visual C++ Version 5.0.

But it should be Visual C++ Version 6.0.

To see the correct information, please read Release Bulletin.



CR:435147
CR Number:   435147
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jun 2007 Fixed
24 Jul 2007 Fixed
Description
Coordination Module application connected to Secondary Companion OpenSwitch Server will NOT receive / respond to any notifications when the Primary ASE Server is shutdown for any reason followed by the Primary Companion OpenSwitch Server going down. Primary OpenSwitch Server would have already handled the initial failure processes when Primary ASE Server is down.
Workaround Description
 CR 435147:

Once the Primary ASE, ASE1 is brought back UP as part of the failback operation,

the following steps has to be performed after logging into OpenSwitch Server

( Secondary Companion OpenSwitch Server, in this case. ) as an Administrator.

These steps will mark the Primary ASE as UP and will switch all the clients

back to the Primary ASE.

1)

Login into OpenSwitch as an Administrator.

isql -U<Admin User> -P<Admin Password> -S<OpenSwitch Server>

Issue the following registered procedures.

1)rp_stop <POOL NAME>, <Secondary ASE>, NULL, 0, 1

go

2)rp_server_status <Primary ASE>, UP

go

3)rp_switch <POOL NAME>, <Secondary ASE>, NULL, <Primary ASE>, 0, 1

go

4)rp_start <POOL NAME>, <Secondary ASE>, NULL

go



CR:435150
CR Number:   435150
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Jan 2007 Fixed
15 Jun 2007 Fixed
Description
Clients hang when no available server is found during failover in a OpenSwitch setup with CM.
Workaround Description
 Login into OpenSwitch Server as an Administrator and issue rp_kill command to kill the existing client connections that are hanging.



1)

isql -U<Admin User> -P <Admin Password> -S<OpenSwitch ServerName>



2)

Issue the following registered procedure:





rp_kill <Pool Name>,NULL,NULL

go





This will kill/shutdown all the client connections connected to the Pool specified by <Pool Name>.



CR:435201
CR Number:   435201
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 02 25 Oct 2006 Fixed
Description
Transaction name and userid are not written to the log in gatewayless environment.



CR:435299
CR Number:   435299
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLE DB Provider by Sybase: The properties listed in the DataLink GUI is missing some required information.



CR:435330
CR Number:   435330
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1 ESD#13
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#5 22 Dec 2006 Fixed
12.5.1 ESD#15 08 Dec 2013 Fixed
Description
OLE DB Provider by Sybase: OLE DB Provider does not fill the some recordset properties such as Count when the recordset is created.
Workaround Description
 Use the ADO Parameter property to execute the SP

Dim param As ADODB.Parameter

With sybCmd

.CommandText = sql

.let_ActiveConnection(sybConn)

.CommandType = ADODB.CommandTypeEnum.adCmdStoredProc

.CommandText = "ADOPROP_Check"

param = sybCmd.CreateParameter("returnvalue", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamReturnValue)

sybCmd.Parameters.Append(param)

.Execute()

TextBox1.Text = .Parameters("returnvalue").Value

End With



CR:435402
CR Number:   435402
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0.2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Oct 2006 Fixed
16 Sep 2012 EOL'd version. Not to be Fixed.
Description
CERTUTIL: OpenSSL cannot read server certificates due to a extra '\0' at the end of the encodings

in the file. OpenSSL gets an error with these certificates. For example, the command "openssl pkcs8 < server1.crt" will return the following error message:"Error reading key

24292:error:0906D06C:PEM routines:PEM_read_bio:no start line:pem_lib.c:642:Expecting:

ENCRYPTED PRIVATE KEY". This error is not seen with certicom.



When using an ASE that uses OpenSSL, you may get the following error message:

"Sybase CSI Error Message: Error reading the private key. The specified buffer content

is not in the expected format."



If this error is encountered, the corrective action would be to regenerate

certificate/private key using the new tools.



CR:435658
CR Number:   435658
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Sep 2006 Fixed
22 May 2007 Fixed
10 Aug 2006 Fixed
15 Oct 2006 Fixed
Description
Memory leak in the CM during the CM_CB_LOST callback while the CM is trying to re-establish a connection to the OpenSwitch.



CR:435799
CR Number:   435799
Product Name:   Organic OLE DB Provider
Product Component:   Install
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2006 Duplicate
Description
It's possible to install the Datadirect driver without a installer.

By doing a regsvr32 sybdrvoledb.dll and put the directory in the path.

This seems not to be possible with our Organic drivers.



CR:435876
CR Number:   435876
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Aug 2006 Not a Bug
Description
When selecting data it may be truncated when specifying the exact length x for a column whose data type is char(x).



CR:436080
CR Number:   436080
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2006 Fixed
5.5 ESD#22 05 Oct 2006 Fixed
Description
jConnect: Unable to retrieve return status from CallableStatement when IGNORE_DONE_IN_PROC connection property is set to true.



CR:436132
CR Number:   436132
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 17 Jul 2006 Not a Bug
Description
The new Release needs to have the RSP/CSA DB2 Table creates in teh release



CR:436175
CR Number:   436175
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 03 05 Oct 2006 Fixed
Description
RSP sample assemble JCL has an incorrect parmater name, ALGN, causing assembly errors.



CR:436447
CR Number:   436447
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Modifying the values of a disconnected recordset whose fields are not derived from columns in a table, will give the error: Multiple-step operation generated errors. Check each status value. -2147217887 Microsoft Cursor Engine.
Workaround Description
 None known.



CR:436770
CR Number:   436770
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Kon-Tiki 22 Aug 2006 Fixed
Tonga 05 Feb 2007 Fixed
Description
Problem: It took about 2 min. to create a trigger in a large database.



Resolution: This performance issue has been fixed.
Target Version
 1.6 ESD1



CR:436773
CR Number:   436773
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Kon-Tiki 22 Aug 2006 Fixed
Tonga 05 Feb 2007 Fixed
Description
Problem: It took about 10 seconds to create a stored procedure.



Resolution: This performance issue has been fixed.
Target Version
 1.6 ESD1



CR:436774
CR Number:   436774
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Kon-Tiki 22 Aug 2006 Fixed
Tonga 09 Feb 2007 Fixed
16 Oct 2006 Duplicate
Description
Problem: It took 30 sec. to start SQL Debugger.



Resolution: This performance issue has been fixed.
Target Version
 1.6 ESD1



CR:437253
CR Number:   437253
Product Name:   Open ClientCONNECT for IMS and MVS
Product Component:   Open ClientCONNECT for IMS and MVS
Status:   Closed
OS:   MVS
Original Version:   12.6 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 02 29 Sep 2006 Fixed
Description
Result varchar column is truncated when followed by a varchar column.



CR:437257
CR Number:   437257
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Enhance Sybase Organic Odbc Driver's ability to read values from the interfaces file sql.ini ie. to display a login box but maybe have the server name grayed out and it should show server name from the SQL.INI.

Change of login,password,database should be allowed.



CR:437718
CR Number:   437718
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Aug 2006 Third Party Problem
Description
This is a regression from ESQL/C 12.5. When inserting or updating a table with an empty string "", the data is inserted as NULL into table incorrectly. Th issue happens only when adding -G option to cpre. Due to customer's architecture, he needs to use the -G option in his environment.
Workaround Description
 Technically, not to use -G option. This is not applicable to customer's environment.



CR:437843
CR Number:   437843
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.09
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 04 25 Oct 2006 Fixed
Description
Abnormal end in CICS when clients connect through TDS 4.6.



CR:437845
CR Number:   437845
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2006 Fixed
17 Nov 2006 Fixed
Description
SRVLIB: When the conversion of character set is involved, srv_send_text() fails during the second invocation.



CR:437938
CR Number:   437938
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.15 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#6 19 Dec 2006 Fixed
1.15 ESD#6 21 Dec 2006 Fixed
Description
ADO.NET: The ADO.NET Provider produces Internal Error: 30016 with a specific query and using network packet size of 8192 or higher.



CR:437958
CR Number:   437958
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.6 ESD#3 25 Oct 2006 Fixed
Description
Interlink TCP/IP support discontinued.



CR:438281
CR Number:   438281
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Using the '-c' option with bcp allows copy of data when target table coulmn count differs from column count in data in some instances. Customer would like bcp should report an error if the column counts in the data and target table do not match.
Workaround Description
 *** Thursday, July 27, 2006 3:22:33 PM *** cooperg ***

None.



CR:438423
CR Number:   438423
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#7 16 Jan 2007 Fixed
12.5.1 ESD#17 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Accessing ASE using ODBC Driver from Microsoft Access 2003 causes reserved error (-7707).



CR:438584
CR Number:   438584
Product Name:   Open Client/Open Server-Doc
Product Component:   Programmer's Supplement
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 02 Jul 2007 Fixed
Description
In ASE11.9.2, "allow remote access" does not need "reconfigure with override" for dynamic parameter.



CR:438587
CR Number:   438587
Product Name:   Open Client/Open Server-Doc
Product Component:   Configuration Guide
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 02 Jul 2007 Fixed
Description
In Appendix B,libtcl.cfg support only directory and security driver.



CR:438591
CR Number:   438591
Product Name:   Open Client/Open Server-Doc
Product Component:   Configuration Guide
Status:   Closed
OS:   Solaris
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 02 Jul 2007 Fixed
Description
dscp does not use tli format. When specified, dscp uses tcp format. But it is not explained by manual.



CR:438735
CR Number:   438735
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Dec 2013 Fixed
02 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Unexpected behavior in Crystal Reports when connecting using ODBC Driver, because SQLProcedureColumns returns 揘O for IS_NULLABLE.



CR:439093
CR Number:   439093
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Open
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
insert after select...get data all...fails with Invalid cursor state (30111)



CR:439714
CR Number:   439714
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2006 Fixed
22 Sep 2006 Fixed
Description
BCP:bcp out under native mode does not support CS_LONGBINARY datatype.
Workaround Description
 Use character mode.



CR:439724
CR Number:   439724
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
create 64 bit OLE DB provider for the Sybase 15.x Organic 64bit ODBC driver



CR:439880
CR Number:   439880
Product Name:   Database Development
Product Component:   SQL Editor
Status:   Closed
OS:   Windows XP
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Kon-Tiki 21 Aug 2006 Fixed
Tonga 28 Mar 2007 Fixed
Description
Problem Details:

The content assist in SQL Editor gives the user the incorrect syntax when typing in "create index index_name on table_name (". The content assist gives table_name.column_name, which doesn't fit the ASE index. If user select one column from content assist and try to save, error will occur.
Target Version
 1.6 ESD1



CR:440044
CR Number:   440044
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
26 Oct 2006 Fixed
26 Oct 2006 Fixed
27 Nov 2006 Fixed
29 Nov 2006 Fixed
Description
NETLIB: If multiple threads are calling ct_connect() using Kerberos security mechanism, a race condition may cause a SEGV in csd_bind().
Workaround Description
 Use a single global context seems to help avoid the crashes, not sure it is 100% safe.



CR:440092
CR Number:   440092
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2006 Fixed
22 Sep 2006 Fixed
Description
CTLIB:Memory leak occurs between ct_con_alloc() and ct_con_drop() when connecting to server fails.



CR:440285
CR Number:   440285
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows 2000
Original Version:   Kon-Tiki
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 25 Oct 2006 Fixed
Tonga 18 Jan 2007 Fixed
Description
Problem: Cannot step into system stored procedure during debugging.



Resolution: This issue has been fixed.
Target Version
 1.6 ESD1



CR:440308
CR Number:   440308
Product Name:   Database Development
Product Component:   SQL Debugger
Status:   Closed
OS:   Windows 2000
Original Version:   Kon-Tiki
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2006 Fixed
09 Oct 2006 Fixed
Description
Problem: Failed to load trigger definition during debugging when the quoted identifier preference is 慜N'.



Resolution: This issue has been fixed.
Target Version
 1.6 ESD1



CR:440498
CR Number:   440498
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 Jan 2007 Fixed
Description
OLE DB Provider by Sybase: Unable to access subsequent Rowsets if query retuned multiple result sets.



CR:440656
CR Number:   440656
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Jul 2012 Fixed
Description
Customer needs way to identify Open Server spid in a network trace/TDS



CR:440827
CR Number:   440827
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#7 16 Jan 2007 Fixed
16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: ODBC connection to ASE from Microsoft Office 2000 / Excel results in Application crash.



CR:441438
CR Number:   441438
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
12.5.1 ESD#16 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Setting statement attribute SQL_ATTR_CURSOR_TYPE to Static or Keyset options produces SQL_ERROR.



CR:441451
CR Number:   441451
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Sep 2006 Fixed
30 Oct 2006 Fixed
Description
coord__valid_appname uses non-thread safe function strtok



CR:441465
CR Number:   441465
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#6 16 Jan 2007 Fixed
12.5.1 ESD#16 16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: Calling SQLSetCursorName before a SQLPrepare statement doesn't set the cursor name to the user specified cursor name when SQLExecute is called, it defaults to the driver generated cursor name instead.



CR:441476
CR Number:   441476
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Sep 2006 Fixed
16.0 18 Jun 2007 Fixed
17 Oct 2006 Fixed
Description
OpenSwitch truncates the name of CM to 30 characters.
Workaround Description
 Make the server's hostname shorter than 30 characters. Around 10 characters would work well.



CR:441853
CR Number:   441853
Product Name:   Open Client
Product Component:   blklib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Mar 2007 Fixed
19 Mar 2007 Fixed
Description
BLKLIB: Bulk copy in of client-side character set conversion from utf8 to iso_1 (-Y option) is incorrect.
Workaround Description
 bcp in and out using -Jiso_1 so that the column retains it's original value of 0xE3



CR:441896
CR Number:   441896
Product Name:   Database Development
Product Component:   Other
Status:   Closed
OS:   Generic
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Samoa - Official 08 Oct 2006 Fixed
Tonga 04 Jan 2007 Fixed
Description
Problem: Cannot create procedural objects on ASE 12.5.3 when logged in as a user who is aliased to 慸bo.



Resolution: This issue has been fixed.
Target Version
 1.6 ESD1



CR:442470
CR Number:   442470
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2006 Fixed
5.5 ESD#22 04 Oct 2006 Fixed
Description
jConnect: DatabaseMetaData.getTypeInfo call no longer returns ASE Local type of "double precision".



CR:442559
CR Number:   442559
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Nov 2006 Fixed
29 Nov 2006 Fixed
Description
NETLIB: Open server core dump when using wrong SSL password, due to inappropriate close.
Workaround Description
 None known.



CR:442593
CR Number:   442593
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Linux
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
06 Oct 2006 Fixed
27 May 2007 Fixed
15 Oct 2006 Fixed
Description
Mutually aware OpenSwitches started simultaneously will hang. Clients trying to connect to either server will time out.
Workaround Description
 Make sure there is a small delay between starting

the primary and the companion OpenSwitches.



CR:442632
CR Number:   442632
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.15 ESD#9
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.15 ESD#7 21 Dec 2006 Fixed
08 Dec 2013 Fixed
Description
ADO.NET: When a command with CommandBehavior.SequentialAccess is closed using CommandBehavior.CloseConnection the connection is not closed.



CR:442781
CR Number:   442781
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Win32s
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jan 2007 Duplicate
Description
Memory leaks in libintl when tcl config (%SYBASE%\ini\libtcl.cfg) is missing.
Workaround Description
 none



CR:442817
CR Number:   442817
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jan 2007 Fixed
16 Jan 2007 Fixed
Description
ODBC Driver by Sybase: SQLConfigDataSource will display the DSN configuration dialog even if NULL parent window handle is specified. The ODBC_CONFIG_SYS_DSN function configures DSNs as User DSN as opposed to system DSN.



CR:442936
CR Number:   442936
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   Unknown
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
30 May 2008 Fixed
28 May 2008 Fixed
29 May 2008 Fixed
24 Jan 2008 Fixed
30 May 2008 Presently Not Targeted For Any Future Release Of This Product
02 Dec 2008 Not reproducible with latest version of the product available as of Resolution Date
Description
SRVLIB: Implemented Open Server Connection Migration



CR:442988
CR Number:   442988
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Generic
Original Version:   ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Oct 2006 Fixed
11 Jan 2007 Fixed
15 Nov 2006 Fixed
Description
Both instances of a mutually-aware OpenSwitch installation are handling SVR_FAIL_ACTION.



CR:443123
CR Number:   443123
Product Name:   Database Development
Product Component:   Database Explorer
Status:   Closed
OS:   Windows 2000
Original Version:   Samoa - Official
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 02 Nov 2006 Fixed
Description
Problem: The Database Explorer view is very slow in expanding the 慡tored Procedure node for a large database.



Resolution: This performance issue has been fixed.
Target Version
 1.6 ESD1



CR:443182
CR Number:   443182
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)
16 Nov 2006 Fixed
16 Nov 2006 Fixed
03 Jan 2007 Fixed
27 Nov 2006 Fixed
03 Jan 2007 Fixed
Description
NETLIB: 3rd party certificates may result in SSL connection failure.
Workaround Description
 use sybase certs or 12.5.1 client software



CR:443204
CR Number:   443204
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)
19 May 2008 Fixed
03 Jun 2008 Fixed
19 May 2008 Fixed
20 May 2008 Fixed
23 May 2008 Fixed
Description
DRIVERS: Provide directory schema for Active Directory (AD) and/or Active Directory Application Mode (ADAM) to store Sybase Server entries.



CR:443327
CR Number:   443327
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
03 Oct 2006 Fixed
5.5 ESD#22 05 Oct 2006 Fixed
Description
jConnect: DatabaseMetaData.getTypeInfo returns internal ASE system user types (like longsysname) which should not be returned.



CR:443503
CR Number:   443503
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   all
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
oslib.loc lists SRV_EEINITNET instead of SRV_EINITNET



CR:443570
CR Number:   443570
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   6.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Change sp_jdbc_getbestrowidentifier so it can run in transaction



CR:444031
CR Number:   444031
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   all
Original Version:   15.0 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#7 16 Jan 2007 Fixed
12.5.1 ESD#17 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Connection to ASE from ODBC Driver fail from some client machines running non-english locales. The connection fails if the locale matches one of the languages supported by ASE and that language module is not installed on ASE.



CR:444060
CR Number:   444060
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Oct 2006 Fixed
Description
BCP: bcp-in of an empty file fails when the table has computed columns.



CR:444136
CR Number:   444136
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Nov 2006 Fixed
13 Nov 2006 Fixed
Description
CTBCP: bcp supports two new arguments --colpasswd and --keypasswd for sending passwords of encrypted columns and keys to database server to gain decryption permission of the encrypted columns.



CR:444301
CR Number:   444301
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2006 Fixed
18 Jun 2007 Fixed
Description
OpenSwitch crashes/core dumps when RCM_PATH is incorrect
Workaround Description
 Include the "rcm" binary in the path specified:

RCM_PATH = /software/openswitch15/OpenSwitch-15_0/bin/rcm



CR:444520
CR Number:   444520
Product Name:   Organic OLE DB Provider
Product Component:   OLE DB Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   15.0 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12 Oct 2006 Duplicate
Description
OLE DB Provider by Sybase: Modifying the values of a disconnected recordset whose fields are not derived from columns in a table, will give the error: Multiple-step operation generated errors. Check each status value. -2147217887 Microsoft Cursor Engine.



CR:444961
CR Number:   444961
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15.0 ESD#8 08 Dec 2013 Fixed
Description
ODBC Driver by Sybase: Using the "Import Data" function in Microsoft Excel (Office 2003) fails with following error: "The Data Connection Wizard cannot obtain a list of databases from the specified data source.".



CR:445165
CR Number:   445165
Product Name:   Database Development
Product Component:   Creation Wizards
Status:   Closed
OS:   Windows XP
Original Version:   Kon-Tiki
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.6 ESD1 16 Nov 2006 Fixed
Description
Description: The Procedural Object creation wizard cannot list user-defined datatypes with spaces in the type name.



Resolution: This issue has been fixed.
Target Version
 1.6 ESD1



CR:445584
CR Number:   445584
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   all
Original Version:   15.0 ESD#6
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Nov 2006 Fixed
11 Jan 2007 Fixed
01 Nov 2006 Fixed
Description
SRVLIB: Dynamic SQL commands returning multiple result sets will fail when running against an Open Server gateway application.





--------------------------------------华丽的分割线-------------------------------------------------------------------------
之前就已经研发成功了能够从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等等。
+-------------------------------------华丽的分割线-------------------------------------------------------------------------