9,624 questions
200
votes
10
answers
319k
views
what is the difference between OLE DB and ODBC data sources?
I was reading a MS Excel help article about pivotcache and wonder what they mean by OLE DB and ODBC sources
...You should use the CommandText
property instead of the SQL property,
which now ...
- 21.6k
109
votes
9
answers
264k
views
How to convert "0" and "1" to false and true
I have a method which is connecting to a database via Odbc. The stored procedure which I'm
calling has a return value which from the database side is a 'Char'. Right now I'm grabbing
that return ...
- 6,355
78
votes
4
answers
190k
views
Connecting to MS SQL Server with Windows Authentication using Python?
How do I connect MS SQL Server using Windows Authentication, with the pyodbc library?
I can connect via MS Access and SQL Server Management Studio, but cannot get a working connection ODBC string for ...
- 2,090
51
votes
5
answers
36k
views
Creating a custom ODBC driver
At my current job, we're looking to implement our own odbc driver to allow many different applications to be able to connect to our own app as a datasource. Right now we are trying to weigh the ...
- 11.9k
48
votes
3
answers
125k
views
How to search for rows containing a substring?
If I store an HTML TEXTAREA in my ODBC database each time the user submits a form, what's the SELECT statement to retrieve 1) all rows which contain a given sub-string 2) all rows which don't (and is ...
- 40.5k
45
votes
9
answers
80k
views
Linux - PHP 7.0 and MSSQL (Microsoft SQL)
Yes, I know that PHP 7.0 removed the extensions needed to connect to MSSQL. FreeTDS was my option prior to PHP 7.0 but now there really is no obvious upgrade path for those needing to still connect to ...
- 1,237
43
votes
6
answers
69k
views
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
I need to reverse engineer a Microsoft SQL Server 2008 in order to create a Microsoft Visio 2007 Database Model Diagram. So I choose "Reverse Engineer" from the Database menu to connect to the DB.
I ...
- 12.5k
39
votes
4
answers
143k
views
Setting up PostgreSQL ODBC on Windows
I have the latest 64 bit version of PostgreSQL. I am running Win 7 64 bit. I had installed the ODBC driver (via the initial installer) when I installed PG, and upgraded it to the latest version from ...
- 18.4k
37
votes
4
answers
38k
views
How to fix endless reboot loop installing Microsoft ODBC Driver 17 - message: A previous installation required a reboot of the machine for changes
Installing Microsoft® ODBC Driver 17 on windows 10.
During the install, Microsoft ODBC Driver 17 for SQL Server setup stops and shows "A previous installation required a reboot of the machine for ...
- 1,171
36
votes
4
answers
251k
views
Excel: Use a cell value as a parameter for a SQL query
I'm using MS Excel to get data from a MySQL database through ODBC.
I successfully get data using an SQL query. But now I want that query to be parameterized.
So I wonder If it is possible to use a ...
- 43k
32
votes
9
answers
91k
views
What is a privileged instruction?
I have added some code which compiles cleanly and have just received this Windows error:
---------------------------
(MonTel Administrator) 2.12.7: MtAdmin.exe - Application Error
--------------------...
- 1,523
31
votes
3
answers
14k
views
Fetching UTF-8 text from MySQL in R returns "????"
I'm stuck trying to fetch UTF-8 text in a MySQL database from R. I'm running R on OS X (tried both via the GUI and command line), where the default locale is en_US.UTF-8, and no matter what I try, ...
- 21.9k
29
votes
1
answer
47k
views
sql.h header file missing though unixODBC is installed
I am on an up-to-date Ubuntu 12.04 system. I have unixodbc (v2.2.14 from ubuntu repos), MySQL and its relevant drivers installed. Also connected to a valid DSN. Verified by issuing isql DBName UName ...
user749138
28
votes
1
answer
38k
views
Python odbc; how to find all tables in an odbc
Is there any way to get a list of all tables available through an odbc connection.
I have to fetch data from tables that are generated along the way, and therefore I don't know the names in advance.
- 10.6k
27
votes
7
answers
46k
views
How do I create an ODBC DSN entry using C#?
I'm working on a legacy application that has a C++ extended stored procedure. This xsproc uses ODBC to connect to the database, which means it requires a DSN to be configured.
I'm updating the ...
- 42.3k
27
votes
3
answers
54k
views
Install ODBC driver in Alpine Linux Docker Container
I currently have the following Dockerfile to create my Docker image.
FROM python:3.6.6-alpine3.8
# Add dependencies for Python packages pandas, numpy and pyodbc
RUN apk add --no-cache curl gcc g++ ...
- 6,421
26
votes
4
answers
136k
views
Connecting Python with Teradata using Teradata module
I have installed python 2.7.0 and Teradata module on Windows 7. I am not able to connect and query TD from python.
pip install Teradata
Now I want to import teradata module in my source code and ...
- 634
26
votes
4
answers
137k
views
Why am I getting "Data source name not found and no default driver specified" and how do I fix it?
When trying to make a program on Windows that connects to a database via ODBC, I got the following error:
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
...
- 32.8k
26
votes
4
answers
7k
views
'PDOException' with message 'SQLSTATE[22001]: String data, right truncated: 0
NOTE: I have narrowed this problem down to specifically PDO because I am able to successfully prepare and execute statements using the odbc_* functions.
Why can't I bind this parameter to the PDO ...
- 41.5k
25
votes
4
answers
44k
views
SQL Server: Native client vs. ODBC?
What is the difference between SQL Server Native Client connection and ODBC connection? What are the pros and cons of these two?
- 5,773
24
votes
7
answers
47k
views
How To Convert An Elixir Binary To A String?
So I'm trying to convert a binary to a string. This code:
t = [{<<71,0,69,0,84,0>>}]
String.from_char_list(t)
But I'm getting this when I try this conversion:
** (ArgumentError) ...
- 15.4k
23
votes
5
answers
63k
views
Linked SQL Server database giving "inconsistent metadata" error
I am currently running a third-party software suite, which uses SQL Server as its database. I have a second instance of SQL Server running in a different location, and some apps that I am building in ...
- 1,341
23
votes
4
answers
76k
views
Hand Install of 64-bit MS Access ODBC drivers when 32-bit Office is present
I want to do a hand install of the MS Access 64 bit odbc drivers. Uninstalling 32 bit Office and installing 64 bit Office is not an option due to the add-ins that our company uses.
I downloaded the ...
- 321
23
votes
1
answer
26k
views
Libraries for connecting node.js to odbc on Windows? [closed]
I'm looking for a library that allows node.js to connect to ODBC on windows. All the libraries I have found thus far seem to work with UnixODBC but not windows, can someone please suggest a library ...
- 26.6k
22
votes
3
answers
34k
views
FreeTDS working, but ODBC cannot connect
I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC.
Using tsql i can connect to the server with
~$ tsql -S dbs3 -U <username> -P <password&...
- 550