代码如下:
Dim iDb As ADODB.Connection, iRe As ADODB.Recordset
Dim iConcStr$, iSql$, iReturn$, iI&
' On Error GoTo lbErr
'创建对象
Set iDb = New ADODB.Connection
Set iRe = New ADODB.Recordset
'连接数据库服务器,根据你的情况修改连接字符串
iConcStr = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Data Source=localhost"
iDb.Open iConcStr
iSql = "create database DataBaseName"
iRe.Open iSql, iDb, adOpenKeyset, adLockReadOnly
问题:如何实现点击第二次创建数据库时给一个提示“DataBaseName数据库已存在”
请大家帮助
谢谢!
'将idb连接至master数据库
StrSql = "select * from master..sysdatabases where [name] ='DataBaseName'"
If ide.State = adStateOpen Then ide.Close
ide.Open StrSql, idb, adOpenKeyset, adLockReadOnly
If ide.RecordCount > 0 Then
msgbox "数据库已经存在!",48,"提示"
else
'创建
end if
ide.close
发代码给你,用SQL存储过程创建数据库