Page 1 of 1

New to PHP..A Question

Posted: Wed Jun 02, 2004 1:41 pm
by Hornet1958
Does PHP work with Microsoft windows SQL

Posted: Wed Jun 02, 2004 1:49 pm
by PrObLeM

Posted: Wed Jun 02, 2004 3:31 pm
by Hornet1958
Thanks for the reply PrObLeM:: But r u sure!!..Its just that I made inquiry to my host about this and they emailed me with::::

Dear Andrew,

You do have PHP as an option that can be activated for your Windows Hosting plan via Site Control.

You do not have MYSQL as this is only available for LINUX customers. However you have Microsoft Windows SQL Server Database: dfakstats

The product you are trying to install appears to expect the UNIX/Linux operating system. Please check the documentation to see if it also support Microsoft SQL.

Regards,

Naeem


Hornet1958

Posted: Wed Jun 02, 2004 3:41 pm
by PrObLeM
what are you trying to install? because it may not be coded for ms sql but rather mysql....

Posted: Wed Jun 02, 2004 3:44 pm
by andre_c
It sounds like you're trying to install a script that uses a database, PHP does support SQL Server but you need to change the script in order to do that.

Posted: Wed Jun 02, 2004 4:33 pm
by Hornet1958
I am trying to hold a stats page for a game called BHDTS and I am trying to install babs stats chronos from http://www.ai-hq.com/babstats/dloads.ph ... %20Chronos it files are in PHP format I have read all documents that come with this program and have been to their forums for help..no such luck.

In the config file I have to change a few settings for my Database and localhost (what is localhost??): ie::

// Database settings
$dbhost = "localhost"; // Database host
$dbname = "dfakstats"; // Database name
$dbusername = "deltaforceak"; // Database user name
$dbuserpw = "xxxxxxxxxx"; // Database password

$tablepre = "chronos"; // Table prefix. Change this if you want to have several
// installations of stats on the same database. Do not edit
// after stats were installed!

$admin_name = "xxxxxxxxxx"; // Admin username
$admin_pass = "xxxxxxxxxx"; // Admin password

$website_title = "BAB.stats Chronos"; // Website title
$charset = "windows-1252"; // Character encoding (windows-1252 for english)

Then save and upload all files that come with the babs stats to a folder called Chronos.

When i have uploaded all files to my webpage I proceed to continue install the install PHP via the internet explorer

http://www.deltaforceak.com/chronos/install.php

and I get this error:

"Can't connect to MySQL server on 'localhost' (10061)"

Yes I do have a database and PhP, but not MYSQL just SQL alldone by the host I have signed up with.

Like to thank everyone for trying to help me sort this out. Thankyou

Hornet1958

Posted: Wed Jun 02, 2004 4:55 pm
by andre_c
That script is made to use MySQL. To be able to use SQL Server with it will most likely take a lot of changes to the script.

Posted: Wed Jun 02, 2004 5:03 pm
by PrObLeM
yea as you can see here if you click the link "Can't connect to MySQL server on 'localhost' (10061)"

Posted: Wed Jun 02, 2004 7:45 pm
by Hornet1958
OK guys thankyou very much for help and info.

Think I will get my host to switch from windows to linux.....

thankyou all

hornet1958

Posted: Thu Jun 03, 2004 9:59 am
by JAM
Hornet1958 wrote:Thanks for the reply PrObLeM:: But r u sure!!..Its just that I made inquiry to my host about this and they emailed me with::::

Dear Andrew,

You do have PHP as an option that can be activated for your Windows Hosting plan via Site Control.

You do not have MYSQL as this is only available for LINUX customers. However you have Microsoft Windows SQL Server Database: dfakstats

The product you are trying to install appears to expect the UNIX/Linux operating system. Please check the documentation to see if it also support Microsoft SQL.

Regards,

Naeem


Hornet1958
Just note, that it's often the webhost(er) themselves that makes this possible or not. I know host that for example have 3 various of accounts:
1. Linux as os and MySQL as databse, PHP as programming lang..
2. Windows as os and MSSql as database, ASP as programming lang..
3. Linux as os and MSSql, Oracle (!) and MySQL as database(s) as well as either ASP, PHP as programming languages and much more (Frontpage supprt etc.).

It's all about how much time they want to put into it, and at what rate they want their standards to end.