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

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

CR:461446

CR Number:   461446 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   Windows Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2007 Fixed 27 Mar 2007 Fixed 27 Mar 2007 Fixed Description BCP: bcp'ing to an SSL connection on winx64 and ibmplinux with text columns may fail.

CR:461544

CR Number:   461544 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 02 12 Sep 2007 Fixed Description Need to read the MFCLIC file only once, not for ever request

CR:461606

CR Number:   461606 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Using the "exec" command to dynamically call SQL Statements is failing.

CR:462113

CR Number:   462113 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 31 Oct 2007 Fixed 14 Dec 2007 Fixed 14 Dec 2007 Fixed Description OLE DB Provider by Sybase: Cannot obtain Database Schema information for queries that reference tables from a database other than the one defined in the Datasource definition.

CR:462304

CR Number:   462304 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#4 07 23 Apr 2007 Fixed Description Sample VSAM defines missing for SYGWLSA1 and SYTACCT1.

CR:462809

CR Number:   462809 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Generic Original Version:   1.6 Fixed Version Build Resolution Date Closure Code (If Appropriate) Tonga 10 Aug 2007 Fixed Description REPRODUCTION: In an ASE 15 database, create a new user. Do not have this user as the DBO. Create a new stored procedure, and give ownership to the new user. In the Enterprise Explorer, create a connection to that database using the sa or DBO information Browse to the database --> new user schema --> expand the Procedures You should now see the error Disconnect the DB session, and modify the properties such that you are logging in as the new user In the Enterprise Explorer, log in to the database again (as the new user) Browse to the database --> new user schema --> expand the Procedures You are now able to see the stored procedure. You may also now expand the DBO procudures, and see the list available there as well.

CR:462831

CR Number:   462831 Product Name:   Connectivity Utilities Product Component:   bcp Status:   Closed OS:   Solaris Original Version:   15.0 ESD#2 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jun 2007 Fixed 26 Jun 2007 Fixed Description SRVLIB: Bulk copy of text/image column that has a default value through gateway server results in server error "16067/10/0: Illegal length (0) for datatype 'CS_IMAGE_TYPE'"

CR:462904

CR Number:   462904 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   1.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.1 ESD#24 03 Feb 2011 Not reproducible with latest version of the product available as of Resolution Date 1.15 ESD#14 08 Dec 2013 Fixed Description ADO.NET: Executing a stored procedure that returns numerous DONEINPROC tokens results in excessive memory usage on the client proportional to the number of tokens in the result.

CR:463480

CR Number:   463480 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows 2000 Original Version:   15.0 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#12 08 Dec 2013 Fixed 12.5.1 ESD#22 08 Dec 2013 Fixed Description OLE DB Provider by Sybase: Getting "Access Violation" when loading OLAP database from ASE using OLEDB

CR:463595

CR Number:   463595 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   all Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 Apr 2007 Fixed 24 Sep 2007 Fixed Description ODBC Driver by Sybase: The SQL used in "sp_odbc_datatype_info" stored procedure that is used by ODBC functions like SQLGetTypeInfo, does not produce an optimal query plan. This is increasing the time taken to make an ODBC connection to ASE. Workaround Description  *** Monday, April 23, 2007 16:37:31 *** pvero *** This was discovered by Customer and Alliance Engineer in case 11340629 Significant increase in performance when adding this line: and c.type =* d.ss_dtype to the WHERE clause: from sybsystemprocs.dbo.spt_datatype_info d, syscolumns c, sybsystemprocs.dbo.spt_datatype_info_ext e, systypes t where d.ss_dtype = t.type and t.usertype *= e.user_type and c.type =* d.ss_dtype In simple ISQL testing the time diff was: 610 millisec for sp_odbc_datatype_info (sdk15 esd07) 240 millisec for change to sp_new_odbc_datatype_info (look in dt_new.sql)

CR:463872

