Администратор odbc windows 10 - Windowsa.top - ваш верный помощник с OS Windows

November 10, 2017 updated by

Leave a reply »

How can I open the 32-bit ODBC Data Source Administrator in Windows 10 64-bit? ODBC Data Source Administrator is a Windows component that lets you create and manage ODBC data sources. In this tutorial we’ll show you 5 ways to open ODBC Data Source Administrator in Windows 10.

Note: The 32 -bit version of the ODBC Data Source Administrator must be used to configure data sources for 32- bit applications.

Method 1: Open ODBC Data Source Administrator from Control Panel

Open the Control Panel and set the View by option to Large icons, and click Administrative Tools.

You can then access both 32-bit and 64-bit versions of ODBC Data Source applet.

Method 2: Open ODBC Data Source Administrator from Start Menu

Click the Start button. When the Start Menu comes up, scroll down until you see the “Administrative Tools” folder. Expand that folder and you can then open either ODBC Data Source (32-bit) or ODBC Data Source (64-bit).

Method 3: Open ODBC Data Source Administrator via Search

Simply type odbc into the Cortana Search box on your Windows 10 taskbar, the ODBC Data Source tool will show up in the search result and you can click to launch.

Method 4: Open ODBC Data Source Administrator via Run or Command Prompt

Open the Command Prompt, or press the WIN + R keys to open the Run dialog box. Type odbcad32 and press Enter.

If you’re running Windows 10 64-bit, this should launch ODBC Data Source (64-bit). Otherwise, it will open ODBC Data Source (32-bit) instead.

Method 5: Create ODBC Data Source Administrator Shortcut

A 32-bit version of Windows includes only ODBC Data Source (32-bit), which is located in C:\WINDOWS\System32\odbcad32.exe

If you’re running Windows 64-bit operating system, you can access both 32-bit and 64-bit ODBC Data Source from the following locations:

ODBC Data Source (64-bit) – C:\WINDOWS\System32\odbcad32.exe
ODBC Data Source (32-bit) – C:\WINDOWS\SysWOW64\odbcad32.exe

When you need to access ODBC Data Source frequently, you can create a desktop shortcut that points to odbcad32.exe.

Previous Post: How to Reset PIN from Lock Screen on Windows 10 Fall Creators Update
Next Post: 2 Ways to Change MAC Address on Windows 11 / 10 / 8 / 7

Источник

ODBC is basically a protocol generally used for connecting Microsoft Access Database with another outbound source like Microsoft SQL server. Open Database Connectivity (in short ODBC) is a driver permitting applications to access data from DBMS (Database Management Systems) with the help of SQL. So in this write-up today, we will show you a few most effective methods to start ODBC Data Sources in Windows 11 or 10.

Maximum number of interoperability is permissible by ODBC which eventually proves that; one program can retrieve various DBMS. It’s a significant Windows component and you may need to use it in order to create along with managing the ODBC data source.

Start ODBC Data Sources

Here is How to Start ODBC Data Sources in Windows 11 or 10 –

1] Use taskbar search

Click the search icon located in the taskbar.
Type odbc in the text bar.
When ODBC Data Sources app for both 64-bit and 32-bit shows up in search result, click preferred one to launch.

2] Start ODBC Data Sources through Start menu

Press Windows key to invoke the Start menu.
Reach to Windows Administrative Tools by approaching alphabetically.
Expand the same folder.
From available ODBC Data Source (32-bit) and ODBC Data Source (64-bit), opt for the desired one.

3] Take help of Run dialog box

Press Win+R at one go to directly open Run dialog box.
Insert odbcad32 in the command box and click OK button.

Note – Whether your Windows 11 or 10 device runs 64-bit or 32-bit, the command will open the right version automatically.

4] By means of Control panel

Press Win+S and type in control panel and hit Enter key to launch the same.
Set View by option to Large icons and select Administrative Tools.
When a separate window turns up, look for ODBC Data Sources.
The app will be available in both 32 and 64 bit, hence click the one compatible with your system.

5] Access Command Prompt to open ODBC Data Sources

Right-click on Start button and choose Run.
Put cmd in the text field and hit Enter.
Insert odbcad32 after the blinking cursor followed by pressing the Enter key.

6] Navigate the directory of ODBC

