I am trying to connect my php application with SQL server in my Linux box. I installed unixODBC successfully and made required changes in odbc.ini and odbcinst.ini file.
When I run command.<br><b>sqlcmd -S DSN -U USERNAME -P Password</b>
I am able to connect to sql server, but when I tried to connect with same DSN using isql (isql -v DSN USERNAME PASSWORD)<br> I am gating Data source name not found exception.
content of my odbc.ini file is
[SPSQLDEV]
Driver = ODBC Driver 11 for SQL SERVER
server = *.com,portno
Database = TEST
content of odbcinst.ini is
[SQL SERVER Native Client 11.0]
Driver = /opt/microsoft/sqlncli/lib64/libsqlncli-11.0.so.1790.0
Threading = 1
Output of command odbcinst -q -d is.
SQL Server Native Client 11.0
out put of command odbcinst -q -s is
SPSQLDEV