Key features:
- Total Pages Views and Load times
- Top Pages Viewed and Load Times
- Real Time Site Page Build Performance
- Users’ Browser and Platform Performance
- Geographic User Breakdown
- And more
COURSE of the MONTH
12 days, left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Need help, go daddy host can't connect to MS SQL DB with php
Posted on 2009-05-11
I am very frustrated right now with go daddy and their services. I spent last week upgrading to IIS 7 and removing and restoring databases, so that I can use ms sql extensions in php.
I'm trying to create a very simple script that merely connects to the database server that I have, but all I'm getting is it saying that it can't connect to the server.
I know this information is correct because it's the same information that I use for a .NET connection string and it works just fine.
Does anyone have any suggestions? I'm desperate.
I'm trying to create a very simple script that merely connects to the database server that I have, but all I'm getting is it saying that it can't connect to the server.
I know this information is correct because it's the same information that I use for a .NET connection string and it works just fine.
Does anyone have any suggestions? I'm desperate.
<?php
// Server in the this format: <computer>\<instance name> or
// <server>,<port> when using a non default port number
error_reporting(E_ALL);
if (!function_exists('mssql_connect')) {
echo 'mssql_connect not exist';
exit;
}
$server = 'ggcircuit.db.3438312.hostedresource.com';
$link = mssql_connect($server, 'ggcircuit', 'xxxxxx');
if(!$link)
{
die('Something went wrong while connecting to MSSQL');
} else {
echo 'aaaaaaaaaa';
}
?>
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2-
2
- +1
6 Comments
can you try by using OLE DB, just to check?
http://www.builderau.com.au/program/mysql/soa/Access-Microsoft-SQL-Server-2000-using-PHP/0,339028784,320283164,00.htm
http://www.builderau.com.au/program/mysql/soa/Access-Microsoft-SQL-Server-2000-using-PHP/0,339028784,320283164,00.htm
well in that case, all I can guess is, either you are providing wrong credentials or you don't have proper permission to connect to database, as long as syntax and method concern, it is perfact, there is no problem in it. Only GoDaddy people can help you.
i'm using godaddy now, but my service is Linux server
godaddy provide quick install service godday connect, maybe you can try this
http://hostingmetropolis.com/Home.aspx
http://hostingmetropolis.com/Application/WordPress.aspx
if the application is work fine, you can reference they connection code
otherwise the problem in godday
godaddy provide quick install service godday connect, maybe you can try this
http://hostingmetropolis.com/Home.aspx
http://hostingmetropolis.com/Application/WordPress.aspx
if the application is work fine, you can reference they connection code
otherwise the problem in godday
Ok I hate GoDaddy for this cause they have a zillion links on every page and it's hard to explain to someone where to click. But here goes.
Signin to GoDaddy.
Click 'hosting' lefthand menu area
Click 'manage' for the domain of the database
Under Action column click the pencil 'Edit / View'
Then click the 'Configuration' button.
This will display your php connect code. You have to correct the password.
(your server string looks a little odd, not that it's not correct, but this will verify)
Signin to GoDaddy.
Click 'hosting' lefthand menu area
Click 'manage' for the domain of the database
Under Action column click the pencil 'Edit / View'
Then click the 'Configuration' button.
This will display your php connect code. You have to correct the password.
(your server string looks a little odd, not that it's not correct, but this will verify)
Featured Post
WordPress is a very popular option for running your web site and can be used to get your content online quickly for the world to see. This guide will walk you through installing the WordPress server software and the initial setup process.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Many old projects have bad code, but the budget doesn't exist to rewrite the codebase. You can update this code to be safer by introducing contemporary input validation, sanitation, and safer database queries.
This article is in regards to the Cisco QSFP-4SFP10G-CU1M cables, which are designed to uplink/downlink 40GB ports to 10GB SFP ports. I recently experienced this and found very little configuration documentation on how these are supposed to be confi…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg).
If you're interested in additional methods for monitoring bandwidt…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses
Course of the Month12 days, left to enroll
752 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.