在VB中如何判断程序所在的电脑有没有安装SQL SERVER?
解决方案 »
- 大伙帮我看看,看缺点啥?
- 大家新年好!问题不难,就是奇怪,UP者也有分,分不够可以再加!谢谢!
- 可不可以将dbgrid 的datasource 的值设置为recordset对象?
- 小弟有问题想请各位大虾们帮忙
- 怎样关闭RICHTEXTBOX用loadfile方法打开的文件
- 如何把数据库中的数据导出到文件中,即备件数据库中的数据
- 水晶报表中定义的参数字段,如何在水晶报表预览前,将实际的值传递给它们
- 为日期型字段赋空值
- 关于情内存的问题!
- 请教一个关于visual basic6.0的问题
- 問個問題。。。如何讓窗體有滾動條啊。。。只滾動一部份。。。上邊有菜單。。。分不夠可以加加加。。。
- 再问DLL===============
On Error GoTo ErrHandler
Dim conOnlineBank As ADODB.Connection
Set conOnlineBank = New Connection
With conOnlineBank
.CommandTimeout = 5
.ConnectionString = "User ID=sa;Password=;data source ='127.0.0.1';Initial Catalog=OnlineBanking"
.Provider = "SQLOLEDB"
.Open
End With
Exit Sub
ErrHandler:
If Err.Number = -2147467259 Then
MsgBox "SQL数据库不存在"
End If
Dim ServerName() As String
Dim Server As String
Dim I As Long
Dim j As LongPublic Function SQLServerList(ByRef strServerName() As String, _
Optional ByRef rlngErrNum As Long, _
Optional ByRef rstrErrDescr As String) As Boolean
Dim objServerApp As SQLDMO.Application
Dim objServers As SQLDMO.NameList
Dim lngServerCount As Long
On Error GoTo SQLServerListErr
SQLServerList = False
Set objServerApp = New SQLDMO.Application
Set objServers = objServerApp.ListAvailableSQLServers
lngServerCount = objServers.Count
ReDim strServerName(lngServerCount - 1)
For I = 1 To lngServerCount
strServerName(I - 1) = objServers.Item(I)
Next I
SQLServerList = True
Err.Clear
SQLServerListErr:
Set objServers = Nothing
Set objServerApp = Nothing
rlngErrNum = Err.Number
rstrErrDescr = Err.Description
End FunctionPrivate Sub Command1_Click()
Dim strString As String
strString = String(255, Chr$(0))
'得到计算机名
GetComputerName strString, 255
strString = Left$(strString, InStr(1, strString, Chr$(0)) - 1)
Call SQLServerList(ServerName())
For I = 0 To UBound(ServerName)
If ServerName(I) = strString Or ServerName(I) = "(local)" Then MsgBox "有"
Exit Sub
Next
End Sub
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup