odbc in vb6.0

1 ANSWERS

1. Jessica_Nancy
   

   A Data Source Name (DSN) is the logical name that is used by Open Database Connectivity (ODBC) to refer to the drive and other information that is required to access data. The name is used by Internet Information Services (IIS) for a connection to an ODBC data source, such as a Microsoft SQL Server database. To set this name, use the ODBC tool in Control Panel.
   
   Create a System DSN
   
      1. Click Start, point to Control Panel, double-click Administrative Tools, and then double-click Data Sources(ODBC).
      2. Click the System DSN tab, and then click Add.
      3. Click the database driver that corresponds with the database type to which you are connecting, and then click Finish.
      4. Type the data source name. Make sure that you choose a name that you can remember. You will need to use this name later.
      5. Click Select.
      6. Click the correct database, and then click OK.
      7. Click OK, and then click OK.

   Report (0) (0)  |   12 years, 9 month(s) ago