Tech Support Forum - Web Serving and Management

GoDaddy PHP mssql_query problem

milledj — Sat, 21 Nov 2009 00:49:41 GMT

I am attempting to set up a simple query for my (hosted) GoDaddy database, and I am having trouble getting things to work. I have an example of a working PHP file (I am no expert here, far from it, I am an Oracle DBA), but when I attempted to adapt it to the GoDaddy environment, I am comming up on a brick wall.

If someone has a working example of a GoDaddy, MSSQL query PHP file that works, that would be great.
Otherwise, this is what I have working on another server environment, at home:
$myServer = "habisys.db.2276763.hostedresource.com";
$myUser = "habisys";
$myPass = "****";
$myDB = "habisys";
//connection to the database
$dbhandle = mssql_connect($myServer, $myUser, $myPass)
or die("Couldn't connect to SQL Server on $myServer");

//select a database to work with
$selected = mssql_select_db($myDB, $dbhandle)
or die("Couldn't open database $myDB");

$query = "SELECT [PIDM],[BU_Name],[Link] from [habisys].[dbo].[Sponsors]";
$query .= " order by [BU_Name] ";

$result = mssql_query($query);
//execute the SQL query and return records

/* fetching data and output as xml */
print "\n";
while( $Row = mssql_fetch_object( $result ) )
{
print "
... data here ...
\n";
}
print "";
?>
--- now, when I attempted to use it, I would get an error on the server connection. GoDaddy sent me this as proof that the connection is working:
$myServer = "habisys.db.2276763.hostedresource.com";
$myUser = "habisys";
$myPass = "*****";
$myDB = "habisys";

//create an instance of the ADO connection object
$conn = new COM ("ADODB.Connection")
or die("Cannot start ADO");

//execute the SQL query and return records
//define connection string, specify database driver
$connStr = "PROVIDER=SQLOLEDB;SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB;
$conn->open($connStr); //Open the connection to the database
echo "Connection Open";
$conn->Close();
$conn = null;
?>
However, if I add the mssql_query to this, I get another connection error on the query. Does the fact that the above example prints out Connection Open when the PHP file is run proof that the connection is indeed open?
If so, why won't my $query statement run?

TIA,

DJM

IIS default web site log information

rokosz — Thu, 19 Nov 2009 20:23:51 GMT

hello folks,

Running IIS6.0 on W2003 R2.

I've got a frustrating clientside activeX filescriptingobject login error.

In bing/google searches I've seen people who talk about enabling logging and they then can see more information about the stuff IIS is choking on.

I've looked at the IIS default web-site properties. Enable Logging is checked and creates a W3C extended log file format. When I look at that file I see nothing but hundreds of Posts and Gets with IP address. Interesting but nothing that shows a choke/error.

Am I looking in the wrong place? Can anyone tell me how I can gen a log that includes (good, useful info about) errors?

Since my current error (unknown user name or bad password) is under &activeX is there a different scenario for logging than using IIS?
It seems the server kicked out the login attempt so the server should be able to tell me what login was passed to it.

If you've interest in the fso error you can see my earlier post here at TSF from about 15 minutes ago.

thanks for any help, B

files won't appear on url

gingerrulz — Sun, 15 Nov 2009 14:51:45 GMT

I have to make a website for my class, and my teacher gave me the server name and all so I can upload files with FTP.

I uploaded the index.html, it shows on the FTP but once I go to the url, its blank.

I then tried index.php, and it showed on the url, but when i wanted another page, sections (html or php) that didn't show.

does anyone understand this? I don't know php and I dont understand why the index.php file worked but not the .html file. and the other files don't show up at all, it gives me an error message.

I know I should contact the host provider, but I don't know who it is. My teacher isn't answering my messages yet, and I'm afraid he won't know the problem either.

How do I set up a 2nd website with GoDaddy?

Rhondrew — Sat, 14 Nov 2009 00:38:34 GMT

I'm new at this, so forgive me if this is confusing; GoDaddy support didn't understand my question. I have a website up and running on GoDaddy. I would like to set up a second one and I've already purchased the domain name through GoDaddy. I have a deluxe hosting plan. How do I do this?

Database configuration

Ex-Para — Fri, 13 Nov 2009 16:34:14 GMT

I have got to Database configuration basic options in Drupal 5.2. in connection with a server in Ubuntu 8.04.
Database type, Database username and Database password where already entered and a radio button high lighted on mysql. I can't workout what I put in Datarbase name as it says The name of the datarbase your Drupal data will be stored in. It must exist on your server before Drupal can be installed.
I have looked in FAQ but that has confused me more. I have installed all the files for the server and this is the last thing I have to do. I would appreciate any help regarding this.

mail mail everywhere, and not a single sent

Stingray1969vet — Thu, 12 Nov 2009 21:21:28 GMT

Hey all,

I have been managing several domains for the past few years, but they have all been hosted elswhere, and I would update conent as well as users and databases.

I decided to try the whole ball of wax, including the hosting.

I have the server up and running, but cannot get the mailserver figured. It cannot send.

I have Ubuntu 9.10
apache2
postfix
started with courier IMAP but also have dovecot
ISP comcast ( i do have a static IP)

Let me know what other information you need, I am new to the linux world, so please bear with me. Thanks

--S

Help Needed with Web Server Setup

boogeyman67 — Wed, 11 Nov 2009 15:00:59 GMT

Hello everyone, I'd like to first thank you in advance for your kind assistance. What a great idea...

My name is Dex and I'm the owner of a Company 'The C:\Prompt>'.

http://www.thecprompt.com.

I'd like the ability to be able to invoke our vTiger application right from the webpage.. I suppose it's called the 'virtual host' within apache.

If there's anyone out there who would be willing to help, possibly rdp to our server to assist, we would be extremely grateful...

Thanks again...
D. Edwards
Owner,
The C:\Prompt>
www.thecprompt.com

How Do I Login In MySQL Query Browser?

Bob_Binky — Fri, 06 Nov 2009 11:32:57 GMT

I keep getting the Error Number 2003

Could not connect to the specified instance

MySQL Error Number 2003
Can't Connect to MySQL server on localhost (10061)

If you want to check the network connection, please click the Ping Button

Pinging localhost
Reply from 127.0.0.1: Time = 0ms TTL = 128
Reply from 127.0.0.1: Time = 0ms TTL = 128
Reply from 127.0.0.1: Time = 0ms TTL = 128

I user "localhost" as my Service host

I even tried setting the username as root

I disabled my Firewall and uninstalled my anti-viruses...

MySQL Server is running but shuts down due to inactivity from time to time I think...

Additional details I can give:

Im using ---
Vista Home Premium 32bit
MySQL 5.0
MySQL GUI TOOLS 5.0
MySQL Connector ODBC 5.1.5

PHP 5.3.0 setup

wheresmyres — Fri, 06 Nov 2009 05:01:13 GMT

OS: Windows Vista

I've installed Apache 2.2 and it's working just fine. I'm now attempting to install PHP 5.3.0 as I've done before, but it's not recognizing apache server. Why? When I get to "select the web server you wish to setup", I get the following options:

IIS FastCGI
Other CGI
Do not setup a web server

Any reason it doesn't show Apache? I did change the install directory for both apache and PHP so that they're under C:\{app name}, but I don't see where that would be a problem. Apache is running. If I select the last option, can I set it up manually?

Thanks. Hopefully not a stupid question.