unixodbc Questions
3
I am trying to connect to my company's SQL Server Databases via my MacBook and have followed the steps outlined here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Mac-OS...
Chrisy asked 4/8, 2019 at 23:40
4
When I run
$ python manage.py inspectdb --database=mssql_database
I have the following error
django.db.utils.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib '/opt/microsoft/...
Younts asked 5/5, 2022 at 10:29
7
Solved
I have trouble getting pyodbc work. I have unixodbc , unixodbc-dev, odbc-postgresql, pyodbc packages installed on my Linux Mint 14.
I am losing hope to find solution on my own, any help appreciated...
Astri asked 29/4, 2013 at 13:47
1
I am trying to set up unixODBC to access Amazon Redshift and I keep getting this error, I have triple checked my setup but not sure what the issue is
> isql -v mlaws
[01000][unixODBC][Driver Man...
Excite asked 29/9, 2020 at 22:48
2
Solved
I've been unable to find a documented way to set a timeout for the initial connection that actually works. I'm not asking about a "query timeout", but rather a timeout on an initial connection atte...
Cadwell asked 12/9, 2013 at 20:51
11
"Adaptive Server is unavailable or does not exist" error connecting to SQL Server from PHP
I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined here. However, when I try to connect in to a different DB using the same setup, I get:
C...
Chiffchaff asked 14/12, 2011 at 20:42
4
Solved
I am trying to connect to a Microsoft SQL Server database from R studio.
I installed the unixODBC driver manager using homebrew:
brew install unixodbc
I then tried to install the freetds driver as...
Mc asked 28/10, 2021 at 18:33
7
Solved
I was installing the Google Cloud SDK on my Ubuntu VM using the following commands
# Add the Cloud SDK distribution URI as a package source
echo "deb [signed-by=/usr/share/keyrings/cloud.google.gp...
Congener asked 20/6, 2019 at 4:55
2
I am trying to get ODBC Driver 17 for SQL Server to work but somehow it doesn't on my brand new apple M1.
Apparently I got unixodbc installed and also the driver, but starting them doesn't work. Lo...
3
Solved
I'm trying to install this mysql odbc connector on my macOS High Sierra machine, but I get this error:
I tried installing it using installer in the hopes of getting information about what went wr...
Mekong asked 24/11, 2017 at 10:14
3
I'm currently trying to connect to a SQL Server (that I don't have visibility into, but have credentials for) using PyODBC. The code that I have works on my Windows desktop, but does not work when ...
Darlenadarlene asked 12/4, 2018 at 21:20
8
Solved
I'm new to the linux world and I want to query a Microsoft SQL Server from Python. I used it on Windows and it was perfectly fine but in Linux it's quite painful.
After some hours, I finally succe...
Elegit asked 14/1, 2016 at 9:18
1
Solved
When I run
$ odbcinst -j
it prints
unixODBC 2.3.7
odbcinst: symbol lookup error: odbcinst: undefined symbol: odbcinst_system_file_name
How can I fix it?
According to this I reinstalled ODBC a no...
2
Solved
I installed unixodbc and unixodbc-dev through apt-get. I then installed oracle instantclient (both the basic and the odbc drivers). Now I am trying to run odbc_update_ini.sh but none of the paths I...
Incestuous asked 31/7, 2017 at 21:35
2
In order to execute this python code [that works on Ubuntu 18] on a MAC,
import pyodbc as odbc
sql_conn_irs = odbc.connect('DRIVER={ODBC Driver 17 for SQL Server};SERVER=xxx.xxx.xxx.xxx;DATABASE...
Danialdaniala asked 17/2, 2020 at 23:12
2
Solved
ive got an error to fix. its:
[FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted
when i use turkish characters to insert i ge...
Adjuvant asked 27/5, 2010 at 16:15
2
Solved
I'm trying to work out how these two pieces of the jigsaw interact and fit together when connecting to an MS-SQL server on linux.
As I understand it, FreeTDS is protocol (i.e. a set of rules) for ...
3
Simple R script
library(RODBC)
odbChannel <- odbcConnect(dsn = "CTPRD03", uid = "BD_RPT_RO", pwd = "****")
df.test <- sqlQuery(channel = odbChannel, query = "select * from DUAL;")
df.test
cl...
2
Solved
There are two major Open Source platform independent implementation of the ODBC. It is iODBC and unixODBC.
Considering Unix as ODBC user platform and feature-wise, what are the real practical diff...
4
/local/rvm/gems/ruby-1.9.2-p320/gems/activerecord-sqlserver-adapter-3.2.12/lib/active_record/connection_adapters/sqlserver_adapter.rb:455:in `initialize': IM002 (0) [unixODBC][Driver Manager]Data s...
Trenna asked 20/1, 2014 at 15:21
3
Solved
The following is a complete ODBC program. All it does is attempt to open a connection to a SQLite database using a fully qualified connection string. The issue I'm having is that when Unicode is en...
3
Solved
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+...
Thomasthomasa asked 17/8, 2018 at 3:38
0
Recently I migrated an ETL platform from Python 2.7 to 3 and also updated its Docker image from Ubuntu 16.04 to 18.04.
After the migration I started encountering some really strange behavior when ...
Jerky asked 7/1, 2020 at 21:23
2
I try to install msodbcsql17 on AWS EC2 with CentOS/RedHat (Linux).
These are the steps, I have followed, from Microsoft (LINK):
sudo su
#Download appropriate package for the OS version
#Choose...
Nina asked 17/5, 2018 at 21:30
3
I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here.
However, when I try to configure /etc/odbc.ini and enter a driver path I have no driver at locat...
Perrin asked 26/10, 2015 at 8:38
1 Next >
© 2022 - 2024 — McMap. All rights reserved.