Questions tagged [odbc]
The odbc tag has no usage guidance.
53
questions with no upvoted or accepted answers
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 ...
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 ...
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
...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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][...
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 ...
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 ...
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 ...
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 ...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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","...
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 ...
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 ...
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] ...
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....
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 ...
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 ...
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 ...
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.
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 ...
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 ...
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.&...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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,...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...