In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).

learn more… | top users | synonyms

2
votes
2answers
556 views

odbc error connecting mysql: “sql server does not exist or access denied”

For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever. I have no problem connecting to the database ...
0
votes
2answers
312 views

Unable to make ODBC connection on Ubuntu 14.04

I usually access an ODBC connection through a CentOS server, and I'm trying to make the same connection locally on my Ubuntu Trusty laptop. So far as I can tell I've duplicated everything properly ...
0
votes
2answers
3k views

MySQL ODBC driver 5.1 and Windows 7

I successfully installed the MySQL ODBC 5.1 driver for Windows: But unfortunaly it doesn't appear in the ODBC Data Source Administrator of Windows (yes, I even did a log off + log on): Why?
6
votes
1answer
2k views

SQL Server ODBC authentication errors

I'm trying to connect to a SQL Server 2008 database from a 3rd-party application through an ODBC connection. I am having success when the ODBC is set up with Windows Authentication but not when it's ...
1
vote
1answer
29 views

Why does ODBC connection from win2k (to ASA 8) stop working after moving workstation from LAN to VPN connection?

Background of my question is, from a local network we take one workstation, and connect it again via VPN from a home office. I thought, a connection via VPN would be the same as if the computer were ...
1
vote
1answer
248 views

Impact of adding a 32-Bit ODBC driver to a 64-Bit Win Server 2008 R2

Would there be no problem if i ADD another ODBC driver to a server (a 32bit version to cater my 32bit PHP application) with an existing ODBC 64bit version? Would it not create confilict to other ...
1
vote
1answer
608 views

Unable to format datetime in Excel Table

I have an Excel document with a table linked to a table in sql server containing a datetime field. The datetimes display as yyyy-mm-dd hh:mm:ss.sss and I'm unable to format the cells directly to a ...
0
votes
1answer
97 views

SQL server missing in ODBC

I installed a SQL Express server on a 32-bit Windows 2008 server r2. I installed this while installing a Phoenix fueling station program. When I am trying to add a user DSN in ODBC I am unable to find ...
0
votes
1answer
618 views

Copy ODBC Driver to another computer

I am trying to copy multiple installed ODBC drivers from one computer to another. I can see the driver name, version, company, file name, and date but no way to export it. Both computers run the ...
0
votes
1answer
28 views

Precisions on ODBC ports use

When creating a new ODBC source on windows 7, you have to provide the host and the port on which you want to connect : Since it is is managed by windows, I assume all ODBC driver work the same way ...
0
votes
1answer
393 views

Sage Line 50 ODBC Driver Causes Crashes in application when run

I can open up a connection to my sage line 50 version 2014 file via the odbc link in visual studio and see all the tables. However, when I try to execute a query, the program comes up with "Visual ...
0
votes
1answer
431 views

How to reference individual cells in Excel to variable data from records in an external SQL table

I have a SQL table containing date oriented financial data eg. multiple daily records with fields for Date, Account code and Value. I want to set up dynamic links (formulas) from cells in an Excel ...
0
votes
1answer
1k views

Data Source not found in Excel (Data/From other sources/From MS Query) connecting to PostgreSQL

I set up an ODBC connection to a datamart with c:\windows\SysWOW64\odbcad32.exe. I set up my Data Sources in the System DSN tab using the PostgreSQL ANSI driver. When I go into Excel bring in the ...
0
votes
1answer
840 views

Questions about setting up PHP-ODBC driver for remote SQL-Server-2008 connection on CentOS-6

I have CentOS 6 and PHP 5.3.3 VPS at GoDaddy. I have to interact with remote SQL Server 2008. I've seen many tutorials and quite lost here, so: There is a way to simply yum install it ? If not, what ...
0
votes
1answer
955 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
0
votes
1answer
1k views

Export data from ODBC to CSVs or similar

I have a SQL Anywhere 5 database which I can currently access through ODBC. I managed to open it with Access but when I used Access to export text files it would truncate the data. Is there a way ...
4
votes
0answers
448 views

Access 2010: The Oracle client and networking components were not found

I've installed these Oracle client and ODAC files required for "Microsoft ODBC for Oracle": ODAC112021Xcopy_32bit win32_11gR1_client But alas it will not work! I'm on Windows 7, using Access 2010. ...
1
vote
0answers
176 views

How to install SQL Server ODBC driver on OSX?

I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error: The ODBC driver that was selected for the source connection ...
1
vote
0answers
688 views

What's the best way to get a MySQL database into SQL Server 2012 Reporting Services?

