远程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:353088
CR Number:   353088
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   HP-UX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Fixed
Description
Following the execution of a notification process on HP, RCM may hang.



CR:353270
CR Number:   353270
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   HP-UX
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Nov 2004 Fixed
22 Nov 2004 Fixed
15.0 06 Jul 2005 Fixed
15.0 17 Dec 2004 Fixed
15.0 28 Jan 2005 Fixed
12.5.1 28 Jan 2005 Fixed
Description
Coordination Module hangs under extreme load, causing OpenSwitch to stall.
Workaround Description
 To workaround this problem, modify CM to adding a timer in the program that calls a dummy function every 1 second. This will force the ct_poll to timeout every 1 second, which will "unstuck" any msg that is stuck in the queue.



The change is as follows:

Add this declaration at the top:

CS_STATIC CS_RETCODE CS_PUBLIC cm_time_dummy();



Before calling cm_run in main(), add this:

if (cm_timer_add( cm, "dummy", (CS_INT)1000,

(cm_timer_cb*)cm_time_dummy, (CS_VOID*)NULL,

(CS_INT)0 ) != CS_SUCCEED)

{

fprintf(stderr, "cm1: Unable to add cm_time_dummy\n" );

}



Finally, add the definition of cm_time_dummy:

/*

* cm_time_dummy():

*

* Dummy function to force the CM to check its message queue at least once

* every second. This function is installed using cm_timer_add() before

* calling cm_run.

*/

CS_STATIC CS_RETCODE CS_PUBLIC cm_time_dummy( cm, name, data )

cm_t *cm;

CS_CHAR *name;

CS_VOID *data;

{

return CS_SUCCEED;

}



See an example of this incorperated into the cm1.c sample in:

/remote/oswhp2/12.5.1/OpenSwitch-12_5/sample/cm1.c



CR:353365
CR Number:   353365
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.0 ESD#2 16 Nov 2004 Fixed
5.5 ESD#15 16 Nov 2004 Fixed
Description
jConnect: Request a stored procedure to inquire version of jConnect meta-data (MDA) stored procedures installed on the Adaptive Server.



CR:353377
CR Number:   353377
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Aug 2004 Fixed
Description
ODBC: TDS ODBC Driver throws Kerberos error msgs when not using Kerberos.



CR:353584
CR Number:   353584
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
11 Aug 2004 Fixed
Description
ADO.NET: Output parameters are not accessible once you close the AseDataReader object.
Workaround Description
 Access the output parameter(s) before closing the AseDataReader object.



CR:353618
CR Number:   353618
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Aug 2004 Fixed
Description
ADO.NET: Enhancement request to overload AseParameter constructor to allow Integer values for scale and precision. This allows literal values to be specified in a VB.NET program.
Target Version
 1.1 ESD#5



CR:353786
CR Number:   353786
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jul 2004 Fixed
15 Sep 2004 Fixed
Description
CTLIB: Calling ct_options() repeatedly causes small memory leak.
Workaround Description
 Check if ct_option() is already set?



CR:353904
CR Number:   353904
Product Name:   Open Server
Product Component:   srvlib
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 May 2004 Fixed
04 May 2004 Fixed
Description
SRVLIB: Under some circumstances, Open Server might not correctly handle the byte swapping for DATE and TIME data types.



CR:353948
CR Number:   353948
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2005 Fixed
Description
ODBC: When Select Method = Cursor is used in the ODBC Connection string, An error occurs: "[DataDirect][ODBC Sybase Wire Protocol driver]Socket closed.", when executing a query, containing a "--" style of comment line, using ASE 12.5.0.3. This problem is now fixed. ODBC Error message also contained SQLState "08S01", and NativeError = 7503. Problem will not occur with ASE 12.5.2 and higher.



CR:353992
CR Number:   353992
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)
07 May 2004 Fixed
07 May 2004 Fixed
Description
BCP: BCP might get signal BUS error in com__chtoi4_mb when loading integer data in character mode.