Bring forth File Explorer with hotkey Win+E.
In its address bar, insert C:\WINDOWS\System32\odbcad32.exe and press Enter key. This will open ODBC that is compatible with 64-bit.
In the case of running 32-bit, you need to insert C:\WINDOWS\SysWOW64\odbcad32.exe directory instead.

7] Create a shortcut key for ODBC Data Sources

Open File Explorer and go to the following directory –

C:\WINDOWS\System32

After reaching there, press Ctrl+F to activate its search function.
Type odbcad32 and press Enter key.
When the search result appears, right-click on odbcad32.exe and choose Send to => Desktop (create shortcut).

8] With the assistance of PowerShell

Press Win+X and select Windows PowerShell.
Insert odbcad32.exe after the winking cursor and hit Enter.

Methods:
1] Use taskbar search
2] Open ODBC Data Sources through Start menu
3] Take help of Run dialog box
4] By means of Control panel
5] Access Command Prompt to open ODBC Data Sources
6] Navigate the directory of ODBC
7] Create a shortcut key for ODBC Data Sources
8] With the assistance of PowerShell

That’s all!!

Источник

Открытие «Администрирование источников данных ODBC»

У некоторых пользователей драйвер ODBC для подключения к базе данных имеет нестандартные параметры настройки. В этом случае подключить базу данных к программе Call Office стандартными способами в разделе «Источник данных» не всегда возможно.

Эту проблему можно решить выбрав ODBC-источник данных с произвольной строкой подключения и добавлением нового источника данных.

Для 32-разрядной Windows

Необходимо перейти, «Панель управления» —> «Система и безопасность» —> «Администрирование» и выберите «Источники данных ODBC».

Для 64-разрядной Windows

ВНИМАНИЕ: В 64-разрядных ОС семейства Windows нужно запускать 32-разрядную версию приложения «Источники данных ODBC», так как программа Call Office является 32-разрядным приложением.

Для Windows 10 необходимо нажать правой кнопкой по кнопке «Пуск» —> «Найти» и ввести ODBC и в результате поиска выбрать «Настройка 32-разрядных источников данных ODBC».

Для Windows 7 Необходимо перейти, «Пуск» —> «Найти» —> C:\WINDOWS\syswow64\odbcad32.exe

Создание своего источника данных

Откройте вкладку «Пользовательский DSN» и добавьте свой источник данных (кнопка «Добавить»).

Выбираем нужный драйвер и нажимаем кнопку «Готово».

Указываем «Имя источника данных» или «Имя», для последующего обращения по заданному имени и заполняем необходимые настройки для подключения к нужной базе данных.

В данном примере «Имя источника данных» — «my_connection».

Подключение созданного ODBC-источника, в программу Call Office

В выбранной конфигурации, необходимо выбрать «Источник данных» и указать «ODBC-источник / произвольная строка соединения», нажать «Далее».

Далее в «Имя источника данных либо строка соединения с БД», указать строку соединения с созданного ODBC-источника. В нашем случае мы указываем имя источника, который мы указали при создании своего источника данных — «my_connection».

Источник

Introduction
Connect to Microsoft SQL Server
Setup ODBC
Troubleshooting
More Information

Introduction

This article explains how to connect to Microsoft SQL Server with ODBC from Windows 10.

It covers the following topics:

How to connect to Microsoft SQL Server (with code samples).
How to setup ODBC:
- Configure ODBC using the ODBC Data Source Administrator:
  We recommend using system DSNs (available to all users).

Connect to Microsoft SQL Server [top]

We strongly recommend using connection objects to connect to databases, and this is what we demonstrate in the code samples.

Follow these steps to connect:

Create a new channel to try out the code:
- Create a channel like this:
  - Name: DB SQL Server Connection (or similar)
  - Source: From Translator
  - Destination: To Channel
- Alternatively use an existing channel:
  Your channel will need a From/To Translator or a Filter component.
Connect to a database using ODBC:
- Paste this code into the Translator:
  If your script uses connection object methods conn:query{} or conn:execute{}to connect to a remote Microsoft SQL Server database, the location of the remote host is specified as part of the name parameter in the db.connect{ } command. If you use conn:merge{} to connect the remote host is specified as part of the name parameter in the conn:merge{} command itself.
```
function main()
      local conn = db.connect{   
      api=db.SQL_SERVER, 
      name='your_odbc_server_name',
      user='',      -- use empty string for integrated security
      password='',  -- use empty string for integrated security
      use_unicode = true,
      live = true
   }

   conn:execute{sql='SELECT * FROM <your table>', live=true}
end
```
- The name is the name of an ODBC source that you create using the ODBC Administrator.
Adapt the code to your requirements.

