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

learn more… | top users | synonyms

21
votes
3answers
89k 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 ...
8
votes
1answer
12k views

Anyway to use SSMS to connect to MySql?

I've grown to love SQL server management studio (ssms), I realise that it is not naturually compatible, however is there a way of connecting to MySQL? Perhaps using an ODBC connection? I realise ...
8
votes
2answers
6k views

How to connect to Oracle DB via ODBC

I am attempting to connect to a remote Oracle DB via ODBC. I am totally inexperienced and fail to connect. What I have installed: Oracle 'ODBC Driver for RDB' A program I want to connect from ...
6
votes
1answer
5k 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
2answers
8k 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 ...
6
votes
0answers
1k 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 ...
5
votes
1answer
470 views

ODBC Query cannot be executed because it is too complex?

I have a CSV file which I am using as a database with LibreOffice DB. What I'm doing is explained in detail in this answer. I can do some operations, but when I try to enter the following into the ...
3
votes
1answer
22k 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 ...
3
votes
2answers
25k 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 ...
3
votes
2answers
12k views

How do I configure ODBC DSNs in Windows Server 2003 and Windows 7?

I haven't done this in quite a while, but years ago I have set up DSNs for an ODBC connection using Windows 2000 and maybe Windows XP. I remember there being a Data Sources or ODBC icon to click in ...
3
votes
1answer
112 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 ...
3
votes
2answers
12k views

Windows 7 ODBC Text Driver

Some software requires me to setup an ODBC Text Driver. In the Windows 7 Control Panel > ODBC Data Source Administrator, the only driver available is "SQL Server". How do I find/download/install a ...
3
votes
0answers
416 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. ...
2
votes
2answers
2k views

Database access through odbc driver and excel

Is it possible to access a database via ODBC and access this in MS Excel or OpenOffice, then exporting the database into a flat file? The program I am accessing data only allows an ODBC connection ...
2
votes
2answers
1k views

What's the difference between ODBC Manager and ODBC Administrator?

I have two applications in my Applications/Utilities folder that look exactly the same except for the icon. One is ODBC Manager, the other is ODBC Administrator. Does anyone know what the difference ...
2
votes
1answer
6k views

Error when refreshing data from external source in excel. Data source name not found and no default driver specified

I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the data I get the following error: ...
2
votes
1answer
2k 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 = ...
2
votes
1answer
6k views

How do I automate creation of an ODBC connection in the system DSN?

I need to create an ODBC connection in System DSN on a bunch of windows machines. What can I do to make this process simpler than manually typing the details into the Create New Datasource Wizard on ...
2
votes
1answer
222 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
6k 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
1answer
341 views

Log of SQL queries to ODBC driver?

I have an application on my Windows XP SP3 machine that's querying and returning data from a database through the SQL Server Native Client. Is there a log file being kept that would show me the SQL ...
1
vote
1answer
966 views

Querying big databases with Excel

Is it possible to use Excel's pivot table as a kind of query builder against a database, without copying the entire database into Excel? I know that with the External Data Sources feature, you can ...
1
vote
1answer
88 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 ...
1
vote
2answers
506 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
1answer
101 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 ...
1
vote
1answer
606 views

Data Sources (ODBC) hangs when trying to create a new database connection

When I try to create a new database connection, the Data Sources (ODBC) programs hangs or takes a very long time to find the list of available SQL Servers. This only happens when there are other ...
1
vote
1answer
121 views

Dealing with modal popups in Dynamics GP when running as a Remote Application in Terminal Services

Running GP10 as a Remote Application in Terminal Servers (W2K8). The multi-analysis tool requires ODBC credentials, when it executes against the database, to build the data cube. Unfortunately, ...
1
vote
2answers
3k views

Problem creating ODBC connection to SQL Server 2008 with Vista

Well, I'm trying to get a database schema thing working, first I tried just doing it in Linux where I'm more comfortable, but ODBC seems to be a hack there and I couldn't get it to work. So I figured ...
1
vote
2answers
2k views

How to set up ODBC provider for Mysql in Windows 7

I've just downloaded Mysql-obbc-connector driver, and how can I enable this driver to connect to Mysql from vbscript. How can I set up new odbc provider in Odbc source administrator window in Windows ...
1
vote
0answers
7 views

Why does the ODBC connection (ASA 8) not more work on win2k worstation after the workstation was released from local network and reconnected via VPN?

Background of my question is, that from a local networ we take one workstation and connect it again via VPN from a home office. I thought, a connection via VPN would as the same as if the computer ...
1
vote
0answers
29 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
249 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
1k 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
0answers
473 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
125 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
2answers
728 views

How to have a whole, refreshable MySQL database inside Excel

I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want: I know how to import a MySQL database into Excel. I know ...
1
vote
0answers
59 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
2answers
7k views

Why won't MS Access 2010 show my list of System DSNs when I attempt to link data tables from SQL Server?

Recently the company that I work for has upgraded my PC from Windows XP to Windows 7. On my new PC they've also update my version of MS Access from 2003 to 2010 and they also gave me a new domain ...
0
votes
2answers
2k views

Where'd my System DSN that I just added go to?

I installed Oracle 11g on my Win 7 x64 PC. When I look in Data Sources (under Administrative Tools in the Control Panel) and click on the System DSN tab, I can see the Oracle driver listed ("Oracle ...
0
votes
2answers
288 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
2answers
24k 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?
0
votes
1answer
27 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
66 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
504 views

fail to reload module res_odbc.so in asterisk server

I configure my /etc/asterisk/modules.conf file with following code: [modules] autoload=yes preload => res_odbc.so preload => res_config_odbc.so After that, i went back the CLI console to ...
0
votes
1answer
699 views

iodbctest works but Excel says “No ODBC driver installed”

I'm trying to connect Excel in OS X to a Vertica database and I have their ODBC driver working with iodbctest but when I boot Excel and click on Database I get "No ODBC driver installed" What are the ...
0
votes
1answer
825 views

Linked Query in MS Access 2007 to SQL database - ODBC error - How do I see the linking details?

I am converting an old Access 2003 database to 2007. It has a query linking to a SQL database. How do I look at the link, e.g., whether it using a DSN, etc.? The query has the globe to the left of ...
0
votes
1answer
725 views

is using Hosts for resolving a sql-server more performant?

we have a legacy application which uses a access.mdb with hundreds of ODBC-connected tables on a sql-server. the access.mdb contains nothing else than these odbc-connections. Now we consider to use a ...
0
votes
1answer
78 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
0answers
170 views

Changing the Table name for a linked table in Microsoft Access

I have a Access form application to create a labour posting import file. we use it enter the labour posting details and create a edi import file, which is later imported to our ERP software(Syspro). ...