CR Number:   463872 Product Name:   Database Development Product Component:   Online Help Status:   Closed OS:   Windows 2000 Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 23 Oct 2007 Added to user documentation Description *** Monday, October 08, 2007 3:15:30 PM *** kliu *** Problem Description: Some users have experienced that for some ASE procedural objects-- stored procedures and triggers in database other than 'master', the debugger breakpoint cannot be set at the correct location. Problem Resolution: The workaround is to restart ASE database server For some ASE procedural objects-- stored procedures and triggers in database other than 'master', the debugger breakpoint cannot be set at the correct location. Usually, those procedural objects contain SQL statements eRxpanded by the ASE server after the definition is modifed and saved. For example, after the following statement in a stored procedrue got saved and expanded by the server, the user will not be able to set the breakpoint on that statement: "select * from authors", will be expanded to "--Adaptive Server has expanded all '*' elements in the following statement select authors.au_id, authors.au_lname, authors.au_fname, authors.phone, authors.address, authors.city, authors.state, authors.country, authors.postalcode from authors", and when the user tries to set breakpoint at the 'select authors...' statement, the breakpoint will be off. This problem is caused by an ASE bug, CR463870. Target Version  Tonga

CR:463944

CR Number:   463944 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 19 Apr 2007 Fixed 11 May 2007 Fixed Description DBLIB: dbsetinterrupt() fails to handle interrupt until after read from server completes.

CR:464319

CR Number:   464319 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   Solaris Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 May 2007 Fixed 03 Jun 2007 Fixed Description SRVLIB: ODBC client executing a language command against Open Server application may result in server error message "16227/15/0: Unknown token TDS stream received by spid".

CR:464325

CR Number:   464325 Product Name:   Open Client Product Component:   cslib Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Aug 2007 Fixed 22 Feb 2008 Fixed 06 Dec 2007 Fixed 28 May 2008 Fixed 06 Mar 2008 Fixed 03 Mar 2008 Fixed 04 Mar 2008 Fixed 24 Apr 2008 Fixed 30 May 2008 Fixed 14 Jul 2008 Fixed Description CTLIB, SRVLIB: Allow partial text/image updates to open server.

CR:464833

CR Number:   464833 Product Name:   Connectivity Utilities Product Component:   bcp Status:   Closed OS:   Microsoft Win32s Original Version:   12.5.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Apr 2007 Fixed 03 May 2007 Fixed Description BCP: BCP fails to truncate trailing space due to wrong interpretation of univarchar space. Workaround Description  Various awkward work-arounds: 1. BCP into varchar() and then select into target column. 2. Use UNIX BCP application. 3. Use CIS external file system (XFS) option.

CR:464864

CR Number:   464864 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.6 ESD#4 19 Apr 2007 Not a Bug Description TDSETPRM is adding an a binary Zero in front of the Data area of a TDSCHAR parm Workaround Description  None

CR:464989

CR Number:   464989 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) 12.5.1 ESD#19 08 Dec 2013 Fixed 15.0 ESD#9 08 Dec 2013 Fixed Description ODBC Driver by Sybase: Visual Basic applications using rdoResultset that's opened with rdOpenDynamic and rdConcurReadOnly attributes receive runtime error. Workaround Description  Use DataDirect driver, or use ADO technology, instead of rdo.

CR:465281

CR Number:   465281 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   all Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) aries 29 May 2009 Fixed Description Documentation not clear on PATH where install_odbc_sprocs.bat is located.

CR:465337

CR Number:   465337 Product Name:   ESQL Product Component:   C Status:   Closed OS:   NA Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 17 Apr 2007 Fixed 24 Apr 2007 Fixed Description CPRE: When parsing recursive structures or unions, cpre incorrectly reports a syntax error "M_SYNTAX_PARSE".

CR:465402

CR Number:   465402 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#8 27 Jul 2007 Fixed Description jConnect: Calling DatabaseMetaData.getDatabaseMajorVersion() method fails when connected to a Data Federation (Avaki) backend.

CR:465646

CR Number:   465646 Product Name:   Database Development Product Component:   Database Explorer Status:   Closed OS:   Windows 2000 Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Dec 2011 Presently Not Targeted For Any Future Release Of This Product 23 Oct 2007 Added to user documentation Description *** Monday, October 08, 2007 2:55:53 PM *** kliu *** Problem Description: In WorkSpace2.0, if you use Visual SQL, the Query editor, or the DataWindow editor with a particular connection profile and database, then make a change to the tables/columns of that database (eg, add/delete a table or column), you will not see those changes the next time you use Visual SQL, the Query editor, or the DataWindow editor; Problem Resolution: Disconnect and connect to the database server again.

CR:465836

