Questions tagged [odbc]

In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).

Filter by
Sorted by
Tagged with
0 votes
1 answer
116 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 ...
BdR's user avatar
  • 201
0 votes
0 answers
224 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 ...
Matt's user avatar
  • 1,226
-1 votes
1 answer
2k 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 ...
Brute's user avatar
  • 23
1 vote
1 answer
2k 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 ...
Michaelinscarbororough's user avatar
3 votes
0 answers
2k 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
abbas-h's user avatar
  • 143
0 votes
1 answer
175 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 ...
TheLittlePeace's user avatar
0 votes
1 answer
146 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,...
SenseiRalph's user avatar
0 votes
1 answer
157 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 ...
Tim's user avatar
  • 17.3k
0 votes
1 answer
19 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: ...
User1974's user avatar
  • 137
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 ...
jordanpg's user avatar
  • 135
1 vote
0 answers
227 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 ...
dwcecil's user avatar
  • 21
0 votes
1 answer
418 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 ...
Spencer Barnes's user avatar
0 votes
0 answers
1k views

ODBC with active directory password authentication using a login ID and password not configurable

The server MYSERVER holds the SQL database MyDatabase. The account MYCOMPANY\myaccount is registered for MyDatabase with server roles public and sysadmin and with permission Connect SQL granted by sa. ...
stonebe's user avatar
  • 207
5 votes
1 answer
935 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 ...
Alex's user avatar
  • 1,407
2 votes
1 answer
3k 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 ...
PChemGuy's user avatar
  • 133
0 votes
1 answer
363 views

MySQL Server configuration, is it enough for my needs?

I've never dealt with MySQL before, so I am very new at this. I am connecting my MS Access front-end to MySQL server. The server configuration is 2 CPU Cores, 2GB RAM and 60GB SSD. The server has ...
Alex's user avatar
  • 11
0 votes
0 answers
49 views

MS Office Update removes my ODBC Connection to MySQL Server

I've had couple times where an Office Update cleared or removed MS Access Database ODBC connection to MySQL server. I have three people using this database, and if anyone updates their Office Suite ...
Alex's user avatar
  • 11
0 votes
2 answers
1k views

ODBC driver inserted from registry key does not show up in Source Administration

I have exported an existing PostgreSQL ODBC driver (64 bit) entry from the registry at Computer\HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI And modified the name of the driver name. The original was ...
ap0's user avatar
  • 1,318
0 votes
1 answer
395 views

Asterisk: ODBC options not available in menuselect

I have done yum install unixODBC and yum install freetds, but when I try make menuselect while installing Asterisk, none of the ODBC options are available. func_odbc and res_odbc show up with an XXX ...
Matt's user avatar
  • 121
-1 votes
1 answer
3k views

SSIS Error - ODBC Source

I am using ODBC connection to connect to MYSQL in SSIS - the connection is successful, but when the SSIS package is executed, I get the below error. [ODBC Source [30]] Error: SQLSTATE: 22018, Message: ...
Jeni's user avatar
  • 3
0 votes
0 answers
2k views

How to setup Oracle ODBC for MS Access 64bit on windows

I have used more time on getting ODBC for Oracle to work than I would like to admit. The crest is simple. Link tables from MS Access to Oracle Everything is running 64bit. Oracle Express 11.2G, ...
Martin Andersen's user avatar
0 votes
0 answers
233 views

Why VM in domain can't see SQL Server outside domain?

I have the following scenario: 1 Windows 10 home host machine with SQL Server up 2017 and running. 1 Domain server VM running over host machine. 1 Windows 10 pro VM running over host machine, and ...
Dandev's user avatar
  • 3
1 vote
0 answers
291 views

Can I copy an entire database from an ODBC connection to a local file?

I have a working ODBC connection to an external database which will soon be shut down. I have already extracted all the information I think I'll need in the future, but I can't help but wonder if I ...
Michael Murphy's user avatar
1 vote
0 answers
62 views

Can't add new System ODBC to PostgreSQL db

I am working on HP 64-bit machine on Windows 10. Already have a working System ODBC connection to a "Production" PosgreSQL db, it is postgreSQL ANSI(x64), using it for a while now. The problem is, ...
DataWrangler's user avatar
1 vote
1 answer
302 views

Data from Excel file is not being displayed using odbc in php