CR:354130
CR Number:   354130
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Feb 2005 Fixed
Description
cm_ping inadvertently blocks/suppresses client and server error messages
Workaround Description
 Make sure that cm_ping() will not fail due to configuration

issues such as invalid username/password or lack of connections

on ASE.



CR:354265
CR Number:   354265
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
Description
ODBC: Passing input parameters using the Len_Or_IsNull parameter in SQLBindParameter function does not work under the ASE ODBC Driver 12.5.1 on Linux.
Workaround Description
 Use null terminated strings (SQL_NTS).



CR:354330
CR Number:   354330
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
10 May 2004 Fixed
Description
Clients that whose versions are less than 12.5.1 will no longer get an error when they

select from a table that contains a column that is of type date or of type time.
Target Version
 12.5.1
Workaround Description
 Use only 12.5.1 clients against OpenSwitch when trying

to query new "date" and "time" datatypes.



CR:354593
CR Number:   354593
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   all
Original Version:   12.5.0.3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description



CR:354694
CR Number:   354694
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)
25 May 2004 Fixed
08 Jun 2004 Fixed
Description
BCP: Under boundary conditions, BCP might leave the connection in an unstable state.



CR:354845
CR Number:   354845
Product Name:   ESQL
Product Component:   Cobol
Status:   Open
OS:   AIX
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
PIC S9(3) datatypes never assume CS-COBSMALLINT-TYPE (102).

Tested and reproduced with:

cobpre 12.5 EBF 11508 (NT) and 11510 (AIX)

cobpre 12.0 EBF 11240 (NT) and 11235 (AIX)

cobpre 12.5.1 EBF 11410 (NT)



CR:354891
CR Number:   354891
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT for IMS/MVS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
002 12 Jul 2004 Fixed
Description
Add SYGWXCPH load module to released datasets



CR:355133
CR Number:   355133
Product Name:   Open ClientCONNECT for CICS
Product Component:   Open ClientCONNECT for CICS
Status:   Open
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer would like OCC on the CTBCONNECT to be able to support H.A.

Like Open Cleint on the lan customer would like High Availabilty.

Would like CTBCONNECT using SYGWHOST lib to be able to failover to a backup server if the connection to the first server fails.



CR:355161
CR Number:   355161
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Dec 2004 Duplicate
22 Dec 2004 Duplicate
Description
Batching together multiple commands in a DB-Library client application, may cause OpenSwitch to get the error: srv_sendstatus: State error (0x5a104)



CR:355417
CR Number:   355417
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Solaris
Original Version:   To Be Determined
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has asked for an extension which enables him to retrieve

the current transaction status which is included in every TDS_DONE/

TDS_DONEPROC/TDS_DONEINPROC packet. jConnect already allows this for

SybExceptions and SybWarnings and further; CT-Lib provides access to

this information via the API call "ct_res_info(...TRAN_STATE...) "



CR:355766
CR Number:   355766
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ISQL: Implement the configurable date format for non-English customers.



CR:355797
CR Number:   355797
Product Name:   OpenSwitch
Product Component:   CM
Status:   Closed
OS:   Solaris
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
21 Jul 2004 Fixed
25 May 2004 Fixed
Description
CM uses un-threadsafe calls like usleep causing CM to exit with "Alarm Clock" message



CR:355803
CR Number:   355803
Product Name:   ESQL
Product Component:   C
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
CPRE: fails to give any warning that it cannot handle 64-bit long int host variables.
Workaround Description
 Possibly try typedef-ing long to CS_INT?



CR:355805
CR Number:   355805
Product Name:   Embedded SQL/C-Doc
Product Component:   C Programmer's Guide
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Galaxy 30 Jul 2005 Fixed
Description
CPRE: Documentation should point out that "long int" is only supported in 32-bit applications and NOT in 64-bit applications.
Workaround Description
 N/A.



CR:355860
CR Number:   355860
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2004 Deferred
Description
Request for TYPE_SCROLL_SENSITIVE cursor on jConnect



