The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
12 views

ODBC--connection to 'systemDSN' failed

We have a Microsoft Access 2010 database (ACCDB). This ACCDB file is just a front end to a Microsoft SQL Server 2008 database. Authentication to the database is accomplished by Windows integrated ...
0
votes
1answer
10 views

SSRS 2012 ODBC Driver 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
1answer
114 views

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google. My test machine is a vagrant VM, and these ...
0
votes
0answers
46 views

ODBCConf - Setting up a user DNS for the Microsoft Text Driver

I am trying to 'script' the creation of a User DNS in Windows but don't know where to start. In the ODBC Data Source Administrator application, on the 'User DSN' table, I click Add and pick the "...
0
votes
0answers
142 views

Problems connecting to SQL Server using ODBC

Since three days ago I have problems connecting to SQL Server on a local network using our Access based application which uses linked tables. It happened suddenly and it only happens on my PC which I ...
0
votes
1answer
44 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
0answers
14 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 ...
-1
votes
2answers
28 views

Save ODBC credentials for Oracle on Windows

On my dev machine (Mint Linux), I have ODBC set up with credentials so that I only have to specify DRIVER and DBQ in the connection string. Unfortunately, the script will have to run on a Windows ...
2
votes
1answer
159 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
36 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
12 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
48 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
42 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
53 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
40 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
303 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 ...
2
votes
2answers
291 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
322 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
3k 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
256 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
1answer
497 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,...
2
votes
2answers
324 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
1answer
102 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
917 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
171 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
82 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
145 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 "/files/...
-1
votes
1answer
130 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
1k 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
45 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
277 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
740 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
191 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
392 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 ...
4
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
162 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 2010....
0
votes
1answer
2k 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
1k 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
218 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
67 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
227 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
23k 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
676 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
13k 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
521 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
209 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: [unixODBC]...
1
vote
1answer
4k 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) ...