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

learn more… | top users | synonyms

1
vote
2answers
35k views

What ports does MS SQL Server use for ODBC connections?

I require our firewall to allow ODBC connection from clients to the MS SQL Server. Which ports should be opened for this?
-1
votes
0answers
22 views

ODBC MS ACCESS cannot be detected on data source

i am using ms access 2007 and i want to open an ODBC connection but data source cannot detect any drivers for MS access database. I tried to download engine 2007 but still nothing.
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?
0
votes
0answers
70 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
22 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 ...
7
votes
2answers
44k views

How to Remove ODBC Data Source if Driver is Removed

On my Windows 7 machine, I created an ODBC data source to an Oracle database via the ODBC Data Source Administrator (c:\windows\SysWOW64\odbcad32.exe). Sometime later, I had to uninstall and reinstall ...
0
votes
2answers
8k views

Microsoft ODBC driver can't find Oracle Instant Client

I have an old 32-bit software program that connects to an Oracle database but only works with the Microsoft ODBC driver for Oracle. It does not work with the more up-to-date native Oracle ODBC driver....
0
votes
0answers
22 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
42 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 ...
1
vote
1answer
188 views

Restrict ODBC setting changes

I have an ODBC connection created to an IBM server. This connection is used by Excel files to read data from this server. I want to restrict users from changing any of the ODBC settings either in the ...
0
votes
0answers
27 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 ...
6
votes
2answers
11k views

System DSN vs user DSN

Every new computer in my company undergoes the same software installation process; one program in particular needs to access a MS SQL Server database via ODBC. The program is then used by multiple ...
0
votes
0answers
118 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
47 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 (64-...
2
votes
1answer
107 views

Connection failed, Access denied connecting to MySQL via ODBC on Windows

I know nothing about MySQL or Linux and am tasked with migrating a MySQL DB to MS SQL. I found a tool for that but it requires an ODBC connection so I downloaded the MySQL Connector/ODBC and installed ...
0
votes
0answers
101 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
1answer
91 views

Installing 16bit ODBC driver on modern pc

I need to use AcuODBC drivers which are 16bit. They currently run on Windows XP but it is an old pc with little processing speed and 2gb ram. I wish to upgrade to a faster pc with 16gb ram. These ...
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
1answer
157 views

MS Access won't connect to linked Visual Fox Pro after Symantec Endpoint Update

We have an end user used MS-Access database which connects to a Visual Fox Pro directory of .dbf files via linked tables and an ODBC DSN. This worked fine until Symantec Endpoint Protection installed ...
1
vote
2answers
530 views

VBA Automation error when querying database through ODBC

I am trying to run Excel macro to query some data from my ODBC database. My database details are as below: DSN: sgdv UID:l8qc1 Password:l8qc1 server:sgdv I am trying to query the data from ...
1
vote
0answers
198 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 ...
0
votes
1answer
121 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
0answers
34 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 ...
2
votes
1answer
5k views

Windows 10 Visual FoxPro ODBC Issue

I just upgraded from windows 7 64 to Windows 10 64. Now I am having problems with the Visual FoxPro driver. I am using the 32-bit ODBC manager (C:\Windows\SysWOW64\odbcad32.exe). When I try to add or ...
2
votes
1answer
4k views

ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10

I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and ...
1
vote
2answers
2k views

Reading an Access database from Java (Eclipse)

I'm using Windows 7 (64-bit). I installed 64-bit versions of Eclipse and JRE, but when I tried to read from Access I got problems. The only way to use ODBC seems to be by using a 32-bit variant, but ...
6
votes
1answer
7k views

Exporting a list of ODBC Datasource drivers?

Is it possible to export a CSV file of the list of database driver names from the Create New Data Source of the ODBC Data Source Administrator?
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
32 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
325 views

SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified

I am running a PHP script on a RedHat server using Teradatas ODBC drivers. <?php $conn = odbc_connect("Teradata", "username", "password"); $result = odbc_exec($conn, 'SELECT count(*) FROM table');...
2
votes
1answer
4k views

Writing typical MySQL query in excel

I'm trying to run a MySQL query in excel. I've set up ODBC in excel and the connection to database is solid. Is there a way to input my usual query (e.g. select * from table where date= 20131212) to ...
3
votes
3answers
40k views

Why is my 32bit ODBC connection not showing up in odbcad32.exe?

I have a Windows 7 64bit system that must run a 32bit application that accesses a MSSQL Server 2005 express via an ODBC connection. After installation everything was working fine. Now a few weeks ...
0
votes
2answers
326 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 ...
2
votes
2answers
580 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 ...
1
vote
1answer
264 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
2answers
2k views

Access denied for user 'administrator'@'localhost' (using password: YES)

I've a user account setup asteriskpbx@localhost. From this account I'm trying to execute the following command: echo "select 1" | isql -v asterisk-connector However, I get this error : [S1000][...
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
172 views

Which ODBC connection properties have higher priority ?

I take data from PostgreSQL via ODBC and put the data in excel worksheet. For this I use VBA which makes a query table. In the VBA script I specify a connection string which contains some ODBC ...
1
vote
2answers
874 views

Can LibreOffice Base directly use MySQL syntax?

From what I can see, LibreOffice Base comes with an HSQLDB implementation by default. I understand that ODBC allows users to connect to different data sources, including databases that use different ...
34
votes
3answers
179k views

How can I open the 32-bit ODBC Data Source Administrator in Windows 7 64-bit?

I want to add 32-bit data sources. There seems to be no obvious way to see existing instances of these or create new ones. How can I open the 32-bit "ODBC Data Source Administrator" window in Windows ...
0
votes
2answers
824 views

Strategy for Incremental Datasource fetchings in Excel

I am in an scenario with a table that is refresh by a third app every week. I need to keep accumulating all data in Excel, using an ODBC connection to the database. I am wondering Approach 1: Is ...
0
votes
1answer
34 views

Mysql won't show my databases (MYSQL-WIN7)

I create a database using workbench and don't find this database at ODBC list, I'm able to see only information_schema database. I tried to restart my machine but don't solve the issue. Could you ...
1
vote
1answer
636 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
664 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 ...
3
votes
1answer
248 views

Excel ODBC - General 'How does it work?'

Thinking of moving a couple of linked spreadsheets into a database model instead. However, I have a lot of non-technical uses who can just barely use Excel but having them use something like MS Access ...
0
votes
1answer
227 views

Best way to share an Excel with an ODBC connection?

What's the best way to share within local network any Excel file that uses ODBC? I guess any user must define the ODBC connection locally in order to reload the data. Is there a way to dump an ...
0
votes
1answer
399 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
436 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 ...