如何在代码中用ADO创建SQLSERVER数据库,并在新生成的数据库中创建表? 我看了一些FAQ和原来的的帖子,说得不太详细,我也不太懂,有那位朋友热心相告,分不够可以在加100 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 他们写的只是针对ACCESS的,还有就是一些CREATE DATABASE 的语句 我是想知道在代码中应该调用什么函数,类,路径等对于SQLSERVER和ACCESS不同的 创建Test数据库:'引用ADO(Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click()' On Error GoTo err Dim cn As New ADODB.Connection' 连接到master 数据库,借助master数据库来建立新的数据库' cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=master;Data Source=服务器别名/IP" cn.CursorLocation = adUseClient '设置客户端游标 cn.Open cn.Execute ("use master create database Test")'创建Test数据库 Exit Suberr: MsgBox err.DescriptionEnd Sub Dim cn As ADODB.Connection Dim strCn As String Dim strSQL As String Set cn = New ADODB.Connection '1.创建数据库newDB strCn = "Provider = SQLOLEDB.1;Persist Security Info = False;" & _ "User ID = sa;Password = MOFZaCW3Ob;Data Source = 192.168.0.179;" & _ "Initial Catalog =master" cn.ConnectionString = strCn cn.Open strSQL = "CREATE DATABASE newDB" cn.Execute strSQL MsgBox "成功创建数据库" cn.Close '2.连接到新数据库newDB创建表 strCn = "Provider = SQLOLEDB.1;Persist Security Info = False;" & _ "User ID = sa;Password = MOFZaCW3Ob;Data Source = 192.168.0.179;" & _ "Initial Catalog =newDB" cn.ConnectionString = strCn cn.Open '创建表名为tb的表 strSQL = "CREATE TABLE tb(" & _ "username varchar(20) not null primary key," & _ "pass char(10) not null)" cn.Execute strSQL MsgBox "成功创建数据库表tb" cn.Close Set cn = Nothing 创建指定数据文件和事务日志文件的数据库-----------------------cn.Execute ("USE master CREATE DATABASE Sales " & _ "ON( NAME = Sales_dat, " & _ "FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf'," & _ "SIZE = 10,MAXSIZE = 50,FILEGROWTH = 5 ) " & _ "LOG ON( NAME = 'Sales_log'," & _ "FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf'," & _ "SIZE = 5MB,MAXSIZE = 25MB,FILEGROWTH = 5MB )") 在Test数据库上建立testTable表:------------------------------------'引用ADO(Microsoft ActiveX Data Objects 2.X Library)Private Sub Command1_Click() Dim cn As New ADODB.Connection' 连接到Test数据库 cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=Test;Data Source=服务器别名/IP" cn.CursorLocation = adUseClient '设置客户端游标 cn.Open cn.Execute ("create table testTable " & _ "[colTime] [datetime] NULL ," & _ "[colFlt] [float] NULL ," & _ "[myImg] [image] NULL ," & _ "[myInt] [int] NULL ," & _ "[myNText] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,")End Sub 非常感谢faysky2(),vbman2003两位的热心帮助,谢谢你们 求高手解决:有关VB中.exe 文件的问题 VB实现下滑移动菜单? 有无好的例程??? winsock传文件的问题 USB等设备拔除问题 编程问题 关于combobox的问题 请教一个统计学中判别分析的算法 数据集更新的问题(在线等待) 如何获知WIN2000的写盘动作? 急用:有关调shell问题. 如何用sendmessage发送按键消息?? 求助:在vb菜单中Reference一个dll文件时出错:“Can't add a reference to the specified file.”
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
' On Error GoTo err
Dim cn As New ADODB.Connection
' 连接到master 数据库,借助master数据库来建立新的数据库
' cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=master;Data Source=服务器别名/IP"
cn.CursorLocation = adUseClient '设置客户端游标
cn.Open
cn.Execute ("use master create database Test")'创建Test数据库 Exit Sub
err:
MsgBox err.Description
End Sub
Dim strCn As String
Dim strSQL As String
Set cn = New ADODB.Connection
'1.创建数据库newDB
strCn = "Provider = SQLOLEDB.1;Persist Security Info = False;" & _
"User ID = sa;Password = MOFZaCW3Ob;Data Source = 192.168.0.179;" & _
"Initial Catalog =master"
cn.ConnectionString = strCn
cn.Open
strSQL = "CREATE DATABASE newDB"
cn.Execute strSQL
MsgBox "成功创建数据库"
cn.Close
'2.连接到新数据库newDB创建表
strCn = "Provider = SQLOLEDB.1;Persist Security Info = False;" & _
"User ID = sa;Password = MOFZaCW3Ob;Data Source = 192.168.0.179;" & _
"Initial Catalog =newDB"
cn.ConnectionString = strCn
cn.Open
'创建表名为tb的表
strSQL = "CREATE TABLE tb(" & _
"username varchar(20) not null primary key," & _
"pass char(10) not null)"
cn.Execute strSQL
MsgBox "成功创建数据库表tb"
cn.Close
Set cn = Nothing
-----------------------
cn.Execute ("USE master CREATE DATABASE Sales " & _
"ON( NAME = Sales_dat, " & _
"FILENAME = 'c:\program files\microsoft sql server\mssql\data\saledat.mdf'," & _
"SIZE = 10,MAXSIZE = 50,FILEGROWTH = 5 ) " & _
"LOG ON( NAME = 'Sales_log'," & _
"FILENAME = 'c:\program files\microsoft sql server\mssql\data\salelog.ldf'," & _
"SIZE = 5MB,MAXSIZE = 25MB,FILEGROWTH = 5MB )")
------------------------------------
'引用ADO(Microsoft ActiveX Data Objects 2.X Library)
Private Sub Command1_Click()
Dim cn As New ADODB.Connection
' 连接到Test数据库
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=登陆用户名;Password=登录密码;Initial Catalog=Test;Data Source=服务器别名/IP"
cn.CursorLocation = adUseClient '设置客户端游标
cn.Open
cn.Execute ("create table testTable " & _
"[colTime] [datetime] NULL ," & _
"[colFlt] [float] NULL ," & _
"[myImg] [image] NULL ," & _
"[myInt] [int] NULL ," & _
"[myNText] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,")
End Sub