CR:355934
CR Number:   355934
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
Description
ODBC: The ASE ODBC Driver 12.5.1 on Linux does not support SQLPutData() function for fixed length datatypes such as int, float, double etc.
Workaround Description
 Bind the fixed length datatypes to host variables instead of using SQLPutData.



CR:355936
CR Number:   355936
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Aug 2004 Fixed
Description
ADO.NET: The sybaseServerName filter in the DSURL property does not work and throws a NullPointerException
Target Version
 1.1 ESD#5
Workaround Description
 string aseConnDSURL = "DSURL=ldap://pvero-srv:389/dc=sybase,dc=com??one?sybaseServername=pv2k1251;Server=pv2k1251;User Id=sa;Pwd=;";



CR:356081
CR Number:   356081
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
SYGWCTXH is allocating 4K PRM_DESC, and only freeing them at the client logoff.

This is causing a problem for customer that stay connect all day running requests.

At Logoff SYGWCTXH does a TDFREE and cleans up the chained 4K ESDSA Parm Desc, since there is many of them SUGWCTXH is in a tight loop cleaning up the descriptors and causes CICS to abend the TASK with a AICA.



CR:356118
CR Number:   356118
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Sep 2007 Not a Bug
Description
Customer would like a way to test for revoked pswds, using LESCR=U. There is noway to do this at this time with making backend calls to the Secuirty manager. So it makes sense to give the customers a way to code their own security exit.



CR:356225
CR Number:   356225
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.04
Fixed Version Build Resolution Date Closure Code (If Appropriate)
18 Oct 2004 Fixed
Description
Incorrect setting of end-of-message TDS packet indicator.



CR:356437
CR Number:   356437
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
Description
ODBC: The ASE ODBC Driver 12.5.1 on Linux does not currently support SQLColAttributes() function as described in the ODBC 2.x specification, but deprecated in the ODBC 3.x specification. This function is needed for backwards compatibility with ODBC 2.x applications.
Workaround Description
 Change application to use the SQLColAttribute() function as described in the ODBC 3.x specification.



CR:356710
CR Number:   356710
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
current_date() function displays localized date format.



CR:357065
CR Number:   357065
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
Description
ODBC: The ASE ODBC Driver 12.5.1 on Linux will produce an internal error when a SELECT statement with "FOR BROWSE" clause is executed.
Workaround Description
 Remove the "FOR BROWSE" clause if application logic permits.



CR:357160
CR Number:   357160
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB: <Fixed in 12.5.1/P-EBF12008 ESD#4/02.70.0038> For table names that have 30 chars, ADO OpenSchema replaced the 30th char by a blank character.



CR:357238
CR Number:   357238
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)
14 Feb 2007 Fixed
21 Feb 2007 Fixed
Description
NETLIB: The memory usage for an application may increase dramatically when the size of interfaces file increases.



CR:357239
CR Number:   357239
Product Name:   OpenSwitch
Product Component:   RCM
Status:   Closed
OS:   Generic
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 May 2005 Fixed
Description
After the failure of the active database, the first login attempt to the OpenSwitch/RCM will initiate the failover sequence, but subsequent data queries may hang. Both established logins and new logins will be able to successfully perform data queries.



CR:357274
CR Number:   357274
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows 95
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2004 Fixed
Description
ODBC: When mapping a Sybase ASE stored procedure with Microsoft DTS, in the "Transformation" tab, the columns in ASE are not mapped to the columns of MS SQL Server. When performing the "Execute Step", this should transfer the result set of the stored procedure from the ASE to MS SQL Server. When inspecting the table in the MS SQL Server the rows are not there.



CR:357375
CR Number:   357375
Product Name:   ADO.NET Data Provider
Product Component:   TDS Library
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Apr 2005 Fixed
Description
ADO.NET: Feature request to add support for CP949 (Korean) character set.



