How to create ODBC connection strings by setup?

[alim]

When we use ODBC connection string , users have to create the connection string most of the time but some applications like Northwind Sample DB have the capability to create their connection string in ODBC directory by the setup instance .. how I can do that?

 

[cjard]

You mean a DSN in the datasources control panel?

Why even do that? Why not just put the conenction string with your app so the user isnt having to set it?

 

[alim]

Yeah you are right @Cjard , I am talking about DSN in the datasources at control panel ..
But I don't know how to set it in the app .. can you teach me .. please..

and can you tell me how northwind setup works.

thanks...

 

[cjard]

I don't use DSNs. It's much easier to just use the connection string you want within your app

 

[alim]

like how sql express edition does..

 

[cjard]

er. yeah. A DSN is only a connection string stored in the registry (or whatever) -> not much poiont using that and trying to make it if you can just put the connection string in your app..

The only time you'd use a dsn was if a legacy program needed it