Re: connecting to a mssql database
- From: Jerry Stuckle <jstucklex@xxxxxxxxxxxxx>
- Date: Wed, 30 Aug 2006 13:35:18 -0400
Kim André Akerø wrote:
Advo wrote:
Im having major problems trying to connect to a mssql database thats
hosted on our server.
I've got the ip, username, password and database name, yet no matter
what i try, I cant seem to connect. I've trawled the net for hours
looking for code, has anyone got any that definately works, or just a
simple way I can check the connection.
I don't know how you've tried it, but you should be doing something
like this in your code:
mysql_connect($ip, $username, $password);
mysql_select_db($database);
You should also be doing this on the server, and not directly from
home. Security settings on the database server will only allow
connections from a certain IP (or IP range).
Except he's using MS SQL Server, not MySQL. But the statements are the same - just substitute 'mssql' for 'mysql'.
It's hard to say without knowing what error messages you get. Did you check the user notes for mssql_connect at http://www.php.net/manual/en/function.mssql-connect.php? They contain some good information.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@xxxxxxxxxxxxx
==================
.
- References:
- connecting to a mssql database
- From: Advo
- Re: connecting to a mssql database
- From: Kim André Akerø
- connecting to a mssql database
- Prev by Date: Re: What editor is the most common in PHP developer?
- Next by Date: Re: Serving a website based on source internet address ?
- Previous by thread: Re: connecting to a mssql database
- Next by thread: Re: connecting to a mssql database
- Index(es):
Relevant Pages
|
