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
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?
6
votes
1answer
7k 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 ...
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
2answers
40k 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
375 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
9k 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
44 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
11k 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
990 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
4k 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
938 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
5k 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
378 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
4k 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
17k 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
209 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
833 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
58 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
87 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
473 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
49 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
665 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
379 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
115 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
636 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
5k 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
1answer
56 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
8k 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
18k 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
365 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
491 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
778 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
619 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
19 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
0answers
8 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
39 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
288 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
132 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
1k 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
77 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
1answer
173 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

Java, Eclipse, ODBC 32 or 64 bit what should I change?

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 make an ODBC seems to be by using a 32 bit variant. ...