CR Number:   465836 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   all Original Version:   15.0 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Apr 2007 Fixed 23 Apr 2007 Fixed Description CTLIB: When CS_ASYNC_NOTIFS is enabled and ct_recvpassthru is called with CS_EOM set, message 0x0502070a (A read was attempted on a connection already executing a read.) is raised.

CR:465955

CR Number:   465955 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   all Original Version:   15.0 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 18 May 2007 Fixed 18 May 2007 Fixed 10 Jan 2008 Fixed 11 Jan 2008 Fixed Description CTLIB: Race condition exists in non-reentrant libraries when CS_ASYNC_NOTIFS is set to CS_TRUE.

CR:466137

CR Number:   466137 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#9 08 Dec 2013 Fixed 12.5.1 ESD#19 08 Dec 2013 Fixed Description OLE DB Provider by Sybase: Applications using Microsoft ADO or ADO.NET OleDb Client cannot correctly read Unicode data stored in char/varchar/nchar/nvarchar columns.

CR:466158

CR Number:   466158 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Open OS:   Microsoft Windows XP Original Version:   1.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description ADO.NET provider >System.NullReferenceException on AseDataReader.close() when using the "Using" statment in c#. Workaround Description  finally { if(reader != null && !reader.IsClosed) reader.Close();

CR:466533

CR Number:   466533 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   HP-UNIX Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jun 2007 Fixed Description SRVLIB: Open Server may core dump at srvr__xi4Swap while reading cursor command sent by the client.

CR:466666

CR Number:   466666 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   1.15 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) aries 18 Jun 2009 Fixed Description 'Connection Lifetime' and 'Idle Connection Timeout properties should be detailed in ASE ADO.NET Data Provider API Reference.

CR:467003

CR Number:   467003 Product Name:   Open ClientCONNECT for CICS Product Component:   Open ClientCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 10 May 2007 Fixed Description OCC is overlaying the hostvar in a PLI RPC with the length field of the next varaible.

CR:467090

CR Number:   467090 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   12.5.1 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Replication MS SQLServer 2005 to Sybase ASE via 'linked server' and Sybase Organic ASE OLE DB provider fails to connect to subscriber.

CR:467092

CR Number:   467092 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   Microsoft Windows Original Version:   12.5.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 25 May 2007 Not a Bug Description Tested and reproduced with: Version: Sybase DB-Library/12.5.1/P-EBF14280 ESD #17/PCIntel/BUILD1251-048/OPT/Tue Jan 23 01:47:19 2007 (we kept this same version in client side when testing all servers below) When running C application that calls xp_server, the following error message appears: Returns error: Msg 8015, Level 0, State 1 Server 'ase1254', Procedure 'xp_cmdshell', Line 2 Adaptive Server has truncated parameter number 1 passed to rpc '08sybsyespxp_cmdshell' on server 'ASE1254_XP'. The remote server does not support character or binary data wider than 255 bytes. Issue happens with dblib applications only. Ctlib applications work fine.

CR:467483

CR Number:   467483 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   Unknown Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description If using dynamic_prepare=true and executeBatch() support, very large numbers of inserts can cause hangs between the client and the server. jConnect should batch up the inserts to eliminate hangs. Workaround Description  make your own small batches, or set "dynamic_prepare = false" on the connection properties. New bulk insert support should help here also.

CR:467510

CR Number:   467510 Product Name:   OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows NT Original Version:   15.0 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Nov 2007 Fixed Description OLE DB Provider by Sybase: The OLE DB Provider exhibits excessive memory accumulation and some leaks executing queries.

CR:467639

CR Number:   467639 Product Name:   Connectivity Utilities Product Component:   dscp Status:   Closed OS:   Linux Original Version:   15.0 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 16 May 2007 Fixed Description DSCP: Dscp deletion corrupts the data of an interfaces file when the first line of the interfaces file is a blank or comment line.

CR:467846

CR Number:   467846 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows 2003 Original Version:   15.0 ESD#1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description OLE DB Provider by Sybase: Microsoft Data Link utility fails with "Catastrophic failure" when creating MS Data Link 64bit entry with OLEDB provider. Works fine in 32-bit environment only.

CR:468655

CR Number:   468655 Product Name:   jConnect Product Component:   JDBC Gateway Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 30 Jul 2007 Fixed Description jConnect: Feature request to support passing connection property values as part of directory services URL (dsurl).

CR:468750

