Perhaps this is a question for the Configurations forum, but I as it tangentially involves ASP.NET I thought I would start here.
My company has contracted a vendor to build website that we could host on our own servers which would, among other things, display a catalog of our products. As the site would NOT be a shopping cart , but perhaps still in an oversimplification of what we needed, it was agreed that it would be built using WP and THEN work in conjunction with our IS/IT dept to couple the WP with our own inventory DB.
We had several meetings with the vendor and our IS/IT dept prior to the contract being signed and work starting on the site. However it appears no server maintenance people within the IS/IT dept were brought to the meeting.
As expected the vendor wanted development space in our servers, which originally seemed like a simple idea. On last Friday a bombshell was dropped, essentially the following: our company servers/pages use ASP.NET and SQL, not PHP ( this I knew, or had an inkling to) and as such they could not set up the dev space for our vendor.
Here are my questions in a nut shell, knowing that PHP and .NET are two different animals.
1) WHY CAN'T the SAME server run PHP and .NET? The sever maintenance made it seem as if this was an near impossibility.
2) Assuming that the answer to #1 is PHP can be installed simultaneously with .NET why can't there be a WP installation as well ( assume for the sake of simplicity that this installation runs off it's own MYSQL DB.. etc. Essentially an independent site, hosted in the same server , concurrently with the .NET apps, but separate.
3) Are not MYSQL and SQL so SIMILAR that, barring transactions, the two installations could have basic communication?
4) SO in theory, would it not be possible to build a 'bridge' , instantaneous or not, between the DBs of the two installations?
I understand the task might not be the optimal and most graceful solution, but the question is is it still reasonably possible. All suggestion welcome. Thanks in advance!