提供Sybase ASE及Sybase SQL Anywhere数据库修复服务,电话:13811580958(微信),QQ:289965371!We have many years of experience in recovering data from damanged Sybase devices. Contact us by Phone: +86 13811580958 Wechat: 13811580958 Email: 289965371@qq.com
2020-08-02 Sybase ASE 16.0数据库无法连接报错There is a protocol packet error. An illegal length was received (0) 1、问题现象:
使用isql无法连接Sybase ASE 16.0数据库服务器,报错:
CT-LIBRARY error:
ct_connect(): network packet layer: external error: There is a protocol packet error. An illegal length was received
查看Sybase ASE 16.0的错误日志文件,发现除了Cannot send, host process disconnected: XXXXXX-PC 29464 suid: 1外无任何错误信息。
数据库服务器版本:Adaptive Server Enterprise/16.0/EBF 22383 SMP/P/x86_64/Enterprise Linux/asecepheus/3530/64-bit/FBO/Sun Feb 16 06:09:40 2014
2、问题分析:
当前Sybase […]
2012-01-17 在VM Server中配置SQL Server 2005故障转移群集(3)—安装实例 (0) 在VM Server中配置SQL Server 2005故障转移群集(3)---安装实例
8. 安装SQL Server实例
8.1. 准备工作
8.2. 安装SQL Server
9. 安装客户端组件
8. 安装SQL Server实例
本 实验中安装的SQL Server实例名为:SQLCLUSTER。SQL Server 2005可以在群集中的任何一个联机的节点上进行安装。选择某一个节点进行数据库实例的安装过程,其他节点会自动同步安装,不用再执行手动安装过程。实验 中选择"Node1"来安装SQL Server 2005。
8.1. 准备工作
在 确保群集的工作正常的情况下,安装SQL Server 2005之前,我们需要先配置好MSDTC(Microsoft分布式事务处理协调器 )群集资源。如果只安装数据库引擎,则MSDTC群集资源不是必需的。如果安装数据库引擎、SSIS、Notification […]
2010-08-23 利用dbcc writepage命令修改SQL SQLSERVER中的物理页面上的内容 (3) dbcc writepage是sqlserver 2000 和 2005中未公开的命令,也就是说使用这些未官方支持的命令出现的任何后果与MS无关。
同样,本文仅仅演示dbcc writepage的使用,您在操作时出现的任何后果与本人无关。
dbcc writepage的语法为:
dbcc writepage ({ dbid, ‘dbname’ }, fileid, pageid, offset, length, data)
下面演示dbcc writepage的使用方法:
----------------------------------------------------------------------------
第一步:创建一个测试表
1> create table test (id int not null,name varchar(30) null)
2> go
1> insert into test
2> select […]
2010-11-03 SQL2005 如何更新系统表 (2) Most of us know how to update system table in sql server 2000, but there is rare information about how to do it in sql 2005. We know, Microsoft doesn't like anyone that is not in Microsoft company to update sql server system tables. But he always likes to leave a back door for himself. I think, the men, who commited themselves to design and develop SQL sever 2005 in Microsoft, would be the first ones know how to update SQL 2005 system table. And I look for related infomation in […]
2011-10-20 ASE12.5.3 Error 1204错误的解决方法 (0) Sybase ASE12.5.3ESD#7的错误日志文件中频繁报下面的错误信息:
Error 1204, Severity 17, State 2 occurred for User 'sa'. Client IP address is 'XXX.XXX.XXX.XXX'.
SQL Text: select xxxx from xxxxx where xxxxx
查询Sybase错误信息手册,Error 1204是由锁数量不够导致的。
Error 1204的错误信息内容应该为:
SQL Server has run out of LOCKS. Re-run your command when there are fewer active users, or contact a user with System Administrator (SA) role to reconfigure SQL Server with more […]
提供Sybase数据库远程及现场技术支持
提供Sybase ASE和ASA数据库修复服务
QQ :289965371
Email:
电话:(微信)
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371
Email: 289965371@qq.com
提供7*24专业Sybase数据恢复、性能优化、迁移升级、紧急救援等服务,
Sybase ASE及Sybase SQL Anywhere数据库修复服务,
电话:(微信),
QQ :289965371
Email:
We supply technical support for Sybase ASE and Sybase SQL Anywhere, also have many years of experience in recovering data from damanged Sybase devices.
Please contact us:
Phone:
Wechat: 13811580958
QQ: 289965371
Email: 289965371@qq.com