Sybase数据库技术,数据库恢复

• 首页
• 关于
• 订阅
• 归档
• 留言
• 标签
• 免费ASE测试环境
• 镜像站
• 恢复工具

CR:551627

CR Number:   551627 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Windows 2000 Original Version:   2.1 ESD1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.1.2 05 Mar 2009 Fixed 2.1.2 19 Apr 2009 Fixed 2.1.2 03 Jun 2009 Fixed 05 Mar 2009 Fixed Description Problem: Debugger shows the wrong current line. Workaround: While loading the source of ASE compiled objects, the content retrieved from 'sp_helptext' should not be trimmed. The trimmed blank line leading to break point toggling error. Fixed to NOT trim the content retrieved from 'sp_helptext' while loading the source of ASE compiled objects.

CR:551942

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

CR:552097

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

CR:552434

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

CR:552582

CR Number:   552582 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   Microsoft Windows XP Original Version:   15.0 ESD#15 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Organic ODBC: Opening a connection to the database using Microsoft DAO DBEngine.OpenConnection and a configurable ODBC datasource DSN: After the connect, the Connect property of the Connection does not contain the Database and Server name copied from the DSN as DataDirect drivers did.

CR:552667

CR Number:   552667 Product Name:   Database Development Product Component:   Creation Wizards Status:   Closed OS:   Windows 2000 Original Version:   2.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 May 2009 Fixed Description Problem: IQ: Need to set a temporary data_order option for event creation. Workaround: This is an I18N issue. When user uses Sybase WorkSpace in some locales, the date_order may not use US format, which is MDY. Consequently, Event-wizard-generated DDL may fail. Scheduled events require that the database option be set correctly according to the specified date. Added fix to set the correct date_order option in Event-wizard-generated DDL. Also when modifying a scheduled event, you can add a set db option SQL when needed.

CR:552796

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

CR:552863

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

CR:552873

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

CR:552905

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

CR:553039

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

CR:553734

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

CR:553773

CR Number:   553773 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#18 14 Apr 2009 Fixed 12.5.1 ESD#27 08 Dec 2013 Fixed Description OLE DB Provider by Sybase: SQL Server Integration Services (SSIS) transfer from integer source column to decimal target ASE column fails with invalid conversion error. Workaround Description  You can perform a workaround - in the connection object add the "readwriteunknown"= 1 property to the Extended Properties field of evloader.sisdnlder.sybase. Next modify the query for the evloader object: SELECT --inst_id, dir_rssd_num inst_id, convert(int, dir_rssd_num) as dir_rssd_num /* read write unknown? */ /*dir_rssd_num*/ FROM dbo.test_tqtrly_inst We're converting the field to integer type since the SSIS calls a SELECT statement on the ASE object with a "where 1=2" clause, so it can collect the metadata. Once it has this information, the SSIS will "think" the field is int. Also we provide an alias of the same name as the column name. This is why we need to use the readwriteunknown=1 property, so we can update this field. This works fine. Unknown if customer will use at this time <12-15-08>.

CR:553886

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

CR:553893

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

CR:554068

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

CR:554280

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

CR:554294

