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

learn more… | top users | synonyms

8
votes
2answers
5k 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
2answers
6k 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 ...
5
votes
1answer
32k 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 ...
5
votes
1answer
3k 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?
5
votes
1answer
6k 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 ...
5
votes
1answer
347 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
2answers
8k 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
37 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
10k 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
862 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 ...
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
1answer
3k 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
763 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
4k 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
0answers
369 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
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 ...
1
vote
1answer
3k 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
15k 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 ...
1
vote
1answer
184 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
789 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
54 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
1answer
81 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
446 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
118 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
1answer
37 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
563 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
349 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
114 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
607 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
58 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
4k 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
1answer
36 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
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
17k 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
5k 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
1answer
321 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
444 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
729 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
595 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
0answers
7 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
33 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
0answers
137 views

How to fix Microsoft ODBC for Oracle on a Windows Server 2008 R2 RDP

I share a Windows Server 2008 R2 RDP with several colleagues and we all make heavy use of Microsoft ODBC to do our jobs. One of the important databases we have to connect to is an Oracle database ...
0
votes
1answer
88 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
728 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
0answers
69 views

Google Contacts to ODBC

I want to import my Google contacts into a linked database on MS Access 2010 and I think an ODBC driver is the easiest way to do it. Is there a driver authenticated by Google? Also which are the ...
0
votes
0answers
20 views

Unable to view the ouptut in netbeans IDE 7.1 when I use fullscreen

Hi Everyone I am doing a new project on web services, actually I should get output from database and display it in the front end. I have used NETBEANS IDE as the front-end and then I have completed ...
0
votes
1answer
168 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
0answers
30 views

SQLGetInstalledDrivers Function always searches /etc/odbcinst.ini file with iODBC driver manager on linux

Thanks in advance, I want to list all installed drivers on linux, I am using SQLGetInstalledDrivers Function for the same. Heres my code snippet: char buf[1024] = {0}; char *drivers= buf; if ...