Questions tagged [odbc]
In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
144
questions
0
votes
0answers
18 views
MailMerge Word with MySQL database
I try to mailmerde a word document with Word 2016. I want to connect to a MySQL database. I have a connection using odcb32 and I use it frequently for other db applications. It also works from Excel.
...
0
votes
0answers
33 views
Asterisk Call Data Record Logging via Adaptive ODBC to IBM DB/2 not working
I'm running a stock Debian 9 with the accompanying Asterisk packages (Version 13.14.1). To save loading time and memory consumption, I don't autoload modules in modules.conf but edit the list of ...
0
votes
0answers
243 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, ...
0
votes
0answers
53 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 ...
1
vote
0answers
22 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 ...
0
votes
0answers
7 views
mysql odbc ssl default configuration centos
I am trying to determine if my ODBC code is using SSL or not. I know I do not configure it in my /etc/odbc.ini or ~/.odbc.ini files. But when I go into isql, it seems to be enabled. So I am a ...
1
vote
0answers
35 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, ...
1
vote
1answer
48 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){
$...
0
votes
0answers
46 views
Any Work-Arounds for the IBM DB2 ODBC exception 0xc0000005 in db2clio.dll?
I'm running MS Office 2016 64 bit and trying to connect to an IBM DB2 server to attach tables in MS Access 64 bit through 64 bit ODBC, but I keep running into this error - https://www.ibm.com/support/...
0
votes
0answers
102 views
ODBC failing to connect to AWS RDS when SSL enabled
I cannot get ODBC to connect to our MySQL RDS instance using SSL. I get the following output:
[root@localhost]# isql mysql-test_db -v
[S1000][unixODBC][MySQL][ODBC 5.1 Driver]SSL connection error
[...
0
votes
1answer
268 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 ...
0
votes
0answers
46 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. ...
0
votes
0answers
247 views
Simba ODBC Driver for BigQuery “Error interacting with REST API: Already Exists: Dataset”
I am trying to set up the Simba ODBC Driver connection to BigQuery connecting to Excel on my home computer, but it is giving this error:
[DataSource.Error] ODBC: ERROR [HY000] [Simba][BigQuery] (...
1
vote
0answers
84 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 ...
0
votes
0answers
54 views
Simba Athena ODBC driver ,does not save the configuration details such as password, username
I am trying to connect ODBC Athena driver using assumed role to AWS Athena.
This driver has the configuration details. I have given username ,password and session token for IAM credentials. This ...
2
votes
0answers
543 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 ...
0
votes
0answers
161 views
Setup ODBC Connection to Allow Remote Access
I got a Windows PC with MySQL installed and I'll need to access it remotely via ODBC from another machine on a different network. Is it possible and how can I do that?
I've Googled and found a lot of ...
0
votes
0answers
19 views
Simba Spark ODBC Driver DSN Setup
enter image description here
I believe I have the right host and port specified. So how do I confirm if SSL should be enabled?
0
votes
0answers
19 views
Client side connection issues. Connecting to SQL server 2017 from 64 bit brand new Surface tablet
I have been trying for 2 days to connect a new tablet to our SQL server. We usually have no issues and I have at least 10 other devices set up exactly the same way on the same network with the same ...
0
votes
0answers
120 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 - ...
0
votes
1answer
45 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 ...
0
votes
0answers
10 views
Character/Text Column Corruption in Returned Data from DB2 12 via an ODBC connection on macOS
Executing a SQL query using Excel against DB2 for z/OS 12 via ODBC on macOS.
Problem is returned character column data contains corrupted (or unsubstituted) bytes in column names and result content.
...
0
votes
0answers
163 views
asterisk ODBC Data source name not found debian 9
I've been trying to get odbc working with asterisk.
As of now, I think the fault is with ODBC/driver/packages as I am not able to even run isql command and get output:
Error :
root@odbctest:/home/...
0
votes
1answer
215 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 odbc.ini,
bash-4.2# cat /opt/teradata/client/16.20/odbc_64/odbc.ini
[ODBC]
For ...
2
votes
1answer
1k 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....
0
votes
0answers
147 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 ...
0
votes
0answers
160 views
Connecting Access to Oracle
Just downloaded Oracle XE 18c for Windows x64. I have Office 365 64-bit. Trying to connect Access to Oracle via ODBC driver. Never had this problem with 11g XE. I am able to setup the DSN just fine ...
1
vote
0answers
125 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 ...
0
votes
1answer
334 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 ...
0
votes
1answer
272 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 ...
0
votes
1answer
2k 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 @...
2
votes
0answers
141 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 ...
1
vote
0answers
37 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 ...
0
votes
1answer
943 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 ...
1
vote
1answer
656 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. ...
0
votes
1answer
88 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 ...
0
votes
0answers
93 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 ...
0
votes
1answer
120 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 ...
1
vote
1answer
501 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 ...
0
votes
2answers
299 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 ...
0
votes
1answer
1k 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 ...
0
votes
0answers
1k 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 ...
0
votes
1answer
29 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 ...
0
votes
1answer
1k views
How can we disable ODBC credentials popup in excel
Can we disable the ODBC credential popup on refresh of external data
in Excel 2016:
and, if so, how?
2
votes
1answer
390 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 ...
0
votes
2answers
8k 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 ...
1
vote
0answers
446 views
Linked Server between Progress database and MS SQL Server management studio
I wish to set up a linked server within MS SQL Server Management 2014 to access my PROGRESS DB. The Linked Server will allow us to update the tables etc and then run our queries off of SQL Server.
I ...
4
votes
2answers
538 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 ...
0
votes
0answers
293 views
Odbc connection with Sqlserver Progress openEdge
I am working on the MS SQL server so I want to connect MS SQL Server to progress OpenEdge Database and import all data from OpenEdge to SQL Server through ODBC. I add driver from Data sources in ...
0
votes
0answers
31 views
Why is the database tab not functional in Crystal Reports 9?
I have a particular report that I can run, it prompts for an Oracle username and password and then generates the report. The Database tab is not fully available. I cannot select Database Expert or set ...