Here is my code: <?php $connect = odbc_connect('Test','EWF','EWF'); $query = "SELECT * FROM [Sheet1$];"; $result = odbc_exec($connect,$query); $row = odbc_fetch_array($result); if (!$row){ $...
WhiteRose's user avatar
0 votes
1 answer
1k views

Cannot connect to Oracle Database with Power Query

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online: That picture not being there I hit the documentation explaining I should ...
neydroydrec's user avatar
0 votes
0 answers
149 views

Unable to connect to MySQL with ODBC Driver

I'm unable to connect to MySQL via Remote MySQL using ODBC Driver for our Microsoft Access Application. I have the same setup at the office and it's working fine but not at home. That's my setup. 1. ...
Murtaza Abbasi's user avatar
1 vote
0 answers
313 views

SQL Server 2017 - Support for old SQL Server ODBC Driver (SQLSRV32.dll)?

I have a legacy application that currently uses an ODBC connection to an instance of SQL Server 2008. However, we are migrating to a new server running SQL Server 2017. It seems I am not able to ...
jaker's user avatar
  • 11
2 votes
0 answers
932 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 ...
HyperQBE's user avatar
0 votes
0 answers
369 views

Microsoft Access ODBC Call to MySQL Failed with No Error Information

I'm trying to connect Access to a View Table in an MySQL Database that I have access permission to. However, when I select the table to import, the following error message pops up: Which is great - ...
skeetman's user avatar
0 votes
1 answer
83 views

Issues attempting to use MongoDB connector for BI

I am trying to add MongoDB as a linked server to MSSQL server but it is not working. I need to set up MongoDB connector for BI and then add it in the system DSN of the ODBC driver. I am following the ...
Shm3nt1's user avatar
  • 11
0 votes
1 answer
319 views

Teradata odbc configuration on Linux

I have installed ttu 16.20 on amazon linux and trying to configure it now for application access. I have the below and I have set the below path, When I try to connect to the datasource it throws ...
Karthikeyan Janakiraman's user avatar
3 votes
2 answers
5k 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....
aucuparia's user avatar
  • 307
0 votes
0 answers
910 views

ODBC: user data source

Within the ODBC admin tool, there are the following Platform column values. How do you get ODBC to display 32/64 bit? We're only seeing 32-bit and need for it to show 32/64 bit in the Platform ...
user7571572's user avatar
1 vote
0 answers
266 views

MS Access Error: Invalid field definition 'CON474' in definition of index or relationship

Looking for some help with a MS Access problem. I am creating a bunch of linked tables between Access and our AS400 (iSeries) system. I have some OBDC DSN's set up and can access the system without ...
Ben  Smith's user avatar
0 votes
1 answer
1k views

MySQL 5.7 connection issue using ODBC 3.51 32 driver

I'm facing a really strange problem. I have the following configuration: Ubuntu host with MySQL 5.7.25 Community edition running on it Windows 10 guest VM with ODBC 32 bit driver 3.51 ssl tunnel from ...
Alex B's user avatar
  • 1
0 votes
1 answer
1k views

Hot to force Asterisk to write date in UTF-8 charset?

CentOS Linux release 7.6.1810 (Core) Kernel: localhost.localdomain 5.0.7-1.el7.elrepo.x86_64 MariaDB: Ver 15.1 Distrib 10.4.4-MariaDB, for Linux (x86_64) using readline 5.1 Asterisk: 16.3.0 built by ...
rGA145's user avatar
  • 111
0 votes
1 answer
8k views

Where to find libmyodbc5.so library after mysql-connector-odbc installation?

CentOs7 Want to connect my Asterisk installation with MariaDB via mysql-connector-odbc driver. yum list installed | grep maria MariaDB-client.x86_64 10.4.4-1.el7.centos @...
rGA145's user avatar
  • 111
2 votes
0 answers
321 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 ...
i_love_chocolate's user avatar
1 vote
0 answers
351 views

How do I stop the following error from occuring? "A connection attempt failed" (see full error in body)

I am getting the following error on an excel workbook which has a data connection to a sql database. A connection attempt failed because the connected party did not properly respond after a period ...
Jack Thompson's user avatar
0 votes
1 answer
2k views

MS ODBC SQL Driver 13 version issue, How do I get/install a newer version?

It simply seems that MS has not updated their download site to have the most up to date version of the version 13 ODBC driver. When I download the MS SQL ODBC driver 13 from the Microsoft site, it ...
GraspSoftwareCorp's user avatar
1 vote
1 answer
2k views

'invalid pointer' with ODBC on CentOS 7

I'm running into an 'invalid pointer' with ODBC on a CentOS 7 machine while developing a new Asterisk (PBX) configuration. A previous server with identical set-up (unixODBC version 2.3.1) works fine. ...
Olivier's user avatar
  • 11
0 votes
1 answer
1k views

Simba ODBC Driver DSN Setup Cannot Test The Connection

I'm having an issue with Simba ODBC Driver DSN Setup. I'm using Service Authentication, can reach the catalog and dataset. So, the "Catalog (Project)" and "Dataset" dropdowns are filled with the ...
HazalCamur's user avatar
0 votes
0 answers
801 views

Excel, ODBC - desired database not listed

When I attempt to create an ODBC to a server (named DARKHELMET for all you spaceballs fans out there) it doesn't show in the list of available data sources. ..but it does show up under data source ...
Jason's user avatar
  • 1
0 votes
1 answer
513 views

PowerQuery ODBC connection revokes password: due to auto-refresh?

I have a nice PowerQuery query that connects with ODBC to a database. Our passwords change every month. When I enter GetAndTransform to edit the query, that time of the month - even if I don't ...
Relaxed1's user avatar
  • 189
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 ...
Andy K's user avatar
  • 392
0 votes
2 answers
1k views

Migrating multiple User DSN connections (ODBC)

I'm looking for a way to migrate multiple User DSN connections (ODBC) from an old server to a fresh new server. In the registry i can only see the saved User DSN connections of my own user, is there ...
M. St.'s user avatar
  • 1
0 votes
1 answer
2k views

32-bit ODBC32 system DSN on Windows 10 apparently not able to access network

I have an application which runs correctly on most of my machines here. Two of them stopped working for no reason that I could fathom (same updates as all the others, same network settings, same ...
LSerni's user avatar
  • 8,435
1 vote
0 answers
2k views

[unixODBC][Driver Manager]Can't open lib '/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.1.so.0.1

I am trying to run windows command line program that uses ODBC to connect to a remote MSSQL server. It works fine in Windows 10. Now I want to run the same program in Linux using Wine. I have ...
Jake He's user avatar
  • 111
0 votes
1 answer
40 views

How to know/contact a community which hold an API (ODBC API)

I am currently working with the unix-odbc API to create my own ODBC driver. I found on wikipedia that ODBC is a standard and is implemented by communities. In computing, Open Database ...
Brighter side's user avatar