Create VB.Net Connection With SQL Server using ODBC. After creating database in SQL Server see Create VB.Net Connection With SQL Server (Part 1), next step is creating ODBC in control panel :
Previously we have made through the CONTROL PANEL CONNECTIONS - Administration Tools - ODBC, which serves to make the connection to the Database to be used which will be used for LINK TO APLICATION and REPORT.
By using ODBC, then all our database connections can easily be provided NAME / DRIVER DATABASE they have been listing in ODBC.
STEP TO CREATE ODBC :
1. Open Control Panel - Administrative Tools - Choose ODBC
2. In ODBC Data Source Administrator choose User DSN Tab
3. Click Add
4. In Create New Data Source Dialog choose "SQL Server"
5. For this connection use ODBC_WORKSHOP as name of connection, Server = Local and choose WORKSHOP for database.
Previously we have made through the CONTROL PANEL CONNECTIONS - Administration Tools - ODBC, which serves to make the connection to the Database to be used which will be used for LINK TO APLICATION and REPORT.
By using ODBC, then all our database connections can easily be provided NAME / DRIVER DATABASE they have been listing in ODBC.
1. Open Control Panel - Administrative Tools - Choose ODBC
3. Click Add
4. In Create New Data Source Dialog choose "SQL Server"
5. For this connection use ODBC_WORKSHOP as name of connection, Server = Local and choose WORKSHOP for database.
No comments:
Post a Comment