CR:357574
CR Number:   357574
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Jan 2005 Fixed
Description
ODBC: Query Timeout not working in RDO application when ODBC Connection Property Select Method = Cursor, CursorDriver was set to rdUseServer and executing in Asynchronous Mode. If Select Method is set to Direct, and Asynchronous mode is selected, the Query Timeout will not work.



CR:357628
CR Number:   357628
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jan 2006 Duplicate
Description
If you drop all existing contexts after ctlib has been initialised and then try and use ctlib again then then netlib error messages are unavailble. netlib errors will result in bus errors or unexpected behaviour.
Workaround Description
 Before doinbg any Sybase related calls you can create a context, initialise ctlib and then exit ctlib but leave the context lying around. This will make sure a copy of the tcllib errors stay around. Use a function like:



void dummy_create_context()

{

CS_CONTEXT *cp;



cs_ctx_alloc(CS_CURRENT_VERSION, &cp);



ct_init(cp, CS_CURRENT_VERSION);



ct_exit(cp, CS_UNUSED);

}



CR:357833
CR Number:   357833
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
Description
ADO.NET: Under specific circumstances, the ASE ADO.NET Data Provider could produce an Internal Error: 30002 when a command is executed. This typically happens when large numbers of parameters or parameters with very long names are used.
Workaround Description
 Reduce the length of one or more parameter names or use parameter markers instead.



CR:357847
CR Number:   357847
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Dec 2007 Fixed
08 Mar 2008 Fixed
18 Sep 2012 EOL'd version. Not to be Fixed.
Description
COMNLIB: The supported character set for section/entry names in Open Client/Open Server configuration files has been extended. Now all seven-bit ASCII printable characters except square brackets, space and equal symbol are supported. Other current rules for section and entry names still apply.
Workaround Description
 None. The customer cannot change the vendors naming just to use this file.



CR:357888
CR Number:   357888
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Linux
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Sep 2004 Not a Bug
Description
The ct_exit() function will segv on IA64 in a threaded application if one tries to use the

NPTL threads libraries of RH AS 3.0. Note: at the time of this investigative CR filing. The NPTL libraries are not certified but this symptom was observed.
Review Status
 The ct_exit() function will segv on IA64 in a threaded application if one tries to use the

NPTL threads libraries of RH AS 3.0. Note: at the time of this investigative CR filing. The NPTL libraries are not certified but this symptom was observed.
Workaround Description
 Use the LD_ASSUME_KERNEL but unacceptable for this customer, other customers may be ok.



CR:358061
CR Number:   358061
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
29 May 2009 Fixed
Description
Add section in doc on handling numeric overflow errors when sent as warnings



CR:358163
CR Number:   358163
Product Name:   OpenSwitch
Product Component:   OpenSwitch
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 Jun 2004 Fixed
25 Jun 2004 Fixed
Description
OpenSwitch returns invalid TDS packets resulting in invalid column status error when a client issues a writetext language command for pre-12.5 clients.



CR:358169
CR Number:   358169
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0 ESD#2
Fixed Version Build Resolution Date Closure Code (If Appropriate)
6.5 Beta3 15 Mar 2005 Fixed
15 Mar 2005 Fixed
Description
jConnect: Request to add a sample that demonstrates ExecuteQueryNumeric call.



CR:358313
CR Number:   358313
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Request to raise an error or warning when jConnect skips a resultset

because the application code has requested to retrieve a registered

output parameter prior to reading the result set.
Workaround Description
 The JZ0R0 error will not happen when the ResultSet is processed

before the output parameter is retrieved.



CR:358325
CR Number:   358325
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Nov 2004 Presently Not Targeted For Any Future Release Of This Product
Description
Customer request to enhance performance on ResultSet.getDate() method when target type is ASE datetime.



CR:358356
CR Number:   358356
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Nov 2004 Fixed
Description
The issue is when a Program is linked as RENT CICS puts the Program in CICS KEY, Since We load the Addressed of the Drivers into the SYGWXCPH storage any program that access SYGWXCPH has to also be in CICS Key...



