modcon.bas

来自「串口调试相关源码」· BAS 代码 · 共 28 行

Attribute VB_Name = "Modcon"
Global cn As ADODB.Connection
Public computername As String   '用于存储得到的计算机名字

Option Explicit

Public Declare Function GetTickCount Lib "kernel32" () As Long
Global m_id As Single '定义个编号，也就是是那个猫收到的数据进行处理

Public Sub MakeConnection()
On Error GoTo err_exit

Dim ipadd$
Open App.Path + "\ip.txt" For Input As #1
Input #1, ipadd
Close #1
Set cn = New ADODB.Connection
  With cn
    .ConnectionString = "Driver=SQL Server;Server=" + ipadd + ";DataBase=saige;uid=sa;pwd=sa;"
    .Open
  End With
Exit Sub
err_exit:
       MsgBox ("数据库连接错误，请确认主机的ip地址！")
      End
End Sub