Stack Overflow
Stack Overflow

Questions tagged [freetds]

FreeTDS is a set of libraries for Unix and Linux that allows your programs to natively talk to Microsoft SQL Server and Sybase databases.

Website: http://freetds.schemamania.org/

658 questions
0
votes
1 answer

odbcinst symbol lookup error SQLManageDataSources

I've just installed unixODBC on Pop-OS (Ubuntu 20 base). there's no odbcinst.ini file, just odbc.ini and when I run odbcinst -j I just get the following odbcinst: symbol lookup error: odbcinst: undefined symbol: SQLManageDataSources I'm not an…
Marc Nealer
  • 374
  • 1
  • 4
  • 10
0
votes
0 answers

Python SQLAlchemy pyodbc.Error: ('HY000', 'Unknown error')

I am working with python, sqlachemy and MSSQL. For no apparent reason I received the following error, it has only happened twice and I have not been able to replicate it. /usr/local/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line…
Laura Ochoa
  • 1
0
votes
0 answers

Postgres 14 tds_fdw for SQL Server requires setting ANSI_NULLS and ANSI_WARNING

I am looking into establishing foreign data wrapper between PostgreSQL 14 and remote SQL Server 2014. I do not have administrative-level access to the remote SQL Server, thus need to make changes only at Postgres. The error I currently encounter is…
zaidwaqi
  • 609
  • 1
  • 8
  • 25
0
votes
1 answer

Rails migration giving errors when using with MSSQL [MicroSoft SQL SERVER] - Cannot find data type primary_key

I am working on Rails 3 project where I initially used MySQL as RDBMS. But later my client requested that we should use MSSQL. After spending half a day, I am able to connect with the MSSQL server using the article here:…
Chandresh Pant
  • 1,173
  • 15
  • 19
0
votes
2 answers

Problem installing tiny_tds gem in rails 3

I have succesfully installed free_tds on my mac and can use tsql to access the db and query tables. However when I try to use the gem tiny_tds gem on rails 3 I get the following error: Installing tiny_tds (0.4.5) with native extensions…
gugguson
  • 819
  • 2
  • 13
  • 32
0
votes
1 answer

tds_fdw PostgreSQL Foreign Table Truncates Large Text to 2048 Characters

I have created several foreign tables already, and they all work fine, but now I have to deal with a table that has a column containing 20-30 KB of text in some rows. If that text is small, it is rendered in full, but if it happens to be longer than…
Brewer
  • 23
  • 6
0
votes
1 answer

Can't connect to Azure SQL instance using FreeTDS config

I can connect from my Ubuntu 20.04 VM to my Azure SQL database with: TDSVER=7.3 tsql -H mysubdomain.database.windows.net -U un -P pw -p 1433 I want to get this working with freetds.conf, but it's failing, and I'm not sure why; here's what I'm…
Crag
  • 1,723
  • 17
  • 35
0
votes
1 answer

Does FreeTDS ODBC + pyodbc support table-valued parameters (TVPs)?

I'm working on unix/rhel7 system. I have installed require drivers for FreeTDS, unixODBC and pyodbc.Other query is working fine but when I'm trying execute stored proc with TVP (table valued parameter), its giving me error. Is there any way to…
user11853415
  • 41
  • 6
0
votes
1 answer

Is freetds version 1.1.4 compatible with Microsoft SQL Server 2017?

We are planning to use freetds 1.1.4 in our organisation to connect to SQL Server 2017 using Perl and C++. We saw a compatiblity chart but it doesn't have any info for SQL Server 2017. Could you please let us know whether we can use 1.1.4 for…
Prakruthi Alosri
  • 27
  • 3
0
votes
0 answers

Migrate from FreeTDS driver to MSODBC17 driver

I needed to change our sql driver from FreeTDS to msobdc17 for msi support. The problem results in a degradation in our insertion operations. Specifically, when we insert in bulk (with batch size~=50), the performance is highly degraded on…
Yoni Mantzur
  • 42
  • 8
0
votes
1 answer

Pyodbc if connection fails retry

Hi there I have the following python code to connect to my SQL-Server DB class CDBTools: details = { 'server' : 'localhost', 'database' : 'MyDB', 'username' : 'me', 'password' : 'myPass' } conn = None …
TitovkaJeKapa
  • 5
  • 2
0
votes
0 answers

PHP CLI ODBC FreeTDS MSSQL Login failed

I have an AW server with CentOS. I have installed PHP7.3 and the PHP-CLI for it. I also installed ODBC and FreeTDS modules to be able to connect to a MSSQL database. I have written a PHP script which is connecting to this database with PDO. When I…
Thallius
  • 2,482
  • 2
  • 18
  • 36
0
votes
1 answer

Can't open lib 'FreeTDS' : file not found and /etc/odbcinst.ini is missing

I want to connect R to Athena in AWS so that I can get a table from the database into R. So I went online and I googled how to do this. I found this website here. That told me that I need to install drivers. I have a mac (which is also new to me)…
Nick
  • 369
  • 1
  • 3
  • 18
0
votes
0 answers

FreeTDS + Doctrine remove zero decimal

I have Symfony 3.4 + Doctrine 2 + FreeTDS + MSSQL Server 2005 I try to get decimal column from DB, and have little trouble. If in db i have value like 100.00 i have in return 100. But i wish to get 100.00. New information, i try run query with go...…
Никита Рассамахин
  • 27
  • 5
0
votes
0 answers

connect to external sql server using pyodbc and FreeTDS drivers on rhel 7 linux

I have an AWS EC2 instance, installed FreeTDS, I run osql and it tells me Configuration looks ok but then does an isql. That fails. I tried the tsql -LH but nothing returned. tsql -S returns: locale is "en_US.UTF-8" locale charset is…
Schwan
  • 1
1 2 3
…
43 44