CR:358457
CR Number:   358457
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC (CT-Lib) RDO applications that call stored procedures which return both output parameters and RAISERROR messages. If the parameters are fetched the RAISERROR is not seen.
Workaround Description
 None.



CR:358471
CR Number:   358471
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
002 12 Jul 2004 Fixed
Description
Problem with overriding character sets in SYGWXCPH table.



CR:358496
CR Number:   358496
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
17 Sep 2004 Fixed
16 Nov 2004 Fixed
Description
CTLIB:ct_connect fails to connect to a remote server when CS_TIMEOUT is set.
Workaround Description
 none.



CR:358596
CR Number:   358596
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   DOS
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
28 Jun 2004 Fixed
22 Jul 2004 Fixed
Description
NETLIB: On NT machines with two or more network cards, ct_connect() will hang when CS_NETIO is set to asynchronous mode and the server it's connecting to is not started.



CR:358760
CR Number:   358760
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2004 Fixed
Description
ODBC: ODBC should also support old connection parameters "ServerName" ("SRVR") as equivalent to "InterfaceFileServerName" ("IFSN") in OpenStrings and DSN registry entries.
Workaround Description
 Difficult. Modify source code of many applications.



CR:358769
CR Number:   358769
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#4 13 Aug 2004 Fixed
Description
ADO.NET: Command parameters cannot be accessed, if the IdbCommand.Add() method is used to add the parameters. A NullReferenceException is thrown when you try to access the parameters.
Workaround Description
 Use the AseCommand.Add() method to add the parameters.



CR:358978
CR Number:   358978
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Closed
OS:   NA
Original Version:   Galaxy
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Oct 2006 Fixed
01 Feb 2007 Fixed
11 Jan 2007 Fixed
22 Feb 2007 Fixed
22 Feb 2007 Fixed
01 Mar 2007 Fixed
01 Mar 2007 Fixed
23 Dec 2008 Fixed
Description
BCP: New feature to enable BCP to log all the rows that are rejected into a new discard file (-d discardfileprefix).



CR:359418
CR Number:   359418
Product Name:   Open Client
Product Component:   dblib
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Dec 2004 Fixed
11 Jan 2005 Fixed
Description
DBLIB: dbpoll crashes and gets an exception in comn_waitfor_event on Windows platforms



CR:359594
CR Number:   359594
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2012 Fixed
Description
Redhat 3.0 AS is certified with the restriction that one must link applications with the archive libraries. This CR is a request to provide a set of libraries which remove this restriction, thus providing customers the ability to create applications which use dynamic linking for Sybase OCS applications.



CR:359944
CR Number:   359944
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   Unknown
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Jun 2006 Fixed
6.0 ESD#2 05 Jul 2006 Fixed
5.5 ESD#15 07 Jul 2006 Fixed
Description
jConnect: The setNanos(), getNanos() calls will not set/retrieve nanoseconds precisely in ASE. A value set cannot be retrieved and match the inserted value.



CR:360023
CR Number:   360023
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Nov 2004 Fixed
Description
ODBC: Connection.Properties("Server Name") returns hostname instead of Sybase ASE server name.



CR:360138
CR Number:   360138
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   6.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Sep 2004 Fixed
Description
jConnect: Incorrect Adaptive Server version picked by Meta-data stored prcoedures for Adaptive Server versions 12.x.



CR:360267
CR Number:   360267
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Aug 2004 Fixed
Description
ADO.NET: Enhancement request to implement DerivedParameters support in AseCommandBuilder
Target Version
 1.1 ESD#5



CR:360368
CR Number:   360368
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
31 Aug 2004 Fixed
Description
ADO.NET: Enhancement request to have AseConnection implement ICloneable
Target Version
 1.1 ESD#5



CR:361004
CR Number:   361004
Product Name:   ESQL
Product Component:   Cobol
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Aug 2004 Fixed
24 Aug 2004 Fixed
Description
COBPRE: Upgrade to 12.5.1 causes Cobol app: 25009 Unexpected CS_STATUS_RESULT received



