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

learn more… | top users | synonyms

0
votes
0answers
12 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
5 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
18 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
26 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
11 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
85 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
30 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 ...
2
votes
1answer
79 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
77 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
65 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
15 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?
1
vote
0answers
154 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
76 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
29 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 ...
1
vote
2answers
399 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 ...
0
votes
1answer
96 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
3k 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 ...
1
vote
1answer
307 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 ...
0
votes
2answers
5k 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 ...
1
vote
1answer
27 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
231 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 ...
2
votes
2answers
526 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
303 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
1answer
33 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 ...
0
votes
1answer
161 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 ...
0
votes
1answer
577 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
27 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 ...
3
votes
1answer
239 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
199 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
2answers
743 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
383 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 ...
1
vote
1answer
575 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 ...
6
votes
2answers
40k 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 ...
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 ...
0
votes
1answer
423 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 ...
1
vote
1answer
175 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 ...
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
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 ...
1
vote
2answers
824 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 ...
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 : ...
1
vote
1answer
123 views

Can't choose MS Acess as an option for a ODBC User DSN: why?

I try to setup an User DSN using an MS Access driver, but although visible as an option in the User DSN tab I only can choose for SQL Server in the second dialog. Why? I am using Windows 7 and Access ...
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 ...
1
vote
0answers
673 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: ...
0
votes
0answers
102 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 ...
2
votes
1answer
3k views

how to connect to pervasive sql through odbc?

I am trying to add a linked server to a sql server 2012 database using ssms 2012. the linked server is pervasive sql. here's how i am trying to do it: EXEC sp_addlinkedserver @server = ...
1
vote
1answer
10k views

How does one acccess the registry hive inside NTUser.dat?

Is it possible to access the registry hive inside of NTUser.dat file? The reason I am asking is that I frequently install ODBC DSN on computers, and I know that the User DSNs are stored in the ...
1
vote
2answers
4k views

System DSN command prompt

I can create a System DSN connection via the following command: odbcconf.exe /a {CONFIGSYSDSN "SQL Server" ...
3
votes
3answers
38k 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 ...