Hi,


I've got a Windows form Form1 with a button button1 and the
code below.
The OleDb fillschema doesn't seem to work.
ASA 11.0.0.1549

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

using iAnywhere.Data.SQLAnywhere;
using System.Data.Odbc;
using System.Data.OleDb;
namespace asatEST
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();

}


private void ShowFillschema()
{
this.fillschemaNet();
MessageBox.Show(".net Provier");
dataGrid.DataSource = "";
this.fillschemaODBC();
MessageBox.Show("ODBC");
dataGrid.DataSource = "";
this.fillschemaOleDB();
MessageBox.Show("OleDB");
}
private void fillschemaNet()
{
iAnywhere.Data.SQLAnywhere.SAConnection conn =
new
SAConnection("UserID=dba;Password=sql;DataSourceNa me=SANorthwindMM");
conn.Open();
iAnywhere.Data.SQLAnywhere.SADataAdapter adapter
= new SADataAdapter("SELECT * FROM Employees", conn);
DataTable dataTable = new DataTable("Table");
adapter.FillSchema(dataTable,
SchemaType.Source);
conn.Close();
dataGrid.DataSource = dataTable;
}

private void fillschemaODBC()
{
System.Data.Odbc.OdbcConnection conn = new
OdbcConnection("dsn=MyNorthWindODBC");
conn.Open();
System.Data.Odbc.OdbcDataAdapter adapter = new
OdbcDataAdapter("SELECT * FROM Employees", conn);
DataTable dataTable = new DataTable("Table");
adapter.FillSchema(dataTable,
SchemaType.Source);
conn.Close();
dataGrid.DataSource = dataTable;
}
private void fillschemaOleDB()
{
System.Data.OleDb.OleDbConnection conn = new
OleDbConnection("Provider=SAOLEDB.11;Data
Source=SANorthwindMM;User ID=dba;Password=sql;Initial
Catalog=SANorthwindMM");
conn.Open();
System.Data.OleDb.OleDbDataAdapter adapter = new
OleDbDataAdapter("SELECT * FROM Employees", conn);
DataTable dataTable = new DataTable("Table");
adapter.FillSchema(dataTable,
SchemaType.Source);
conn.Close();
dataGrid.DataSource = dataTable;

}

private void button1_Click(object sender, EventArgs
e)
{

this.ShowFillschema();

}
}
}