CR Number:   468750 Product Name:   Organic OLE DB Provider Product Component:   Configuration UI Status:   Closed OS:   Microsoft Windows 2003 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 06 Nov 2007 Fixed 12.5.1 ESD#21 12 Dec 2007 Fixed Description OLE DB Provider by Sybase: DSNs created through Sybase Data Source Administrator cannot be created as system DSNs such that they can be used by any user on the system.

CR:468860

CR Number:   468860 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   all Original Version:   12.5.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 27 Mar 2009 Fixed 12.5.1 ESD#19 05 Sep 2007 Fixed Description ODBC Driver by Sybase: Executing a query that includes a COMPUTE clause results in an Internal Error. Workaround Description  None apart from avoiding using COMPUTE clause

CR:469317

CR Number:   469317 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#9 06 May 2013 Fixed 12.5.1 ESD#18 06 May 2013 Fixed Description ODBC Driver by Sybase: Some Microsoft ADO/Access/Excel applications make repeated calls to SQLGetConnectAttr(SQL_ATTR_TXN_ISOLATION) to obtain current transaction isolation level. Request to cache this value rather than get it each time from ASE to improve performance.

CR:469452

CR Number:   469452 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 May 2009 Presently Not Targeted For Any Future Release Of This Product Description Clarify documentation about the executeBatch and Dynamic prepare.

CR:469693

CR Number:   469693 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   1.15 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2007 Fixed Description ADO.NET: Adding a row to DataTable derived from DataReader with multiple result sets fails. Workaround Description  *** Thursday, May 24, 2007 09:50:49 *** pvero *** Possible to use ODBC driver (didn't test OLEDB) but haven't approached customer on this yet. Probably not a practical approach since this is ADO.NET 1.1 code. Also fails with ADO.NET 2.0 Beta Provider.

CR:469739

CR Number:   469739 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Closed OS:   Microsoft Windows 2003 Original Version:   1.15 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) 1.15 ESD#11 21 Jan 2008 Fixed 1.1 ESD#22 08 Dec 2013 Fixed Description ADO.NET: NullReferenceException thrown when disposing AseDataReader outside the scope of the using block that created the AseCommand object. Workaround Description  *** Thursday, May 24, 2007 17:09:37 *** pvero *** Finding out if customer can use AseDataReader.Dispose() within the using block.

CR:469800

CR Number:   469800 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) 08 Apr 2009 Fixed Description Massive difference in performance with 12.5 driver taking 20 minutes and the Sybase 11 ODBC takes seconds to retrive rows from a query via a linked table in MS Access.

CR:470206

CR Number:   470206 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Arithmetic overflow occurs when using NUMERIC OUTPUT parameter

CR:470275

CR Number:   470275 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Open OS:   Microsoft Windows XP Original Version:   1.1 ESD#8 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The method AseDataReader.GetGuid() throws an NotSupportedException and it seems that the Method is there but not fully implemented. Sideinfo: When using AsaDataReader from IAnywhere Ado.Net driver it works fine.

CR:470377

CR Number:   470377 Product Name:   ODBC Driver Kit Product Component:   ODBC Driver Kit Status:   Open OS:   Microsoft Windows Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Massive difference in performance with 12.5 driver taking 20 minutes and the Sybase 11 ODBC takes seconds to retrive rows from a query via linked table in MS Access.

CR:470457

CR Number:   470457 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#11 06 Nov 2007 Fixed 14 Dec 2007 Fixed Description ODBC Driver by Sybase: SQLCancel is not working in VB/ADO applications.

CR:470558

CR Number:   470558 Product Name:   ESQL Product Component:   C Status:   Closed OS:   NA Original Version:   12.5.1 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) 28 Jun 2007 Fixed 08 Jul 2007 Fixed Description CPRE: When using the -G option cpre generates incorrect T-SQL stored procedures when the host variable is a char type with length given as a numeric expression eg: char myVar[4+1]; Workaround Description  Avoid numeric expressions - use macros instead.

CR:470568

CR Number:   470568 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#11 06 Nov 2007 Fixed 18 Dec 2007 Fixed Description ODBC Driver by Sybase: Calling SQLSetConnectAttr(SQL_ATTR_QUERY_TIMEOUT) returns error.

CR:471060

