HTTP<\/span><\/span><\/a>]<\/p>\n <\/p>\n
Imports Microsoft.Data.Odbc<\/p>\n
Public Class Form1
\nInherits System.Windows.Forms.Form<\/p>\n
#Region ” Windows Form Designer generated code ”<\/p>\n
Public Sub New()
\nMyBase.New()<\/p>\n
‘This call is required by the Windows Form Designer.
\nInitializeComponent()<\/p>\n
‘Add any initialization after the InitializeComponent() call<\/p>\n
End Sub<\/p>\n
‘Form overrides dispose to clean up the component list.
\nProtected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
\nIf disposing Then
\nIf Not (components Is Nothing) Then
\ncomponents.Dispose()
\nEnd If
\nEnd If
\nMyBase.Dispose(disposing)
\nEnd Sub<\/p>\n
‘Required by the Windows Form Designer
\nPrivate components As System.ComponentModel.IContainer<\/p>\n
‘NOTE: The following procedure is required by the Windows Form Designer
\n‘It can be modified using the Windows Form Designer.
\n‘Do not modify it using the code editor.
\nFriend WithEvents Button1 As System.Windows.Forms.Button
\nFriend WithEvents TextBox1 As System.Windows.Forms.TextBox
\nFriend WithEvents password As System.Windows.Forms.TextBox
\nFriend WithEvents hpgroup As System.Windows.Forms.TextBox
\nFriend WithEvents Button2 As System.Windows.Forms.Button
\nFriend WithEvents Label1 As System.Windows.Forms.Label
\nFriend WithEvents Label2 As System.Windows.Forms.Label
\nFriend WithEvents Label3 As System.Windows.Forms.Label
\n<system.diagnostics.debuggerstepthrough()>\u00a0Private Sub InitializeComponent()
\nMe.Button1 = New System.Windows.Forms.Button()
\nMe.TextBox1 = New System.Windows.Forms.TextBox()
\nMe.password = New System.Windows.Forms.TextBox()
\nMe.hpgroup = New System.Windows.Forms.TextBox()
\nMe.Button2 = New System.Windows.Forms.Button()
\nMe.Label1 = New System.Windows.Forms.Label()
\nMe.Label2 = New System.Windows.Forms.Label()
\nMe.Label3 = New System.Windows.Forms.Label()
\nMe.SuspendLayout()
\n‘
\n‘Button1
\n‘
\nMe.Button1.Location = New System.Drawing.Point(136, 24)
\nMe.Button1.Name = “Button1”
\nMe.Button1.Size = New System.Drawing.Size(112, 30)
\nMe.Button1.TabIndex = 2
\nMe.Button1.Text = “Use ADO”
\n‘
\n‘TextBox1
\n‘
\nMe.TextBox1.Location = New System.Drawing.Point(192, 200)
\nMe.TextBox1.Name = “TextBox1”
\nMe.TextBox1.ReadOnly = True
\nMe.TextBox1.Size = New System.Drawing.Size(200, 20)
\nMe.TextBox1.TabIndex = 1
\nMe.TextBox1.TabStop = False
\nMe.TextBox1.Text = “TextBox1”
\n‘
\n‘password
\n‘
\nMe.password.Location = New System.Drawing.Point(192, 96)
\nMe.password.Name = “password”
\nMe.password.PasswordChar = Microsoft.VisualBasic.ChrW(42)
\nMe.password.Size = New System.Drawing.Size(200, 20)
\nMe.password.TabIndex = 0
\nMe.password.Text = “”
\n‘
\n‘hpgroup
\n‘
\nMe.hpgroup.Location = New System.Drawing.Point(192, 136)
\nMe.hpgroup.Name = “hpgroup”
\nMe.hpgroup.Size = New System.Drawing.Size(200, 20)
\nMe.hpgroup.TabIndex = 1
\nMe.hpgroup.Text = “PUB”
\n‘
\n‘Button2
\n‘
\nMe.Button2.Location = New System.Drawing.Point(280, 24)
\nMe.Button2.Name = “Button2”
\nMe.Button2.Size = New System.Drawing.Size(112, 32)
\nMe.Button2.TabIndex = 3
\nMe.Button2.Text = “Use ODBC .NET”
\n‘
\n‘Label1
\n‘
\nMe.Label1.Location = New System.Drawing.Point(88, 96)
\nMe.Label1.Name = “Label1”
\nMe.Label1.Size = New System.Drawing.Size(88, 24)
\nMe.Label1.TabIndex = 4
\nMe.Label1.Text = “User Password”
\n‘
\n‘Label2
\n‘
\nMe.Label2.Location = New System.Drawing.Point(88, 136)
\nMe.Label2.Name = “Label2”
\nMe.Label2.Size = New System.Drawing.Size(88, 24)
\nMe.Label2.TabIndex = 5
\nMe.Label2.Text = “HP Group”
\n‘
\n‘Label3
\n‘
\nMe.Label3.Location = New System.Drawing.Point(88, 200)
\nMe.Label3.Name = “Label3”
\nMe.Label3.Size = New System.Drawing.Size(88, 24)
\nMe.Label3.TabIndex = 6
\nMe.Label3.Text = “Sample Result”
\n‘
\n‘Form1
\n‘
\nMe.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
\nMe.ClientSize = New System.Drawing.Size(616, 374)
\nMe.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label3, Me.Label2, Me.Label1, Me.Button2, Me.hpgroup, Me.password, Me.TextBox1, Me.Button1})
\nMe.Name = “Form1”
\nMe.Text = “Form1”
\nMe.ResumeLayout(False)<\/p>\n
End Sub<\/p>\n
#End Region<\/p>\n
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
\nDim conn As New ADODB.Connection()
\nDim rs As New ADODB.Recordset()<\/p>\n
TextBox1.Text = “busy…”
\nApplication.DoEvents()<\/p>\n
conn.Open(“DRIVER=HP3000 Data Access Driver;” & _
\n“2DriverTable=;” & _
\n“Database0=MSCARD.MM.MINISOFT,DO-ALL,N,1;” & _
\n“2HostTable=Customers;” & _
\n“Server=192.168.23.70;” & _
\n“Server Port=2185;” & _
\n“Jobname=MSJOB;” & _
\n“User=MGR;” & _
\n“User Password=” & password.Text & “;”& _
\n“Group=” & hpgroup.Text & “;” & _
\n“Account=MINISOFT”)<\/p>\n
rs.Open(“SELECT * FROM CUSTOMER”, conn)<\/p>\n
rs.MoveFirst()<\/p>\n
TextBox1.Text = CStr(rs.Fields(2).Value)<\/p>\n
End Sub<\/p>\n
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click<\/p>\n
Dim conn As New OdbcConnection()<\/p>\n
Dim myConnString As String = _
\n“DRIVER=HP3000 Data Access Driver;” & _
\n“2DriverTable=;” & _
\n“Database0=MSCARD.MM.MINISOFT,DO-ALL,N,1;” & _
\n“2HostTable=Customers;” & _
\n“Server=192.168.23.70;” & _
\n“Server Port=2185;” & _
\n“Jobname=MSJOB;” & _
\n“User=MGR;” & _
\n“User Password=” & password.Text & “;” & _
\n“Group=” & hpgroup.Text & “;” & _
\n“Account=MINISOFT”<\/p>\n
Dim mySelectCommandText As String = _
\n“SELECT * FROM CUSTOMER”<\/p>\n
TextBox1.Text = “busy…”
\nApplication.DoEvents()<\/p>\n
conn.ConnectionString = myConnString<\/p>\n
conn.Open()<\/p>\n
Dim myCommand As New OdbcCommand(mySelectCommandText, conn)
\nDim myReader As OdbcDataReader
\nmyReader = myCommand.ExecuteReader()
\nIf myReader.Read() Then
\nTextBox1.Text = myReader.GetString(2)
\nElse
\nTextBox1.Text = “error”
\nEnd If<\/p>\n
End Sub
\nEnd Class<\/p>\n","protected":false},"excerpt":{"rendered":"
Download the sample: [HTTP] Imports Microsoft.Data.Odbc Public Class Form1 Inherits System.Windows.Forms.Form #Region ” Windows Form Designer generated code ” Public Sub New() MyBase.New() ‘This call is required by the Windows Form Designer. InitializeComponent() ‘Add any initialization after the InitializeComponent() call End Sub ‘Form overrides dispose to clean up the component list. Protected Overloads […]<\/p>\n","protected":false},"author":75,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,63],"tags":[],"_links":{"self":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2327"}],"collection":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/users\/75"}],"replies":[{"embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/comments?post=2327"}],"version-history":[{"count":3,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2327\/revisions"}],"predecessor-version":[{"id":2331,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/posts\/2327\/revisions\/2331"}],"wp:attachment":[{"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/media?parent=2327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/categories?post=2327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/c002.minisoft.com\/support\/wp-json\/wp\/v2\/tags?post=2327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}