Sybase [ASE]版发贴提问的智慧和技巧

[iihero]

发贴时，标题包含数据库名称操作系统以及相应版本号，
e.g. Windows XP下ASE15.0.3安装出错
Ubuntu 9.10下ASE15.0.2中ODBC程序运行失败

内容准确的描述出问题的现象以及结果（包括相应的日志片段），运行现场数据等等，
信息越准确越好，方便大家重现问题和解决问题，也节省了提问者的有效时间。

再引用版主ACMAIN_CHM的总结：
(不要高估你的汉语表达能力或者我的汉语理解能力)
建议你列出你的表结构，并提供测试数据以及基于这些测试数据的所对应正确结果。
参考一下这个贴子的提问方式http://topic.csdn.net/u/20091130/20/8343ee6a-417c-4c2d-9415-fa46604a00cf.html

1. 你的 create table xxx .. 语句
2. 你的 insert into xxx ... 语句
3. 结果是什么样，（并给以简单的算法描述）
4. 你用的数据库名称和版本(经常有人在MS SQL server版问 MySQL)

这样想帮你的人可以直接搭建和你相同的环境，并在给出方案前进行测试，避免文字描述理解上的误差。

[ACMAIN_CHM]

[Sybase数据库恢复]

好！！！！！　顶一个！！！　　向sqlserver那样提问题就好了， 列出表的创建语法还有测试数据，写出自己想要的结果。


这样不用文字就能够表达出清晰的意思， 还能方便回答者进行测试。

回答者不用测试数据验证的话， 这样的结果可信吗？　你自己想亲自测试吗？　　把这活交给回答者，对你自己是多么省心的事情。　呵呵，

[十豆三]

支持！

以前也发过类似的说明，可是效果一般。

如果有些人会这样提问，就有能力自行解决了。

[meexiu]

您好！ 我遇到一个问题，我用ado.net访问远程sybase数据库可是失败了！
一：用OleDb，客户端sybase已经安装了，ping也能通！ 不知道如何使用！报Sybase.ASEOLEDBProvider驱动器未安装 ，我装的sybase版本是最新版的。
二：用Odbc，添加数据源的时候找不到sybase驱动！ 运行也报错了！ 试了非常多种方式都报错了，现在继续帮助!
附 ：我的系统是win7 不知道会不会是这个影响！.. AseClient也试过！
大哥大姐帮下忙！ 小弟急需！...

[iihero]

[Quote=引用 4 楼 yujinsimon 的回复:]

您好！ 我遇到一个问题，我用ado.net访问远程sybase数据库可是失败了！
一：用OleDb，客户端sybase已经安装了，ping也能通！ 不知道如何使用！报Sybase.ASEOLEDBProvider驱动器未安装 ，我装的sybase版本是最新版的。
二：用Odbc，添加数据源的时候找不到sybase驱动！ 运行也报错了！ 试了非常多种方式都报错了，现在继续帮助!
附 ：我的……
[/Quote]
请发新贴提问!!

[rnmsb]

公开课索取密码连接：http://www.upemb.com/free-training/322.html

[mis09leo]

初学 顶下

[zhuzhangliang]

UP,支持下

[qihuanfengyun]

http://topic.csdn.net/u/20110102/20/03178edb-fbca-4beb-9cc4-1fd02fb11a38.html?49982

求linux系统下sybase数据库图形管理软件...

[lrh2001025]

