Skip to main content

How to Open ODBC Data Source Administrator on Windows 10


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

Popular posts from this blog

A Guide on Disabling Microsoft Outlook From Saving Sent Emails

  Do you want to de-clutter your Outlook email account by deleting sent emails? Well, normally everybody does that by moving the emails to the archive section or deleting them. But, how about an automated action that could disable your Microsoft Outlook account from saving the sent emails? Yes, you’re thinking it right! You no longer have to de-clutter your account manually from time to time. All you need to do is change certain settings and the action will be automated. You must have noticed that upon sending an email, your Outlook account stores a copy of the same. However, the platform enables you to turn off the settings to keep any sent emails from getting saved. Alternatively, your Outlook account lets you create a rule for saving the copies in some other folder. Interestingly, the settings can be changed for all emails, but if you want to do it for a few individuals, it is possible. 1.       Open the Outlookapplication. 2.   ...

Top Tricks to Increase Your Windows 10 PC Performance

  Windows 10 already has a fast working system, and it goes better with strong hardware. But at some point, the performance reduces because of viruses and bugs, malware several more reasons. So if you are using a powerful computer and still facing a major problem like slow performance, then should try out some easy and important steps that can help you to deal with this certain type of issue. Slow performance not just reduces the device’s speed but it also affects the user experience, so here’s the guide to increase your PC performance. Restart Your PC Restarting a PC looks like a simple process, but actually, it helps a lot to improve PC performance. After shutting down the PC or starting it, its system closes all running apps and their working. Every data those apps are collecting and storing in PC stops, and additionally, it clears some device memory also which helps in improving PC performance. Apart from this, every user must restart their PC after installing and uninstall...

How to Disable Access to Windows Registry for Standard Account?

  The Windows Registry is a kind of database that saves the low-level settings of the OS and apps. It has values and keys that are duplicates of the files and folders. Moreover, applying an incorrect setup into the Registry Editor can cause issues with the PC. Thus, the administrator should turn off the Registry Editor access for default users who don’t know much about registries. If you want to know how to turn off the Windows registry access to the default account, then read on and follow the steps given below. Disable Access of Registry via the Local Group Policy Editor Hit the Windows and R combination over the keyboard to launch the run prompt. Afterward, input “gpedit.msc” in it and select the OK button to invoke the Local Group Policy Editor. Now, pick the Yes button when prompted by the UAC. Go to the window of User Configuration, and then go to the following path: User Configuration\ Administrative Templates\ System\ You should select the “Prev...