Questions tagged [odbc]
The odbc tag has no usage guidance.
182
questions
31
votes
11
answers
377k
views
How do I get this SQL Server ODBC Connection working?
Note: I've obviously changed the server names and IPs to fictitious ones.
Here's what's going on. I've got a server, which I'm calling MYSERVER, running Microsoft SQL Server Express 2005. Right on ...
- 719
9
votes
3
answers
64k
views
How can I create an ODBC connection from .bat file in Windows?
I need a batch script to create an ODBC/DSN connection from a .bat file in Windows. How can I do this?
- 195
8
votes
8
answers
133k
views
Remote MySQL connection fails (10060)
When I am trying to connect to a MySQL database from a remote computer I get a prompt saying: Connection Failed: [HY000] [MySQL][ODBC 5.1 Driver]Can't Connect to MySQL server on 'XXX.XXX.XX.XX' (10060)...
6
votes
1
answer
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 ...
- 201
5
votes
2
answers
22k
views
Unable to Create System DSN
Environment:
Windows 7 Professional 64-bit Operating System
Problem:
(ODBC Data Source Administrator)
Opening Administrative Tools -> Data Sources (ODBC) -> Click "System DSN" tab.
Error:
ODBC ...
- 167
5
votes
2
answers
10k
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 ...
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
4
votes
3
answers
12k
views
Lotus NotesSQL Driver - cannot install
I need to install Lotus NotesSQL Driver (current version is 8.5) onto a virtual machine running XP. Here's what's I've done so far:
I retrieved the file (CZOWFEN.zip) from the IBM website.
I ran the ...
- 165
4
votes
3
answers
8k
views
ODBC: trouble removing system DSN
I have a colleague who has two DSNs with the same name - one's a user DSN and the other, a system one. He removed the user DSN but can't remove the system DSN in ODBCad32
Anybody encountered this ...
- 155
4
votes
2
answers
5k
views
How do I install Informix ODBC on Windows Server 2003/2008?
I installed the Informix Client SDK on my PC (32 bit) and on the server. I could create an ODBC connection on my PC easily, but on both Windows 2003 and 2008 (64 bit) I can't.
I don't know if there ...
- 335
4
votes
3
answers
4k
views
Windows 2003 ODBC Issues - Error 10055
Using data integrator for ETL's pulling data from DB2 to SQL Server, after some time, will get these odbc errors:
Communication link failure. comm
rc=10055 - CWBCO1003 - Sockets error,
function ...
- 285
4
votes
3
answers
3k
views
What is the difference between running a Windows service vs. running through shell?
I am trying to troubleshoot an issue on a Windows 2008 server where running attempting to connect to a "Timberline Data Source" ODBC driver crashes if the call is in a "service" context, but succeeds ...
- 143
3
votes
4
answers
17k
views
Is it possible to connect to a System DSN on remote machine?
We have a DSN on machine A that points to a DB on machine B. We have a machine C, that we want to be able to use that DSN on machine A...but we don't want to create the DSN on machine C.
Is there a ...
- 133
3
votes
2
answers
12k
views
ODBC (SQL Server): How do I turn on Multiple Active Result Sets(MARS) for a System DSN?
I need to turn on Multiple Active Result Sets for an ODBC data source, but I can not figure out how to set it.
And the end of the wizard I see this in the configuration summary:
Multiple Active ...
- 133
3
votes
1
answer
444
views
Windows 7 WMI ODBC driver installation?
I am interested leveraging the ease of report production provided by Microsoft SQL Report Builder, but I would like WMI as an available datasource. Since SQL Report Builder relies only on SQL, I ...
- 1,860
3
votes
1
answer
33k
views
Cannot create Oracle ODBC source on 64bit Windows 7 [closed]
I have installed the 64-bit version of the Oracle ODBC driver (instantclient-odbc-windows.x64-12.1.0.1.0 from http://www.oracle.com/technetwork/topics/winx64soft-089540.html) on my 64 bit Windows 7 ...
3
votes
2
answers
217
views
for-free installation of php-mssql and dependencies
Problem: trying to install RPMs for RedHat EL, php-mssql. There does not appear to be a free open-source option for connecting to MSFT SQL Server database.
Has anyone had any luck with this?
- 453
3
votes
1
answer
903
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 ...
- 973
3
votes
3
answers
54k
views
How to connect an ODBC DSN to nondefault SQL Server instance on default port?
We are migrating an SQL Server 2000 database on one server to SQL Server 2008 R2 on another server. The client application use a User DSN to connect directly to the SQL Server on the internet.
I have ...
3
votes
1
answer
16k
views
How to establish ODBC connection through ssh tunnel?
I have SSH access to an iSeries (DB2 Database) through a firewall. I am trying yo make queries to a db in the machine using ODBC.
I have found several tables explaining what ports are used by the ...
- 143
3
votes
1
answer
4k
views
Native SQL Server connection vs ODBC?
What is the difference between native SQL Server connection and ODBC? What are the benefits when using native SQL Server connection?
- 615
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
3
votes
0
answers
492
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 ...
- 153
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
...
- 648
2
votes
2
answers
3k
views
how does odbc driver work?
I have an application hosted on jboss.
use jdbc driver of oracle to connect to an oracle 10.2g database.
Can anyone guide as to what happens when a session is established.
Just trying to understand ...
- 648
2
votes
1
answer
3k
views
Is TCP/IP required to connect to SQL Server 2008R2 with ODBC over a LAN *NOT* the internet
I have read one two three related threads but im not clear if SQL Server 2008 needs TCP/IP to make this work. Can it not accomplish with a pipe? I would prefer not to open up the machine to the ...
- 179
2
votes
6
answers
8k
views
Why am I getting this 500 error from IIS?
I'm running PHP 5.3.1 on IIS 7.5 on Windows 7 Ultimate x64. I've been trying to make PHP connect to my local installation of SQL Server 2008 Express over ODBC using ADODB. At first I had trouble ...
- 719
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
608
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
2
votes
1
answer
228
views
Issue With Case Sensitivity on IBM Power server queries
Where I work, we have an IBM Power System that we use for data storage and access. It is currently running i OS 6.1. We have a website on an IIS server that pulls data from this server and has ...
- 165
2
votes
2
answers
9k
views
How to configure Windows user accounts for ODBC network with NT authentication?
I'm trying to create a connection to an SQL Server database from the ODBC Data Source Administrator using "Windows NT authentication using the network login ID". Both server and client are running ...
- 193
2
votes
1
answer
14k
views
Is it possible to increase the maximum pool size on an ODBC connection?
I have a server supporting a phone system of about 300 phones. When calls are made, many different connections are opened and closed during the course of a call. I'm starting to see "out of database ...
- 359
2
votes
2
answers
6k
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
2
votes
1
answer
166
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
2
votes
1
answer
2k
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
2
votes
1
answer
3k
views
Need help making an ODBC MySQL Connection
Short Version:
How do I connect from PowerShell to an ODBC 5.1 MySQL Driver? I can't seem to find any connection strings that accurately have a "Provider" field for this particular instance. (See ...
- 121
2
votes
3
answers
12k
views
User cannot access a system DSN on Windows Server 2008
We run our SQL Server services using a low privileged domain account. That account is NOT a local admin on the OS. Only access I give the user account is assigned during install of SQL: full control ...
- 173
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
2
votes
1
answer
5k
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 ...
- 121
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 ...
- 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 ...
- 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 ...
- 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 ...
- 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 ...
- 21
2
votes
0
answers
202
views
Increase 32K BLOB limit in Postgres ODBC [closed]
Is there a way to increase the limit of a BLOB field from 32K in Postgres ODBC driver?
- 789
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 ...
- 121
2
votes
1
answer
547
views
Is ODBC on Windows 2003 slower than on Windows 7?
I am seeing some MSSQL 2005 performance issues, and I am trying to diagnose the cause. I am using SQL Profiler to gather query execution times. Both the client app (using ODBC), and the SQL server are ...
- 5,146
1
vote
5
answers
41k
views
DSN, ODBC: How to create DSN using different windows account
Is there a possibility to create DSN (ODBC to SQL Server) using different Windows account than current coputer login account? I’m trying to create System DSN to SQL Server and I would like to create ...
- 615
1
vote
1
answer
19k
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 ...
- 11
1
vote
1
answer
420
views
Managing mass SQL Server ODBC Changes when migrating to a new SQL Server
How do you manage changing out a SQL Server and updating all the clients that connect to it to point to the new server? If I have SQLSERVER1, then buy new hardware and call the new server SQLSERVER2 ...
- 197