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
0 answers

FreeTDS/pyodbc produces segmentation fault - driver for Raspbian?

I wrote a small Python script to use executemany(sql, *params), with fast_executemany=True. Running it produces a 'segmentation fault' error. The fast_executemany = True uses an ODBC feature called "parameter arrays" and that feature is not…
Nils Deschrijver
  • 31
  • 4
0
votes
1 answer

Run sql script on remote SQL Server database from my Linux machine

I have a .sql file in my linux machine. I would like to connect to MS SQL database in the remote windows machine and run the .sql file in that database. osql -S servername -U xx -P yy runs okay and returns a SQL window like: SQL> I can run…
Aparna Moorthi
  • 11
  • 1
  • 4
0
votes
0 answers

pyodbc ProgrammingError: No results on aws instance but works fine on local machine

I'm running pyodbc on aws instance with FreeTDS installed. The same code runs fine on my local machine (mac) but runs into this error: pyodbc.ProgrammingError: No results. Previous SQL was not a query. Here is the code that I am running. import…
kyc12
  • 349
  • 2
  • 15
0
votes
0 answers

Cant connect to Docker SQL SERVER container using FreeTDS

Error: connection = pyodbc.connect('Driver={FreeTDS};' pyodbc.OperationalError: ('08S01', u'[08S01] [unixODBC][FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist (20009) (SQLDriverConnect)') memorysnapshot_app_1…
DreWalton
  • 1
  • 2
0
votes
2 answers

Using pytds with sqlalchemy

I am trying to connect to an SQL Server from a version of python (pythonista) that requires that I use pure python drivers. I am able to connect using pytds if I don't use sqlalchemy so I know this works. However, I would like to be able to use…
ihf
  • 51
  • 1
  • 9
0
votes
1 answer

Using freeTDS to connect to SQL Server database working with TSQL but not completely in python

I've successfully setup a connection from a stock raspberry pi 4 to our local database running on windows 10. In the terminal if I type: tsql -S *servername* -U *username* -P *password* select * from testlist_table go I get the result for the…
Adam Schulz
  • 137
  • 1
  • 1
  • 7
0
votes
2 answers

how to connect to local mysql using freeTDS on macOS

I don't get why mysql is so hard to connect... I'm following some guides to connect to mysql local server on macOS 15 with python3.8 Everywhere it says to use pyodbc, unixodbc, and freetds. I'm reading all the documents but I can't seem to figure…
Hyunwoo Lim
  • 312
  • 3
  • 15
0
votes
1 answer

08S01 FreeTDS SQL Server Unable to connect: Adaptive Server is unavailable or does not exist

For some reason I'm not able to establish a connection to MSSQL Server with FreeTDS in a python:3.7-slim-buster (debian) docker image. Code Also available on github .. Dockerfile FROM python:3.7-slim-buster # install free-tds used for MSSQL…
Loknar
  • 1,169
  • 2
  • 13
  • 38
0
votes
0 answers

Can't disconnect from SQL Server database

I am not new in software developement but I am new to developement with Lazarus IDE. Currently I am working on a project that uses a SQL Server database. It is not difficult to connect to the database and executing SQL queries. But I have the…
Andreas Schaller
  • 1
0
votes
1 answer

Connect to MS SQL Server Database Using isql on Mac

Summary: tsql connects and isql doesn't. Details: I have tried every official installation guide and Stack Overflow question I can find, but none of them produce joy. I'm trying to connect to a MS SQL Server database from my Mac (Mohave), and…
Adrian Keister
  • 842
  • 3
  • 15
  • 33
0
votes
2 answers

"Incorrect syntax near 'migrations'. " error when migrating with SQL Server 2017 on Laravel in Docker

I'm trying to set up a Jenkins test environment for my Laravel app which has an SQL Server for its database. For this I'm using two Docker containers: A web server for the Laravel app Apache & PHP 7.1.30 Debian 8 Jessie The SQL Server 2017 Linux…
Wouter-s
  • 1
0
votes
1 answer

Read-only connection to SQL Server with PDO DBLIB

Is it possible to create a read-only connection using PDO dblib, or set an attribute with a similar effect? $connection = new PDO("dblib:host={$info['host']};dbname={$info['database']}", $info['username'],…
mbomb007
  • 3,788
  • 3
  • 39
  • 68
0
votes
1 answer

Adaptive Server connection failed TinyTDS::error when connecting ruby on SQL Server 2008 R2

I'm trying to connect my Rails app (rails version 4.2.5 and ruby 2.2.2) in Ubuntu(wsl) with my SQL SERVER 2008 R2 database. i have tried to connect it with tsql -H mydb.database.windows.net -p 1433 -U myuser@mydb -P mypassword -D mydb but i…
Rizky Firmansyah
  • 11
  • 3
0
votes
1 answer

erlang:odbc - cannot get correct query results in unicode from mssql

What i'am trying: - just make a select with erlang-odbc from elixir and dump all result to console. Enviroment: my side Red Hat Enterprise Linux Server release 7.6 (Maipo) unixODBC-devel ( yum) Elixir 1.8.2 (compiled with Erlang/OTP 20) …
Drilla
  • 109
  • 8
0
votes
0 answers

FreeTds inside Docker throwing unknown symbol exception

I'm trying to run a CGI website in a docker. The software is written in c++ and uses to FreeTDS-dev package to connect to a mssql database. so far its working as it should the only problem is: If I try to compile or run it inside of the docker I…
Phillip
  • 789
  • 4
  • 22
1 2 3
…
43 44