Database Schema using ODBC Connection

  • Thread starter Thread starter Rohit
  • Start date Start date
R

Rohit

Hello,

I am creating a ODBC Connection to the SQL Server and I want the listing of
tables and columns.

How can I acheive this? I dont want to use a OLEDB Connection,

Regards,
Rohit.
 
Hi Cor,

I need to have the listing of tables and columns from the Database to which
the User connects using ODBC.

The link you have provided will only gimme the Table Schema.

Regards,
Rohit

Cor Ligthert said:
Rohit,

It is just at MSDN, what do you mean?

http://msdn.microsoft.com/library/d...dbcodbcdatareaderclassgetschematabletopic.asp

Cor
Click to expand...
Hello,

I am creating a ODBC Connection to the SQL Server and I want the listing of
tables and columns.

How can I acheive this? I dont want to use a OLEDB Connection,

Regards,
Rohit.
 
¤ Hello,
¤
¤ I am creating a ODBC Connection to the SQL Server and I want the listing of
¤ tables and columns.
¤
¤ How can I acheive this? I dont want to use a OLEDB Connection,

There currently is no support for table/column schema in ODBC.NET.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Hi Paul,

Yes , I understand the difference,But to get the Schema I could not get a
better solution other than to use ADO.

Do you think it will create any issues?

Regards,
Rohit
 
Back
Top