Loading

how to take user defined tablename from a database ----query using odbc

srini vasan

hi
i used a sqlquery to select the user defined tables in database like this

SELECT name FROM sysobjects WHERE type ='u'

when i use the same using odbc like the below it fails to retrieve to the table names

OdbcCommand cmd=new OdbcCommand("SELECT name FROM sysobjects WHERE type ='u' ",con);

thankx in advance
srini

Replies

Know the answer? Post it — somebody with the same question will find it here.