Recent content by Janus Bahs Jacquet

Yeah, it’s not needed, but it sure would have been nice if it had been added nonetheless – I wouldn’t have needed to ask, then!

Thank you so much! In hindsight, I suppose it’s fairly obvious that it’s just a .bak file, but (1) I didn’t realise that .bak files are binary, and (2) with all the trouble extracting files within files, I was a bit lost. Restoring to a new database worked exactly as it should!

I have a remote Windows 2019 server running Plesk. Incremental backups are done daily and stored locally on the server; complete backups are done weekly and stored in a DigitalOcean space. Backups include database dumps of the SQL Server (Express) database. My own machine is a Mac, running...

I’m having the same issue, stuck in the same loop. It spawns an ever-increasing number of plesk installation processes as well (though killing one seems to kill them all), but never gets beyond telling me that the Plesk installer was updated. I have no files named plesk_installer*.exe in...

This ended up getting solved by the host’s support team. I’m not sure precisely what they did, but they removed ODBC Driver 13 (as the Plesk update was presumably, then, supposed to have done automatically) and reinstalled ODBC Driver 17 from scratch, and that fixed it.

Some further testing shows that I can connect to the SQL Server database using the old odbc_connect() and odbc_do() functions in PHP – the problem only seems to relate to PDO connections. So I guess that limits it to the pdo_sqlsrv driver? (Except that’s the one that wasn’t actually changed...

Here’s a better version of the screen shot – I hadn’t realised the resizing happened on the hosting site and not in the preview here (and for some reason I get an error message in Russian when I try to edit the post):

Since some time between Tuesday afternoon (7 May) and Wednesday morning (8 May), European time, all attempts to connect to our SQL Server database through PHP (specifically PDO) fail with the following error message: SQLSTATE[IM004]: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on...