CR:361150
CR Number:   361150
Product Name:   Connectivity Utilities
Product Component:   bcp
Status:   Open
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
29 Sep 2004 Fixed
13 Sep 2004 Fixed
Description
BCP: Provide -C option to allow support for copying in/out ciphertext from encrypted columns.



CR:361169
CR Number:   361169
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#5 23 Aug 2004 Fixed
Description
ADO.NET: Cannot set charset in ConnectionString property in the properties window when using Visual Basic .NET
Target Version
 1.1 ESD#5



CR:361199
CR Number:   361199
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
22 Jul 2004 Fixed
13 Sep 2004 Fixed
22 Jul 2004 Fixed
Description
NETLIB: Open Server core dumps when closing SSL connections.
Workaround Description
 Don't run in preemptive mode.



CR:361331
CR Number:   361331
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
16 Sep 2004 Not a Bug
Description
Customer's app sometimes hangs in ct_cancel()



CR:361484
CR Number:   361484
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT for IMS and MVS - DOC
Status:   Closed
OS:   MVS IMS
Original Version:   3.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
08 Feb 2005 Fixed
Description
Install & Admin Guide OSC for IMS/MVS 3.1 does not explain the SYGWDRIV macro in the OSC Global Customerization module (SYGWICPH). The only references are in the manual OSC for CICS 12.5 (see http://sybooks.sybase.com/onlinebooks/group-or/orp1250e/@Generic__CollectionView?DwebQuery=SYGWDRIV)



CR:361489
CR Number:   361489
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Add new DTM coordinator type to stop sending back @xactstatus



CR:361514
CR Number:   361514
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Unknown
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
09 Jul 2006 Fixed
17 Jul 2006 Fixed
13 Jul 2006 Fixed
27 Jul 2006 Fixed
Description
SSL:ct_con_props(CS_SET, CS_PROP_SSL_CIPHER) doesn't support comma delimited but null terminated ciphersuite.
Workaround Description
 use valid cipher names followed by a comma.



CR:361824
CR Number:   361824
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Open
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Passing zero to the isql -w flag should turn off the line wrapping finctionality completly.



CR:362016
CR Number:   362016
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Sep 2004 Fixed
Description
ODBC: Stored procedure with output parameter and raiserror message would sporadically crash during execution.



CR:362082
CR Number:   362082
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2004 Fixed
Description
ADO.NET: Enhancement request to have AseParameter support converting a double literal value to a Decimal type.
Target Version
 1.1 ESD#5
Workaround Description
 Convert a double literal value to an instance of Decimal object and then assign it to the AseParameter.Value



CR:362098
CR Number:   362098
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Red Hat Enterprise Linux
Original Version:   12.5.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
12.5.1 ESD#4 13 Aug 2004 Fixed
Description
ODBC: The ASE ODBC Driver 12.5.1 on Linux does not correctly support UTF-16 encoding.



CR:362119
CR Number:   362119
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.05
Fixed Version Build Resolution Date Closure Code (If Appropriate)
20 Oct 2004 Fixed
Description
Customer would like to have one Listener Config that will cross LPARs.

In other word customer would like the same region ID to have muliply TCP SSIDs.

So we need a way to Ingnore the SSID if is not valid on that LPAR, and bring up the correct REGION with the TCP/IP SSID that is up for that LPAR.



CR:362309
CR Number:   362309
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
1.1 ESD#5 24 Aug 2004 Fixed
Description
ADO.NET: Enhancement request to have AseParameter support upto 255 byte binary output parameter if the length is not specified.
Target Version
 1.1 ESD#5



CR:362445
CR Number:   362445
Product Name:   ESQL
Product Component:   C
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
02 Mar 2006 Fixed
21 May 2007 Presently Not Targeted For Any Future Release Of This Product
Description
CPRE: cpre occaisionally gives Access Violations precompiling some source files.
Workaround Description
 None known.



CR:362529
CR Number:   362529
Product Name:   Open Server
Product Component:   srvlib
Status:   Closed
OS:   NA
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Aug 2004 Fixed
24 Aug 2004 Fixed
Description
SRVLIB:Sending empty text string with srv_send_text() fails.



CR:362886
CR Number:   362886
Product Name:   Open Client
Product Component:   ctlib
Status:   Closed
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
13 Feb 2006 Fixed
21 Feb 2006 Fixed
Description
DEFNCOPY: When using kerberos network security authentication, defncopy should not prompt the user for a password via the -P parameter.



CR:362973
CR Number:   362973
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Closed
OS:   NA
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
07 Jan 2005 Fixed
Description
jConnect: Request to add support for 揵ig5hk character set in jConnect.



CR:362997
CR Number:   362997
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.6.ESD1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
04 Oct 2012 Fixed
Description
Customer would like OSC/OCC to run with CICS THREADSAFE Concurrency option



CR:363126
CR Number:   363126
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ODBC: Request to provide support for ASE IMAGE datatype with SQLDescribeParam



CR:363192
CR Number:   363192
Product Name:   Organic ODBC Driver
Product Component:   ODBC Driver
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Dec 2004 Fixed
15.5 ESD 9 4 07 Mar 2011 Fixed
Description
ODBC Driver by Sybase: Enhancement request to support SQLDescribeParam()

Workaround: None



CR:363220
CR Number:   363220
Product Name:   Open Client
Product Component:   ctlib
Status:   Open
OS:   Solaris
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer wants a CT-Library wrapper for their DB-Library applications



CR:363335
CR Number:   363335
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS
Status:   Closed
OS:   MVS
Original Version:   12.50.06
Fixed Version Build Resolution Date Closure Code (If Appropriate)
14 Apr 2006 Fixed
Description
MFC Server Option for CICS needs configurable timeout option for the listener Read



CR:363687
CR Number:   363687
Product Name:   Open ServerCONNECT for IMS and MVS
Product Component:   Open ServerCONNECT for IMS and MVS - DOC
Status:   Closed
OS:   MVS IMS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2004 Not a Bug
Description
Applying EBF10454 to upgrade OSC for IMS from 3.1 to 12.5.2 will cause IMS App using IBM LU61 Adapter to LU62 (aka the Bridge) to hit TDACCEPT RC -4998; IBM has ceased the support for its Adapter since IMS V5.1 in 1998.
Workaround Description
 Configure OSC to use the LU62 CPIC driver to support IMS applications on IBM's native APPC/IMS instead



CR:363702
CR Number:   363702
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Fixed
Description
ADO.NET: Selecting a resultset that utilizes convert function to convert data into a smalldatetime datatype may cause may cause an Internal Error 30016.
Target Version
 1.1 ESD#5
Workaround Description
 Use datetime instead of smalldatetime.



CR:363732
CR Number:   363732
Product Name:   jConnect
Product Component:   JDBC Driver
Status:   Open
OS:   Unknown
Original Version:   5.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
Customer has difficulty with jConnect during HA Failover because the connection state of AutoCommit=true is not set when a connection fails over to the secondary server. If there were a HA only or connection property then the Application Server pooling could handle this failover and not provide transactional boundary issues.
Workaround Description
 Customer testing has not been able to work around the problem reliably by using the connection initialization string.



CR:363778
CR Number:   363778
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#3
Fixed Version Build Resolution Date Closure Code (If Appropriate)
23 Aug 2004 Fixed
Description
ADO.NET: Selecting a smalldatetime column that does not allow null may cause an Internal Error 30016 or 30002.
Target Version
 1.1 ESD#5



CR:363806
CR Number:   363806
Product Name:   Connectivity Utilities
Product Component:   isql
Status:   Closed
OS:   Microsoft Windows
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
19 Oct 2004 Fixed
03 Nov 2004 Fixed
Description
ISQL: When isql is invoked with input redirected from an operating system file and password has not been specified on the command line, then isql should attempt to login using the first line of the redirected input as password. However it prompts for password. This problem occurs only on Windows NT.



CR:363816
CR Number:   363816
Product Name:   Open Client
Product Component:   InstallShield
Status:   Closed
OS:   Microsoft Windows
Original Version:   15.0
Fixed Version Build Resolution Date Closure Code (If Appropriate)
24 May 2010 Bundled Request
Description
InstallShield should allow spaces in directory names on Windows platforms



CR:364174
CR Number:   364174
Product Name:   Open ServerCONNECT for CICS
Product Component:   Open ServerCONNECT for CICS - DOC
Status:   Closed
OS:   MVS
Original Version:   12.5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
15 Apr 2005 Fixed
Description
SYBCLOS needs to be Documeneted in the Installation Guide. SYBCLOS is not documented anywhere. There needs to be documentation on how to use and what it is used for....



CR:364237
CR Number:   364237
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Open
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
ADO.Net: Throws exception "Unsupported parameter type" when parm.DbType is omitted.
Workaround Description
 Set DbType in every case.



CR:364290
CR Number:   364290
Product Name:   ODBC Driver Kit
Product Component:   ODBC Driver Kit
Status:   Closed
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
05 Dec 2004 Fixed
Description
ODBC: With "set arithabort arith_overflow off" in initialization string, or if application set this property on ASE, the execution of a stored procedure was returning SQL_ERROR. Now it returns SQL_SUCCESS_WITH_INFO.



CR:364571
CR Number:   364571
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)
05 Dec 2004 Fixed
Description
OLEDB: After the 2.70.0022 build, default values of ADO CreateParameter method for adChar and adVarChar are no longer NULL, they were empty strings. This was regressing ADO applications. Now the behavior is back to setting the implicit (default) values for adChar/adVarChar parameters to NULL.
Workaround Description
 You can explicitly set Value to Null - however this is not good if customer has 1000s of applications or even 100s since they have to change every CreateParameter line that relates to this procedure.



