Questions tagged [odbc]

The tag has no usage guidance.

53 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
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 ...
Ash's user avatar
  • 458
3 votes
0 answers
491 views

System.Data.Odbc.OdbcConnection.Open() takes a second for every db call

My experience is with LAMP stacks and not so much with .NET on Windows, but I've been given the task of trying to debug a slow site and I've run into a dead end after Googling everything I can think ...
Matt R. Wilson's user avatar
3 votes
1 answer
4k views

ORA-12705: invalid or unknown NLS parameter value specified

I have a J2EE application hosted on JBoss on Linux. When I try to access the application, I see following error in the server.log file. ORA-12705: invalid or unknown NLS parameter value specified ...
Viky's user avatar
  • 648
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 ...
delizat's user avatar
  • 21
2 votes
2 answers
1k 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 ...
sdjuan's user avatar
  • 221
2 votes
0 answers
314 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 ...
JJBurgess's user avatar
  • 141
2 votes
0 answers
551 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 ...
user52874's user avatar
  • 829
2 votes
0 answers
1k views

Website loses connection to database intermittently

Every so often our website loses connection to the sql server and I receive the following errors: "The following error: A network-related or instance-specific error occurred while establishing a ...
Nixon's user avatar
  • 21
2 votes
0 answers
2k views

Restricting access through ODBC to only schema views SQL 2008

I'm pretty green to SQL security, so maybe someone can help me. We've got a database application that, when installed, by default grants the public role access to all the tables in the database. When ...
user160456's user avatar
2 votes
0 answers
861 views

Can you use SQLite 64 bit odbc from powershell

I have installed 64 bit ODBC driver for SQLite, downloaded from this page. I am running PowerShell version 2 on Windows 7. In the ODBC configuration I create a system DSN with name LoveBoat, pointing ...
Levin Magruder's user avatar
1 vote
0 answers
48 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 ...
Appleoddity's user avatar
  • 3,860
1 vote
2 answers
108 views

Diagnosing sporadic MySQL fault

I have some C++ applications that access our MySQL database via unixODBC on Ubuntu 10.04. Once every few weeks for the last several weeks, I've seen this error appear in our error logs: [unixODBC][...
Scott's user avatar
  • 133
1 vote
0 answers
3k views

SQL Server 2008 R2 Express connection error

Hi I'm having issues with SQL connection for a client PC We have software that uses SQL database, and I have just updated from SQL2005 to SQL2008 We have 5 pcs: 2 x vista (32 bit) 2 x win7 (64bit) 1 ...
Solway's user avatar
  • 11
1 vote
0 answers
728 views

How do I install linux ODBC driver for IBM iSeries?

Been following instructions here: http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html Trying to install in CentOS instance after installing unixODBC. Installed all dependencies ...
cabe56's user avatar
  • 143
1 vote
0 answers
1k views

Sybase ODBC driver not working over a VPN

I need to run a client's software locally on my machine and have it talk over a VPN link (Team Viewer VPN) to connect to the live database so I can attach a debugger to the client software and figure ...
Scott Chamberlain's user avatar
1 vote
0 answers
871 views

What does the error message "Communication link failure (SQL-08S01)" actually mean?

Our application is running on dozens of servers and only a few get this error message. What is worse, is that the SQL query that causes this error message seems to be executing. The application is ...
Jason Lamoreux's user avatar
1 vote
1 answer
1k views

MySQL ODBC Connector & unixODBC Issue - Garbled connections

Having a heck of a time trying to isolate an issue on a new server install: I've installed MySQL, unixODBC and the MySQL Connector for ODBC, setup odbc.ini and odbcinst.ini as I have on my other 32-...
quidpro's user avatar
  • 11
1 vote
0 answers
153 views

Add new ODBC driver libs to PHP on OS X 10.6?

I'm trying to access a PostgreSQL datasource via ODBC from the installed stock PHP (OS X 10.6). Queries just hang, and I'm suspecting it can't find the PostgreSQL driver library which was installed ...
bpanulla's user avatar
  • 186
1 vote
0 answers
507 views

Oracle ODBC: DB on Windows Server 2003 – Windows 7 Client Connection Problems

