odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

Question

I am getting error

odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect for Linux server

while executing following command to connect with sybase from PHP.

$db = ADONewConnection('odbc');

$DSN = 'UID=username;PWD=password;EngineName=dbServiceName;AutoStop=No;Integrated=No;Debug=No;DisableMultiRowFetch=No;CommLinks=SharedMemory,TCPIP{};Compress=No;Driver={Adaptive Server Anywhere 9.0}';


$db->Connect($DSN );

I have installed ODBC drivers with FreeTDS to connect Sybase database with PHP code with following commands

sudo apt-get install unixodbc
sudo apt-get install tdsodbc
sudo apt-get install freetds-bin tdsodbc

/etc/odbc.ini file

Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so
Setup = /usr/lib/x86_64-linux-gnu/odbc/libtdsS.so
Server = server_name
Port = port_number
Database = dbname
Username = dbusername
Password = dbpassword

freetds.conf file

[sybase]
    host=
    port=
    Tds version=

FlipperPA · Accepted Answer · 2016-09-30 20:18:11Z

0

If you're using FreeTDS, you need to specify the driver from odbcinst.ini, which is normally FreeTDS. Try:

$DSN = 'UID=username;PWD=password;EngineName=dbServiceName;AutoStop=No;Integrated=No;Debug=No;DisableMultiRowFetch=No;CommLinks=SharedMemory,TCPIP{};Compress=No;Driver={FreeTDS}';

answered Sep 30, 2016 at 20:18

FlipperPA

14.4k5 gold badges46 silver badges76 bronze badges

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

1 Comment

Ruta Over a year ago

Thanks a lot for suggestion. I have tried to connect database server using terminal and it is working fine but I am getting same error in php connection? I have tried in terminal "tsql -S SYBASE -U <username> -P <password>"

Collectives™ on Stack Overflow

odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related