473,385 Members | 1,769 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

MSSQL_connect problem

Ciary
247 Expert 100+
hi all,

i've encountered a new problem. i was trying to connect to a ms sql server (9.0) to connect i use this:
Expand|Select|Wrap|Line Numbers
  1. mssql_connect("***.***.***.***","User","userpw");
and i got this error:
-------------------------------------------------------------------------------------------------------------------------
Warning: mssql_connect() [function.mssql-connect]: Unable to connect to server: ***.***.***.***
-------------------------------------------------------------------------------------------------------------------------

so i thought: "server is down", and i tried connecting with sql management studio. this worked. so now im search why php tells me it can't connect.

also, i tried adding the port (which i think is standard 1433) to the IP address without any luck.

can anyone help me with this matter?
Apr 29 '09 #1
3 2122
Markus
6,050 Expert 4TB
Maybe mssql_get_last_message() will hold the error.
Apr 29 '09 #2
Dormilich
8,658 Expert Mod 8TB
if you're using PDO, the thrown PDOException might hold additional info.
Apr 29 '09 #3
Ciary
247 Expert 100+
well, i found the source of my problem. it was an invalid dll.

tnx anyway guys
Apr 29 '09 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: Håvard Olerud Eriksen | last post by:
I'm trying to connect to MSSQL server 2000 using IIS 6.0. The only way I've been able to connect, however, is by disabling anonymous access and setting mssql.secure_connection = On. If I try to...
0
by: Jochen Daum | last post by:
Hi, I'd like to use a DNS entry for the server name in mssql_connect. The documentation on php.net says, I have to specify the server name in the interfaces file (I assume...
4
by: Biffo | last post by:
I have PHP Version 5.0.3 installed on Windows XP Pro with IIS as the webserver. All is working well, except I get a - Fatal error: Call to undefined function mssql_connect() in...
2
by: David Haynes | last post by:
I can't seem to get the magic to work to connect to SQL Server via mssql_connect(). I can get odbc_connect to work just fine, but not mssql_connect. Could someone please post an example of how the...
6
by: spamguy21 | last post by:
I have a server with Windows 2000, PHP 5, IIS and SQL Server 2000 running. Individually, each works great. When trying to bring PHP and MSSQL together, though, I'm tearing my hair out...it just...
13
by: printline | last post by:
Hello I have problems connecting to my MSSQL through php. I have a microsoft windows server 2003, web edition with php5 installed and Microsoft SQL Server: SQL Server 2005 Express Edition as my...
4
by: aryan2cool | last post by:
hii all i am using php 5 and a warning has occured in my application " Warning: mssql_connect() : message: Login failed for user 'PAYDATA'. (severity 14) in C:\WINNT\Temp\tmpqjqokj.php on...
1
by: shlomisderot | last post by:
Hi all, I'm trying to connect to MSSQL by using PHP but I got the following error: Warning: mssql_connect() : Unable to connect to server: When I'm using ODBC to connect MSSQL with the same...
2
by: mirali00 | last post by:
Hello, This is a strange one! I'm getting blank results for mssql_connect. I created a simple testmssql.php page with the following code: <?php if (function_exists('mssql_connect')) {...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.