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

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

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
...

Read More...
  

[问题 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.
...

Read More...

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:

Ad

...

Read More...

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. 部署
还没做,以后再讲.

...

Read More...

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

...

Read More...

...

Read More...