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

Why can I connect to Azure SQL with tsql but not pymssql in centOS?

I am able to connect to Azure SQL Server using T-SQL like below. tsql -H testdb.database.windows.net -p 1433 -U testuser -P testpass -D testdb I am not able to connect when I use pymssql. >>import pymssql >>connection =…
Srinivas
  • 1
  • 1
0
votes
1 answer

Cannot connect to MSSQL server using FreeTDS on Raspberry Pi (Rasbian)

I am trying to connect to an MSSQL Server database, which is a named instance, from my Raspberry Pi running Rasbian, using FreeTDS. My server\instance name is DISRUPT-L02\SQLEXPRESS2014 so my freetds.conf file looks like this: [SQL] host =…
paularmy42
  • 39
  • 7
0
votes
1 answer

Django MsSQL FreeTDS - Nvarchar(max) Auto Truncates

I'm using Django that is connected to AWS' RDS MSSQL. So I'm to input very long texts, but they are generally longer than 4000 characters. In Django, this specific field is using TextField and the data type in MSSQL is nvarchar(max). So my question…
Justine Sinel
  • 21
  • 1
0
votes
0 answers

Asterisk - use custom functions

My Asterisk can write Call Data Record and channel event logging use freetds. I know, that for my question i can use func_odbc. But my linux knowledge is low. I can use custom dialplan function without func_odbc. Maybe "func_tds"?
Nikita Grishchenkov
  • 19
  • 4
0
votes
1 answer

Failed to install pymssql using pip and linking to FreeTDS installed using fink on a Mac

I am running MacOS 10.11.6 (El Capitan) on an iMac. I have set up a Python 3.4.7 virtual environment and I have pip (9.0.1) installed various packages including numpy, pandas, scipy etc. However, I'm having difficulty installing pymssql using. I…
user1718097
  • 4,090
  • 11
  • 48
  • 63
0
votes
2 answers

ADODB / SQL Server mssql_execute stored procedure fails but works if debug is set to true

I am connecting to a SQL Server database from PHP using ADODB. I have several stored procedures that I have been executing just fine. The last call that I have created for some reason keeps failing. I put debug as true and it works just fine. I have…
dan.codes
  • 3,523
  • 9
  • 45
  • 59
0
votes
1 answer

Unable to connect to sql server from tsql

I am able to connect to remote sql server using SQLpro for MSSQL. However, When I am trying to use tsql to connect, i am not able to connect to the database OS: Macos x My freetds.conf path: /usr/local/freetds.conf [global] # tds protocol …
Bhargav
  • 454
  • 1
  • 6
  • 15
0
votes
1 answer

Unable to install pyodbc or pymssql on mac sierra

I am trying to install pyodbc or pymssql python library using "pip install pyodbc" and "pip install pymssql". However, I keep getting the following error message: Command "/usr/bin/python -u -c "import setuptools,…
Sakura
  • 869
  • 4
  • 13
  • 32
0
votes
0 answers

pymssql/FreeTDS does not connect to server (anymore)

Trying to connect to an MS SQL server in Python. import pymssql server = '172.17.149.7\SQLEXPRESS' user = 'test_user' pw = 'test_pw' db = 'test_db' conn = pymssql.connect(server=server, user=user, password=pw, database=db) Funny enough, this…
danny
  • 55
  • 11
0
votes
1 answer

Is it possible using Pymssql to access SQL Server 2012 remotely, with domain (windows) user account

I could not access SQL Server 2012 remotely using windows user account, even though its possible to access SQL Server after login to Windows OS with the same credentials. Is there any way to achieve that? Due to Security (OS Hardening) reason's SQL…
user2264738
  • 302
  • 4
  • 18
0
votes
0 answers

freeTDS not working via macOS Terminal

I'm using this guide to use my Mac to connect to a MS-SQL-Server: https://github.com/lionheart/django-pyodbc/wiki/Mac-setup-to-connect-to-a-MS-SQL-Server On step three, I'm trying to run freeTDS and check whether it works, but I'm getting this…
user5943954
  • 49
  • 2
  • 6
0
votes
1 answer

Trouble Installing pymssql on Windows 10

I am trying to install pymssql version 2.1.3 into an Anaconda 4.3.0 environment running on windows 10. I have been following the steps outlined to resolve in this post: Trouble installing pymssql on Windows. However I am still getting this…
Todd Dziedzic
  • 1
  • 1
0
votes
0 answers

freetds bash $variable

I need to automatize an sql script via bash. I'm asking about how to use bash variable in an sql command use by freeTDS. Here is my command and the code below : echo "Declare @montant int =$mobile ,@categorie varchar(12) = 'mobile',@nom…
Axel Bonnafoux
  • 9
  • 3
0
votes
1 answer

Can't Connect to SQL Server on Mac

I've followed these instructions (exchanging the dummy variables where necessary) and can't get pass the step where you run with isql. The FreeTDS driver seems to be working (though instead of getting a CLI it just starts counting upwards), but I…
James Kelleher
  • 1,957
  • 3
  • 18
  • 34
0
votes
0 answers

osql not able to find Driver in odb.ini file

my freetds.conf file: [global] # TDS protocol version ; tds version = 7.4 # A typical Sybase server [egServer50] host = symachine.domain.com port = 5000 tds version = 5.0 # A typical Microsoft server [ABC] host = IP…
poshita singh
  • 131
  • 1
  • 1
  • 9
1 2 3
…
43 44