How to connect to ODBC data source through C#. net

Hi experts,
I am doing an application which takes the DSN name from user in text
box and then open the ODBC data source dialog box. i.e. I want the
(ODBC data source administrator) form which comes after clicking on
ODBC data source icon in administrative tools.
Now my problem is that is it possible to call that system form
(utility) through my program or I have to design the same form (ODBC
data source administrator).
If I can call that form then please tell me how....i can do that?
Any help will be appreciated.
Thanks
DineshYou would be better off posting this in a C# newsgroup. This is for
Reporting Services.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Dinesh" <dinesht15@.gmail.com> wrote in message
news:1166091132.509799.4510@.f1g2000cwa.googlegroups.com...
> Hi experts,
> I am doing an application which takes the DSN name from user in text
> box and then open the ODBC data source dialog box. i.e. I want the
> (ODBC data source administrator) form which comes after clicking on
> ODBC data source icon in administrative tools.
> Now my problem is that is it possible to call that system form
> (utility) through my program or I have to design the same form (ODBC
> data source administrator).
> If I can call that form then please tell me how....i can do that?
> Any help will be appreciated.
> Thanks
> Dinesh
>

How to Configure DSN with DataReader Source

Hi
I am not able configure DSN in SSIS, I tired with DataReader Source but its given error
" Check SQL Command Property"
Appriciate to you for Help

Errr....try checking the SQLCommand property. What is it set to?
What is a DSN in SSIS?

You have to provide more specific info if you really want people to help.

-Jamie|||

Hi Jamie

I made one DSN which pointing Excel Driver, But when Create Connection Manager for these DSN by using ADO.NET Connection Manager.
When i configure this connection manager in DataReader Source its give as error "check SQL Command property"
Here I am ot able to set SQL Commmand property
so please Help me to set the property with any example

|||If you are connecting to Excel, why give yourself the added grief of maintaining an external DSN? Use the OLE DB Provider for Jet and a file path. ODBC simply adds one more unnecessary layer of DLLs in the background.

-Doug|||Thanks Doug
I got it from OLE DB,Thanks again for your help