ODBC is the abbreviation of Open Database Connectivity, which is
a protocol that you use to connect the particular Microsoft Access Database
with an outsourced data source like MS SQL Server.
ODBC is generally a driver that permits applications to fetch
user data from the section of the DBMS Database Management System. It performs
this task with the help of SQL servers. Here, we are going to provide various
methods to launch ODBC Data Sources on Windows 10. It’s one of the prominent
Windows tools that you can use to create various setups and can manage various
ODBC. In the whole process, DBMS plays a great role in the smooth running
of ODBC.
Pursue these guidelines to launch ODBC Data Sources on Windows
10:
Using Taskbar Search Tool
§ First
of all, you have to hit the search bar situated on the taskbar.
§ Now,
enter “ODBC” into the search text panel.
§ Then,
once the ODBC data sources 32 and 64 bit launches on your screen, then hit the
appropriate one to open it on your system screen.
Starting ODBC Data Sources via
Start Menu
§ In the
beginning, hit the Windows logo to fetch the Start menu.
§ Now, go
to the Windows Administrative Tools option. You can search for this option
through alphabetic mode.
§ Now,
open the same folder there.
§ You
have to choose your desired option from the 32 bit and 64-bit option.
Starting ODBC Data Sources
through Run Dialog Box
§ First
of all, tap Window logo and R tab to launch Run Dialog Box there.
§ After
that, you have to enter “odbcad32” into the Run dialog search panel.
§ Then,
press the OK button there.
Note: The respective command will launch the perfect edition of
the data source automatically. No matter your device is running with which
memory slot. You can choose either 32 bit or 64 bit there.
Starting ODBC Data Source via
Control Panel
§ Firstly,
hit the Window and S keys from the Control Panel and then hit the Enter key
there.
§ After
that, now you have to adjust to viewing by the option to large and then hit the
Administrative tools tab there.
§ Next,
once the new screen opens on your device, search for the ODBC data source
option.
Note: the application will be available in both the memory
types: 32 and 64 bits. You have to select the most compatible one.
Open ODBC Data Source through
Command Prompt
§ First
of all, apply the right mouse click on the Start tab and then hit the Run
button.
§ Next,
input cmd into the search bar, followed by the Enter key.
§ Then,
type “odbcad32” into the respective section just after the blinking cursor and
then hit the Enter button.
Starting ODBC Data Source by
Navigating the ODBC Directory
§ First
and foremost, you have to launch the File Explorer window on your device screen
by hitting the combo key of Window and E.
§ Now, go
to the URL section and then type “C:\Windows\System32\odbcad32.exe,” followed
by the Enter key there. This action helps you to launch the ODBC source file
that works compatible with 64 bit.
§ If you
are using a 32-bit source file, you have to type
“C:\Windows\SysWOW64\odbcad32.exe” into the navigation pane of your directory.
Opening ODBC Data Sources by
Creating the Shortcut Key
§ In the
beginning, launch File Explorer and navigate to the directory:
“C:\Windows\System32.” Then hit the Enter button there.
§ Once
you have reached the next page, hit the Ctrl key and F tab to get the search
function activated.
§ Now,
enter “odbcad32” into the search bar, followed by the Enter key.
§ After a
while, the search result will expand on your screen, and you have to apply
right mouse click on the file related to “odbcad32.exe” and then select the option
“Send to.”
§ Then,
press the Desktop tab that is related to creating a shortcut.
Using PowerShell to Start ODBC
Data Source
§ First
and foremost, tap Window and X keys.
§ Then, a
panel will launch, and you have to choose the Windows PowerShell option there.
§ Type
“odbcad32.exe” into the search bar after the blinking cursor appears.
§ Tap
enter to proceed.
David Root is an inventive person who has been doing intensive research
in particular topics and writing blogs and articles on Office.com/setup and many other
related topics. He is a very knowledgeable person with lots of experience.
Comments
Post a Comment