ODBC Data source
1. What is ODBC
ODBC (Open DB connectivity, open Database interconnection), is currently the international common Database access standards.
2. What is an ODBC data source
An ODBC data source is a tool for ODBC configuration and management on your computer that enables users to customize the use of ODBC to mail 狻?br>
Oracle 9i Client
Process Analysis of VB program connecting with Database
1. vb program Specify DSN name
2. "ODBC data source" resolves the DSN name
3. Oracle 9i Client resolution database server name
4. The database server verifies the user name and password in the DSN
How to establish an ODBC data source
(1) The User DSN tab of the ODBC Data Source Manager as shown in Figure 10.6.
(2) switch to the System DSN tab of the ODBC Data Source Manager as shown in Figure 10.7.
(3) The "Create New Data Source" interface, as shown in Figure 10.8, appears.
(4) The Microsoft ODBC for Oracle Setup interface, as shown in Figure 10.9, appears.
(5) The System DSN tab after the successful establishment of the System DSN name is shown in Figure 10.10.