Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
3
votes
1 answer

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 would like to install the WMI ODBC driver on Windows…
brandeded
  • 1,845
  • 8
  • 32
  • 50
3
votes
3 answers

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 backed up the database on the old server, and…
Luis Alonso Ramos
  • 43
  • 1
  • 3
  • 8
3
votes
1 answer

Cannot create Oracle ODBC source on 64bit Windows 7

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 system. The driver shows up in the ODBC…
Marcus Rickert
  • 83
  • 1
  • 1
  • 9
3
votes
1 answer

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 protocol but don't know what to do with this…
cabe56
  • 143
  • 1
  • 1
  • 4
3
votes
0 answers

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 of. This is the problem: Every time a sql call is…
Matt R. Wilson
  • 153
  • 1
  • 7
3
votes
4 answers

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 way to use the System DSN on machine A from…
Beska
  • 133
  • 1
  • 1
  • 7
3
votes
2 answers

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 Result Sets(MARS): No
mikerobi
  • 133
  • 1
  • 1
  • 3
3
votes
1 answer

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?
atricapilla
  • 615
  • 6
  • 12
  • 15
3
votes
2 answers

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?
dreftymac
  • 453
  • 6
  • 15
2
votes
1 answer

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), unixODBC, unixODBC-devel Installed…
Fabio
  • 131
  • 5
2
votes
6 answers

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 getting it to connect, because even after I added my…
soapergem
  • 719
  • 4
  • 13
  • 29
2
votes
0 answers

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 driver to ODBC Driver 17 for SQL Server Using DSN's.…
delizat
  • 21
  • 2
2
votes
1 answer

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:\temp\kr5ccache This setup works fine, but I…
frengel
  • 23
  • 1
  • 3
2
votes
1 answer

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) installed. The connection is Unicode-based,…
Thunderbeef
  • 161
  • 5
2
votes
1 answer

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 ODBC driver (yum install…
Agop
  • 121
  • 1
  • 6
1
2
3
…
11 12