MS SQL instead of MySQL?

[umar]

Hi,
I'm new here and don't know very much about all this technical stuff.
I've followed the instructions for installation, and have set up everything in pixelpost.php correctly (I think).

When I go to my website, http://www.umarshahzad.com/admin/install.php, I get the following error:

Error: Unknown MySQL Server Host 'vmssql02\i2' (11004)

"vmssql02/i2" is from the database host information I've received from my hosting service.

I'm just wondering if this could be due to the fact that my hosting service uses MS SQL instead of MySQL, or if there is another issue.

Thanks in advance.

[Connie]

normally hosters offer either both databases or only MySQL, I never saw a hoster who offers only MSQL, as MySQL is the most intregrated Database in the majority of PHP scripts which uses Databases

As we declare, PP demands MySQL - database, it is not written for MSQL

but I am quite sure that your problem is caused by wrong data in pixelpost.php for the database connect

I am very sure your hoster support can help you to find out which data is need to connect to your MySQL-Database:

$pixelpost_db_host = "change_this"; // database host, often "localhost"
$pixelpost_db_user = "change_this"; // database user
$pixelpost_db_pass = "change_this"; // database user password
$pixelpost_db_pixelpost = "change_this"; // database

if you still believe that there is no MySQL at your hoster, which I doubt, you can proof that, using the file phpinfo.php
upload that to your webspace and call it from a browser, search for the string "MYSQL"
I included a file phpinfo.php.txt, use this, but rename it to phpinfo.php before you upload it to your server

Delete this file from your server after using it!

If there is really no MySQL-database at hand, ask your hoster to install it for you. It is free and it is standard, so why not?

Good luck!

[GeoS]

There is no way without changing the code of PP to use MSSQL DB. Pixelpost uses mysql_* PHP's functions so it must be replaced and SQL statements also must be checked if there are compatabile?