Setup ODBC [top]

Note: Iguana may not always support the very latest version of the Microsoft SQL Server ODBC drivers, so you can simply download an earlier version if necessary. This is particularly true if you are not able to use the the latest version of Iguana.

If you need to know which versions of Microsoft SQL Server are supported by the version of Iguana you are using please contact us at support@interfaceware.com.

To set up a new ODBC data source for Microsoft SQL Server:

Install the latest Microsoft SQL Server ODBC drivers:
- Download the latest drivers from the Microsoft ODBC download site.
- Run the installer and accept the defaults.
Open the 64 bit ODBC Administrator:
Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources — always use the 64 bit ODBC Administrator.
Open the System DSN tab and click Add:

Картинка с сайта: help.interfaceware.com
Choose the latest SQL Server ODBC driver and click Finish:

Картинка с сайта: help.interfaceware.com
Enter the ODBC credentials:
- Use any Name and Description you prefer.
- Enter the Network Name of the SQL Server in the Server field:
  Note: If you are unsure of the name ask your DBA (database administrator).
- Click Finish to create the ODBC data source:
  
  Картинка с сайта: help.interfaceware.com
This will open the the ODBC Microsoft SQL Server Setup dialog box that lists the chosen settings:
The ODBC source will use all the standard defaults which will work in most cases. There are two settings that you may need to change: Use Integrated Security and Database. Speak to your DBA (database administrator) about changing these if necessary.
- Use Integrated Security: Sometimes you might want to use a SQL Server user and password
- Database: You can specify the database that you want to use by default.
Test the data source connection:

If you need to modify the ODBC source follow these steps:

These are the two most common things to change:
- Default Database: Change to Test
- User Login: Change to user billsmith with password something-secret
Modify the ODBC source to change Database and User:
Change the default database:
- Select the Change the default database option:
- Choose your default database from the drop list and click Next:
  
  Картинка с сайта: help.interfaceware.com
Finally test the connection to see that the changes worked.

Troubleshooting [top]

Problems with connection settings:
Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc.
Iguana may not always support the very latest version of the ODBC drivers:
Please contact us at support@interfaceware.com if you need to know the latest supported version of the ODBC drivers.
Incorrect port number:
SQL Server defaults to port 1433, but a different port can be used. Speak to your database administrator (DBA) or network administrator.
Using integrated security:
Using integrated security is the usual way to connect to a Microsoft SQL Server database. If this does not work speak to your DBA (database administrator) about the user credentials you should use to connect to the database.

If you need more help please contact us at support@interfaceware.com.

More Information [top]

Using Database Connection Objects
Forum thread on Windows ODBC
Using Integrated Authentication, Microsoft SQL Server documentation (kerberos etc)
Connect to Microsoft SQL Server from Linux or Mac with ODBC

Источник

The Microsoft ODBC Data Sources tool helps you connect your apps to various database management systems. But how does this tool work, and what are the different ways to access it? Let’s dive in and find out.

How Does the ODBC Data Sources App Work?

An illustration of a question and an idea

Mohamed_hassan/Pixabay

ODBC (Open Database Connectivity) is a system that connects apps to database management systems. For example, if you use an app that accesses data in an SQL database, the ODBC Data Sources tool lets you connect that app to a different data source (such as Microsoft Excel).

Let’s now check out how you can use the ODBC Data Sources tool:

Press Win + R to open the Run command dialog box.
Type odbcad32.exe and press Enter.

Картинка с сайта: www.makeuseof.com

Navigate to the User DSN tab.

A DSN establishes a connection to a target database through an ODBC driver. It can also help you pull information from a database.

Click the Add button on the right to start creating a User DSN.

Картинка с сайта: www.makeuseof.com
On the next screen, select the relevant ODBC driver and click the Finish button. From there, enter the details of your data source in the next window.
Follow the on-screen steps and then click the Finish button.

Once you’ve created a User DSN, you can explore some cool tricks with the ODBC tool. For example, you can check out how to connect your databases with VBScript by creating a VBScript ODBC Connection.

Want to discover the various ways to access the ODBC Data Sources tool? Let’s help you out!

Windows computer next to a book and a cup

One of the easiest ways to access the ODBC Data Sources tool (or any other app) is by using the Start menu search bar.

