running web application in MSSQL on server with MySQL; 4CRM SQL & EMS MSSQL Manager Lite

• johnyjj2

  SSC Enthusiast

  Points: 147

  More actions

  August 11, 2009 at 4:02 am

  #99822

  Hello!

  I've got web application written in MSSQL and I need to run it on server. But on the server I've go MySQL (not MSSQL), PHP, KFWS.

  Do I have to install MSSQL and have both MySQL and MSSQL? Won't it make any problems?

  Can I use 4CRM SQL 5.1.4 or EMS MS SQL Manager Lite 1.8 to run my MSSQL web application? How to run it?

  (In the web application I've got two directories. One which I copied to htdocs on KFWS, the other with scripts. At the beginning of installing this application on server, I need to run script which craetes database. I couldn't do it in Command Prompt with mysql because there were some errors).

  Greetings!

• spaghettidba

  SSC Guru

  Points: 105732

  More actions

  August 11, 2009 at 6:09 am

  #1037341

  If the application was designed for MSSQL I don't think it will run on MySQL. It could, but I don't think it will.

  The same applies to the web server: if the code runs in IIS I don't think PHP is an option.

  I suggest you take a look at the documentation of your app and see what the prerequisites are.

  As far as I know, there's no problem installing MSSQL together with MySQL, but I don't think this is the main point.

  Regards

  Gianluca

  -- Gianluca Sartori