CR Number:   471060 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   SunOS Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Jul 2007 Fixed 30 Jul 2007 Fixed Description SRVLIB: Open Server crashes at comn__oidtoname() when client attempts to connect using network security service and charset conversion is not requested.

CR:471451

CR Number:   471451 Product Name:   Database Development Product Component:   SQL Debugger Status:   Closed OS:   Generic Original Version:   1.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Jan 2008 Fixed 06 Jan 2008 Fixed Description It would be useful to have the ability to save the contents of variables and dump the first x number of rows in the referenced tables at each breakpoint. Resolution: Added a context menu to allow the user to invoke the Dump Variable & Table Data wizard during a SQL debug session to save the variable values and selected table rows to a log file specified by the user.

CR:471471

CR Number:   471471 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) 06 Mar 2008 Bundled Request Description ODBC Driver by Sybase: Error in MS Query: Column 'col_name' can't be used in criteria

CR:471786

CR Number:   471786 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   Red Hat Linux Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2007 Fixed 11 Mar 2008 Fixed Description OpenServer hits assertion error with invalid TDS length.

CR:471938

CR Number:   471938 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Access ASE via Visual Studio Designer 2005 fails with error msg "The given type name was unrecognized"

CR:471996

CR Number:   471996 Product Name:   Open Client Product Component:   cslib Status:   Closed OS:   all Original Version:   To Be Determined Fixed Version Build Resolution Date Closure Code (If Appropriate) 29 Oct 2007 Fixed 04 Oct 2007 Fixed 07 Dec 2007 Fixed 23 May 2008 Added to user documentation 09 Oct 2007 Fixed 22 Nov 2007 Fixed 12 Oct 2007 Fixed 10 Oct 2007 Fixed 23 Nov 2007 Fixed 07 Dec 2007 Fixed 17 Dec 2007 Fixed 20 Dec 2007 Fixed 02 Jan 2008 Fixed 03 Jan 2008 Fixed Description CSLIB: Add cs_config() properties to specify alternative Sybase home directory, libtcl.cfg configuration file and interfaces file location.

CR:472155

CR Number:   472155 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#8 02 Aug 2007 Fixed Description jConnect: BatchUpdateException is thrown by executeBatch, if one of the statements in the batch throws an error.

CR:472296

CR Number:   472296 Product Name:   jConnect Product Component:   JDBC Driver Status:   Open OS:   NA Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Feature request so cancel isn't blocked when two statements are not pending

CR:472309

CR Number:   472309 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   Microsoft Windows 2000 Original Version:   12.5.1 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) 06 Nov 2007 Fixed 14 Dec 2007 Fixed Description ODBC Driver by Sybase: SQLExecute() raises error #30128 when binding fixed length parameters as SQL_C_DEFAULT and not explicitly setting the bufferlength or columnsize. Workaround Description  If you use MS Access, there is no workaround.

CR:472565

CR Number:   472565 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 10 Dec 2007 Fixed Description ISQL: ISQL fails to load locales when $SYBASE environment variable is set to a relative path.

CR:472612

CR Number:   472612 Product Name:   Organic ODBC Driver Product Component:   Install Status:   Open OS:   Microsoft Windows XP Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Request for adding infos in the following sections in documentation/installer a.) ITransactionJoin Interface as being implemented in http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.dc00075_1500/html/oledb/Supported_interfaces_oledb.htm b.) The MS DTC registry entries for the OLEDB and ODBC dlls had to be entered manually. (http://support.microsoft.com/kb/817066/en-us) amd tp configure the MS DTC (http://support.microsoft.com/?scid=kb%3Ben-us%3B839279&x=14&y=9).

CR:472651

CR Number:   472651 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows 2003 Original Version:   12.5.1 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) 12.5.1 ESD#21 08 Dec 2013 Fixed Description OLE DB Provider by Sybase: OLEDB Provider returns "-2147467259/Unspecified error" in a COM+ component.

CR:472683

CR Number:   472683 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Documented connection parameters that contain a space do not work with OLEDB Provider with VC++. Workaround Description  Do not use the connection parameters that contain a space (ie User ID or Initial Catalog)

CR:472694

CR Number:   472694 Product Name:   OpenSwitch Product Component:   RCM Status:   Closed OS:   Windows 2000 Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Nov 2009 Presently Not Targeted For Any Future Release Of This Product 18 Dec 2007 Fixed 09 Aug 2007 Fixed Description Intermittent failure of RCM to set the ASE status and switch connections

