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
6 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
26 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
26 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
28 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
0answers
79 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
57 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
33 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
4k 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
536 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
64 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
167 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
51 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
29 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 ...
0
votes
0answers
147 views

pgpass file never gets recognized by the 64-bit postgreSQL ODBC driver.

I have been spending quite a while trying to get the amd64 version of the postgreSQL ODBC driver to establish a connection with a pgpass file. Every time I try to open a connection using SSLMODE = ...
3
votes
0answers
769 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 ...
0
votes
1answer
835 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. ...
0
votes
1answer
291 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
517 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
75 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
584 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
340 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
80 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
663 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
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 ...
0
votes
2answers
2k views

System DSN command prompt

I can create a System DSN connection via the following command: odbcconf.exe /a {CONFIGSYSDSN "SQL Server" ...
1
vote
1answer
14k 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
0answers
1k views

Are there new ODBC and OleDb drivers for Microsoft Office 2013 (Excel, Access and CSV)?

Microsoft provided 32 and 64 bit ODBC and OleDb drivers for JetSQl, Excel, and CSV files with Microsoft Office and the free Office 2010 Redistributable. They also provided a 32-bit free ...
1
vote
1answer
425 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 ...
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: ...
0
votes
1answer
301 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 ...
1
vote
1answer
172 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 ...
0
votes
2answers
1k 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?
5
votes
2answers
5k 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
1answer
476 views

Questions about setting up PHP-ODBC driver for remote SQL-Server-2008 connection on CentOS-6

I have CentOS 6 and PHP 5.3.3 VPS at GoDaddy. I have to interact with remote SQL Server 2008. I've seen many tutorials and quite lost here, so: There is a way to simply yum install it ? If not, what ...
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?
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` ( ...
0
votes
0answers
145 views

How to ssl-secure mysql connection on Windows XP?

I use MS Access to connect my remote MySQL database, and use MySQL ODBC connector for that. I would like to secure the connection with SSL. ODBC connector offers some SSL setup, but I don't have idea ...
5
votes
1answer
29k 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
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
414 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
827 views

Access MS SQL server from CentOS (OpenOffice calc)

I installed FreeTDS in CentOS 6 and I can connect from php to remote MS SQL server. However I cannot set up odbc connection so that it shows in list of ODBC connections in OpenOffice apps. If my ...
0
votes
0answers
506 views

How can I use the ODBC connection of another computer on my network?

I'm not sure if I need to look at this problem a different way but here goes. Computer A (windows XP) has an SSH Tunnel to the web server. Port 3306 on the web server is tunneled to port 3306 on ...
0
votes
1answer
513 views

MySQL ODBC Debugging to myodbc.sql overwrites file instead of appending new queries

I am using the MySQL ODBC driver on a Windows Server 2008 R2 64-bit box. I enabled the debug feature on the odbc driver using the ODBC administrator at %windir%\SysWOW64\odbcad32.exe It does write ...
5
votes
1answer
336 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 ...
0
votes
1answer
631 views

Troubleshooting inconsistent ODBC connectivity

I'm attempting to integrate UPS WorldShip with a SQL Server 2008 R2 database but the connection is very inconsistent. UPS claims this is a DSN/Windows problem and I have not been able to convince them ...
2
votes
0answers
364 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
1answer
742 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 ...
8
votes
2answers
4k 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 ...
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 ...