Database Schema using ODBC Connection

[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.

 

[Cor Ligthert [MVP]]

Rohit,

It is just at MSDN, what do you mean?

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

Cor

 

[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

Rohit,

It is just at MSDN, what do you mean?

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

Cor

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.

 

[Paul Clement]

¤ 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)

 

[Rohit]

Hi ,

Paul there is a support for getting the schema using ODBC.NET.

Check out this link.

http://eggheadcafe.com/ng/microsoft.public.dotnet.framework.odbcnet/post101797.asp

Regards,
Rohit

 

[Paul Clement]

¤ Hi ,
¤
¤ Paul there is a support for getting the schema using ODBC.NET.
¤
¤ Check out this link.
¤
¤ http://eggheadcafe.com/ng/microsoft.public.dotnet.framework.odbcnet/post101797.asp
¤

The link to the example you posted uses ADO and not ADO.NET (or ODBC.NET).

Just so you know, ADO is a COM based library so you are essentially using COM interop. If that is OK
with you then OpenSchema will do the job.


Paul
~~~~
Microsoft MVP (Visual Basic)

 

[Rohit]

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