ODBC driver is un-selectable

Ondra, Mon Aug 02 2021, 12:20AM

Trying to connect and existing mssql database. The SQL native client shows up in the drop down list, but selecting it does nothing. It does not appear in the edit box as the selected Item. 

Note there is only one Item in the drop down. "SQL server native client 11.0" 

Re: ODBC driver is un-selectable
administrator, Mon Aug 02 2021, 07:37AM

Can you try to connect using ADO? We use the ADO connection as can be found here:
https://www.phspeed.com/docs/doku.php?id=setupsqlserver
Re: ODBC driver is un-selectable
Ondra, Mon Aug 02 2021, 03:14PM

Yes, I did follow the instructions as linked here. The issue is that the driver is in the drop down but when I click it nothing happens. The selection is not accepted.

Re: ODBC driver is un-selectable
bkafecadm, Tue Aug 03 2021, 04:38PM

Hello Ondra, have you enable it in the enabled pdo drivers from phspeed?, in the other hand, verify your odbc driver instalation and configuration, the driver will appear in the database connection manager once the odbc configuration has been done.
Re: ODBC driver is un-selectable
Ondra, Tue Aug 03 2021, 08:09PM

Working, thanks.