How to Add Data Environment in VB6 using Microsoft OLEDB Provider For SQL Server as a Data Source for SQL Server Database
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 SQL Server,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.) At this time i used the Windows NT Integrated Security and if you want to access your
this is the way of Sql Server Authentication:
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 SQL Server,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.) At this time i used the Windows NT Integrated Security and if you want to access your
server on SQL Server Authentication just select Specific User name and password, 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
this is the way of Sql Server Authentication:
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