freetds Questions

1

I've got a CentOS 7 machine running PHP with webtatic PHP 5.6 and the php56w-mssql package installed. My application is in the Laravel framework connecting to an MSSQL 2012 database. I've modified...
Flattie asked 14/12, 2016 at 0:20

8

Solved

MY QUESTION What are some surefire steps I can take to 100% get this working? I would need real instructions, not one liner answers or vague conceptual descriptions of the process. Let's get to th...
Maxilliped asked 21/2, 2013 at 14:15

3

I am trying to connect to my company's SQL Server Databases via my MacBook and have followed the steps outlined here: https://github.com/mkleehammer/pyodbc/wiki/Connecting-to-SQL-Server-from-Mac-OS...
Chrisy asked 4/8, 2019 at 23:40

2

Solved

I am trying to connect to a SQL server from a python script on a Mac OSX and after installing freeTDS using brew install freeTDS I can't seem to find the driver "libtdsodbc.so" anywhere on my machi...
Radiometer asked 21/1, 2015 at 18:59

11

I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined here. However, when I try to connect in to a different DB using the same setup, I get: C...
Chiffchaff asked 14/12, 2011 at 20:42

4

When I try to connect into Azure database by Pymssql in python I face this error: pymssql.OperationalError: (20002, 'DB-Lib error message 20002, severity 9:\nAdaptive Server connection failed (ipri...
Delilahdelimit asked 25/3, 2016 at 9:30

3

Solved

I'm trying to get MSSQL working on Ubuntu 12.04 via ODBC, and I've followed these steps to the letter: http://jamesrossiter.wordpress.com/2011/03/08/connecting-to-microsoft-sql-server-using-odbc-f...
Trimetrogon asked 20/8, 2012 at 3:13

4

Solved

I used homebrew (linux port) to install freeTDS and am trying to deploy /bundle install my app with gem tinytds. I get this error output when doing bundle install Installing tiny_tds (0.5.1) with ...
Heterochromosome asked 3/4, 2012 at 16:42

4

Solved

I try to insert bunch of data to database insert_list = [(1,1,1,1,1,1),(2,2,2,2,2,2),(3,3,3,3,3,3),....] #up to 10000 tuples in this list conn = pyodbc.connect('DRIVER={FreeTDS};SERVER=xxxxx;DATA...
Precursor asked 1/2, 2017 at 7:13

2

Solved

ive got an error to fix. its: [FreeTDS][SQL Server]Error converting characters into server's character set. Some character(s) could not be converted when i use turkish characters to insert i ge...
Adjuvant asked 27/5, 2010 at 16:15

2

Solved

I'm trying to work out how these two pieces of the jigsaw interact and fit together when connecting to an MS-SQL server on linux. As I understand it, FreeTDS is protocol (i.e. a set of rules) for ...
Demography asked 13/8, 2015 at 6:29

3

Solved

I am trying to connect an SQL server from an Ubuntu machine, everythings works great except for named instances: this works 'data' => array( 'driver' => 'sqlsrv', 'host' => 'xxxx', 'p...
Swot asked 19/3, 2015 at 13:46

3

I keep seeing this error, and I am unable to connect to the database on the remote server. I am given a connection string to the database, that looks like the following: data source=qsss.gar.de\S...
Breakthrough asked 3/8, 2016 at 12:54

3

Solved

I tried following the instructions in the article below but it says, "No package freetds available." http://www.hosting.com/support/linux/installing-freetds-for-linux/ This is my I/O: [root@mydo...
Chestnut asked 24/11, 2013 at 19:10

1

I want to host Shiny applications on my company network using Docker for Windows. How do I set up the Docker, odbc.ini, odbcinst.ini, freetds.conf, or possibly other files so that my Shiny applicat...
Golightly asked 30/5, 2019 at 16:51

8

Solved

I can't seem to get data from MSSQL encoded as UTF-8 using FreeTDS extension. Connecting: ini_set('mssql.charset', 'UTF-8'); $this->_resource = mssql_connect($config['servername'], $config['us...
Chlorobenzene asked 14/11, 2012 at 11:19

4

I have no idea why I am getting this error and cannot find any solutions for it. I can connect to a SQL Server database using freetds tsql but I keep getting an error when connecting using pymssql....
Selfseeking asked 12/4, 2012 at 9:49

1

Solved

I am using python 2.7 for a specific job. I am connecting to MSSQL Server (2008) using FreeTDS. I can make some simple select queries but when I try to run a parametrised query I got an error: ('H...
Oblivion asked 9/11, 2012 at 15:45

1

I know this question is asked many times and I have tried all but nothing worked. I am trying to connect to a MSSQL database on a different server from Ubuntu 14.04. Content from /etc/odbcinst.in...
Angelicangelica asked 10/11, 2017 at 11:11

4

I am trying to connect mssql server to PHP 7.0.8 through MAMP. I have tried using freetds. On some blog people are saying to use pdo_dblib.so extension but it's not working. Please guide me throug...
Reverso asked 6/10, 2016 at 7:21

6

Solved

I have setup FreeTDS to connect to SQL Server database. When I try to open TSQL in terminal on Mac (lion) I get this error: locale is "en_US.UTF-8" locale charset is "UTF-8" using default charset ...
Deceleron asked 7/8, 2011 at 14:28

3

I am trying to connect to MSSQL server from Ubuntu. I have installed freetds like suggested here. However, when I try to configure /etc/odbc.ini and enter a driver path I have no driver at locat...
Perrin asked 26/10, 2015 at 8:38

3

I am trying to run connect to a MSSQL server from an Ubuntu 12.04 webserver with FreeTDS and unixODBC. Using tsql i can connect to the server with ~$ tsql -S dbs3 -U <username> -P <passw...
Charland asked 14/8, 2013 at 12:57

1

Following online examples and the documentation for PDO I have this one line for creating a PDO object using persistent connections: $p = new PDO('dblib:host=SOMEHOSTNAME;dbname=SOMEDB',$user,$pas...
Casias asked 8/9, 2015 at 20:35

2

Solved

I am running Ubuntu 13.10 with FreeTDS and ODBC (package: php5-odbc) installed. I use tds version = 8.0, but also tried tds version = 7.2. I am using PDO and this is my DSN: $dsn = sprintf('odbc:...
Macrae asked 15/12, 2013 at 12:49

© 2022 - 2024 — McMap. All rights reserved.