1.) First you must click the Project Tab shown in the figure below,Then Click Add Data
Environment
2.) Connection Environment will Appear
3.) To connect to Data Source Name,just right-click the connection,then click properties like
shown on the image below
4.) Data Link Properties dialog will appear and select Microsoft OLEDB Provider For
OBDC Drivers,then Click Next
5.) From the Connection Tab,select the button Use data source name, then press the drop
down button of the combo box then select your DSN file listed,like what i did
7.) then press Test Connection,if you done this tutorial correctly this is the result.
Happy Coding ^_^
"The Hardest Thing to Do is to Do Nothing"
Environment
2.) Connection Environment will Appear
3.) To connect to Data Source Name,just right-click the connection,then click properties like
shown on the image below
4.) Data Link Properties dialog will appear and select Microsoft OLEDB Provider For
OBDC Drivers,then Click Next
5.) From the Connection Tab,select the button Use data source name, then press the drop
down button of the combo box then select your DSN file listed,like what i did
6.) then at User Name:(enter the username of your server) password:(enter your server
password) then at the Enter Initial catalog to use: just select your listed server database
7.) then press Test Connection,if you done this tutorial correctly this is the result.
Happy Coding ^_^
"The Hardest Thing to Do is to Do Nothing"
Posts
Leave a comment