CR:364623
CR Number:   364623
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)
14 Sep 2004 Fixed
Description
OLEDB: When registering the SYDAASE.DLL, the Registry string for

the name of the driver is invalid as follows:"Sybase Sybase ASE OLE DB

Provider". The string should be: "Sybase ASE OLE DB Provider".



CR:364724
CR Number:   364724
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows XP
Original Version:   1.1 ESD#5
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2004 Fixed
Description
ADO.NET: AseParameter class is not derived from MarshallByRefObject as documented.
Target Version
 1.1 ESD#5



CR:364762
CR Number:   364762
Product Name:   ADO.NET Data Provider
Product Component:   ADO.NET Data Provider
Status:   Closed
OS:   Microsoft Windows 2000
Original Version:   1.1 ESD#4
Fixed Version Build Resolution Date Closure Code (If Appropriate)
01 Sep 2004 Fixed
Description
ADO.NET: AseDataReader.GetBytes() throws null pointer exception if the buffer argument passed is null.
Target Version
 1.1 ESD#5
Workaround Description
 Pass a byte array of 1 in the buffer parameter. The method will return the total number of available bytes. The program can then use the return value to calculate the length of row in bytes.



CR:364821
CR Number:   364821
Product Name:   OLE DB Provider
Product Component:   OLE DB Provider
Status:   Open
OS:   Microsoft Windows NT
Original Version:   12.5.1
Fixed Version Build Resolution Date Closure Code (If Appropriate)
Description
OLEDB: LDAP not working without using Data Source in connection string. Now it will work with this format (example from ADO):

ADO connection string sample: "Provider=Sybase.ASEOLEDBProvider;Use Sybase LDAP=1;Sybase LDAP URL=ldap://aseHost:389/dc=sybase,dc=com;Sybase Server Name=ase1252;Initial Catalog=odbc;"

Properties:

Use Sybase LDAP=1 (this indicates to Provider to use LDAP scheme)

Sybase LDAP URL=ldap://ldapHost:389/dc=sybase,dc=com (Site specific ldap url)

Sybase Server Name=ase1252 (ase server name as defined on LDAP server)





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