phpBB.de - Die deutsche phpBB-Community
https://www.phpbb.de/community/
Wenn PHP korrekt auf dem IIS installiert ist (also als ISAPI, nicht als CGI) und Du von PHP aus auf dem SQL Server connecten kannst, liegt es wohl an phpBB. Soweit ich gesehen habe, läuft phpBB mit SQL Server 2000 nur über ODBC...Datenbanktyp: SQL Server 7
oderTo connect named instance, you have to specify the port number for name instance.
This document help you find the instance port number.
HOWTO: Connect to a SQL Server 2000 Named Instance with JDBC
( http://support.microsoft.com/default.as ... us;Q313225 )
To find the SQL Server instance port number, follow these steps: ...blahblahblah...
oder>> Problems With Multiple Instances <<
If you are having problems to connect PHP 4.x to MSSQL 2000 on Win2K, there is a simple way to solve it:
Open the Client Network Utility and do the following:
1. Add a new Alias choosing Named Pipes
2. Type in the ‘Alias’ field (anything you want): CONN1
3. Erase ‘Server field’ and type exactly: SERVER_NAME\INSTANCE_NAME
The field ‘Pipe Name’ should be: \\SERVER_NAME\pipe\MSSQL$INSTANCE_NAME\sql\query
Now, in PHP, use:
mssql_connect('CONN1', 'username', 'password');
or
mssql_pconnect('CONN1', 'username', 'password');
Regards
Guilherme Cruz
Einer der Wege sollte vermutlich funktinonieren. Der letzte erscheint mir dabei der elegantesteProblems using mssql_connect with MSSQL 2000.
You have to:
1 - have installed MSSQL 2000 Client on the server that run PHP. This allows to use the libraries of MSSQL.
2 - when you use mssql_connect the parameter SERVERNAME has to be SERVERNAME\INSTANCE.
Ej: mssql_connect("MYSERVER\\MYINSTANCE","USER","PASWWORD")
NOTE the use of \\ intead of \, because this is escape caracter. This is very important!!
If you dont have configured instances on your server use as instance the name of the server.
Ej: mssql_connect("MYSERVER\\MYSERVER","USER","PASWWORD")
! Ich hoffe mal schon 
!!