Question mssql connect

Noam Harel

Regular Pleskian
Hi

we are trying to connect to MSSQL from our plesk server, but when we run the page we get this error:
mod_fcgid: stderr: PHP Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in <file name>

we have installed: mssql-tools and unixODBC-devel but still things don't work out.

inside our PHP settings we have:
shmaya-plesk.png

could you please guide me how to make this work?

Noam
 
Ok, I got it, you try to connect to MSSQL directly from PHP (not from Plesk).

"Data source name not found, and no default driver specified"
- In a 64 bit windows server operating system, there are two ODBC managers (32 bit is C:\Windows\SysWOW64\odbcad32.exe).


I suggest checking which ODBC used by PHP, but I'm not sure.
 
Ok, I got it, you try to connect to MSSQL directly from PHP (not from Plesk).


- In a 64 bit windows server operating system, there are two ODBC managers (32 bit is C:\Windows\SysWOW64\odbcad32.exe).


I suggest checking which ODBC used by PHP, but I'm not sure.

thanks for your reply, i think this can't be the correct answer, since the problem is in the Linux side. connection has not being established yet at this stage
 
Back
Top