The tag has no usage guidance.

learn more… | top users | synonyms

2
votes
1answer
24 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 ...
0
votes
0answers
8 views

FileMaker Server 14 not allowing ODBC connections

We just upgraded from FileMaker Server 11 to Server 14. I've been trying to get one of our databases setup to allow ODBC connections to it. I think I have narrowed it down to a point that it appears ...
0
votes
0answers
6 views

How do I change the log format for IIS8 ODBC Logging

With IIS8 (and 7) you can log directly to a database using ODBC logging. Unfortunately I can't find a way to customize which fields are logged using this method. In particular the referral link is not ...
0
votes
1answer
21 views

Is it possible to connect to a PostgreSQL server using FreeTDS driver and tsql?

Can I make a connection to a PostgreSQL server using FreeTDS, more specifically tsql command? I've been trying for a few days now, using many different configurations. Even though I am able to ...
1
vote
1answer
25 views

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. ...
3
votes
1answer
30 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 ...
0
votes
0answers
24 views

odbc - codegniter - 2 databases but connects only 1 database

we have a huge problem with database.php to azure database. 1 application run already. codeigniter to azure database in / 2 application : /development same files, same database.php only database is ...
0
votes
1answer
154 views

Connect via ODBC to Progress 9.1D database running on SCO Unix

We are looking to take a database dump of a really old database from a Progress DB system we have running at our office, however we've come up against a brick wall trying to connect to the system ...
1
vote
2answers
93 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) ...
0
votes
2answers
161 views

Centos, PHP encrypted connection through freeTDS/ODBC to Microsoft SQL Server

I would like to connect from PHP to a Microsoft SQL Server through an encrypted connection. PHP scripts will run from a CentOS release 6.7 (Final) I want to connect to a Microsoft SQL Server 2014 ...
0
votes
1answer
879 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 ...
0
votes
1answer
164 views

32Bit ODBC DSN “Server does not exist or access denied” but 64 bit ODBC OK connecting to SQL Server 2014

Using a new SQL Server 2014 Connecting via 32bit ODBC fails giving the error "Server does not exist or access denied" Connecting via 64 bit ODBC is successful What might cause this?
0
votes
0answers
90 views

Any solution for ODBC disconnections in Asterisk?

I have configured my Asterisk real time using ODBC. I am using MySQL as data base. I am getting these below messages on Asterisk CLI frequently and immediately my server console is disconnecting: ...
0
votes
1answer
352 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 ...
0
votes
0answers
415 views

Oracle 11.2 linked server from SQL Server: missing oraclient11.dll required for distributed transactions

I've set up a linked server to Oracle 11g R2 in my 32-bit SQL Server 2005 instance, using the Oracle-provided OraOLEDB.Oracle. When I try to query against the linked server from SSMS, I get OLE DB ...
1
vote
2answers
236 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 ...
0
votes
0answers
50 views

MySQL ODBC DSN ignoring IP address of server - Windows 7

I'm trying to create an ODBC connection to a MySQL server on my network. I can create the DSN but when I click test I get an error (HY000) Access denied for user user@localhost despite the fact that I ...
0
votes
1answer
79 views

Microsoft Access Duplicates Auto Incremented MySQL Record When Info Identical

I've recently run into one of the most frustrating bugs I've seen with a Microsoft Access integration with MySQL. What happens is that if you type something in a record, and then quickly move to the ...
0
votes
1answer
685 views

ODBC Driver Version 03.86.3959 connection to SQL Server 2014

Ok so I have some accounting software running on a Windows Server 2003 box. This server uses a System DSN, that uses Microsoft SQL Server ODBC Driver Version 03.86.3959 to connect to a Management ...
0
votes
1answer
129 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
1answer
68 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 ...
0
votes
1answer
121 views

How to read/ modify freetds.conf (for ODBC) using augtool or similar in bash script?

