Hello guys - You can create DSN for the sql server Databases using below steps
In this window you have to select provider corresponding to your database. As we want to connect to sql server database, I have selected "sql server".
Next you have to give the name for dsn and provide sql server name. Then click on next
Next screen you will be asked for the user id and password. If you are using windows authentication mode, you don't need to do anything on this screen. Click next.
Then you have to click on next and finally you can test your data source as well
You should see below message on the final window.
You are done. Now You can access your database from any language using this dsn name.
What do you think on this topic? Please express your opinion through comment below
- Open Control Panel
- Click on Administrative tools
- Select Data Sources (ODBC)
- DSN Configuration window Opens as shown below.
After you get this window, follow below steps.
- Select System DSN Tab and click on Add button
- You will see below window where you will have to select a database provider.
In this window you have to select provider corresponding to your database. As we want to connect to sql server database, I have selected "sql server".
Next you have to give the name for dsn and provide sql server name. Then click on next
Next screen you will be asked for the user id and password. If you are using windows authentication mode, you don't need to do anything on this screen. Click next.
Then you have to click on next and finally you can test your data source as well
You should see below message on the final window.
You are done. Now You can access your database from any language using this dsn name.
What do you think on this topic? Please express your opinion through comment below