CR:472710

CR Number:   472710 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   15.0 ESD#7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Jan 2008 Fixed Description OLE DB Provider by Sybase: Microsoft UDL raises a runtime error when configuring for ASE OLEDB Provider.

CR:472980

CR Number:   472980 Product Name:   Organic ODBC Driver Product Component:   TDS Library Status:   Closed OS:   all Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 06 Nov 2007 Fixed 12.5.1 ESD#21 18 Dec 2007 Fixed Description ODBC Driver by Sybase: Request to support iso15 charset.

CR:473031

CR Number:   473031 Product Name:   Open Server Product Component:   srvlib Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 04 Jul 2007 Fixed Description SRVLIB: Open Server crashes at srv__putchar() when returning row data containing unitext

CR:474154

CR Number:   474154 Product Name:   Open ClientCONNECT for CICS Product Component:   Open ClientCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 03 12 Sep 2007 Fixed Description API call returns an actual length of 2 when a numeric is null.

CR:474307

CR Number:   474307 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#2 01 30 Apr 2008 Fixed Description The TRS CSP program AMDCCPGM will ASRA, if unicode pages missing

CR:474493

CR Number:   474493 Product Name:   Open Client Product Component:   dblib Status:   Open OS:   Solaris Original Version:   12.5.1 ESD#18 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description The customer would like for DBLIB that is staticly linked to return an error when the Sybase Environment Variables are incorrectly set.

CR:474626

CR Number:   474626 Product Name:   ADO.NET Data Provider Product Component:   ADO.NET Data Provider Status:   Open OS:   Microsoft Windows XP Original Version:   2.0 Beta1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2007 Fixed Description ADO.NET: AseCommandBuilder.DeriveParameters describes parameters of nchar type as char.

CR:474759

CR Number:   474759 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 07 Nov 2007 Fixed 12.5.1 ESD#21 18 Dec 2007 Fixed Description ODBC Driver by Sybase: In VB/ADO application, get MoveNext error when fetching from a LONGCHAR column. Workaround Description  Works if we set CursorLocation to adUseClient

CR:474828

CR Number:   474828 Product Name:   Database Development Product Component:   Online Help Status:   Closed OS:   Windows XP Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) Tonga 23 Oct 2007 Added to user documentation Description Problem 1 Decription: In ASE 15, proxy table mapped to external directory/file sometimes can't be opened. Problem 1 Resolution: Restart ASE 15 server. Problem 2 Decription: Proxy table can't be updated/inserted/deleted when proxy table have datetime datatype column,and the proxy table mapped to the remoted table in Chinese language ASE server. Problem 2 Resolution: This is ASE server issue, it will be fixed in the later version.

CR:474846

CR Number:   474846 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Windows XP Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 2.0 ESD1 03 Jan 2008 Fixed 03 Jan 2008 Fixed Description IQ index has placements tabs and Fragmentation tabs in Sybase Central, so we should add them. Resolution: Added Placements and Fragmentation read-only pages in the IQ Index Editor.

CR:475273

CR Number:   475273 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 01 04 Jan 2008 Fixed Description Iso_1 definition always used for code page translation when IBMUNICODE=N.

CR:475275

CR Number:   475275 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   Solaris Original Version:   12.5.1 ESD#17 Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Jul 2009 Fixed 28 Jul 2009 Fixed 25 Aug 2009 Fixed 24 Sep 2009 Fixed Description DBLIB: dbexit() unpaired with dbinit() causes a core dump after upgrading to 12.5.1 ESD#12. Workaround Description  Remove the DBEXIT () or comment it out there is no need to have DBEXIT () in the source code if you not using any dblib functions.

CR:475457

CR Number:   475457 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 01 04 Jan 2008 Fixed Description ASRA in new context handller when IBMUNICODE=Y and a charset override.

CR:475482

CR Number:   475482 Product Name:   Connectivity Utilities Product Component:   dscp Status:   Closed OS:   NA Original Version:   15.0 ESD#10 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Feb 2008 Fixed Description NETLIB: Dscp fails to add entry if the interfaces file does not exist.

CR:475640

CR Number:   475640 Product Name:   OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows NT Original Version:   15.0 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 31 Oct 2007 Consult Complete Description OLE DB Provider by Sybase: opening multiple connections causings issues with temp tables Workaround Description  None at this time

