Public Function Command_Click() Dim sKeyName As String, sKeyValue As String, sKeyValueIcon As String Dim Ret As Integer, lphKey As Long If DCN.State = "1" Then sKeyName = "Software\Microsoft\Windows\CurrentVersion\Run" sKeyValue = "C:\PcposX8\Suntouch.exe" Ret = RegCreateKey&(HKEY_LOCAL_MACHINE, sKeyName, lphKey) Ret = RegSetValue&(lphKey&, "", REG_SZ, sKeyValue, 0&) Else Delay (100) Call Command_Click End If End Function如何判断mysql已经先于程序启动?
Public Function CreateConnection(ByVal pProvider As String, pDataSource As String) As ADODB.Connection Dim oCn As ADODB.Connection
Set oCn = New ADODB.Connection oCn.CursorLocation = adUseClient Delay (100) oCn.Open NMySqlCon Set CreateConnection = oCn End Function这个是连接MYSQL数据库,每次开机出错是oCn.Open NMySqlCon 发现连不上本地MYSQL服务器,要等一会就可以了。
程序启动时检测数据库连接,连接成功后停止检测,转入正常功能。不必判断mysql是否先于程序启动
Public Function CreateConnection(ByVal pProvider As String, pDataSource As String) As ADODB.Connection Dim oCn As ADODB.Connection
Set oCn = New ADODB.Connection oCn.CursorLocation = adUseClient oCn.Open NMySqlCon Set CreateConnection = oCn End Function 我把程序加入注册表之后,开机运行,启动到oCn.Open NMySqlCon时,显示没有连接本地mysql数据库。 开机是先运行程序,然后在运行进程中的MYSQL服务器的。请问如何解决?
这个API函数可以贴出来吗?
查看 如果sql没启动 就sleep一次 然后再查看
msgbox "已经启动"
else
msgbox "未启动"
end if
netstat -ant | grep 3306 #查看mysql是否启动,mysql用的是3306端口
Dim sKeyName As String, sKeyValue As String, sKeyValueIcon As String
Dim Ret As Integer, lphKey As Long
If DCN.State = "1" Then
sKeyName = "Software\Microsoft\Windows\CurrentVersion\Run"
sKeyValue = "C:\PcposX8\Suntouch.exe"
Ret = RegCreateKey&(HKEY_LOCAL_MACHINE, sKeyName, lphKey)
Ret = RegSetValue&(lphKey&, "", REG_SZ, sKeyValue, 0&)
Else
Delay (100)
Call Command_Click
End If
End Function如何判断mysql已经先于程序启动?
Dim oCn As ADODB.Connection
Set oCn = New ADODB.Connection
oCn.CursorLocation = adUseClient
Delay (100)
oCn.Open NMySqlCon
Set CreateConnection = oCn
End Function这个是连接MYSQL数据库,每次开机出错是oCn.Open NMySqlCon
发现连不上本地MYSQL服务器,要等一会就可以了。
Dim oCn As ADODB.Connection
Set oCn = New ADODB.Connection
oCn.CursorLocation = adUseClient
oCn.Open NMySqlCon
Set CreateConnection = oCn
End Function 我把程序加入注册表之后,开机运行,启动到oCn.Open NMySqlCon时,显示没有连接本地mysql数据库。
开机是先运行程序,然后在运行进程中的MYSQL服务器的。请问如何解决?