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

learn more… | top users | synonyms

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?
1
vote
1answer
31 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
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
48 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
443 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
165 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
780 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
555 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 ...
0
votes
1answer
460 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 ...
0
votes
1answer
620 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 ...
0
votes
1answer
684 views

Export data from ODBC to CSVs or similar

I have a SQL Anywhere 5 database which I can currently access through ODBC. I managed to open it with Access but when I used Access to export text files it would truncate the data. Is there a way ...
3
votes
0answers
719 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
0answers
362 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
0answers
331 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
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
0answers
59 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
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
0answers
28 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
146 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 = ...
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 ...
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 ...
0
votes
0answers
143 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 ...
0
votes
0answers
503 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 ...