Odbc data source....

[invader7]

Good afternoon everybody, i want to ask something, i want to connect to database using the visual studio menu Tools - > Connect to database... i want the data source to be odbc... i made it some days before but i formated my pc and i don't remember how i did it... the reason to do this is because if i use Microsoft SQL Server Database File (SqlClient) the config file will store the password to connect to the database... but with odbc it will store only dsn=mydsn.... please help me

[Shuja Ali]

Not really an ideal way of doing it. You should use the SQLClient rather than ODBC. What is wrong in storing the uid/pwd in config file? If you are concerned about security, same things can be done with DSN too. All the person needs to know is how to connect using a DSN, thats all.

[invader7]

i want to do it because with uid/pass on config all people will know the password but if they see dsn they could not find out the password, the dsn will be pre-configured by me in each pc....

[Shuja Ali]

I have never tried this, but you can check "Microsoft ODBC Data Source (ODBC)" in the options that you get when you click on Connect to database.

[invader7]

yes i know, i made it in another pc but now it hasn't that option on connect to database.... i wonder how to make it display there in order to select it...