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

xolbm 发表于 2006-5-9 19:28:32

<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"> <span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">系统平台为WINDOWS SEVER 2003,SYBASE是12.5.1,用isql －Usa －Ppassword －Ssystem<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">连接<span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: 'Times New Roman'; mso-bidi-font-family: 'Times New Roman';">数据库时，提示:CS-LIBRARY error:       ct_init(): network packet layer: internal net library error: Failed to open Net-Library localization file  <span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">Attempting to obtain a localized error message failed.<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;"><span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">我是一个初学者,恳请各位大虾帮忙看看<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: 'Times New Roman'; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">这是什么原因!上面的提示是啥意思呀?谢谢先.

ehxz 发表于 2006-5-9 20:01:22

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

xolbm 发表于 2006-5-9 20:41:51

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

flybean 发表于 2006-5-10 09:03:21

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

xolbm 发表于 2006-5-10 11:12:22

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 发表于 2006-5-10 11:28:21

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

xolbm 发表于 2006-5-10 11:29:32

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

xolbm 发表于 2006-5-10 11:56:39

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

xolbm 发表于 2006-5-10 12:00:22

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

flybean 发表于 2006-5-10 12:16:42

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

xolbm 发表于 2006-5-10 16:15:15

在sybase/ini下找到sql.ini文件,其内容为:master=NLWNSCK,192.168.0.60,5000query=NLWNSCK,192.168.0.60,5000master=NLWNSCK,192.168.0.60,6000query=NLWNSCK,192.168.0.60,6000master=NLWNSCK,192.168.0.60,4000query=NLWNSCK,192.168.0.60,4000master=NLWNSCK,192.168.0.60,4000query=NLWNSCK,192.168.0.60,4000这个文件有问题吗?

flybean 发表于 2006-5-10 17:09:31

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

页: [1] 2

PowerBuilder(PB)BBS社区's Archiver

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