I'm trying to get a MySQL database into SQL Server 2012 reporting services as a shared data source, and getting absolutely nowhere after a day. I've tried a couple of options. First, my specs: ...
1
vote
0answers
132 views

MS Access ignores confirmation dialog when updating linked MySQL table

I have a MySQL database (Version 5.1.63) which is connected to MS Access (2002) via ODBC (MySQL ODBC 5.1 Driver). In MySQL I created a simple table like this: CREATE TABLE IF NOT EXISTS `test` ( ...
1
vote
0answers
892 views

How can I use the ODBC connection of another computer on my network?

I'm not sure if I need to look at this problem a different way but here goes. Computer A (windows XP) has an SSH Tunnel to the web server. Port 3306 on the web server is tunneled to port 3306 on ...
1
vote
0answers
63 views

Update Billing Email Addresses in Sage MAS90

I have been tasked with trying to find a method of updating about 500 customer email addresses in MAS90. I recently discovered that they had the ability to email invoices to their customers and ...
0
votes
0answers
51 views

Ubuntu install Amazon Redshift driver: Data source not found

I'm having problems installing the Amazon Redshift ODBC driver on Ubuntu 14.04.4 LTS. These are the steps I took: $ sudo apt-get install unixodbc $ sudo apt-get install php5-odbc $ sudo dpkg -i ...
0
votes
0answers
18 views

System ODBC not visible to user

We have made a couple of ODBC connections on the System DSN with the admin account. They are not visible to the users. This in Windows 7 with 64 bit OS. What do I need to do to get them visible. Let ...
0
votes
0answers
9 views

mySQL ODBC driver is ANSI only

I just downloaded latest mySQL ODBC driver from here. When I tried to install it on my Windows 8.1 laptop the wizard from MSI said that it is an ANSI driver. Is Unicode version of the driver not ...
0
votes
0answers
19 views

What is the best VM network adapter method for VPN?

Remoting into my work computer is tedious and slow. To fix this I started using the company VPN, however the ODBC connections are validated through the machine name so my home PC does not have access. ...
0
votes
0answers
33 views

I want to add iSeries Access ODBC Driver into ODBC Data source administrator on windows server2008

I am trying to add iSeries Access ODBC Driver into ODBC Data source administrator. I tried to install it from IBM from following link link But getting following error. Link of Error Image Can anyone ...
0
votes
0answers
14 views

Reading an Access-compatible File w/ Access

I have a .dfm file extension, which I can read in Microsoft Access 2010 (by selecting All Files *.* in the open menu). When I open this file it says it's an "Access 2000" file. Microsoft Access 2010 ...
0
votes
0answers
20 views

Windows Informix ODBC connection to different host, but same server name

There are two Informix databases on two different hosts. The INFORMIXSERVER is database1 on both machines. When I try to setup an ODBC connection on Windows the latter configuration change overwrites ...
0
votes
0answers
100 views

Microsoft ODBC for Oracle not working with Oracle 11.2.0.2

I have Oracle client installed and i am able to connect using sqlplus, i am also able to use My requirement is to try to use Microsoft ODBC for Oracle using the following VBSript code my .vbs file ...
0
votes
0answers
37 views

ODBCAD.exe same datasource in system32 and syswow64

Currently i want to proof, which odbc data sources are configurated on a windows server 2008 R2 machine. When i open system32/odbcad32.exe and SysWow64/odbcad32.exe, they contains the same sources ...
0
votes
0answers
89 views

Access ODBC connection made on another PC?

I have made an ODBC connection on a Windows XP machine. I have another Windows 8 machine on the same network. I want to access that ODBC connection on XP from the Windows 8 machine without having to ...
0
votes
0answers
16 views

AcuODBC 5.1 and Union All queries

I use AcuODBC 5.1 on Xp machine to connect to an old database. Union All queries are not supported but I badly need them. Is there a way to run Union All Query on AcuODBC 5.1 somehow?
0
votes
0answers
32 views

Alternative option for select * from

In the Excel database query we will use the below syntax to define a reference value SELECT * FROM [Sheet1$A1:Z500] where Dept = 'IT' In the above case I am taking the Dept value IT as a reference ...
0
votes
0answers
104 views

Sync data between two FileMaker12 instances through ODBC

I'd like to know, if there's a way to sync data between two FileMaker 12 instances through an ODBC connector. To be honest, I found how to set-up a DNS, but the problem is that I'm not able to connect ...
0
votes
0answers
198 views

How to ssl-secure mysql connection on Windows XP?

I use MS Access to connect my remote MySQL database, and use MySQL ODBC connector for that. I would like to secure the connection with SSL. ODBC connector offers some SSL setup, but I don't have idea ...