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

pymssql is returning binary data for datetimeoffset

I am using python 3.6 and pymssql to try and pull some data from a table. everything is fine except for datetimeoffset columns. I have a table that has a column called DateCreated with a type of DateTimeOffset. this column has a default set of…
ttallierchio
  • 460
  • 7
  • 17
0
votes
1 answer

Python 3.6.1 module _mssql can not find libsybdb-89a09a88.so.5.1.0

I've compiled and installed python 3.6.1 in Centos 7 and copied pymssql.so and _mssql.so file to /usr/local/lib/python3.6 folder. And finally after long time managed to import pymssql. But get error that can't find this…
Reza Akraminejad
  • 1,412
  • 3
  • 24
  • 38
0
votes
1 answer

How to translate the cast of a memory address in C into python ctypes call?

Sorry if the title isn't accurate, I am not 100% sure it describes the situation correctly: I am attempting to interface with the FreeTDS C-library using Python's ctypes module. I have some code running surprisingly well, but have run into one…
Randy Syring
  • 1,971
  • 1
  • 15
  • 19
0
votes
1 answer

How to configure unixODBC driver with freetds for sphinx. ERROR: source: unknown type 'odbc'; skipping

I am setting up Sphinxsearch for Linux, also I have remote MSSQL Server. I have installed unixODBC and freetds accroding to documentation. odbcinst.ini file: [FreeTDS] Description=v0.63 with protocol v7.3 Driver =…
Somchai
  • 21
  • 4
0
votes
0 answers

Connect to Azure SQL Server via Linux + ODBC + Active Directory Authentication

I'm attempting to connect to Azure SQL Server 2017 from Debian 8 or 9. Our SQL Server instance is connected to our Active Directory requiring Active Directory Authentication. Thus far, I've tried connecting using the Microsoft ODBC Driver in…
Evan Kaeding
  • 192
  • 1
  • 6
0
votes
1 answer

Apache / WSGI and PHP suddenly unable to connect to MSSQL server -- site down

between yesterday and today something happened that prevents processes running under Apache accessing an MSSQL server that is essential for functioning of the site. This is what I find in the Apache error logs for PHP scripts: PHP Warning: …
musbur
  • 567
  • 4
  • 16
0
votes
0 answers

Frequently disconnect the mssql server and getting errors like "core dumped" and sometime "memory corruption"

I'm using python3.5.2, django==1.11, ubuntu16.04, AWS RDS, MSSQL server 17, UNIXODBC==3.2.1, FREETDS (freetds v0.91, TDS version: 4.2) In my django settings: os.environ['TDSVER'] = '8.0' DATABASES = { 'default': { …
Vinay Kumar
  • 1,199
  • 13
  • 16
0
votes
0 answers

Registerd Trademark symbol causing "Unclosed quotation mark after the character string 'xyz'" error

A python script is executing this query: SELECT * FROM dbo.table_x WHERE field_1 = 'xyz®' When run from a Windows machine this python script works. When run from a Linux machine it fails. The database is SQL Server. On the Linux machine…
Mark Andrews
  • 51
  • 5
0
votes
0 answers

Connecting Ubuntu 16.04 to remote MSSQL server in the same domain

I am having a lot of issues trying to connect to my mssql server. I have gone through what feels like hundreds of SO threads and articles over the last two days trying to connect these two. Here's what I can do. From Ubuntu, I can ping Window MSSQL…
Achmann
  • 196
  • 1
  • 11
0
votes
0 answers

*** Error in `./text_buffer': corrupted double-linked list: 0x089cbd98 **

I'm trying to make the app using FreeTDS. Following are my code /* * Purpose: Test to see if row buffering and blobs works correctly. * Functions: dbbind dbnextrow dbopen dbresults dbsqlexec dbgetrow */ #include "common.h" #include…
Dwicahyo Yulianto
  • 1
  • 1
0
votes
1 answer

Use of odbc_exec with successful result downloads PHP page instead of renders is

I'm having a very strange issue. I'm using unixODBC with FreeTDS to connect to MSSQL server. If I perform an SQL command using odbc_exec that results in a valid query, instead of rendering the PHP, I get a prompt to download my php file, which if I…
andypants
  • 23
  • 1
  • 7
0
votes
2 answers

FreeTDS TSQL not working with freetds.conf

I am using freetds version 1.00.91 from HomeBrew. I can successfully connect when I bypass the freetds.conf, e.g. using the following command tsql -H {my_hostname} -p {port_no} -U {username} -P {password} However, when I tried to tsql -S…
Allen Lin
  • 1,179
  • 4
  • 13
  • 23
0
votes
0 answers

Encoding write db issue to SQL after 1024 row

I'm trying to write table to MS SQL Server from R using DBI with Cyrillic words. All looking good but when I write more then 1024 rows I have issue with encoding. I'm try next drivers : Microsoft ODBC Driver 17 for SQL Server ODBC Driver 13 for…
jyjek
  • 2,627
  • 11
  • 23
0
votes
1 answer

Unable to connect to DB2 Database using ODBC and FreeTDS Driver

I am unable to connect my to ODBC using FreeTDS driver. I work on a Mac with High Sierra 10.13.4. (I tried using the IBM DB2 driver. It also does not work. So, I am trying with FreeTDS). I have installed FreeTDS Driver. However, I do not know how to…
Partha
  • 47
  • 2
  • 8
0
votes
1 answer

Sequencing queries for MS SQL with HDBC-ODBC

What is the proper way to use a single connection and run multiple queries when connecting to MS SQL server from Haskell? import qualified Database.HDBC as DB import qualified Database.HDBC.ODBC as DB import Data.Time.Calendar (fromGregorian) import…
bkc
  • 1
  • 2
1 2 3
…
43 44