CR:475704

CR Number:   475704 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   all Original Version:   Galaxy Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Jul 2007 Fixed 26 Jul 2007 Presently Not Targeted For Any Future Release Of This Product Description LANGUAGE MODULES: "locale = en_GB.UTF-8, us_english, utf8" is now available in the [linux] section of locales.dat.

CR:475806

CR Number:   475806 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 ODBC Driver by Sybase: Attempting to insert data that includes 0x84 character using iso_1 character set for the connection results in syntax errors returned from ASE.

CR:475963

CR Number:   475963 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS - DOC Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 11 Sep 2007 Not a Bug Description Cust. would like a List of that Describes all the MF Transactions added to Doc

CR:476196

CR Number:   476196 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   NA Original Version:   6.5 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2007 Fixed Description jConnect: NoClassDefFoundError error raised when connecting to a server that supports extended password encryption.

CR:476201

CR Number:   476201 Product Name:   jConnect Product Component:   JDBC Driver Status:   Closed OS:   Microsoft Windows NT Original Version:   6.05 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Oct 2007 Fixed Description jConnect: JDBC meta data function calls may return partial results if user has set rowcount to limit results on this database connection.

CR:476239

CR Number:   476239 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Open OS:   Microsoft Windows XP Original Version:   15.0 Fixed Version Build Resolution Date Closure Code (If Appropriate) 05 Sep 2007 Fixed Description OLE DB Provider by Sybase: Unable to access multiple resultsets after executing a stored procedure call using TDS_DBRPC.

CR:476250

CR Number:   476250 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Windows 2000 Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2007 Fixed Description ASE CIS proxy table DDL is "create existing". Per an ASE customer, it would be better if we used sp_addobjectdef for DDL.

CR:476487

CR Number:   476487 Product Name:   Connectivity Utilities Product Component:   isql Status:   Closed OS:   Solaris Original Version:   12.5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 01 Jul 2008 Duplicate Description ability to customise the isql prompt so that it shows the servername: isql -Uusername -Sservername -P SERVERNAME:(1)> SERVERNAME:(2)>

CR:476497

CR Number:   476497 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   Solaris Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 22 Aug 2007 Fixed 19 Aug 2007 Fixed 30 Aug 2007 Fixed Description CTLIB: Open Client does not failover when ASE is configured with HA Active-Passive.

CR:476512

CR Number:   476512 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Open OS:   all Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Reproduced with: - Organic ODBC Driver 15.0.0.162 (03.51) 64-bit - SQL Server 2005 64 bit - Windows 2003 Server 64-bit - Adaptive Server Enterprise/12.5.1/EBF 11662 ESD#2 on HP-UX 64-bit box - Visual Studio 2005 When running an SQL Server Integration Services (SSIS) package from within SQL Server 2005 64 bit by using Organic ODBC Driver 15.0 64-bits, the following conversion errors occur when international characters are present in rows data (, , etc.): For string values: Data conversion failed while converting column "di_descripcion" (1817) to column "di_descripcion" (239). The conversion returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page." For integer values: 4495 OnError carga CC_CTACTE 2007-07-23 14:48:03.000 SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "component "DataReader Source" (1)" failed because error code 0x80004002 occurred, and the error row disposition on "output column "cc_protestos" (145)" specifies failure on error. An error occurre When there are no international characters involved in rows data, the SSIS package works fine. In 32-bit environment Windows 2003 (using SQL Server 2005 32-bits, Organic ODBC Driver 15.0 32-bit), the same SSIS package always runs fine, including when there are international characters involved in rows data.

CR:476623

CR Number:   476623 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Windows 2000 Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2007 Fixed 03 Jan 2008 Fixed Description Problem Description: For IQ and ASA, the SQL source displayed in the Stored Procedure Editor is sometimes different from the source entered by the user. Resolution: For ASA and IQ, there are two ways to retrieve the definition of procedural objects, one is via the debug API, the other is using system tables, but the source retrieved are different. Originally, the procedural object editor was using the ASA/IQ debug API to retrieve the source. Now it is fixed by adding a read-only Debug page in the ASA/IQ procedural object editor which still uses the debug API, but the original Source page is now using the system tables to retrieve the correct definition.

CR:476626

