Diagram of various database data sources (ODBC) configuration __ Database

1.       Start the system data source; 2.       new Access data source; a.      Click "Add", select "Microsoft Access Driver (*.mdb)" Drive, click "Finish";   b.      Enter "data source name" and "description" in turn, and click on "Select" button;   c.      in the Select Database window, look for the "MDB" file you are using, select it, and then "OK";

    d.     window below, if you want to higher configuration to open "advanced" and "Options", click "OK", the configuration is completed;   3.       New SQL Server data source; a.      Click "Add", select "SQL Server" driver, click "Finish";   b.      Enter "data source name" and "description" in turn, and click on the server, or directly input, click "Next";   c.      then enter "username" and "password", click "Next";   d.     window below, you can choose the default access to the database, click "Next";   e.      window below, click "Finish", the configuration is complete;   4.       new Oracle data sources; a.      Click "Add", select "Microsoft ODBC for Oracle" driver, click "Finish";   b.      Enter "data source name", "description", login "username", "Server" (is the server name of Oracle client configuration, as described below), if you want advanced configuration to open the options setting; The configuration file Tnsnames.ora part is as follows, the red name is "server" configuration name: HEADPMS3 =   (DESCRIPTION =     (address_list =        (address = (PROTOCOL = TCP) (HOST = 192.168.0.3) (PORT = 1521))    )     ( Connect_data =    &Nbsp;  (service_name = Headpms)    )           c.  click "OK" and the configuration is complete.