In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
0
votes
0answers
16 views
ODBC connection thru SSH
I need to run a script which use odbc thru an SSH port forwarding (tunnels ) . I can do it by interatively running putty.exe first to establish the SSH connection with port forwarding , and then run ...
0
votes
1answer
19 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
80 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
31 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
107 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
0answers
14 views
Export Informix BYTE fields via MS-Access
Is it possible and if how to use MS-Access to export data which is stored in a BYTE column of a table of an Informix database?
Informix runs under HP-UX and access is done via ODBC.
1
vote
0answers
112 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
147 views
Using Visio 2010 Professional to load Oracle database
I can successful connect to my Oracle database using ODBC (SYSTEM DSN), I can access it using SQL*Plus and entering the host (from TNSNames) and username /password and also can see the data when ...
0
votes
0answers
46 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 ...
1
vote
0answers
105 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 = ...
0
votes
0answers
195 views
Windows 7 Home cannot connect to a Firebird database [closed]
I have a firebird database running on a Windows 2003.
I already have windows xp clients, also windows 7 64 bits profesional, all logged into the same domain as the server.
But I want to connect a Win ...
1
vote
1answer
400 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
364 views
System DSN command prompt
I can create a System DSN connection via the following command:
odbcconf.exe /a {CONFIGSYSDSN "SQL Server"
...
0
votes
1answer
4k 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
756 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
199 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
713 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
130 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
0answers
66 views
Missing DSNs after failed Roaming Profile load? [closed]
Now I'm guessing that these were probably stored in my personal registry hive ntuser.dat which likely got corrupted when the logoff didn't complete. Is there anything I can do to get my data sources ...
1
vote
1answer
73 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
0answers
331 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
2k 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
226 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 ...
4
votes
1answer
971 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
102 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
117 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
22 views
Using 64-Bit 2012 SQL Server can I Linked Server Access 2003 .mdb File? [duplicate]
Possible Duplicate:
SQL Sever 2012 Connecting to MS Access 2003
I get an error Every time I try I get (Microsoft SQL Server, Error: 7302).
It's not a permitions issue I have SQL as Local ...
0
votes
0answers
100 views
Trying to connect to an ODBC server using RODBC in ubuntu
I am getting the error:
[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found
2: In odbcDriverConnect("driver={SQL ...
3
votes
1answer
7k 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
2k 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
139 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
571 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
288 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
273 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 ...
3
votes
0answers
219 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
380 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
288 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
467 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 ...
7
votes
1answer
2k 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
4k 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 ...
0
votes
1answer
1k 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 ...
2
votes
2answers
3k views
How can I easily migrate an Access database to MySQL? [closed]
My situation:
Earlier, I asked:
What is the easiest way to edit an Access database online?
[...] What is the easiest way to allow people to make changes to that database without needing to ...
0
votes
1answer
431 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 ...
1
vote
2answers
331 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 ...
0
votes
0answers
837 views
ODBC link from Access to SQL Server changes to read-only [closed]
Cross Posted: ODBC link from Access to SQL Server changes to read-only
I have an Access 2007 db front-end that interacts with a SQL Server engine. All works OK, but there is a linked table that ...
0
votes
1answer
528 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 ...
2
votes
1answer
2k 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 ...
0
votes
2answers
6k 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?
2
votes
2answers
1k 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 ...
0
votes
1answer
147 views
What configuration for DSN access in Apache?
I am configuring a standalone Apache Http Server (2.2.16, on Windows. Can be XP or more recent) to communicate with J (standalone as in not XAMPP or other packages). I can get my list of user DSN's in ...
