srini vasan

srini vasan

  • NA
  • 1
  • 0

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

Sep 20 2005 1:09 AM
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