[求助]ISQL不能连接数据库

xolbm

免费乐捐，感谢支持

 

系统平台为WINDOWS SEVER 2003,SYBASE是12.5.1,用isql －Usa －Ppassword －Ssystem

连接数据库时，提示:

CS-LIBRARY error:

       ct_init(): network packet layer: internal net library error: Failed to open Net-Library localization file 

Attempting to obtain a localized error message failed.

我是一个初学者,恳请各位大虾帮忙看看这是什么原因!上面的提示是啥意思呀?谢谢先.

ehxz

是不是服务没有启动啊？给SYBASE打上最新补丁再试试看。

xolbm

ehxz,谢谢你解答，我是菜鸟问题有点多和低级哈！
你说的是哪个服务没启动呀？我的应用程序能正常使用，但在服务管理那里有Sybase BCKServer  Sybase MONServer Sybase SQLServer Sybase XPServer四个服务不能被启动，提示：错误1067，进程意外终止。我本想通过ISQL命令检查和备份数据库并启动以上服务，能不能实现呀？
打补丁会不会损坏数据库呀？我的数据库较重要，没有备过份呀。

flybean

服务没启动，怎么可能用ＩＳＱＬ？
贴错误日志

xolbm

00:00000:00000:2006/05/09 08:47:29.04 kernel  Checked out license ASE_SBE
00:00000:00000:2006/05/09 08:47:29.07 kernel  Adaptive Server Small Business Edition
00:00000:00000:2006/05/09 08:47:29.42 kernel  Using config area from primary master device.
00:00000:00000:2006/05/09 08:47:29.50 kernel  Warning: Using default file 'C:\sybase\JYFYZJ.cfg' since a configuration file was not specified. Specify a configuration file name in the RUNSERVER file to avoid this message.
00:00000:00000:2006/05/09 08:47:29.71 kernel  Using 100000 file descriptors.
00:00000:00000:2006/05/09 08:47:29.78 kernel  Adaptive Server Enterprise/12.5.0.1/SWR 10291 IR/P/NT (IX86)/OS 4.0/rel12501/1778/32-bit/OPT/Fri May 17 00:59:18 2002
00:00000:00000:2006/05/09 08:47:29.78 kernel  Confidential property of Sybase, Inc.
00:00000:00000:2006/05/09 08:47:29.78 kernel  Copyright 1987, 2002
00:00000:00000:2006/05/09 08:47:29.78 kernel  Sybase, Inc.  All rights reserved.
00:00000:00000:2006/05/09 08:47:29.78 kernel  Unpublished rights reserved under U.S. copyright laws.
00:00000:00000:2006/05/09 08:47:29.78 kernel 
00:00000:00000:2006/05/09 08:47:29.78 kernel  This software contains confidential and trade secret information of Sybase,
00:00000:00000:2006/05/09 08:47:29.78 kernel  Inc.   Use,  duplication or disclosure of the software and documentation by
00:00000:00000:2006/05/09 08:47:29.78 kernel  the  U.S.  Government  is  subject  to  restrictions set forth in a license
00:00000:00000:2006/05/09 08:47:29.78 kernel  agreement  between  the  Government  and  Sybase,  Inc.  or  other  written
00:00000:00000:2006/05/09 08:47:29.78 kernel  agreement  specifying  the  Government's rights to use the software and any
00:00000:00000:2006/05/09 08:47:29.78 kernel  applicable FAR provisions, for example, FAR 52.227-19.
00:00000:00000:2006/05/09 08:47:29.78 kernel  Sybase, Inc. 5000 Hacienda Drive, Dublin, CA 94568, USA
00:00000:00000:2006/05/09 08:47:29.78 kernel  Using 'C:\sybase\JYFYZJ.cfg' for configuration information.
00:00000:00000:2006/05/09 08:47:29.78 kernel  Logging ASE messages in file 'C:\sybase\ASE-12_5\install\errorlog'.
00:00000:00000:2006/05/09 08:47:29.81 kernel  Initializing MSDTC Connection
00:00000:00000:2006/05/09 08:47:31.92 kernel  MSDTC Initialization succeeded
00:00000:00000:2006/05/09 08:47:31.92 kernel  kdcl_sess_open: connectivity library supports master/query syntax.
00:00000:00000:2006/05/09 08:47:31.93 kernel  Directory Control Layer (DCL) using directory driver: InterfacesDriver
00:00000:00000:2006/05/09 08:47:31.93 kernel  *** WARNING ******************
00:00000:00000:2006/05/09 08:47:31.93 kernel  Operating system may favor the system cache when memory is at a premium.
 To disable this warning, set the registry parameter 'LargeSystemCache' to 0 in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session Manager\Memory Management.
