New to PHP..A Question

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
Hornet1958
Forum Newbie
Posts: 4
Joined: Wed Jun 02, 2004 1:41 pm

New to PHP..A Question

Post by Hornet1958 »

Does PHP work with Microsoft windows SQL
User avatar
PrObLeM
Forum Contributor
Posts: 418
Joined: Sun Mar 07, 2004 2:30 pm
Location: Mesa, AZ
Contact:

Post by PrObLeM »

Hornet1958
Forum Newbie
Posts: 4
Joined: Wed Jun 02, 2004 1:41 pm

Post 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
User avatar
PrObLeM
Forum Contributor
Posts: 418
Joined: Sun Mar 07, 2004 2:30 pm
Location: Mesa, AZ
Contact:

Post by PrObLeM »

what are you trying to install? because it may not be coded for ms sql but rather mysql....
User avatar
andre_c
Forum Contributor
Posts: 412
Joined: Sun Feb 29, 2004 6:49 pm
Location: Salt Lake City, Utah

Post 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.
Hornet1958
Forum Newbie
Posts: 4
Joined: Wed Jun 02, 2004 1:41 pm

Post 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
User avatar
andre_c
Forum Contributor
Posts: 412
Joined: Sun Feb 29, 2004 6:49 pm
Location: Salt Lake City, Utah

Post 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.
User avatar
PrObLeM
Forum Contributor
Posts: 418
Joined: Sun Mar 07, 2004 2:30 pm
Location: Mesa, AZ
Contact:

Post by PrObLeM »

yea as you can see here if you click the link "Can't connect to MySQL server on 'localhost' (10061)"
Hornet1958
Forum Newbie
Posts: 4
Joined: Wed Jun 02, 2004 1:41 pm

Post 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
User avatar
JAM
DevNet Resident
Posts: 2101
Joined: Fri Aug 08, 2003 6:53 pm
Location: Sweden
Contact:

Post 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.
Post Reply