In computing, ODBC (Open Database Connectivity) is a standard software interface for accessing database management systems (DBMS).
Questions tagged [odbc]
155 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
- 3,121
37
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
- 966
16
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
- 360
- 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
- 23,552
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
8
votes
4 answers
Use a Cell Value for a Paramater Value using in Power Query
I am using a query like below in power query Excel 2016:
let
Source = Odbc.Query("dsn=AS400", "select * from libm61.emleqpm1 where STN1 = '03' ")
in
Source
I want to replace '03' with a value form cell AD2
Is this possible to do ?
PeterH
- 7,595
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
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
- 508
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,667
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
- 743
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
- 568
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,437
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
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