database DSN

Question

how to make a dsn to a database you made in sql server 2005 express.

Answer 1

You can creat either by notepad and writing manualy all paramaters, or copy that file content from some other dsn file and modify it.
Or you can do that with dsn file wizard: Go to Control Panel\Administrative Tools\Data Sources(ODBC), go to third tab "File dsn" and click add, browse for file location and create a standard connection. After you finish with all settings about connection, file will be created with all that parameters.

Is there a good reason to still in these days of using dsn files? If you work with .NET there is many new ways, but more important better and easy to access storrage posibilities.

Answer 2

well i prefer to be able to connect to the database from within my vcsharp application, using a connection string and thru ODBC but i have not figured out a way of doing this yet. ive tried changing the app.conf file,the settings in it,but no luck there lol,also this is a console application,so the data control binding an all that no work for me