00:00000:00000:2006/05/09 08:47:31.93 kernel  SQL Server NT process id is 0x7e4.
00:00000:00000:2006/05/09 08:47:31.93 kernel  SQL Server was started as a Service.
00:00000:00000:2006/05/09 08:47:31.95 kernel  SSL Plus v3.0.9 security modules loaded successfully.
00:00000:00000:2006/05/09 08:47:31.95 kernel  Network and device connection limit is 99992.
00:00000:00000:2006/05/09 08:47:32.18 server  Number of blocks left for proc headers: 3232.
00:00000:00000:2006/05/09 08:47:32.18 server  Proc header memory allocated 1616 pages for each per engine cache
00:00000:00000:2006/05/09 08:47:32.20 server  Memory allocated for the default data cache cachelet 1: 8192 Kb
00:00000:00000:2006/05/09 08:47:32.20 server  Size of the 2K memory pool: 8192 Kb
00:00000:00000:2006/05/09 08:47:32.20 kernel  Initializing virtual device 0, 'C:\sybase\data\master.dat' with dsync 'on'.
00:00000:00000:2006/05/09 08:47:32.20 kernel  Virtual device 0 started using asynchronous i/o.
00:00000:00000:2006/05/09 08:47:32.20 kernel  Worker Thread Manager is not enabled for use in SQL Server.
00:00000:00000:2006/05/09 08:47:32.20 kernel  Either the config parameter 'use security services' is set to 0, or ASE does not support use of external security mechanisms on this platform. The Security Control Layer will not be initialized. No external security mechanisms will be supported.
00:00000:00000:2006/05/09 08:47:32.21 kernel  engine 0, os pid 1788  online
00:00000:00000:2006/05/09 08:47:32.25 server  No active traceflags
00:00000:00001:2006/05/09 08:47:32.42 kernel  libomni1 - Component Integration Services loaded; version 'libomni1 - Component Integration Services/12.5.0.1/SWR 10291 IR/P/NT (IX86)/OS 4.0/rel12501/1778/32-bit/OPT/Fri May 17 00:59:18 2002'.
00:00000:00001:2006/05/09 08:47:32.42 kernel  libomni1 - Component Integration Services: using 'Sybase Client-Library/12.5/P-EBF9966/PC Intel/BUILD125-011/OPT/Mon Dec 03 14:56:19 2001'
00:00000:00001:2006/05/09 08:47:32.42 server  Opening Master Database ...
00:00000:00001:2006/05/09 08:47:32.65 server  Loading SQL Server's default sort order and character set
00:00000:00001:2006/05/09 08:47:32.65 server  Loaded default Unilib conversion handle.
00:00000:00001:2006/05/09 08:47:32.71 server  Recovering database 'master'.
00:00000:00001:2006/05/09 08:47:32.92 server  Redo pass of recovery has processed 403 committed and 0 aborted transactions.
00:00000:00001:2006/05/09 08:47:33.09 server  Checking external objects.
00:00000:00001:2006/05/09 08:47:33.18 server  Database 'master' is now online.
00:00000:00001:2006/05/09 08:47:33.18 server  The transaction log in the database 'master' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:33.20 server  Warning: ASE_HA has no valid license and therefore is not initialized.
00:00000:00001:2006/05/09 08:47:33.21 server  server is unnamed
00:00000:00001:2006/05/09 08:47:33.21 server  Activating disk 'erm' of size 1996488704 bytes.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Initializing virtual device 2, 'd:\erm_data\erm.dat' with dsync 'on'.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Virtual device 2 started using asynchronous i/o.
00:00000:00001:2006/05/09 08:47:33.21 server  Activating disk 'ermlog' of size 2089779200 bytes.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Initializing virtual device 3, 'd:\erm_data\ermlog.dat' with dsync 'on'.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Virtual device 3 started using asynchronous i/o.
00:00000:00001:2006/05/09 08:47:33.21 server  Activating disk 'sysprocsdev' of size 125829120 bytes.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Initializing virtual device 1, 'C:\sybase\data\sybprocs.dat' with dsync 'on'.
00:00000:00001:2006/05/09 08:47:33.21 kernel  Virtual device 1 started using asynchronous i/o.
00:00000:00001:2006/05/09 08:47:33.45 server  Recovering database 'sybsystemdb'.
00:00000:00001:2006/05/09 08:47:33.46 server  Redo pass of recovery has processed 0 committed and 1 aborted transactions.
00:00000:00001:2006/05/09 08:47:33.56 server  Boot Count: 12
00:00000:00001:2006/05/09 08:47:33.62 server  Checking external objects.
00:00000:00001:2006/05/09 08:47:33.62 server  The transaction log in the database 'sybsystemdb' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:33.64 server  Database 'sybsystemdb' is now online.
00:00000:00001:2006/05/09 08:47:33.67 server  Recovering database 'model'.
00:00000:00001:2006/05/09 08:47:33.71 server  Checking external objects.
00:00000:00001:2006/05/09 08:47:33.73 server  The transaction log in the database 'model' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:33.73 server  Database 'model' is now online.
00:00000:00001:2006/05/09 08:47:33.73 server  The logical pagesize of the server is 2 Kb.
00:00000:00001:2006/05/09 08:47:33.73 server  0 dump conditions detected at boot time
00:00000:00001:2006/05/09 08:47:33.75 server  Resident Node id: de9567164c55
00:00000:00001:2006/05/09 08:47:33.75 server  Transaction coordinator initialized.
00:00000:00001:2006/05/09 08:47:33.75 server  Clearing temp db
00:00000:00001:2006/05/09 08:47:34.84 server  The transaction log in the database 'tempdb' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:34.85 server  Database 'tempdb' is now online.
00:00000:00001:2006/05/09 08:47:34.89 server  Recovering database 'sybsystemprocs'.
00:00000:00001:2006/05/09 08:47:35.18 server  Checking external objects.
00:00000:00001:2006/05/09 08:47:35.20 server  The transaction log in the database 'sybsystemprocs' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:35.20 server  Database 'sybsystemprocs' is now online.
00:00000:00002:2006/05/09 08:47:35.21 kernel  network name 192.168.0.60, type ether, port 5000, filter NONE
00:00000:00001:2006/05/09 08:47:35.34 server  Recovering database 'erm'.
00:00000:00001:2006/05/09 08:47:35.50 server  Redo pass of recovery has processed 46 committed and 2 aborted transactions.
00:00000:00001:2006/05/09 08:47:36.48 server  Checking external objects.
00:00000:00001:2006/05/09 08:47:36.48 server  The transaction log in the database 'erm' will use I/O size of 2 Kb.
00:00000:00001:2006/05/09 08:47:36.51 server  Database 'erm' is now online.
00:00000:00001:2006/05/09 08:47:36.53 server  Recovery complete.
00:00000:00001:2006/05/09 08:47:36.53 server  SQL Server's default unicode sort order is 'binary'.
00:00000:00001:2006/05/09 08:47:36.53 server  SQL Server's default sort order is:
00:00000:00001:2006/05/09 08:47:36.53 server   'bin_cp850' (ID = 50)
00:00000:00001:2006/05/09 08:47:36.53 server  on top of default character set:
00:00000:00001:2006/05/09 08:47:36.53 server   'cp850' (ID = 2).
00:00000:00001:2006/05/09 08:47:36.53 server  Master device size: 30 megabytes, or 15360 virtual pages. (A virtual page is 2048 bytes.)

flybean

服务已经启动，用DSEDIT ping 一下。检查环境变量

xolbm

日志已贴上楼,谢谢flybean,ehxz等各位大大帮忙看看,谢谢!

xolbm

免费乐捐，感谢支持

我运行DSEDIT后,里面的SERVER等栏咋都是空的呀??

xolbm

我运行DSEDIT后,里面的SERVER,path,attributes等栏咋都是空的呀??

flybean

检查 interfaces 文件，WINDOWS下是%SYBASE%/sql/sql.ini，UNIX下为$SYBASE/interfaces

xolbm

在sybase/ini下找到sql.ini文件,其内容为:

[JYFYZJ]

master=NLWNSCK,192.168.0.60,5000

query=NLWNSCK,192.168.0.60,5000

[JYFYZJ_XP]

master=NLWNSCK,192.168.0.60,6000

query=NLWNSCK,192.168.0.60,6000

[JYFYZJ_BS]

master=NLWNSCK,192.168.0.60,4000

query=NLWNSCK,192.168.0.60,4000

[JYFYZJ_BS_]

master=NLWNSCK,192.168.0.60,4000

query=NLWNSCK,192.168.0.60,4000

这个文件有问题吗?

flybean

没有问题，检查sybase环境变量