I’m trying to run my Yii app on a Live 3rd party server. The issue I have is that I’m using MSSQL on a completely different server. Currently I’m getting the error “CDbConnection failed to open the DB connection: could not find driver”. The MSSQL database is using Windows Plesk (also 3rd party), the website is using Linux.
My Questions are
What are the missing drivers?
Where (Server/Folder) and How do I install them (if necessary)?
By the error message "Could not find server" I would say that the problem is in the connection settings or the database server setup… not in the missing drivers…
But if you think some drivers are missing… check the Yii requirements - http://www.yiiframework.com/doc/guide/1.1/en/quickstart.installation#requirements
I think that might be true, I can’t seem to figure out how to write the connection String in a different server
This is what I attempted, if you can have a look
'connectionString' => 'sqlsrv:server=www.example.com ;database=something;',
The server section is what confuses me, because the DB is on a different server I’m not sure how to get connected.
Instead of the domain try with the IP address of the server, also check if you can connect to that server with some management tool to see if the server is configured right for remote connection.
I can’t seem to connect with anything, I emailed my provider so I’m just waiting. Everything passed on the requirements test except for the following
Are they required?
Only if you want to use them… i.e. if you don’t use postgres then you don’t need the extension for it… same for the other two.
I’m able to connect to my DB via Microsoft Data Link .udl, however my problem still persists. I tried using the IP address but the error is still the same.
I realised I didn’t have PDO sqlsrv installed on my server using phpinfo(). My host was nice enough to install the driver and all is well.