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

Error converting characters into server's character set

I am currently stuck at a problem in our project where I read text out of the Database, modify it somewhat and then save it back again. The data is saved in an ntext-field (and is actually an XML-document). Ther error I'm receiving…
Sajus
  • 1
  • 1
  • 3
0
votes
0 answers

Php MSSQL_connect Date Issue

I'm connecting to a mssql server database using my linux cpanel server with php & freeTDS, I can connect and pull all the data i need from the DB but when I pull a date from the database its comes through as a different format, here is my code …
Simon Gersh
  • 41
  • 5
0
votes
0 answers

24000 Invalid cursor state when using pyodbc freetds

I am getting the error :"('24000', '[24000] [FreeTDS][SQL Server]Invalid cursor state (0) (SQLExecDirectW)')" when running pyodbc query using freetds driver. I have been through multiple articles looking for solutions and most of them indicate that…
Parachute
  • 1,178
  • 1
  • 8
  • 13
0
votes
0 answers

Pyodbc on Mac connection issues

I have FreeTDS, unixODBC in my python 3.6.1 installation I'm trying to get pyodbc connected to my sql server (local VM) . I have tried the following to test configuration of freetds tsql -S servername -U pydata I get the following message Error…
Sc-python-leaner
  • 259
  • 1
  • 2
  • 13
0
votes
1 answer

Establishing MS Access connection with UnixODBC and FreeTDS on Mac

I've been trying to establish a connection to an MS Access database I have on my local hard drive using FreeTDS and UnixODBC. My ultimate goal is to open the connection in R via RODBC and implement some SQL scripts developed for this specific…
kanedan29
  • 3
  • 1
0
votes
2 answers

Configuring a connection timeout when connecting to a MS SQL Server database from a lua script using FreeTDS and unixODBC

I have a lua script, running on a RHEL7 host, which has been written to connect to a MS SQL Server database (using FreeTDS / unixODBC) and retrieve a value. The script generally works OK, however, if the target server is offline/unavailable, it will…
verticallygifted
  • 63
  • 2
  • 8
0
votes
1 answer

FreeBSD FreeTDS PHP 7 issues. How to connect php to freeTDS

I have been banging my head against the wall for the last 6 hours. I have a FreeBSD 10 server with PHP 7 installed. Using the commands is isql -v DSN 'USERNAME' 'PASS' I can login to my remote MSSQL server and run commands. I installed PHP with…
Schylar
  • 774
  • 1
  • 5
  • 13
0
votes
2 answers

Why does one ODBC connection work and the second doesn't?

I am using ODBC and FreeTDS on Ubuntu 14.04. We now have three servers that may be running the database at any one time (only one at a time). I tried adding the second server to my freetds.conf and odbc.ini files, but it will never connect, even…
Dan Ringhiser
  • 156
  • 10
0
votes
1 answer

FreeTDS with Django causing Denial of Service on SQL Server

It is a fairly odd behavior coming from an unknown part of the application. My setup: Django FreeTDS Unixodbc django-pyodbc-azure MS SQL The application will work for a seemingly random amount of time (usually 2-3 minutes), then will stop…
Belval
  • 1,236
  • 10
  • 17
0
votes
1 answer

VARCHAR fields trucated to 255 chars

I'm using PHP, SQL Server 2012, and FreeTDS. With TDS version = 7.4, all of my VARCHAR fields are being truncated to 255 characters. I've read that this happens with TDS versions less than 7.0, so that does not apply to this configuration. This was…
Travesty3
  • 14,351
  • 6
  • 61
  • 98
0
votes
1 answer

Can't Install FreeTDS for PHP 7 on Centos 7 server

We move one of our sites to a new server with Centos 7. We make the settings, the PHP 7 is working but we can't run libraries for MSSQL connection. For now we do this: yum install freetds yum install php-mssql FreeTDS appear that was installed,…
Adrian S.
  • 129
  • 1
  • 2
  • 12
0
votes
1 answer

FreeTDS returns SQL Decimal as float

With OS Windows, Python 3.4, pyodbc with SQL Server driver, it converts (and it's correct) SQL Decimal(18,6) to python decimal.Decimal. With Linux, Python 3.4, pyodbc and FreeTDS 0.91-6 driver, same column is converted to python float (and all…
comte
  • 3,092
  • 5
  • 25
  • 41
0
votes
1 answer

Connect to MSSQL database with arm linux board using unixODBC and FreeTDS problems

I am having problems to query a remote MSSQL database from my arm linux board. I compiled unixODBX and FreeTDS, copied all files to the arm board with the same path as in the Ubuntu machine where they where compiled. I also compiled everything for…
GrandJonas
  • 1
  • 2
0
votes
1 answer

pymssql can connect but does not return any results

I am connecting to an MS SQL server with pymssql. I can connect by tsql -H ip -p 1433 -U xx - p xx and by jupyter notebook. The connection does not return any errors. However, I tried many queries with pymssql but none of them returned results. For…
Jill Clover
  • 2,168
  • 7
  • 31
  • 51
0
votes
0 answers

Using freetds to connect to Microsoft SQL server 2014

I'm trying to connect to MS SQL server 2014 with Freetds but I'm stuck. I get the following error locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset "UTF-8" Default database being set to tempdb Error 100…
Joey Hendricks
  • 1
  • 1
  • 3
1 2 3
…
43 44