Icon View Incident Report

Serious Serious
Reported By: Jesper Peterson
Reported On: 10/24/2002
For: Version 3.19 Build 1
# 1268 ODBC Driver Not Working Properly Under VS.NET and Causing a System Error

After getting the driver to work in the VS.Net server explorer I thought it would be no trouble getting it to work in my programs. But now I've tried a very simple example in both C# and VB The lines with the >>>>>>>>>>>>>>> cause exception "System Error".
I've tried a small variety of different column specifications but it makes no difference.

C# Version

using Microsoft.Data.Odbc;
private void button1_Click(object sender, System.EventArgs e)
OdbcConnection dbC35 = new OdbcConnection(@"dsn=clan35;");
OdbcCommand cmC35 = new OdbcCommand();
cmC35.Connection = dbC35;
cmC35.CommandType = CommandType.Text;
cmC35.CommandText = @"select * from membertype";
OdbcDataReader rsC35 = cmC35.ExecuteReader();
while (rsC35.Read())
this.textBox1.Text += (string)rsC35["Description"] + Environment.
>>>>>>>>>>>>>>>> dbC35.Close();

VB7 Version

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles Button1.Click

Dim dbC35 As New Microsoft.Data.Odbc.OdbcConnection("dsn=clan35;")
Dim rsC35 As Microsoft.Data.Odbc.OdbcDataReader
Dim cmC35 As New Microsoft.Data.Odbc.
OdbcCommand("select * from membertype",
cmC35.CommandType = CommandType.Text
rsC35 = cmC35.ExecuteReader()
While rsC35.Read()
TextBox1.Text = TextBox1.Text & rsC35.Item("Description") &
End While
>>>>>>>>>>>>>>> rsC35.Close()
End Sub

Comments Comments
The problem was with VS.NET calling the SQLMoreResults ODBC API call, which DBISAM did not implement.

Resolution Resolution
Fixed Problem on 11/12/2002 in version 3.20 build 1