Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [odbc]

179 questions
2
votes
2 answers

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:, -U -P I have the following in my…
MeMario
  • 65
  • 1
  • 7
2
votes
1 answer

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) works fine when I manually start apache with…
Barry Ralphs
  • 191
  • 1
  • 1
  • 11
1
vote
1 answer

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 status. After I enable the SQL item, hit Check now…
Vertex
  • 121
  • 5
1
vote
3 answers

64bit UnixODBC and FreeTDS: a bug in libtdsodbc.so?

We have a legacy Windows web application which uses Microsoft SQL Server 2005. Two years ago we rewrote a part of this application using PHP and ODBC on a 32 bit virtualized Debian system. This application works okay (about one SQL request of…
nalply
  • 1,087
  • 1
  • 10
  • 19
1
vote
1 answer

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 caused us to have to reboot the server. The problem…
Adam R. Grey
  • 111
  • 1
  • 1
  • 5
1
vote
1 answer

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 PHP 7.0 Needed unixODBC: 2.3.1 sudo yum info…
Sean256
  • 161
  • 1
  • 5
1
vote
1 answer

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 did find bits and pieces which could lead to the…
MPaul
  • 141
  • 2
  • 6
1
vote
1 answer

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. I would like to export the whole configuration…
Igor Pashchuk
  • 113
  • 4
1
vote
1 answer

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 isn't working.. I will try to provide as much…
sudo
  • 11
  • 1
  • 1
  • 3
1
vote
2 answers

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. I have multiple GP applications installed on a…
nairware
  • 309
  • 2
  • 10
  • 17
1
vote
1 answer

Report all ODBC DSN on workstations in the network

In preparation for retiring SQL Server A (2005) and deploying SQL Server B (2012), I've discovered numerous Microsoft Office assets (Excel, Access) that connect via ODBC DSNs. Is there a method to scan all workstations on a network and return a…
EngineeringSQL
  • 275
  • 1
  • 2
  • 8
1
vote
2 answers

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][MySQL][ODBC 3.51 Driver]Lost connection to MySQL…
Scott
  • 133
  • 5
1
vote
0 answers

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 x xp (32bit)) The SQL Server 2008 R2 Express is…
Solway
  • 11
  • 1
  • 3
1
vote
1 answer

IIS ODBC logging doesn't work - solving "Could not initialize the logging module" problem

I'm absolutely new to IIS and hardly know what I'm doing. I've configured ODBC logging for our IIS server exactly following steps specified by Microsoft on this website: support.microsoft.com/kb/245243. When I started browsing on this site, nothing…
agnieszka
  • 111
  • 3
1
vote
0 answers

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 except libodbcinst.so.1, libodc.so.1 and libXm.so.3…
cabe56
  • 143
  • 1
  • 1
  • 4
1 2 3
…
11 12