用程序来自动建立FTP帐号（serv-u的odbc设置）

来源：作者：出处：巧巧读书 2006-09-05 进入讨论组

　　步骤：
1、建立数据库（可以用任何数据库SQL SERVER，ACCESS均可）
2、建立DNS
3、安装Serv-U
4、建立域
5、完成了。呵呵~！
serv-u build 6.0.0.1版本

★ Serv-U FTP Server 6.0.0.1 final

非常好的FTP服务器软件，它设置简单，功能强大，性能稳定。
你现在就可以建立你自己的FTP服务器了。

汉化说明：

1、请先安装原英文软件。
2、退出 FTP Serv-U 应用程序！包括系统栏图标！
3、解压缩后运行汉化包，填入你的安装目录进行汉化。
4、汉化包中另带有企业版的破解补丁:
Serv-U6001cr.exe，如需要，大家可自行破解，破解前请中
止系统中的ServUDaemon.exe进程，或中止Serv-U 的服务。
然后将破解文件复制到 Serv-U 安装目录进行破解。破解后
为永不过期的“企业版”，如果用了以前的破解版本，可能
会报告说你盗用了注册码，这时请在“本地服务器--许可”
中选择“删除密钥”即可。
5、有些原英文版用户汉化后可能会导致设置丢失，这可能是由
于汉化的资源与英文版不同所致，只能请大家重新设置一下
了。以前即用汉化版则无此问题。
6、如果以前使用过我的汉化补丁，请将原目录下旧的“汉化说
明.txt”文件删除后再使用新的汉化补丁。

建立数据库的SQL：

/****** Object: Database host Script Date: 2004-12-24 13:16:31 ******/
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'host')
DROP DATABASE [host]
GO

CREATE DATABASE [host] ON (NAME = N'Host_Data', FILENAME = N'D:\wwwroot\host\database\host.mdf' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'Host_Log', FILENAME = N'D:\wwwroot\host\database\host_log.ldf' , SIZE = 9, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO

exec sp_dboption N'host', N'autoclose', N'false'
GO

exec sp_dboption N'host', N'bulkcopy', N'false'
GO

exec sp_dboption N'host', N'trunc. log', N'false'
GO

exec sp_dboption N'host', N'torn page detection', N'true'
GO

exec sp_dboption N'host', N'read only', N'false'
GO

exec sp_dboption N'host', N'dbo use', N'false'
GO

exec sp_dboption N'host', N'single', N'false'
GO

exec sp_dboption N'host', N'autoshrink', N'false'
GO

exec sp_dboption N'host', N'ANSI null default', N'false'
GO

exec sp_dboption N'host', N'recursive triggers', N'false'
GO

exec sp_dboption N'host', N'ANSI nulls', N'false'
GO

exec sp_dboption N'host', N'concat null yields null', N'false'
GO

exec sp_dboption N'host', N'cursor close on commit', N'false'
GO

exec sp_dboption N'host', N'default to local cursor', N'false'
GO

exec sp_dboption N'host', N'quoted identifier', N'false'
GO

exec sp_dboption N'host', N'ANSI warnings', N'false'
GO

exec sp_dboption N'host', N'auto create statistics', N'true'
GO

exec sp_dboption N'host', N'auto update statistics', N'true'
GO

use [host]
GO

/****** Object: Table [dbo].[GroupAccess] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GroupAccess]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GroupAccess]
GO

/****** Object: Table [dbo].[GroupAccounts] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GroupAccounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GroupAccounts]
GO

/****** Object: Table [dbo].[GroupIPAccess] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GroupIPAccess]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GroupIPAccess]
GO

/****** Object: Table [dbo].[UserAccess] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserAccess]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserAccess]
GO

/****** Object: Table [dbo].[UserAccounts] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserAccounts]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserAccounts]
GO

/****** Object: Table [dbo].[UserIPAccess] Script Date: 2004-12-24 13:16:31 ******/
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[UserIPAccess]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[UserIPAccess]
GO

/****** Object: Table [dbo].[GroupAccess] Script Date: 2004-12-24 13:16:34 ******/
CREATE TABLE [dbo].[GroupAccess] (
[IndexNo] [int] NULL ,
[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[GAid] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[GroupAccounts] Script Date: 2004-12-24 13:16:36 ******/
CREATE TABLE [dbo].[GroupAccounts] (
[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[Notes] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[GAsId] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[GroupIPAccess] Script Date: 2004-12-24 13:16:36 ******/
CREATE TABLE [dbo].[GroupIPAccess] (
[IndexNo] [int] NULL ,
[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[GIpAid] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[UserAccess] Script Date: 2004-12-24 13:16:37 ******/
CREATE TABLE [dbo].[UserAccess] (
[IndexNo] [int] NULL ,
[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Access] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[UAid] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY]
GO

/****** Object: Table [dbo].[UserAccounts] Script Date: 2004-12-24 13:16:37 ******/
CREATE TABLE [dbo].[UserAccounts] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[UserName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Password] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Disable] [bit] NOT NULL ,
[Access] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ChangePass] [bit] NOT NULL ,
[PassType] [tinyint] NOT NULL ,
[Expiration] [smalldatetime] NOT NULL ,
[ExpirationType] [tinyint] NOT NULL ,
[SKey] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[RelPaths] [bit] NOT NULL ,
[HomeDir] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[MessageFile] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[MaxUsers] [int] NOT NULL ,
[MaxUp] [int] NOT NULL ,
[MaxDown] [int] NOT NULL ,
[RatioUp] [int] NULL ,
[RatioDown] [int] NULL ,
[RatioCredit] [float] NULL ,
[RatioType] [tinyint] NULL ,
[QuotaEnable] [bit] NOT NULL ,
[QuotaMax] [int] NOT NULL ,
[QuotaCurrent] [int] NOT NULL ,
[Groups] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Privilege] [tiny保留地址 http://www.qqread.com/dotnet/d240515.html