升级顾问返回错误-1。

Tue, 01 Nov 2011 23:13:23 +0800

SQLSERVER 2000升级到2005 安装过程中返回错误：
“升级顾问返回错误-1。”

解决方法：
从C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA\bin
下把 BPAClient.dll 复制到 C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\BPA

Refer: http://blogs.technet.com/b/isablog/archive/2009/03/16/sql-server-2005-express-edition-service-pack-3-fails-to-install-on-a-tmg-machine.aspx

迁移数据库时遇到的问题及解决

Sun, 30 Oct 2011 00:18:28 +0800

原本数据库建立了数据库复制, 迁移完成后, 修改表结构时仍然提示数据库用于复制不能修改,
用以下方法解决:
sp_removedbreplication

执行数据维护计划时报告数据一致性错误,
用以下方法解决:
--try
USE MASTER
GO
sp_dboption '数据库名', 'single user', 'true'
Go
DBCC CHECKDB('数据库名', REPAIR_ALLOW_DATA_LOSS)
Go
USE 数据库名
go
exec sp_msforeachtable 'DBCC CHECKTABLE("表名",REPAIR_ALLOW_DATA_LOSS)'
exec sp_msforeachtable 'DBCC DBREINDEX("表名")'
go
sp_dboption '数据库名', 'single user', 'false'
Go

Remove All VBA Code Programmatically

Thu, 08 Apr 2010 20:53:01 +0800

Option Explicit Sub DeleteAllCode() 'Trust Access To Visual Basics Project must be enabled. 'From Excel: Tools | Macro | Security | Trusted Sources Dim x As Integer Dim Proceed As VbMsgBoxResult Dim Prompt As

Excel 2007 (Excel.Application) Workbooks.Add 出现内存不够的解决办法

Wed, 31 Mar 2010 12:54:20 +0800

[问题 Issue]
Workbooks.Add时,会出现以下错误:

Microsoft Office Excel 错误 '800a03ec'

内存或磁盘空间不足，Microsoft Office Excel 无法再次打开或保存任何文档。
? 要想获得更多的可用内存，请关闭不再使用的工作簿或程序。
? 要想释放磁盘空间，请删除相应磁盘上不需要的文件。

Microsoft Office Excel cannot open or save any more documents because there is not enough available memory or disk space.
? To make more memory available, close workbooks or programs you no longer need.

Can not access Excel file using OpenRowset

Thu, 11 Feb 2010 12:34:32 +0800

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Providers\Microsoft.Jet.OLEDB.4.0

NOTE: With the DisallowAdHocAccess property set to 1, SQL Server does not allow ad hoc access through the OPENROWSET and the OPENDATASOURCE functions against the specified OLE DB provider. If you try to call these functions in ad hoc queries, you will receive an error message similar to:

用VS2005开发COM 组件

Thu, 11 Feb 2010 12:34:04 +0800

1, 添加引用
using System.Runtime.InteropServices;

2, 在类名前加上
[ProgId("Shanger.Sunrise")] //Com调用的名字
[Guid("CAF9E079-7A4F-46ac-9516-9A5CCAB41ABD")] //设置GUID
Guid 可以在工具-> 创建 Guid里得到

3, 设置Com可见
双击 "解决方案管理器>项目名>Properties", "应用程序">"程序集信息">"使程序集Com可见"
.或者.
AssemblyInfo.cs里修改: [assembly: ComVisible(true)]
效果一样的.

4. 本机调试(可选)
"解决方案管理器>项目名>Properties", "生成"标签里选"为 COM Interop 注册"

5. 部署
还没做,以后再讲.

Simplified and Extended Data Binding Syntax in ASP.NET 2.0

Thu, 11 Feb 2010 12:33:16 +0800

Introduction

The server-side data binding techniques that were introduced in ASP.NET version 1.0 revolutionized the way developers build pages that access data. No longer was there a requirement for complex and lengthy code sections that build up HTML tables or lists of values. However, using ASP.NET 1.x, you still have to write code to perform the data access and expose the data to the

Select data from an Excel sheet in MSSQL

Thu, 11 Feb 2010 12:32:20 +0800

select *
from openrowset('Microsoft.Jet.OLEDB.4.0'
,'Excel 8.0;HDR=YES;IMEX=1;DATABASE=d:\folder\excel.xls',Sheet1$)

-------NOTE------

Setting IMEX=1 tells the driver to use Import mode. In this state, the registry setting ImportMixedTypes=Text will be noticed. This forces mixed data to be converted to text. For this to work reliably, you may also have to modify the registry setting,

FTP via ASP without using 3rd-party components

Thu, 11 Feb 2010 12:31:22 +0800

<%@ Language=VBScript %>
<%
' FTP via ASP without using 3rd-party components
' Ben Meghreblian 15th Jan 2002
' benmeg at benmeg dot com / http://benmeg.com/code/asp/ftp.asp.html
'
' This script assumes the file to be FTP'ed is in the same directory as this script.
' It should be obvious how to change this (*hint* change the lcd line).
' You may specify a wildcard in ftp_files_to_put (e.g. *.txt).

'

网页制作之在线视频播放代码

Thu, 11 Feb 2010 12:27:05 +0800

站长说明：

1.avi格式