View previous topic :: View next topic |
Author |
Message |
leenu_n -
Joined: 02 Dec 2003 Posts: 1 Location: UK
|
Posted: Tue Dec 02, 2003 3:36 pm Post subject: Error 200 |
|
|
I am trying to access Northwind database in MSSQL. I have all the dlls in place . But i get this error 200 !!!
This is the code
$s = @mssql_connect($myServer, ,)
if($s >0)
{
echo "cldnt connect";
}
$d = @mssql_select_db($myDB, $s)
btw I have NT authentication and i set it on in the php.ini |
|
Back to top |
|
|
topniz -
Joined: 11 Nov 2003 Posts: 35 Location: Metz-France
|
Posted: Tue Dec 02, 2003 5:14 pm Post subject: |
|
|
Even with ASP, we get often this error (i mean, the fact that authentification couldn't be well issued).
First of all, try to check if your php scripts can execute without problem before try to connect to the database (e.g. try this script at the root of your CGI directory:
<?php
phpinfo();
?>
)
If it shows you the phpinfo page, look in it for mssql support (you should find that mssql is loaded as an extension to php).
If all that stuff is OK, look forward for help about trusted connection for SQL Server (look in Building SQL Server Applications help). In fact, the trusted connection is required if you use NT authentification (only for MS SQL : shitting, isn't it?).
What, i often do and ask the others to care about, is to use mixed authentification. I create a DB user with the appropriate access rights to database. I set its password and i include authentification data in my connection string (your $myserver). _________________ ToPniz
"Don't ask what the community could do for you but ask what you could do for the community" |
|
Back to top |
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
|