unixodb connection with PHP fails

Question

I have installed freetds with unixODBC and when I test the connection with isql it works perfectly but when I try to make the connection with php I get an S1000 error.

my configuration details are I have a DSN in my freetds.conf

[MYDSN]
host = 192.168.30.233
port = 1433
tds version = 8.0
client charset = UTF-8

My odbc.ini file has

[MYDSN]
Driver = FreeTDS
Descrioption = conn unixodbc with FreeTDS
tds version = 8.0
Server = 192.168.30.233
Port = 1433
Database = mydb
client charset = UTF-8

my odbcinst file has

[FreeTDS]
Description = MSSQL Driver
Driver = /usr/lib64/libtdsodbc.so
UsageCount = 1

I used this tutorial to make the installation and I installed the drivers with odbcinst.

In order to connect with php I use the DSN connection and I tried with both odbc_connect and mssql_connect.

odbc_connect("MYDSN",$this->user,$this->password)

mssql_pconnect( "MYDSN",$this->user,$this->password)

i also tried with PDO with the following code

new \PDO ("dblib:host=MYDSN;dbname=mydb;",$this->user,$this->password);

With isql everything worked fine.

I am using Microsoft SQL Server 2008.

Does anyone know what may cause this problem . Thanks in advance

meda · Accepted Answer · 2013-08-14 21:06:57Z

1

This usually means that you are missing php odbc so install it

sudo apt-get install php5-odbc

answered Aug 14, 2013 at 21:06

meda

45.5k14 gold badges96 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

unixodb connection with PHP fails

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related