Questions tagged [odbc]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
29 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 ...
0
votes
1answer
25 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.&...
0
votes
0answers
39 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 ...
0
votes
0answers
64 views

ODBC / MS Access connection from Hyper-V VM to SQL Server on host

I am working on a very legacy piece of software which requires that the development environment runs in a Hyper-V VM. It uses ODBC to connect to a SQL Server, which is currently installed on my ...
0
votes
0answers
26 views

Diferent dependences Oracle unixodbc

I'm trying to configure Zabbix monitoring on Oracle database, but I have dependence problem from diferent users, when I run: sudo -u zabbix ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so: ...
0
votes
0answers
51 views

Error interacting with REST API The user does not have bigquery.datasets.create permission in project

I'm trying to use Simba Bigquery ODBC driver to extract some data into external database. While connection works fine, and I can see the project tables, I cannot execute my SQL. Query runs just fine ...
0
votes
1answer
331 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), ...
0
votes
0answers
29 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 ...
0
votes
1answer
449 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 ...
3
votes
0answers
527 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 ...
2
votes
0answers
315 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 ...
1
vote
1answer
561 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 ...
0
votes
1answer
287 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 ...
1
vote
1answer
1k 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:...
1
vote
1answer
219 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) ...
0
votes
1answer
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. ...
0
votes
1answer
557 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
vote
1answer
1k 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 ...
1
vote
1answer
7k 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 ...
1
vote
1answer
1k 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 ...
1
vote
1answer
5k 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 ...
0
votes
1answer
308 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 ...
0
votes
0answers
111 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 ...
0
votes
1answer
123 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 ...
0
votes
2answers
9k 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
1answer
2k 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 & ...
0
votes
1answer
383 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 ...
0
votes
1answer
462 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 ...
0
votes
1answer
236 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 ...
0
votes
1answer
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 ...
0
votes
1answer
4k 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 ...
0
votes
1answer
345 views

Setting up End-User Connection to ODBC Data Source

I need to connect my MS Access (front-end) database to SQL Server 2008 (back-end), using my ODBC connection, for all of my team to view the data in the MS Access reports, forms, etc. My MS Access ...
0
votes
0answers
80 views

Conflicting libodbc.so for Teradata and Hive on solaris

We seem to have a situation where the ODBC drivers for solaris of Teradata (v 14.10 from Teradata) and the Simba Hive ODBC (v 2.0.3) are requiring different versions of the shared objects: libodbc.so ...
-1
votes
2answers
1k views

Save ODBC credentials for Oracle on Windows

On my dev machine (Mint Linux), I have ODBC set up with credentials so that I only have to specify DRIVER and DBQ in the connection string. Unfortunately, the script will have to run on a Windows ...
2
votes
1answer
2k views

IBM's iSeries ODBC driver not sending any traffic when invoked via isql or otherwise, getting [08S01][unixODBC] and [ISQL]ERROR: Could not SQLConnect

Note: I've replaced IP addresses, database names, and server users with examples. That shouldn't affect anything. The Setup I've installed unixODBC (yum install unixODBC) and IBM's official iSeries ...
0
votes
1answer
226 views

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to ...
1
vote
1answer
103 views

How to copy ODBC Composite data sources from one server to another?

Both servers are Windows 2008 R2 x64. I have tried exporting [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI] but it doesn't contain the actual data source configuration for a Composite 6.1 data source. ...
3
votes
1answer
667 views

What kind of file and folder permissions are necessary for ODBC?

In our network, we are using an application that connects to an *.mdb access database through ODBC (User DSN). The mdb is based on a subfolder of a share that is locally mapped to W: What kind of ...
0
votes
1answer
931 views

Connect via ODBC to Progress 9.1D database running on SCO Unix

We are looking to take a database dump of a really old database from a Progress DB system we have running at our office, however we've come up against a brick wall trying to connect to the system ...
3
votes
2answers
6k views

Sharing SSH port tunnel with local network

I've successfully created a SSH tunnel to our cloud postgresql server on a local linux server, with this command: ssh -N -f -L 5431:localhost:xxxx mycloudserver.com (where xxxx is remote port) With ...
0
votes
2answers
867 views

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 ...
1
vote
1answer
14k views

Connecting to MSSQL db (PDO, FreeTDS, ODBC)

I have an Ubuntu 12.04 server and I'm trying to establish a connection to a MSSQL database. I've managed to connect using tsql and isql, but osql doesn't work and connecting with PHP using PDO also ...
0
votes
1answer
1k views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
0
votes
1answer
993 views

What is needed for a remote ODBC connection via PARKWAY ConnectWare for Micro Focus Files

Recently I got the task of building a PHP application, that connects to a remote ODBC driver. We got the ODBC driver and set up a test environment. Since it's my first time working with ODBC drivers,...
2
votes
2answers
999 views

Unable to Create MySql 64-bit System DSN on Windows

I have a very similar problem to "Unable to Create System DSN," but none of the fixes suggested there have worked for me. System: Windows 7 64-bit Enterprise. I'm trying to create a DSN to use ...
0
votes
1answer
155 views

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the ...
0
votes
1answer
2k views

ODBC Driver Version 03.86.3959 connection to SQL Server 2014

Ok so I have some accounting software running on a Windows Server 2003 box. This server uses a System DSN, that uses Microsoft SQL Server ODBC Driver Version 03.86.3959 to connect to a Management ...
0
votes
1answer
792 views

Testing MySQL 32-bit ODBC connection via CMD

I'm going to make a batch script to do some basic troubleshooting. Among other things, I want to test 32-bit MySQL ODBC's for connectivity. This script will run locally on each workstation. There ...
0
votes
1answer
175 views

FreeTDS - sudo uses different protocol version

After a while of fiddling with FreeTDS I got my connection to MSSQL from Sphinx up and running as DSN-less connection. After running indexer index Everything works as expected. But, after running ...
0
votes
1answer
302 views

How to read/ modify freetds.conf (for ODBC) using augtool or similar in bash script?

How can I get augtool (augeas) or a similarly common tool to work with freetds.conf, so I can automate some configuration in a bash install script? This doesn't seem to work: augtool print "/files/...