CR Number:   554294 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#16 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#18 14 Apr 2009 Fixed 12.5.1 ESD#27 08 Dec 2013 Fixed Description OLE DB Provider by Sybase: Queries from Microsoft SQL Server to a linked ASE Server always start a Distributed Transaction. Workaround Description  WorkAround: ------------- In order to avoid the problem with sp_who in the distributed transaction I've created a procedure to return similar results as sp_who returns. First try this with SELECT statement: drop table #temp2 create table #temp2 ( spid int, status varchar(128), loginame varchar(128), hostname varchar(128), blk_spid int, dbname varchar(128), cmd varchar(255) ) insert into #temp2 --**/ EXEC ('select spid, status, loginname=suser_name(suid), hostname, blk_spid=blocked, dbname=db_name(dbid), cmd from master..sysprocesses where suid=(select suid from master..syslogins where name="sa")') AT ASE1502 /* Error: Msg 7411, Level 16, State 1, Line 122 Server 'ASE1502' is not configured for DATA ACCESS.*/ /********* select * from OPENQUERY(ASE1502,'select spid, status, loginname=suser_name(suid), hostname, blk_spid=blocked, dbname=db_name(dbid), cmd from master..sysprocesses where suid=(select suid from master..syslogins where name="sa")') *****/ select * from #temp2 The EXEC works okay, but calling the same SQL fails with OPENQUERY and not sure why. You can replace the SELECT with sproc: create proc sp_whotemp (@p1 varchar(128)) as select spid, status, loginname=suser_name(suid), hostname, blk_spid=blocked, dbname=db_name(dbid), cmd from master..sysprocesses where suid=(select suid from master..syslogins where name=@p1) drop table #temp1 create table #temp1 ( spid int, status varchar(128), loginame varchar(128), hostname varchar(128), blk_spid int, dbname varchar(128), cmd varchar(255) ) insert into #temp1 EXEC ('sp_whotemp sa') AT ASE1502 select * from #temp1

CR:554363

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

CR:554366

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

CR:554419

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

CR:554625

CR Number:   554625 Product Name:   Other - Docs: Connectivity Product Component:   Other - Docs: Connectivity Status:   Closed OS:   NA Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed Description Starting from SDK15 ESD13 and SDK12.5.1 ESD23, a new Sybase ODBC property was introduced - "CommandTimeOut". The property was designed to fix the issue on CR488255. It had been verified that the problem was fixed on those ESDs and after. However, there is no official document description for the ODBC "CommandTimeOut"

CR:554887

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

CR:555001

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

CR:555032

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

CR:555231

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

CR:555233

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

CR:555299

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

CR:555399

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

CR:555430

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

CR:555496

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

CR:555546

CR Number:   555546 Product Name:   Other - Docs: Connectivity Product Component:   Other - Docs: Connectivity Status:   Closed OS:   UNIX Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 03 Jun 2009 Fixed Description An ODBC property - "connectiontimeout" has been widely used. However, customer point out that there is not much document on ODBC side and the property is not covered.

CR:555839

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

CR:555993

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

CR:556554

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

CR:556744

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

CR:556808

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

CR:556899

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

CR:557347

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

CR:557463

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

CR:557558

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

CR:557698

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

CR:557805

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

CR:557944

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

CR:557954

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

CR:557956

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

CR:558197

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

CR:558247

CR Number:   558247 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   1.15 ESD#15 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2010 Consult Complete Description Sybase.AdoNet2.AseClient.dll 1.15.325.0 Adaptive Server Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/64-bit/FBO/Fri Mar 24 11:00:22 2006 OS: Windows 2003 Server SP2 Eng Consult: Our customer changed locales.dat at [NT] section - default - from iso_1 to cp850 After that, whenever he inserted data from within SQL Advantage or ISQL, the international characters can only be correctly displayed via SELECT if client session has cp850 set in its options. We could not find how to do the same within ADO.NET Provider sections. Is there a way to change charset in ADO.NET Provider in order to behave just like SQL Advantage? Please refer to repro steps for further details.

CR:558308

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

CR:558309

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

CR:558316

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

CR:558375

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

CR:558543

CR Number:   558543 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   15.0 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Operating System Windows all versions Open Cleint SDK 15.0 ESD#16 and above Microsoft Visual Studio 2005 2008 and above. 32 bit and 64 bit developemnt Visual Basic Dot Net and C# Issue: When creating a vb .net windows application you add a Data Grig to the project. The Microsoft OLEDB driver is selected the Visual studio atomaticly add select insert update delect statment to the data grid propertys. There for the developer does not have to write all the statment out manualy. THe customers complaint is the Sybase OLEDB driver does not do this. We do get a select statment when this is done but nothing else. As I explained to the customer this may be due to the way the Microsoft Wizards works and not all providers would be eaual when creating Data Grids. The customer has requested for Sybase to look in to the issues and provide a seemless way of creating a data base grid in visual studio and when the OLEDB providers is selected the insert,update select and deletes statmens get created automaticly, Target Version  15.5 Review Status  The intergrating will take place in 15.5 Release.

