Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [odbc]

The tag has no usage guidance.

1
vote
1answer
142 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
38 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 ...
0
votes
0answers
15 views

Requirements for Windows Server 2008 application to connect to SQL Server 2016

I have a legacy web server running Windows Server 2008 32-bit - it is not running 2008 R2. I plan on replacing it in 2019 with Windows Server 2016. But in the meantime I would like to move some SQL ...
0
votes
1answer
389 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
82 views

Conflict when editing new records in Access connected to PostrgreSQL 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
0answers
79 views

PostgreSQL server/odbc driver versions matching

I've recently encountered a compatibility issue between postgresql server 8.4 (I know, I know...) and postgresql ODBC driver 10: they can't talk to each other properly. My question is: is there a ...
0
votes
1answer
847 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
365 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
611 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
3k 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
519 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
3k 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
141 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
75 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
81 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
7k 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
1k 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
233 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
230 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
194 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
3k 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
276 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
74 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
494 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
978 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
189 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
87 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
416 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
744 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
4k 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
789 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
12k 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
888 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
878 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
824 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
149 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
1k 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
601 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
124 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
272 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/...
-1
votes
1answer
215 views

Windows 2003 R2 Missing mapped drives under ODBC Administrator [closed]

When I try to set up an ODBC datasource (MS Access) I can't select the network drive where the mdb file is. The network drive is accesible from My Computer.
0
votes
1answer
63 views

Is it safe to Update and/or Insert records into an accounting software's database? (Pastel Evolution)

Our CRM system can post transactions to our accounts software (Pastel Evolution), but it doesn't perform the required currency conversion. Both systems have different "base" currencies (because of our ...
0
votes
1answer
3k views

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some ...
-3
votes
1answer
383 views

Windows Server 2008 iis 7.5 classic asp mdb DB via DSN odbc [closed]

I had a a simple site on a 2003 IIS 6 server for years. I have a small DB in a Mdb file. Everything was great, until I've upgraded to a windows 2008 R2 64bit IIS 7.5 server. I've transferred the site ...
0
votes
1answer
1k views

ORA-01019 under Win 8.1 / Server 2012 R2, ODBC Excel

We getting error message ORA-01019 when trying to connect to an Oracle 9.2 database with ODBC in an Excel macro running in Office 2013 32bit (!!!) under Windows 8.1. We are having the same issue ...
2
votes
0answers
276 views

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding ...
2
votes
0answers
522 views

doing ODBC System DSN's from Active Directory

2008R2 Active Directory, workstations are Win7 Ent, Office/Excel 2013, Oracle 11.2. Excel fetches data from Oracle using System DSN's. Where can I put ODBC System DSN's in Active Directory? Do I ...
5
votes
1answer
2k views

32bit ODBC Postgres driver on Windows 2008 R2 x64

I'm trying to install the Postgres ODBC 32bit driver on a Windows 2008 R2 64bit machine. After installing it, with no errors, I go to the ODBC panel, the 32bit version under the /syswow64 folder and ...
1
vote
2answers
200 views

ODBCs by Application

I am familiar with ODBCs by system (system DSNs) and ODBCs by user (user DNSs). I want to have ODBCs by application. I want to limit the ODBC connections available to a specific application, GP 2010....