Here are the steps you need to apply:

Press Win + S to access the Start menu search bar. Alternatively, Press the Windows search bar icon on the taskbar.
Type ODBC Data Sources and select the Best match.

Картинка с сайта: www.makeuseof.com

You can also easily access the ODBC Data Sources tool from the Start menu. So, let’s check out the steps you need to apply:

Press the Windows key or click the Start Menu icon on the taskbar to access the Start menu.
Select the Windows Administrative Tools folder from the menu items.
Locate and select one of the ODBC Data Sources options.

Картинка с сайта: www.makeuseof.com

3. Access the ODBC Data Sources App Using the Control Panel

The Control Panel is a handy tool that you can use for various purposes. For example, you can use it to troubleshoot system issues or configure some settings.

Interestingly, the Control Panel can also help you open most apps on your PC. So, let’s check out how you can use it to access the ODBC Data Sources app:

Press Win + R to open the Run command dialog box.
Type Control Panel and press Enter.
Click the View by drop-down menu and select Large icons.
Select Administrative Tools from the options.
Double-click on one of the ODBC Data Sources options.

Картинка с сайта: www.makeuseof.com

4. Access the ODBC Data Sources App Using the File Explorer Address Bar

The File Explorer address bar is a convenient tool that helps you locate your file or folder paths. But did you know that you can use this tool to access various apps?

Here’s how you can access the ODBC Data Sources app using the File Explorer address bar:

Press Win + E to open File Explorer.
Type odbcad32.exe in the address bar and press Enter.

Картинка с сайта: www.makeuseof.com

5. Access the ODBC Data Sources App Using the Task Manager

The Task Manager is usually the first tool you might think of whenever you want to close faulty apps on your PC. But did you know that this tool can also help you access almost any app on Windows?

Here’s how you can open the ODBC Data Sources app using the Task Manager:

Type Task Manager in the Start menu search bar and select the Best match.
Click the File tab in the top-left corner of the screen.
Select the Run new task option.
Type odbcad32.exe in the search box and press OK to open the ODBC Data Sources app.

Картинка с сайта: www.makeuseof.com

6. Access the ODBC Data Sources App From the Windows System32 Directory

You can also open the ODBC Data Sources app by clicking the relevant file in the Windows System32 folder.

Here are the steps you need to apply:

Press Win + E to open File Explorer. Alternatively, click the File Explorer icon on the taskbar.
Select This PC on the left.
Select the Local Disk (C:) option on the right.
Open the Windows folder, scroll down, and open the System32 folder.
Double-click on the odbcad32 option to open the ODBC Data Sources app.

Картинка с сайта: www.makeuseof.com

7. Access the ODBC Data Sources App Using the Command Prompt or PowerShell

The Command Prompt and PowerShell can also help you access the ODBC Data Sources app.

Let’s start by checking out the steps for opening the ODBC Data Sources app using the Command Prompt:

Press Win + R to open the Run command dialog box.
Type CMD and press Ctrl + Shift + Enter to open an elevated Command Prompt window.
Type the following command and press Enter.

odbcad32.exe

Let’s now check out the steps for accessing the ODBC Data Sources app using PowerShell:

Type Windows PowerShell in the Start menu search bar.
Right-click on the Best match result and select Run as administrator.
Type the following command and press Enter.

odbcad32.exe

8. Access the ODBC Data Sources App Using a Desktop Shortcut

A lady using a Windows PC while holding a cup

Using desktop shortcuts is one of the best ways to access your apps. So, let’s explore how you can create an ODBC Data Sources desktop shortcut:

Press Win + D to access the desktop.
Right-click on a blank space and select New > Shortcut.
Type %windir%\system32\odbcad32.exe in the location box and press Next to continue.

Картинка с сайта: www.makeuseof.com

Type ODBC Data Sources App in the «name» box and then click the Finish button. Now, you can easily access the ODBC Data Sources app using the desktop shortcut you’ve just created.

Accessing the Windows ODBC Data Sources App Is Quite Easy

Need a Windows tool that can help you connect your apps to various database management systems? Try the ODBC Data sources app! The good news is that this tool is free and easy to use.

And how do you access the Microsoft ODBC Data sources tool? Simply apply any of the methods we’ve covered. From there, you can start exploring some cool «database creation» tricks, such as creating a database in Microsoft Access.

Источник