SQL to ODBC Configuration, Part-2

แชร์
ฝัง
  • เผยแพร่เมื่อ 12 ก.ย. 2024
  • In this video we will learn how to connect SQL and ODBC.
    Search for or browse to the ODBC Data Sources (64-bit) applet in the Start Menu or Control Panel. If you only have a 32-bit driver, or you know that you have to use a 32-bit driver, search for or browse to ODBC Data Sources (32-bit) instead.
    Launch the applet. The ODBC Data Source Administrator window opens.
    On the Drivers tab, you can find a list of all the ODBC drivers installed on your computer. (The names of some of the drivers may be listed in multiple languages.)
    Provide a DSN (data source name) that already exists or that you create with the ODBC Data Source Administrator applet. A DSN is the saved collection of settings required to connect to an ODBC data source.
    If you already know the DSN name, or know how to create a new DSN now, you can skip the rest of this page. Enter the DSN name in the Dsn field on the Choose a Data Source or Choose a Destination page, then continue to the next step of the wizard.
    Provide a DSN
    Provide a connection string, which you can look up online, or create and test on your computer with the ODBC Data Source Administrator applet.

ความคิดเห็น • 2