Attribute VB_Name = "Module1"
Public temp, Str, BS As String
Public adoCon As New ADODB.Connection
Public adoRs As New ADODB.Recordset
Public Sub main()
adoCon.Open "Provider=MSDASQL.1;Persist Security Info=False;User ID=sa;Data Source=tsgl"
End Sub

Function cnn() As ADODB.Connection
  Set cnn = New ADODB.Connection
  cnn.Open "DSN=tsgl;UID=sa;"
End Function