We have an application that we have been testing with lighty+fastcgi and nginx+mongrel. Before we make a final decision on how we want to deploy it, we wanted to give LiteSpeed+LSAPI a try.
The only hiccup in our setup is we are forced to use SQL Server as our database. Our apps run on Linux so we use unixODBC and FreeTDS to connect to the database.
Our app has no problems connecting to the database with the lighty or nginx configurations. However, with LiteSpeed we always get the following error:
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
I have tried setting up LSAPI the easy way and the step by step way and in each case I end up with the same error.
The lighty and nginx installations automatically use our ODBC setup in /etc/odbc.ini. Our database.yml entry matches one of the DSNs in odbc.ini, like so:
production:
adapter: sqlserver
mode : odbc
dsn : TOPAZ
Is there anything I can do to get LiteSpeed to use /etc/odbci.ini or another way I can give LSAPI the DSN information?
The only hiccup in our setup is we are forced to use SQL Server as our database. Our apps run on Linux so we use unixODBC and FreeTDS to connect to the database.
Our app has no problems connecting to the database with the lighty or nginx configurations. However, with LiteSpeed we always get the following error:
[unixODBC][Driver Manager]Data source name not found, and no default driver specified
I have tried setting up LSAPI the easy way and the step by step way and in each case I end up with the same error.
The lighty and nginx installations automatically use our ODBC setup in /etc/odbc.ini. Our database.yml entry matches one of the DSNs in odbc.ini, like so:
production:
adapter: sqlserver
mode : odbc
dsn : TOPAZ
Is there anything I can do to get LiteSpeed to use /etc/odbci.ini or another way I can give LSAPI the DSN information?