How can I get augtool (augeas) or a similarly common tool to work with freetds.conf, so I can automate some configuration in a bash install script? This doesn't seem to work: augtool print ...
-1
votes
1answer
109 views

Windows 2003 R2 Missing mapped drives under ODBC Administrator [closed]

When I try to set up an ODBC datasource (MS Access) I can't select the network drive where the mdb file is. The network drive is accesible from My Computer.
0
votes
0answers
818 views

Microsoft ODBC SQL Server Driver [DBNETLIB] error from client desktops connecting to SQL Server 2005 databases

Problem We have a program installed on numerous client computers making database connections to SQL Server 2005 databases running on a Windows 2003 Server. Client computers are Windows 7. Recently ...
0
votes
1answer
43 views

Is it safe to Update and/or Insert records into an accounting software's database? (Pastel Evolution)

Our CRM system can post transactions to our accounts software (Pastel Evolution), but it doesn't perform the required currency conversion. Both systems have different "base" currencies (because of our ...
0
votes
1answer
2k views

Problems configuring DB2 CLI/ODBC System DSN ODBC Data Source Administrator

I am trying to create a System DSN ODBC connection to a DB2 9.5 database, but I am getting a very strange problem. I've looked through the internet and found the following page that has some ...
-3
votes
1answer
252 views

Windows Server 2008 iis 7.5 classic asp mdb DB via DSN odbc [closed]

I had a a simple site on a 2003 IIS 6 server for years. I have a small DB in a Mdb file. Everything was great, until I've upgraded to a windows 2008 R2 64bit IIS 7.5 server. I've transferred the site ...
0
votes
1answer
555 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 ...
2
votes
0answers
164 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
0answers
347 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 ...
3
votes
1answer
1k 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 ...
1
vote
2answers
141 views

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 ...
0
votes
1answer
1k views

How can I delete this ODBC?

I am unable to delete a specific ODBC of type system DSN. I am able to create and remove other ODBC connections on the same server, but a particular ODBC (name = Default) cannot be removed. If I try ...
0
votes
1answer
948 views

Plesk error when adding a subscription: ODBC error #08S01 can't connect to local MySQL [closed]

I'm getting this error after updating MySQL to 5.6 (Plesk 11.5, fresh installation) using the official MySQL repository right after adding a new subscription. Internal error: ODBC error #08S01: ...
0
votes
1answer
186 views

Access to Windows event observer with ODBC

Is there a way to access the Windows Event Observer data from something like an ODBC datasource? Or a way to export data (lets say that we limit age of data to 1 week or one month) in a structured ...
1
vote
1answer
63 views

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 ...
3
votes
1answer
208 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
vote
3answers
19k 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 ...
0
votes
1answer
487 views

Website can not connect to ODBC (no rights?) “Error: 80004005”

Background I am trying to migrate a website using MSSQL from MS Windows Server 2003 to a Server running MS WS 2008. It's been a while since I tried the last time (because I gave up on this problem) ...
2
votes
1answer
10k 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 ...
0
votes
2answers
485 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
2answers
197 views

32bit ODBC++ dll on Windows 2008 Server 64bit

A client of ours is trying to migrate to 64 bit Windows. They haven't got an ODBC++ dll present and our solution linked against the version shipped with 2003 server (32-bit). However, when looking ...
1
vote
2answers
62 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: ...
1
vote
1answer
3k 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 ...
1
vote
0answers
2k 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) ...
2
votes
0answers
377 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
0answers
344 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 ...
-1
votes
1answer
354 views

SQL server ODBC connection for Active Directory user who doesn't log in to the windows

Do you think it is possible to create a SQL server ODBC Connection for an active directory user who doesn't log in into the windows. Ideally this type of users will be used in the batch process. So, ...
1
vote
0answers
391 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 ...
0
votes
2answers
765 views

PDO ODBC error just resets connection

Trying to write an ODBC PDO driver for CakePHP. Seems like I get closer and closer however whenever a PDO function is called that it doesn't like the connection just gets reset immediately and I'm not ...