CR:558563

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

CR:558573

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

CR:558727

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

CR:558924

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

CR:558960

CR Number:   558960 Product Name:   Open Client-Doc Product Component:   Client-Library Release Bulletin Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Mar 2012 Added to user documentation Description Environment: ASE 15.0.3 for HP-Itanium and Open Client 15.0 that comes with same ASE bundle Description: We'd like to ask you to document the following change detected in ASE 15.0.3 installation for locales directory: In previous ASE 15.0.2, the following directories are found inside /locales subdirectory: /remote/releases2/hpit/rel1502_ebfs/ebf15657/locales > >> sunspot% ls > >> chinese japanese message spanish us_english > >> french korean polish thai > >> german locales.dat portuguese unicode > >> sunspot% > >> In 15.0.3 GA directory structure, under /remote/releases2/hpit/rel1503/locales, we have the following structure: > >> --> checking the directory tree of ASE v 15.03 ga, in special for > >> $sybase/locales we have : > >> > >> > >> sunspot% pwd > >> /remote/releases2/hpit/rel1503/locales > >> sunspot% ls > >> locales.dat message unicode > >> sunspot% > >> > >> So, all language directories (e.g: us_english) are missing. This is not documented anywhere, neither in ASE nor OCS manuals. We'd like to request this change to be properly documented, because customers call CS&S with such doubt and no official documentation is found. Workaround Description  Customer needs to copy all language directories under 15.0.2/locales into 15.0.3/locales in order to continue having applications working on same box.

CR:558978

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

CR:559066

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

CR:559470

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

CR:559651

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

CR:559688

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

CR:559817

CR Number:   559817 Product Name:   OpenSwitch Product Component:   OpenSwitch Status:   Closed OS:   Linux Original Version:   15.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Oct 2009 Diagnostic Provided Description During failback to primary ASE, new client connections get connected to the standby ASE while it's status is LOCKED. Workaround Description  Change NOWAIT_ON_LOCKED=1 in the configuration files, than OpenSwitch will reject client applications attempting to connect to a server that is LOCKED: http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc20191.1510/html/oswadmin/BABCDGBE.htm Customers will see this message in the log file: OSW2: ERROR: spid 29: thrd_connect: Login attempt failed because the target pool or server is locked. The client application will see this message: % isql -Usa -P -S OSW2 Msg 20103, Level 14, State 0: Server 'OSW2': The pool or server which your application is trying to connect to is currently locked. Please try again at a later time. CT-LIBRARY error: ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

CR:559883

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

CR:560039

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

CR:560066

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

CR:560161

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

CR:560299

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

CR:560533

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

CR:560765

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

CR:560858

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

CR:561070

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

CR:561149

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

CR:561299

