MyOLEDB Doesn't support commands like SHOW FIELDS, SHOW TABLES

[Mike]

My code is shown below, I can select * from employees but I cannot get
any data back from SHOW FIELDS, I do not receive an error, in fact,
something is returned but I'm not sure what. I can execute the
command:

SHOW FIELDS FROM test.employees

in the Control Center just fine, even cmd.ExecuteRead er will enter
reader.Read() once, something is returned but what does it look like?

=============== =============

OleDbConnection cn = new OleDbConnection (@"Provider=MyS QLProv;Data
Source=test;DB= test;UID=;PWD=; PORT=3306");

cn.Open();
OleDbCommand cmd = new OleDbCommand("S HOW FIELDS FROM test.employees" ,
cn);
cmd.CommandType = CommandType.Tex t;
DataTable metaData = new DataTable();
OleDbDataAdapte r ad = new OleDbDataAdapte r();
ad.SelectComman d = cmd;
ad.Fill(metaDat a);

=============== ============

[swdev1]

Wow - looks like visual basic.
switch to Visual FoxPro, establish your connection handle via your ole db
hook -
and then use the sqltables() and sqlcolumns() functions.
works very well.. Course - you'd be changing your programming language
completely to something
that is easier for manipulating data - and thats not a bad thing..
hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"Mike" <de**********@h otmail.com> wrote in message
news:95******** *************** ***@posting.goo gle.com...

My code is shown below, I can select * from employees but I cannot get
any data back from SHOW FIELDS, I do not receive an error, in fact,
something is returned but I'm not sure what. I can execute the
command:

SHOW FIELDS FROM test.employees

in the Control Center just fine, even cmd.ExecuteRead er will enter
reader.Read() once, something is returned but what does it look like?

=============== =============

OleDbConnection cn = new OleDbConnection (@"Provider=MyS QLProv;Data
Source=test;DB= test;UID=;PWD=; PORT=3306");

cn.Open();
OleDbCommand cmd = new OleDbCommand("S HOW FIELDS FROM test.employees" ,
cn);
cmd.CommandType = CommandType.Tex t;
DataTable metaData = new DataTable();
OleDbDataAdapte r ad = new OleDbDataAdapte r();
ad.SelectComman d = cmd;
ad.Fill(metaDat a);

=============== ============

[swdev1]

Wow - looks like visual basic.
switch to Visual FoxPro, establish your connection handle via your ole db
hook -
and then use the sqltables() and sqlcolumns() functions.
works very well.. Course - you'd be changing your programming language
completely to something
that is easier for manipulating data - and thats not a bad thing..
hth - mondo regards [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:ex****** **@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"Mike" <de**********@h otmail.com> wrote in message
news:95******** *************** ***@posting.goo gle.com...

My code is shown below, I can select * from employees but I cannot get
any data back from SHOW FIELDS, I do not receive an error, in fact,
something is returned but I'm not sure what. I can execute the
command:

SHOW FIELDS FROM test.employees

in the Control Center just fine, even cmd.ExecuteRead er will enter
reader.Read() once, something is returned but what does it look like?

=============== =============

OleDbConnection cn = new OleDbConnection (@"Provider=MyS QLProv;Data
Source=test;DB= test;UID=;PWD=; PORT=3306");

cn.Open();
OleDbCommand cmd = new OleDbCommand("S HOW FIELDS FROM test.employees" ,
cn);
cmd.CommandType = CommandType.Tex t;
DataTable metaData = new DataTable();
OleDbDataAdapte r ad = new OleDbDataAdapte r();
ad.SelectComman d = cmd;
ad.Fill(metaDat a);

=============== ============