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.
Thanks
Welcome