Super User Stack Exchange
Super User Stack Exchange

Questions tagged [odbc]

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

152 questions
62
votes
3 answers

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 7 64-bit?
Highly Irregular
  • 2,943
  • 18
  • 40
  • 54
32
votes
2 answers

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 there are plenty of MySql admin tools, but it would be…
Alex KeySmith
  • 886
  • 3
  • 14
  • 31
15
votes
2 answers

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 Oracle Client, which resulted in a different…
Mas
  • 350
  • 1
  • 2
  • 9
9
votes
1 answer

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?
leeand00
  • 21,508
  • 43
  • 120
  • 182
9
votes
2 answers

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 (Altova Mapforce, an ETL) What I do: Under…
Topocalma
  • 113
  • 2
  • 2
  • 6
7
votes
2 answers

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 domain users on the same computer at different…
waldrumpus
  • 599
  • 2
  • 7
  • 24
6
votes
1 answer

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 set up with SQL Server Authentication. My general…
Brad
  • 488
  • 1
  • 5
  • 18
5
votes
2 answers

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 Text driver?
nute
  • 1,629
  • 7
  • 24
  • 33
5
votes
1 answer

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 = 'kslap208', @provider = 'MSDASQL', @datasrc =…
Alex Gordon
  • 723
  • 4
  • 15
  • 30
5
votes
2 answers

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 Control Panel. I need to do the same in Windows 7…
GiddyUpHorsey
  • 569
  • 4
  • 11
  • 21
5
votes
1 answer

Access crashes when opening linked table via MySQL ODBC driver

We installed the 32 bit ODBC driver (8.0.27) for MySQL on a Windows 10 machine Made a successfull connection via SSL to a MySQL 8 server Initially tables most table can be opened, but Access crashes often when reopening tables (sometimes also on…
Alex
  • 1,387
  • 2
  • 18
  • 29
4
votes
1 answer

ODBC Data Source Driver 'Does Not Exist' After Updating to Windows 10

I received the following errors in the Microsoft ODBC Data Source manager (64-bit), for my data source an MS Access DB (.accdb), after updating to Windows 10 from 7 and uninstalling MS 2010 and installing 2013: "The driver of this User DSN does not…
marcusdoesstuff
  • 191
  • 1
  • 1
  • 8
4
votes
1 answer

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 would be out of the question. (or OOBase/MySQL…
user332893
4
votes
4 answers

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 after installation I get a report that the…
JRSofty
  • 183
  • 1
  • 2
  • 10
4
votes
1 answer

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 SQL editor: select SUM(Dollars) from original I get…
patrick
  • 1,233
  • 5
  • 24
  • 37
1
2 3
…
10 11