Questions tagged [odbc]
The odbc tag has no usage guidance.
183
questions
0
votes
0
answers
12
views
What's the ODBC SparkSQL Source Format for Connecting with PHP ODBC & Spark?
What's the ODBC SparkSQL Source Format for Connecting with PHP ODBC & Spark?
Here's the code I need to edit:
$conn = odbc_pconnect("CData ODBC SparkSQL Source","user","...
- 1
0
votes
0
answers
24
views
Add ODBC driver for Office 365 (local install) in Windows Server 2016
For some ETL operations using Microsoft's SSIS system, we need to read data from an XLSX file accessible from the database server (Windows Server 2016, Microsoft SQL Server 2017 on prem).
When ...
- 175
0
votes
1
answer
38
views
Have you got a worked example of using Postgres through ODBC with openssl and the Progress DataDirect Linux driver?
I am new to openssl configuration, Postgres, and the Progress DataDirect ODBC driver, and I am trying to set this up. I have Postgres working in a container, set up with
tjcw:~$ openssl req -new -x509 ...
- 69
0
votes
0
answers
125
views
[Microsoft][ODBC Driver 17 for SQL Server] SSL Provider: [error:0A000102:SSL routines::unsupported protocol] in PHP Laravel on macOS using Brew
I'm encountering an issue while trying to connect to a SQL Server database using PHP Laravel on macOS with Brew. I'm receiving the following error message:
[Microsoft][ODBC Driver 17 for SQL Server] ...
0
votes
1
answer
50
views
Is the MariaDB ODBC Connector 3.1.19 now stable for production when used with ASP Classic?
Has anyone used this driver successfully in a production environment?
Some time back I tried the MariaDB ODBC Connector 3.1.15 with a MariaDB 10.6 database; and the site kept crashing.
I had to ...
- 264
0
votes
0
answers
64
views
Windows MariaDB 10.6.5 upgrade to MariaDB 10.6.11
I am considering upgrading my MariaDB 10.6 to 10.11 -- (maintained for 5 years).
I updated 10.6.5 to 10.6.15 with a simple in-place update; but found these troubling comments on doing updates form 10....
- 264
0
votes
1
answer
67
views
Unable to install SQL Server 2019 because of the missing ODBC driver
I am unable to install Microsoft SQL Server 2019 Developer Edition because of a missing ODBC driver 2017 (screenshot attached)
I already installed various version of the ODBC driver, already ran ...
- 101
0
votes
1
answer
37
views
Does installing/updating 64-bit odbc driver automatically install/update 32-bit and 64-bit driver?
I installed odbc driver 18 (64-bit), but notice that it shows up in both system32 and syswow64's odbc.exe.
Does installing/updating 64-bit odbc driver automatically install/update 32-bit and 64-bit ...
- 177
0
votes
0
answers
176
views
CDR not working with asterisk & odbc
I had ODBC working with asterisk to write to my CDR then recently needed to check my CDR to realise nothing had been written for about 6 months. I had a look at my config, nothing seamed to have ...
- 23
0
votes
1
answer
361
views
Installing ODBC 18 driver on Amazon Linux
I see instructions from MS site on how to install ODBC drivers on various Linux distributions but not for Amazon Linux.
https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-...
- 101
1
vote
1
answer
130
views
Is it possible to create a linked server between the ServiceNow ODBC driver and an AWS/RDS SQL Server instance?
I have an internal .NET 7 web application that uses an MSSQL database hosted on Amazon RDS.
I have a requirement to create a linked server to query data from a separate ServiceNow DB instance.
The ...
- 280
0
votes
0
answers
49
views
unixODBC SQLFetch infinite loop after INSERT statement
I'm trying to work with unixODBC and a SAP Hana database, and created a simple C program to INSERT/SELECT into the database. My problem is, if I use for example
SQLExecDirect(stmt, "SELECT * FROM ...
- 1
2
votes
2
answers
4k
views
SQLCMD command works but ODBC does not
I'm trying to connect to a MS SQL server from a Linux machine, but can't get ODBC to work.
The following command works and I get a shell:
sqlcmd -S tcp:<servername>,<dynamic port> -U <...
- 65
0
votes
0
answers
667
views
MSSQL: Service is unavailable
I'm whipping up a demo of Zabbix in our environment and have some trouble monitoring a SQL server.
The error: 'MSSQL: Service is unavailable' > 'The TCP port of the MS SQL Server service is ...
- 65
1
vote
0
answers
21
views
How to optimize network throughput with AWS Redshift
I've read about the sslcompression ODBC option in PostgreSQL, which seems to have some artifacts left in Redshift. But, I'm unsure if it is supported at all, and documentation seems to show that ...
- 3,488
0
votes
3
answers
530
views
MySQL connector/ODBC connection error following a DNS mismatch
I have troubles configuring a new MySQL connection with ODBC Data Sources (64bits) utility on a Windows Server 2019. I'm using MySQL Workbench to define remote accesses as follow:
The user is granted ...
- 75
1
vote
1
answer
878
views
Error: File home.asp Unexpected error. A trappable error (C0000005) occurred in an external object. Using ODBC Connector
How can I get my application pool to stop crashing on me?
Background
All was working well for many years, until I updated Windows 10 Pro to the suggested update Windows Feature Experience Pack.
...
- 264
0
votes
0
answers
48
views
Is it possible to set up the database connection if we are provided with ODBC registry file?
One of the users already has all the OBDC connections configured on to the RDC user account. That machine is used to connect to all the databases.
A new user on boards into the organization, his log ...
2
votes
1
answer
155
views
Built PHP from source with custom DataDirect ODBC drivers, but can't auto start with systemd
I need to build PHP from source in order to use this customer ODBC drivers. I've followed these inspections: https://www.progress.com/tutorials/odbc/using-php and everything (including the ODBC driver)...
- 311
0
votes
1
answer
276
views
Need help to block access ODBC Data Source Administrator for normal users in Windows AD via Group Policy
Users should not add/modify DSN in ODBC Data Source Administrator in Windows client, so we most likely need to block access to ODBC Data Source Administrator for users in Windows AD via Group Policy.
0
votes
1
answer
301
views
RedHat 7 msodbcsql17 problems
I initially asked this on StackOverflow, but it is not application development issue in my opinion. Basically, I have a C++ application which connects to SQL Server using msodbcsql17 package. It is ...
- 113
1
vote
1
answer
3k
views
How i can install mariadb odbc connector on Ubuntu 20.04
How i can install mariadb odbc connector from sources https://github.com/mariadb-corporation/mariadb-connector-odbc? i tryed install by using this https://blog.sleeplessbeastie.eu/2018/01/08/how-to-...
- 121
0
votes
0
answers
917
views
Configuring postgresql12-odbc to use the correct protocol version
I have a Centos 7 box with unixODBC 2.3.1 and postgresql-odbc 12.02 installed, which is connecting to a PostgreSQL server also running v12.
Although I believe I have configured ODBC to use the v12.0 ...
- 105
0
votes
1
answer
564
views
What causes Installshield to fail (error: 1628)?
I'm trying to setup a DB/C FS 4.0 ODBC driver on our server to connect to a client's database, and am receiving an error from the Installshield executable: "1628: Failed to complete installation.&...
- 1
0
votes
0
answers
111
views
Should I install Microsoft Redistributables not marked as "Supported"?
I have a requirement to upgrade one of our Operating Systems from Windows Server 2012R2 to Windows Server 2016. The hosted application requires numerous ODBC Drivers that in turn require a bunch of ...
- 1
2
votes
1
answer
1k
views
ODBC Driver for IBM iSeries AS400 version V7R1
I am trying to connect to IBM iSeries using pyodbc, a Python interface for ODBC, on Linux Red Hat (Intel 64bit arch).
The following is what I have done:
Installed gcc-c++ (needed to compile pyodbc), ...
- 131
0
votes
0
answers
283
views
How to login to MS SQL Server using Ubuntu OS & ODBC with disabled SQL Server Authentication and only accept Windows Authentication?
It is only part of my problem but technically, I am trying to access an SQL Server with disabled SQL Server Authentication using ODBC connection string in Ubuntu OS. I already tried to connect with ...
- 23
0
votes
1
answer
3k
views
SQL Server ODBC Driver
When I create a new ODBC data source, I'm offered 4 different controllers to access SQL Server:
ODBC Driver 13 for SQL Server (Version 2017.140.1000.169)
SQL Server (Version 10.00.17763.01)
SQL ...
- 101
3
votes
0
answers
2k
views
InterSystems ODBC drivers not connecting
Errors when trying to create a ODBC DSN.
Have tried both 32-bit and 64-bit InterSystems ODBC drivers (version 2018.1.2.309.0).
OS: Windows Server 2019 Version 1809
The 32-bit ODBC connection was ...
- 458
2
votes
0
answers
1k
views
ODBC Driver 17 for SQL Server
Morning,
Some background:
Recently upgraded database and web servers from Server 2008R2 => 2016 OS
Recently upgraded database instances from SQL Server 2008R2 => 2016
Recently upgraded the ODBC ...
- 21
1
vote
1
answer
2k
views
ODBC Item on MySQL query causes Zabbix server to stop
I'am new to Zabbix. Today I've tried to add a SQL item (Database monitoring) to a host without success.
Without this SQL item, the Zabbix server runs fine. I check this with service zabbix-server ...
- 121
0
votes
1
answer
1k
views
Is there any way of backing up the ODBC drivers of a server?
I need to replicate the ODBC drivers from one environment to another located on other server, the one that has the drivers I want to backup is running Windows Server 2012 Datacenter and the other ...
- 33
2
votes
1
answer
4k
views
Kerberos ticket cache location on windows for multiple users
I am using multiple odbc drivers connecting to hive and impala, and most of the documentation states that the kerberos ticket location should be defined by a environment variable KRB5CCNAME, such as C:...
- 23
2
votes
1
answer
553
views
Conflict when editing new records in Access connected to PostgreSQL by ODBC
I have a setup with Microsoft Access 2010 as a front-end and PostrgreSQL server 9.5.12 running on Linux as a back-end. Windows PC has PostrgreSQL ODBC driver
version 10_02_0000 (currently latest) ...
- 161
0
votes
1
answer
2k
views
Unable to Connect to SQL Server 2014 SP2 using the SQL Native Client 10
Attempting to connect using the SQL Server Native Client 10.0 Results in the below error:
Client Unable to establish connection
Shared Memory Provider: No Process is on the other end of the pipe.
...
- 26
0
votes
1
answer
1k
views
MariaDB 10.2.9: Storage Engine 'CONNECT' not found when trying to map MSSQL table
I am running a MariaDB Galera cluster and am trying to access MSSQL from within MariaDB on the first node. I have done this in the past on SLES 12 SP2, this time I am trying to do the same on RHEL 7.3....
- 1,032
5
votes
1
answer
3k
views
Issues Programmatically Adding ODBC DSN to ODBC Administrator on Windows
I am working on trying to automate some configuration, and as part of that we need to add an ODBC DSN through a script. The driver I'm trying to use is the Cloudera Impala ODBC Connector, downloaded ...
- 153
1
vote
1
answer
11k
views
System resource exceeded - what resource could that be?
I'm trying to run an asp.net page that connects to an access database via an ODBC Data Source. I'm using the Microsoft Access ODBC Driver. Everything was working fine until a recent power outage ...
- 111
1
vote
1
answer
2k
views
How to update unixODBC via yum on EB awsLinux
In summary I need to update unixODBC on the Elastic Beanstalk PHP instances, preferably using yum as it's quite easy to manage via .ebextensions.
AWS Linux: 64bit Amazon Linux 2017.03 v2.4.2 running ...
- 161
1
vote
1
answer
6k
views
Installing 32 bit and 64 bit Informix drivers on same machine
Currently trying to setup a development environment which can handle both 32-bit and 64-bit ODBC Informix Drivers.
I'm was unsuccessful at finding any sort of guide or walk through online, however I ...
- 141
0
votes
1
answer
791
views
Powershell Get-ODBCDSN error - Timeout when waiting for another concurrent operation to complete
After some database issues the night before, multiple servers (separate from the database servers) are getting the following error when just running the 'Get-ODBCDSN' function from a powershell ...
- 5
0
votes
0
answers
214
views
Simba ODBC driver (130) Unable to authenticate with Google BigQuery
When I trying to connect to BigQuery with Simba ODBC driver using service authentication, I have error
(130) Unable to authenticate with Google BigQuery.
But only on Windows Server 2012 R2. For ...
- 101
0
votes
1
answer
332
views
Mysql Login wildcard not working on a single machine
I am trying to login into mysql on a pc and I just can't figure out what is wrong with it.
The error:
Acces denied for user 'username'@'xxx.xx.xxx.xx'
There are 15-20 connections already made to ...
- 171
0
votes
2
answers
11k
views
Ubuntu 16.04 PHP 7 & Microsoft ODBC Driver for SQL Server on Linux - odbc_connect undefined
I'm new to Linux. I have provisioned a new Ubuntu 16.04 server, added LAMP via Tasksel, and added PhpMyAdmin. I added my web app to the html folder, and ran my MySQL scripts. This part works fine. I ...
0
votes
1
answer
3k
views
Accessing Mysql Database through ssh tunnel in SQL Server
I've had a look around for an answer to this online without much luck. I want to connect a MYSQL Database to SQL Server Management Studios through a ssh tunnel ODBC connection. I have usernames & ...
- 3
0
votes
1
answer
876
views
How to avoid information message of sqlcmd?
I'm writing script to connect database & execute store procedures, which works fine. But sqlcmd prints extra information message/ invalid characters to command line. Sqlcmd version 13.0.0000.0 ...
- 121
0
votes
1
answer
555
views
ODBC--connection to 'systemDSN' failed
We have a Microsoft Access 2010 database (ACCDB).
This ACCDB file is just a front end to a Microsoft SQL Server 2008 database.
Authentication to the database is accomplished by Windows integrated ...
- 3,094
0
votes
1
answer
342
views
SSRS 2012 ODBC Driver architecture mismatch on remote computer, works locally
I have an SSRS 2012 server (Windows 2012) with Ingres ODBC drivers installed, ODBC entries have been configured in the 32 bit (SysWOW64) ODBC manager. Reports ran locally on the server run without a ...
- 11
0
votes
1
answer
2k
views
Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8
I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google.
My test machine is a vagrant VM, and these ...
- 13
0
votes
1
answer
5k
views
Problems connecting to SQL Server using ODBC
Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I ...
- 1