CR Number:   476626 Product Name:   Organic ODBC Driver Product Component:   ODBC Driver Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 09 Nov 2007 Fixed 12.5.1 ESD#21 18 Dec 2007 Fixed Description ODBC Driver by Sybase: Unhandled exception error when you execute a stored procedure with 28 or more parameters.

CR:476843

CR Number:   476843 Product Name:   Connectivity Utilities Product Component:   isql Status:   Open OS:   Linux Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) Description Tested and reproduced with: - SDK 15.0 ESD#9 for Linux - ASE 15.0.2 EBF 14328 for Sun Solaris When selecting data via Linux SDK 15.0 isql, the columns display with double of the original size defined in datatype.

CR:476970

CR Number:   476970 Product Name:   Open ServerCONNECT for CICS Product Component:   Open ServerCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 01 10 Dec 2007 Fixed Description Terminal security is not working from Direct Connect.

CR:477078

CR Number:   477078 Product Name:   Open Client Product Component:   blklib Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 21 Aug 2007 Fixed 29 Aug 2007 Fixed Description BLKLIB: blk_init() leaks memory when error occurs during the blklib initialization.

CR:477349

CR Number:   477349 Product Name:   Connectivity Utilities Product Component:   isql Status:   Closed OS:   Solaris Original Version:   15.0 ESD#9 Fixed Version Build Resolution Date Closure Code (If Appropriate) 09 Sep 2010 Not a Bug Description The EBF number of isql or bcp shows the 32-bit edition after installing SDK15.0 ESD#9.

CR:477638

CR Number:   477638 Product Name:   Open Client Product Component:   ctlib Status:   Closed OS:   Solaris Original Version:   15.0 ESD#5 Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Sep 2007 Fixed 19 Oct 2007 Fixed Description NETLIB: For the non-threaded libraries, when the child process closes a connection shared between the parent and child, the parent process receives a disconnect error.

CR:477725

CR Number:   477725 Product Name:   Open Client Product Component:   dblib Status:   Closed OS:   Solaris Original Version:   12.5.1 Fixed Version Build Resolution Date Closure Code (If Appropriate) 07 Oct 2007 Fixed 17 Oct 2007 Fixed Description DBLIB: One of the memory allocated in dbopen was not freed after use. Workaround Description  None

CR:478185

CR Number:   478185 Product Name:   Database Development Product Component:   SQL Editor Status:   Closed OS:   Windows 2000 Original Version:   1.7 Fixed Version Build Resolution Date Closure Code (If Appropriate) 08 Nov 2007 Fixed 06 Jan 2008 Fixed Description When executing a group of SQL statements, the results are grouped under a root node, but the user needs to go thru each child node, i.e., individual SQL statements to save and collect the results or result sets in the SQL Results view. Resolution: Added a context menu in the SQL Results view on the root node of a group of results so that the user can save all sql statements at the same time.

CR:478258

CR Number:   478258 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Generic Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 20 Nov 2007 Fixed Description Refreshing db node took a long time after DDL wizard is called.

CR:478310

CR Number:   478310 Product Name:   Open ClientCONNECT for CICS Product Component:   Open ClientCONNECT for CICS Status:   Closed OS:   MVS Original Version:   12.6 ESD#4 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#1 01 10 Dec 2007 Fixed Description OCC 12.6 ESD4 is not padding Char field correctly, used to work in 12.5.x, padding with Low-values not Blanks as requested....

CR:478369

CR Number:   478369 Product Name:   Organic OLE DB Provider Product Component:   OLE DB Provider Status:   Closed OS:   Microsoft Windows XP Original Version:   15.0 ESD#3 Fixed Version Build Resolution Date Closure Code (If Appropriate) 15.0 ESD#11 06 Nov 2007 Fixed 12.5.1 ESD#21 14 Dec 2007 Fixed Description OLE DB Provider by Sybase: Memory not released after ADODB.Recordset is closed.

CR:478570

CR Number:   478570 Product Name:   Database Development Product Component:   Other Status:   Closed OS:   Generic Original Version:   Tonga Fixed Version Build Resolution Date Closure Code (If Appropriate) 26 Nov 2007 Fixed Description SQL File Editor and SQL Scrapbook connection information field require minor enhancements. Resolution: Enhanced the usability of the Connection Info. Field in the SQL Scrapbook/File Editor.