Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
151
questions
62
votes
3
answers
397k
views
How can I open the 32-bit ODBC Data Source Administrator in Windows 7 64-bit?
I want to add 32-bit data sources. There seems to be no obvious way to see existing instances of these or create new ones.
How can I open the 32-bit "ODBC Data Source Administrator" window in Windows ...
- 3,061
34
votes
2
answers
109k
views
Anyway to use SSMS to connect to MySql?
I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection?
I realise ...
- 926
15
votes
2
answers
117k
views
How to Remove ODBC Data Source if Driver is Removed
On my Windows 7 machine, I created an ODBC data source to an Oracle database via the ODBC Data Source Administrator (c:\windows\SysWOW64\odbcad32.exe). Sometime later, I had to uninstall and reinstall ...
- 350
9
votes
1
answer
16k
views
Exporting a list of ODBC Datasource drivers?
Is it possible to export a CSV file of the list of database driver names from the Create New Data Source of the ODBC Data Source Administrator?
- 22.7k
9
votes
2
answers
12k
views
How to connect to Oracle DB via ODBC
I am attempting to connect to a remote Oracle DB via ODBC. I am totally inexperienced and fail to connect.
What I have installed:
Oracle 'ODBC Driver for RDB'
A program I want to connect from (...
- 113
7
votes
2
answers
18k
views
System DSN vs user DSN
Every new computer in my company undergoes the same software installation process; one program in particular needs to access a MS SQL Server database via ODBC. The program is then used by multiple ...
- 599
6
votes
1
answer
3k
views
SQL Server ODBC authentication errors
I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...
- 498
5
votes
4
answers
47k
views
Use a Cell Value for a Paramater Value using in Power Query
I am using a query like below in power query Excel 2016:
let
Source = Odbc.Query("dsn=AS400", "select * from libm61.emleqpm1 where STN1 = '03' ")
in
Source
I want to replace '03' with a ...
- 7,485
5
votes
2
answers
26k
views
How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?
I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
- 568
5
votes
1
answer
973
views
Access crashes when opening linked table via MySQL ODBC driver
We installed the 32 bit ODBC driver (8.0.27) for MySQL on a Windows 10 machine
Made a successfull connection via SSL to a MySQL 8 server
Initially tables most table can be opened, but Access crashes ...
- 1,427
5
votes
2
answers
19k
views
Windows 7 ODBC Text Driver
Some software requires me to setup an ODBC Text Driver.
In the Windows 7 Control Panel > ODBC Data Source Administrator, the only driver available is "SQL Server".
How do I find/download/install a ...
- 1,659
5
votes
1
answer
8k
views
how to connect to pervasive sql through odbc?
I am trying to add a linked server to a sql server 2012 database using ssms 2012.
the linked server is pervasive sql. here's how i am trying to do it:
EXEC sp_addlinkedserver
@server = 'kslap208'...
- 733
4
votes
4
answers
75k
views
Why is my 32bit ODBC connection not showing up in odbcad32.exe?
I have a Windows 7 64bit system that must run a 32bit application that accesses a MSSQL Server 2005 express via an ODBC connection. After installation everything was working fine. Now a few weeks ...
- 183
4
votes
1
answer
20k
views
ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10
I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and ...
- 191
4
votes
3
answers
1k
views
Link to Skyward Database to MS SQL Server
I am trying to connect Skyward Database( Progress Database ) to MS SQL Server. What am I doing to connect?
First Setup an ODBC connection to the Progress database in the ODBC Administrator in the ...
- 114
4
votes
1
answer
455
views
Excel ODBC - General 'How does it work?'
Thinking of moving a couple of linked spreadsheets into a database model instead.
However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
user332893
4
votes
1
answer
2k
views
ODBC Query cannot be executed because it is too complex?
I have a CSV file which I am using as a database with LibreOffice DB.
What I'm doing is explained in detail in this answer.
I can do some operations, but when I try to enter the following into the ...
- 1,243
3
votes
3
answers
107k
views
What ports does MS SQL Server use for ODBC connections?
I require our firewall to allow ODBC connection from clients to the MS SQL Server.
Which ports should be opened for this?
- 201
3
votes
1
answer
29k
views
How does one acccess the registry hive inside NTUser.dat?
Is it possible to access the registry hive inside of NTUser.dat file?
The reason I am asking is that I frequently install ODBC DSN on computers, and I know that the User DSNs are stored in the ...
- 22.7k
3
votes
2
answers
3k
views
What's the difference between ODBC Manager and ODBC Administrator?
I have two applications in my Applications/Utilities folder that look exactly the same except for the icon. One is ODBC Manager, the other is ODBC Administrator.
Does anyone know what the difference ...
- 223
3
votes
2
answers
6k
views
Can I connect 64-bit MS Access to a 32-bit ODBC driver?
I have (only) a 32-bit Ingres ODBC driver and 64-bit MS Access. I want to create linked tables in Access that point to an Ingres database.
I know about needing to use c:\windows\sysWOW64\odbcad32....
- 307
3
votes
1
answer
5k
views
Copy ODBC Driver to another computer
I am trying to copy multiple installed ODBC drivers from one computer to another.
I can see the driver name, version, company, file name, and date but no way to export it. Both computers run the ...
- 135
3
votes
2
answers
22k
views
Windows 10 Visual FoxPro ODBC Issue
I just upgraded from windows 7 64 to Windows 10 64. Now I am having problems with the Visual FoxPro driver. I am using the 32-bit ODBC manager (C:\Windows\SysWOW64\odbcad32.exe). When I try to add or ...
- 3,314
3
votes
1
answer
11k
views
Writing typical MySQL query in excel
I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid.
Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
Glenn Low
3
votes
1
answer
667
views
Access 2010: The Oracle client and networking components were not found
I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle":
ODAC112021Xcopy_32bit
win32_11gR1_client
But alas it will not work!
I'm on Windows 7, using Access 2010.
...
- 882
3
votes
0
answers
4k
views
Can't install ODBC Driver 17 for SQL server On Windows 11
i want install SSMS 19.1
this is stuck like picture
the problem for "microsoft ODBC Driver 17 for SQL Server" cant install
i download it manually and try install it but this error appear
- 143
2
votes
2
answers
4k
views
Database access through odbc driver and excel
Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file?
The program I am accessing data only allows an ODBC connection in....
- 1,445
2
votes
1
answer
11k
views
Retrieve ODBC DSN Password
Recently I inherited a web server and nobody knows the password to the ODBC connection that talks to the Sql database.
The screen in particular that is asking for the pass looks like:
I tried ...
- 598
2
votes
1
answer
21k
views
Error when refreshing data from external source in excel. Data source name not found and no default driver specified
I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error:
...
- 207
2
votes
1
answer
2k
views
Querying big databases with Excel
Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
- 356
2
votes
1
answer
1k
views
How does an OLEDB/ODBC connection know the path to a SQL Server database by name only?
If i have a connection string like this that I use in a Data Connection in Excel to get data from a SQL Server database:
OLEDB;
Provider=SQLOLEDB.1;
User ID=MY_USERNAME;
Password=MY_PASSWORD;
Persist ...
- 123
2
votes
1
answer
2k
views
ODBC working only with sudo
I'm having troubles with unixODBC. I've installed the latest version and currently is working only with sudo. To test the ODBC I've used isql. Example:
# isql -v testTable
[IM002][unixODBC][Driver ...
- 173
2
votes
1
answer
804
views
ODBCAD.exe same datasource in system32 and syswow64
Currently i want to proof, which odbc data sources are configurated on a windows server 2008 R2 machine. When i open system32/odbcad32.exe and SysWow64/odbcad32.exe, they contains the same sources (64-...
- 141
2
votes
1
answer
2k
views
Log of SQL queries to ODBC driver?
I have an application on my Windows XP SP3 machine that's querying and returning data from a database through the SQL Server Native Client.
Is there a log file being kept that would show me the SQL ...
- 223
2
votes
1
answer
13k
views
How do I automate creation of an ODBC connection in the system DSN?
I need to create an ODBC connection in System DSN on a bunch of windows machines. What can I do to make this process simpler than manually typing the details into the Create New Datasource Wizard on ...
- 28.2k
2
votes
1
answer
405
views
Locate and/or reinstall link to MS Query in Excel 365
I have a small data querying and analysis team that uses Microsoft Query to pull data from an ODBC connection. We are running Microsoft 365 and tapping into data sources inside Excel. The ODBC data ...
- 23
2
votes
1
answer
4k
views
Install an ODBC driver on Windows without admin rights
Is it possible to install an ODBC driver on Windows 10 without admin rights?
I have SQLiteODBC driver, which is a single dll file. I want to be able to use it without touching any privileged areas. In ...
- 133
2
votes
0
answers
962
views
Unable to connect to SQL server after update
I updated my server today with all pending update and after reboot I was unable to connect to SQL server. Prior to reboot I've also enabled the firewall but now it's disabled again and server is after ...
- 21
2
votes
0
answers
326
views
How to set up driver for Oracle 12c database on Mac
I work on a Mac (macOS Mojave 10.14.1) and I am trying to set up an ODBC driver to connect to an Oracle database (my eventual aim is to connect via R using the DBI package).
I don't have the ...
- 121
2
votes
1
answer
4k
views
Connection failed, Access denied connecting to MySQL via ODBC on Windows
I know nothing about MySQL or Linux and am tasked with migrating a MySQL DB to MS SQL. I found a tool for that but it requires an ODBC connection so I downloaded the MySQL Connector/ODBC and installed ...
2
votes
0
answers
1k
views
How to install SQL Server ODBC driver on OSX?
I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error:
The ODBC driver that was selected for the source connection ...
- 5,836
2
votes
2
answers
2k
views
odbc error connecting mysql: "sql server does not exist or access denied"
For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever.
I have no problem connecting to the database ...
Spids
2
votes
0
answers
1k
views
What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?
I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day.
I've tried a couple of options. First, my specs:
...
- 21
2
votes
2
answers
6k
views
VBA Automation error when querying database through ODBC
I am trying to run Excel macro to query some data from my ODBC database.
My database details are as below:
DSN: sgdv UID:l8qc1 Password:l8qc1 server:sgdv
I am trying to query the data from ...
- 152
1
vote
2
answers
2k
views
Unable to install MySQL ODBC connectors in Excel 365
Upon following the instructions here, which links here, and installing the latest version (8.0.30) ODBC connector, I still receive the following unhelpful error message when selecting Data -> Get ...
- 135
1
vote
1
answer
2k
views
How to create an odbc string connection in an excel spreadsheet to make it portable instead of setting up an odbc connection on every computer?
I'm setting up an excel reporting using Excel 2013 for that.
The spreadsheet is retrieving data, through an odbc connection that I need to set on every computer in order to retrieve the data.
I ...
- 392
1
vote
1
answer
1k
views
SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified
I am running a PHP script on a RedHat server using Teradatas ODBC drivers.
<?php
$conn = odbc_connect("Teradata", "username", "password");
$result = odbc_exec($conn, 'SELECT count(*) FROM table');...
1
vote
2
answers
7k
views
System DSN command prompt
I can create a System DSN connection via the following command:
odbcconf.exe /a {CONFIGSYSDSN "SQL Server"
"DSN=NAME|Description=DESCRIPTION|SERVER=MYSQLSERVER|Trusted_Connection=Yes|Database=...
- 13
1
vote
1
answer
2k
views
is using Hosts for resolving a sql-server more performant?
we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections.
Now we consider to use a ...
- 669
1
vote
1
answer
904
views
ODBC entry is working but not visible in ODBC Data Connections
At my work we have Windows 10 and we use ODBC to connect to databases from SPSS, Rstudio and other apps. Recently we added a new registry entry to register a new database connection:
Windows Registry ...
- 221