I have an Oracle DB on a Win 2k3 Server (64-Bit). I have to access the database from a Win7 (64-Bit) machine. I have downloaded Instant Client and the 64-Bit ODBC driver, and have apparently ...
Hanshan's user avatar
  • 161
1 vote
0 answers
714 views

Oracle Instant Client DSN via unixODBC

I've got the Oracle Instant Client installed on a SuSE webserver and I'm attempting to connect to an Oracle Database with PHP via unixODBC. The connection seems to be working properly, after issuing ...
Brad Westness's user avatar
1 vote
1 answer
406 views

ODBC DSN Authentication Options

I was wondering if besides the standard username/password ODBC authentication, other options exist to authenticate an ODBC connection using an alternate method like PKI similar to SSH. Seems like a ...
noel_g's user avatar
  • 141
1 vote
1 answer
463 views

PHP ODBC Not Closing Connections

I just asked this question on stackoverflow, and it was recommended that I also ask here. I have a PHP application that uses the ODBC functions for database access. My DBA recently discovered that ...
wshato's user avatar
  • 111
0 votes
0 answers
35 views

mariadb-connector-odbc v3.1.20 "t_nobigint" unit test fails for big endian

In mariadb-connector-odbc v3.1.20 under test/types.c, unit test t_nobigint fails for big endian s390x. I am pretty sure it's because of the way hex decimal(byte conversion) took place in big endian. I ...
shubham's user avatar
0 votes
0 answers
29 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","...
Neo's user avatar
  • 1
0 votes
0 answers
71 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 ...
TomS's user avatar
  • 185
0 votes
1 answer
132 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 ...
Chris Ward's user avatar
0 votes
0 answers
972 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] ...
Ainz Ooal Gown's user avatar
0 votes
0 answers
215 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....
MeSo2's user avatar
  • 274
0 votes
1 answer
191 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 ...
variable's user avatar
  • 209
0 votes
0 answers
465 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 ...
Ben's user avatar
  • 23
0 votes
0 answers
52 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 ...
Teja Goud Kandula's user avatar
0 votes
1 answer
374 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.
R.Pradheep Kumar's user avatar
0 votes
1 answer
348 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 ...
Gábor Major's user avatar
0 votes
0 answers
1k 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 ...
davecardwell's user avatar
0 votes
1 answer
628 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.&...
ahbarnum's user avatar
0 votes
0 answers
120 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 ...
jthomp's user avatar
  • 1
0 votes
0 answers
308 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 ...
Rei's user avatar
  • 23
0 votes
0 answers
228 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 ...
maximelian1986's user avatar
0 votes
1 answer
368 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 ...
dansh's user avatar
  • 11
0 votes
1 answer
438 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 ...
HeatherD's user avatar
0 votes
0 answers
92 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 ...
user55570's user avatar
  • 468
0 votes
1 answer
1k 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,...
itd's user avatar
  • 131
0 votes
1 answer
1k 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 ...
Ken Ash's user avatar
  • 11
0 votes
1 answer
253 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 ...
realshadow's user avatar
0 votes
2 answers
608 views

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a ...
RevelingSeven's user avatar
0 votes
1 answer
134 views

Local Db Data To Remote Db Data Connection

Ok guys I was approached by a client to create a web service that will allow users to sort through a bunch of proprietary data. This is all fine and dandy but the catch is, all of this data comes from ...
G Thompson's user avatar
0 votes
1 answer
3k views

Automatically reconnect to ODBC sources?

I am using Asterisk 1.8.10.1 and a MySQL database connected via ODBC to store CDRs. When my MySQL database isn't available when Asterisk starts or has an outage while Asterisk is running, I would ...
me.at.coding's user avatar
0 votes
1 answer
2k views

FileMaker Server not listening on Port 2399 for ODBC/JDBC

I am trying to create a ODBC connection from an OSX machine to a Filemaker server 10 using a DataDirect SeQuel Link 5.5 JDBC drive. I have ODBC/JDBC enabled on the server and I followed all of the ...
Greg_the_Ant's user avatar
0 votes
1 answer
707 views

informix odbc connection slow to open in asp.net

I have an application that takes a long time to open odbc connections (like 20 sec) also takes forever using arcmap and arcsde but when I try the connection on the odbc data source administrator, it ...
sergiogx's user avatar
  • 335
0 votes
1 answer
2k 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 ...
Ewert's user avatar
  • 5