00:00000:00000:2011/06/26 13:49:11.82 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2011/06/26 13:49:11.82 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2011/06/26 13:49:11.82 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2011/06/26 13:49:11.82 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2011/06/26 13:49:11.82 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2011/06/26 13:49:11.82 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2011/06/26 13:49:11.82 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2011/06/26 13:49:11.82 kernel Using 'D:\Sybase\RETONWHP.cfg' for configuration information.
00:00000:00000:2011/06/26 13:49:11.82 kernel Logging ASE messages in file 'D:\Sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2011/06/26 13:49:11.84 kernel Initializing MSDTC Connection
00:00000:00000:2011/06/26 13:49:13.85 kernel MSDTC Initialization succeeded
00:00000:00000:2011/06/26 13:49:13.85 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2011/06/26 13:49:13.85 kernel Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
00:00000:00000:2011/06/26 13:49:13.85 kernel Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
00:00000:00000:2011/06/26 13:54:40.17 kernel Use license file D:\Sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2011/06/26 13:54:40.17 kernel Checked out license ASE_SERVER
00:00000:00000:2011/06/26 13:54:40.17 kernel Adaptive Server Enterprise Edition
00:00000:00000:2011/06/26 13:54:40.28 kernel Using config area from primary master device.
00:00000:00000:2011/06/26 13:54:40.28 kernel Warning: Using default file 'D:\Sybase\RETONWHP.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2011/06/26 13:54:40.31 kernel Using 100000 file descriptors.
00:00000:00000:2011/06/26 13:54:40.31 kernel Failed to load unicode conversion DLL libntlog.dll
00:00000:00000:2011/06/26 13:54:40.31 kernel Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT (IX86)/OS 4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003
00:00000:00000:2011/06/26 13:54:40.31 kernel Confidential property of Sybase, Inc.
00:00000:00000:2011/06/26 13:54:40.31 kernel Copyright 1987, 2003
00:00000:00000:2011/06/26 13:54:40.31 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2011/06/26 13:54:40.31 kernel Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2011/06/26 13:54:40.31 kernel
00:00000:00000:2011/06/26 13:54:40.31 kernel This software contains confidential and trade secret information of Sybase,
00:00000:00000:2011/06/26 13:54:40.31 kernel Inc. Use, duplication or disclosure of the software and documentation by
00:00000:00000:2011/06/26 13:54:40.31 kernel the U.S. Government is subject to restrictions set forth in a license
00:00000:00000:2011/06/26 13:54:40.31 kernel agreement between the Government and Sybase, Inc. or other written
00:00000:00000:2011/06/26 13:54:40.31 kernel agreement specifying the Government's rights to use the software and any
00:00000:00000:2011/06/26 13:54:40.31 kernel applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2011/06/26 13:54:40.31 kernel Sybase, Inc. One Sybase Drive, Dublin, CA 94568, USA
00:00000:00000:2011/06/26 13:54:40.31 kernel Using 'D:\Sybase\RETONWHP.cfg' for configuration information.
00:00000:00000:2011/06/26 13:54:40.31 kernel Logging ASE messages in file 'D:\Sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2011/06/26 13:54:40.32 kernel Initializing MSDTC Connection
00:00000:00000:2011/06/26 13:54:42.34 kernel MSDTC Initialization succeeded
00:00000:00000:2011/06/26 13:54:42.34 kernel kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2011/06/26 13:54:42.34 kernel Connectivity Library (Directory Control Layer) Error: Error returned by service provider.
00:00000:00000:2011/06/26 13:54:42.34 kernel Connectivity Library (Directory Control Layer) Error: (InterfacesDriver): Requested server name not found.
00:00000:00000:2011/06/26 14:04:21.65 kernel Use license file D:\Sybase\SYSAM-1_0\licenses\license.dat.
00:00000:00000:2011/06/26 14:04:21.65 kernel Checked out license ASE_SERVER
00:00000:00000:2011/06/26 14:04:21.65 kernel Adaptive Server Enterprise Edition
00:00000:00000:2011/06/26 14:04:21.79 kernel Using config area from primary master device.
00:00000:00000:2011/06/26 14:04:21.81 kernel Warning: Using default file 'D:\Sybase\RETONWHP.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2011/06/26 14:04:21.84 kernel Using 100000 file descriptors.
00:00000:00000:2011/06/26 14:04:21.84 kernel Failed to load unicode conversion DLL libntlog.dll
00:00000:00000:2011/06/26 14:04:21.84 kernel Adaptive Server Enterprise/12.5.0.3/EBF 11449 ESD#4/P/NT (IX86)/OS 4.0/rel12503/1939/32-bit/OPT/Sat Sep 20 22:28:57 2003
00:00000:00000:2011/06/26 14:04:21.84 kernel Confidential property of Sybase, Inc.
00:00000:00000:2011/06/26 14:04:21.84 kernel Copyright 1987, 2003
00:00000:00000:2011/06/26 14:04:21.84 kernel Sybase, Inc. All rights reserved.
00:00000:00000:2011/06/26 14:04:21.84 kernel Unpublished rights reserved under U.S. copyright laws.

[jesonchu]

不错，学习。

[温水煮青蛙come-on]

up。有理