我是第一次用SQL数据库,请告知如何生成一个SQL数据库,生成的步骤请详细说明,还有怎样用VB与我建立的SQL数据库连接,定重谢!
解决方案 »
- 如何防止程序重复启动?
- 关于程序效率的问题
- 难题,想在frontpage软件的右键菜单自己添加一项内容,用什么函数?
- listBOX 复制到剪切板后再粘贴,中文都变为乱码,怎么办?
- DataGrid控件的Datasource属性,用ADO对象,怎么对其赋值啊?
- 我是写com的菜鸟 做过com的老兄,如果方便的话交流一下QQ.
- 如何用internet transfer 控件上传word文件(至急)
- 菜鸟请教:如何用VBA读取.dbf中的数据输出到excel?
- 不同意"巴顿"离开的请跟贴~~~~!
- 各位大哥,大姐,大弟,大妹,小妹我正在做毕业设计,用VB做ADO谁能帮我做一个
- VB调用C语言的dll,怎么调用返回字符数组的函数?
- MSHFlexGrid中选中行后,selectionmode设的是1,为什么控件的每行第一列无法和后面的列一样背景色改变?
(1)我是第一次用SQL数据库,请告知如何生成一个SQL数据库,生成的步骤请详细说明
------------------------------------------------------------------------------
你在SQL SERVER中新建一个数据库,然后将这个数据库生成脚本文件,根据情况修改后转存为MASTER下的一个存储过程。至于数据库名和数据文件路径可以做成参数传入,然后在VB中用连到MASTER后执行这个存储过程。(2)还有怎样用VB与我建立的SQL数据库连接
---------------------------------------------
1.使用ODBC DSN连接字符串
DSN=mySystemDSN;Uid=myUsername;Pwd=myPassword
----------------------------------------------
2.使用无ODBC DSN的连接字符串
(1)标准安全性
Driver={SQL Server};Server=MyServerName;DataBase=myDatabaseName; _
Uid=myUsername;Pwd=myPassword
------------------------------------------------(2)信任连接(分两种)
1)连接字符串1
Driver={SQL Server};Server=MyServerName;DataBase=myDatabaseName;Uid=;Pwd=;
2)连接字符串2
Driver={SQL Server};Server=MyServerName;DataBase=myDatabaseName;Trusted_Connection=yes
---------------------------------------------------------------------------(3)连接本地SQL SERVER
Driver={SQL Server};Server=(local);DataBase=myDatabaseName; _
Uid=myUsername;Pwd=myPassword
-------------------------------------------------------------(4)连接远程SQL SERVER
Driver={SQL Server};Server=xxx.xxx.xxx.xxx; _
Address=xxx.xxx.xxx.xxx,1433; _
Network=DBMMSOCN;DataBase=myDatabaseName; _
Uid=myUsername;Pwd=myPassword
-------------------------------------------------------3.使用OLEDB PROVIDER FOR SQL SERVER的连接字符串
(1)标准安全性
Provider=SQLOLEDB.1; _
Password=myPassword; _
User ID=myUsername; _
Initial Catalog=myDatabaseName; _
Data Source=MyServerName
-------------------------------------------(2)信任连接
Provider=SQLOLEDB.1; _
Initial Catalog=myDatabaseName; _
Data Source=MyServerName; _
Integrated Security=SSPI
--------------------------------------(3)连接到命名实例
Provider=SQLOLEDB.1; _
Initial Catalog=myDatabaseName; _
Data Source=myServerName\myInstanceName; _
Password=myPassword; _
User ID=myUsername
--------------------------------------(4)连接到本地SQL SERVER
Provider=SQLOLEDB.1; _
Password=myPassword; _
User ID=myUsername; _
Initial Catalog=myDatabaseName; _
Data Source=(local)
-----------------------------------------(5)连接到远程SQL SERVER
Provider=SQLOLEDB.1; _
Netwprk Library=DBMMSOCN; _
Data Source=xxx.xxx.xxx.xxx,1433; _
Password=myPassword; _
User ID=myUsername; _
Initial Catalog=myDatabaseName;
Provider=SQLOLEDB.1; _
Password=myPassword; _
User ID=myUsername; _
Initial Catalog=myDatabaseName; _
Data Source=(local)
《SQL实用教程》清华大学出版社出,这本书不错呀,建议楼主可以看看。
另外一般试验时,初始安装sql的数据库用户名为“sa”,密码为空(即无),楼主按照这个对应程序中的用户名与密码。
Option Explicit
Private Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)
Public conn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public addFlag As Boolean
Public strSql As String
Public Function OpenCn() As Boolean
Dim mag As String
On Error GoTo strerrmag
Set conn = New ADODB.Connection
conn.ConnectionTimeout = 30
conn.CommandTimeout = 120
conn.CursorLocation = adUseClient
conn.ConnectionString = "Provider=SQLOLEDB;Persist Security Info=False;User ID=用户名;PWD=密码;Initial Catalog=数据库名;Data Source=服务器名"conn.Open , , , adAsyncConnectDo While conn.State <> adStateOpen And conn.State <> adStateClosed
Sleep 50
DoEvents
LoopOpenCn = True
Exit Function
strerrmag:
mag = "Data can't connect"
Call MsgBox(mag, vbOKOnly, "Error:Data connect")
OpenCn = False
Exit Function
End FunctionPublic Sub clocn()
On Error Resume Next
If conn.State <> adStateClosed Then conn.Close
Set conn = Nothing
End Sub
Public Function openrs(ByVal strSql As String) As Boolean
Dim mag As String
Dim rpy As Boolean
On Error GoTo strerrmag
Set rs = New ADODB.Recordset
'If addFlag = False Then rpy = True
With rs
.ActiveConnection = conn
.CursorLocation = adUseClient
.CursorType = adOpenKeyset
.LockType = adLockOptimistic
.Open strSql, , , , adAsyncExecute
Do While rs.State <> adStateClosed And rs.State <> adStateOpen
Sleep 50
DoEvents
Loop
End With
'addFlag = True
openrs = True
Exit Function
strerrmag:
mag = "data not connect"
Call MsgBox(mag, vbOKOnly, "error:connect")
openrs = False
End Function
Public Sub clors()
On Error Resume Next
If rs.State <> adStateClosed Then rs.Clone
Set rs = Nothing
End Sub
call 模块名.OpenCn
If 模块名.openrs(strSQL)=true then
……
Else
……
End
call 模块名.clors
call 模块名.clocn
其中,strSQL为所要写的SQL语句