Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
151
questions
2
votes
1
answer
528
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 ...
1
vote
1
answer
1k
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 ...
0
votes
0
answers
536
views
An error occurred but no ODBC error information was available
I have an odd issue with Excel 365 v16.0.16827.20278 installed on a host machine. When trying to access an ODBC source, used successfully by several other individuals, Excel throws the error
An error ...
-1
votes
1
answer
3k
views
How to resolve SQL error 772
Using the preloaded ODBC driver version 10.00.22621.1992 on Windows 11 and added the data source in System DSN. When it tries to test the connection I get this error (picture below).
SqlState:01000
...
1
vote
2
answers
4k
views
MS Access ODBC 64 drivers
I had to reinstall Windows 10 Pro and this went well. When I started using my program, there were some driver related problems with respect to my application connecting to an MS Access database. I am ...
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
0
votes
1
answer
252
views
PostgreSQL ODBC Driver for IBM i Compile Error
I am attempting to compile the PostgreSQL ODBC driver on our IBM i system, and I'm getting a strange error. The version I'm trying to compile is 12.02, since that's the version of PostgreSQL we have ...
0
votes
1
answer
185
views
What is hexedit.exe and who originally created it?
At our company we use an obscure ODBC tool named FlexODBC Driver for DataFlex. Bundled with that software is hexedit.exe. What caught my attention is that the file says it was last modified March 19th,...
0
votes
1
answer
193
views
Unrecognizable options in TNS Service name for a new System DSN in ODBC administrator, after installing Oracle Client 11gR2
On 64-bit Windows 10 Enterprise, I was asked to install win32_11gR2_client.
But I encountered the following problems.
When I run setup.exe in the top directory temporarily as an administrator, I got ...
0
votes
1
answer
29
views
Navigate to a specific table/view in list of objects in Microsoft Query
When setting up a Microsoft Query connection (to an Oracle table/view via ODBC) in Excel 2016:
Problem:
I have hundreds of Oracle views to scroll through in order to get to the view that I want:
...
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 ...
1
vote
0
answers
291
views
Excel ODBC connection to MS SQL server refresh issue
I've created an ODBC connection in Excel in order to create pivots on a large table held in MS SQL Server.
The connection string looks like this:
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist ...
0
votes
1
answer
531
views
make ODBC link work over VPN
I've created an Access file that contains ODBC links to our web-based ERP system, with a form full of graphs tracking various company metrics against target figures.
The Access file is stored on our ...
5
votes
1
answer
983
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 ...
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 ...