Question mssql connect

[Noam Harel]

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:

could you please guide me how to make this work?

Noam

 

[AYamshanov]

Hi, I see you create your question in 'Plesk Onyx for Linux' section. Do you try to connect to MSSQL from Plesk for Linux?

Based on Software Requirements for Plesk, this configuration is not supported.

 

[Noam Harel]

Hi, I see you create your question in 'Plesk Onyx for Linux' section. Do you try to connect to MSSQL from Plesk for Linux?

Based on Software Requirements for Plesk, this configuration is not supported.

yes of course... i add a picture...

 

[Noam Harel]

Hi, I see you create your question in 'Plesk Onyx for Linux' section. Do you try to connect to MSSQL from Plesk for Linux?

Based on Software Requirements for Plesk, this configuration is not supported.

maybe you didn't understand, we are trying to connect from linux with plesk to an mssql server which is on a windows server

 

[AYamshanov]

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.

 

[Noam Harel]

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