CR Number:   561299 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   Microsoft Win32s Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Jan 2013 EOL'd version. Not to be Fixed. Description The script %SYBASE%\%SYBASE_OCS%\scripts\copylibs.bat does not support long filenames which contain white-space. The script can be edited to 'cd %DLLDIR%' and perform the copy without using the pathname. Workaround Description  Alternative script: @ECHO OFF REM As of SDK 15.0 and Open Server 15.0, Sybase library names have REM changed from lib<name> to libsyb<name> to avoid name clashes REM with other libraries. REM REM To allow pre-15.0 applications to continue to work with the REM renamed shared libraries, this script is provided to copy the REM new library names to the old ones in %SYBASE%\%SYBASE_OCS%\dll. REM Usage of the script: REM REM copylibs.bat { create / remove } REM REM where 'create' copies the old-named files in $SYBASE/$SYBASE_OCS/dll REM and 'remove' can be used to delete these files again. SET DLLDIR=%SYBASE%\%SYBASE_OCS%\dll IF "%SYBASE%"=="" ( ECHO %%SYBASE%% is not set. GOTO end ) IF "%SYBASE_OCS%"=="" ( ECHO %%SYBASE_OCS%% is not set. GOTO end ) IF "%1"=="create" GOTO create IF "%1"=="remove" GOTO remove GOTO usage :create cd %DLLDIR% copy libsybblk.dll libblk.dll copy libsybcobct.dll libcobct.dll copy libsybcs.dll libcs.dll copy libsybct.dll libct.dll copy libsybdb.dll libdb.dll copy libsybsrv.dll libsrv.dll copy libsybxadtm.dll libxadtm.dll GOTO end :remove cd %DLLDIR% del libblk.dll del libcobct.dll del libcs.dll del libct.dll del libdb.dll del libsrv.dll del libxadtm.dll GOTO end :usage ECHO Usage: %0 { create / remove } :end

CR:561317

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

CR:561339

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

CR:561547

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

CR:561549

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

CR:561632

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

CR:561654

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

CR:561702

CR Number:   561702 Product Name:   Database Development Product Component:   SQL Editor Status:   Closed OS:   Windows XP Original Version:   2.1.2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2009 Fixed Description Problem: PERF: It's very slow when typing where clause in SQL Scrapbook. Workaround: Batchload all tables/procedural objects before listing in content assist. Since the default schema may not match the table's owner, need to widely search all schemas of this database. Side effect is that a table with the same name would be loaded. The best way is input table is using owner name.

CR:561826

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

CR:561908

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

CR:562199

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

CR:562476

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

CR:562615

CR Number:   562615 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   AIX Original Version:   12.5.1 ESD#24 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Sep 2012 Not a Bug Description PROBLEM: all 12.5 15.0.x and 15.5 are affected by this The problem is customer installes EBF16012 64 bit. It does over lay the original isql 64 bit and that is fine the isql is now 32 bit and that is fine we understand the 64 bit isql for this O/S is not availablem. The issue here is the version out put does not match the EBF numbers installed.There for the customer think the isql was not only bit version down graded but EBF down graded even thou the 32 bit isql is from ESD # 24 EBF EBF16010 Target Version  15.5 Review Status  Issue would be address in 15.5

CR:562664

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

CR:562771

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

CR:562960

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

CR:562963

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

CR:563010

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

CR:563052

CR Number:   563052 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Windows 2000 Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Mar 2009 Fixed Description Problem: Temp table cannot be shown during SP debugging. Workaround: Fixed. When a temp table is created in default schema of TempDB. It cannot be found with default user name. Now find the table in all schemas of TempDB.

CR:563487

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

CR:563747

CR Number:   563747 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   Microsoft Windows 2003 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Customer using Crystal Reports 8.5 - when retrieving table list it's empty. ODBC 15.0 affected. Description: Crystal Reports 8.X displays empty table list Detail: Problem derives from the following: - Crystal Reports 8.X issues SQLSetConnectAttr(SQL_ATTR_TXN_ISOLATION, SQL_TXN_READ_UNCOMMITTED) - This causes an optimizer scan failure on ASE with the 2 static tables used to contain ASE datatype information Observations: -------------- We resolved the error by creating unique index for: create unique index spt_dt_idx on spt_datatype_info(ss_dtype,type_name) create unique index spt_dt_ext_idx on spt_datatype_info_ext(user_type, create_params) Target Version  aries Review Status  Observations: -------------- We resolved the error by creating unique index for: create unique index spt_dt_idx on spt_datatype_info(ss_dtype,type_name) create unique index spt_dt_ext_idx on spt_datatype_info_ext(user_type, create_params)

CR:564282

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

CR:564378

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

CR:564728

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

CR:564847

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

CR:564875

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