MS SQL Server Connection

[Anon]

how do I connect to MS SQL Server?

[codemake]

first check you php.ini
remove ';' before you want use mssql version

extension=php_mssql70.dll
[MSSQL]
;extension=php_mssql.dll
mssql.allow_persistent = On ; allow or prevent persistent link
mssql.max_persistent = -1 ; maximum number of persistent links. -1 means no limit
mssql.max_links = -1 ; maximum number of links (persistent+non persistent). -1 means no limit
mssql.min_error_severity = 10 ; minimum error severity to display
mssql.min_message_severity = 10 ; minimum message severity to display
mssql.compatability_mode = Off ; compatability mode with old versions of PHP 3.0.

second
$openid = mssql_connect("youserver name","name","password");
mssql_select_db("servername");

$SQL = "Select * From isostmp Where isosprj='$isosprj' And isosubjet ='$isosubjet' And ";
$SQL = $SQL . "isostitle = '$isostitle' ";

$result = mssql_query($SQL,$openid);

$sn_index = mssql_num_rows($result);

good luck

[Anon]

Dear sir,
Iam a beginner in PHP. I am facing a big problem that I couldnot able to establish a database connection with PHP. Database Iam using is MICROSOFT SQLSERVER 7.0 and the
ERROR is:
Fatel error: Call to undefined function: mssql_connect()

In my PHP.ini file following information regarding MSSQL are already there, which is given below:

[MSSQL]
mssql.allow_persistent = On ; allow or prevent persistent link
mssql.max_persistent = -1 ; maximum number of persistent links. -1 means no limit
mssql.max_links = -1 ; maximum number of links (persistent+non persistent). -1 means no limit
mssql.min_error_severity = 10 ; minimum error severity to display
mssql.min_message_severity = 10 ; minimum message severity to display
mssql.compatability_mode = Off ; compatability mode with old versions of PHP 3.0.
;mssql.textlimit = 4096 ; valid range 0 - 2147483647 default = 4096
;mssql.textsize = 4096 ; valid range 0 - 2147483647 default = 4096
;mssql.batchsize = 0 ; limits the number of records in each bach. 0 = all records in one batch.

---

The operating system Iam using is WINDOWS 2000 and WEBSERVER IS -IIS5.0.

When ever Iam using ODBC to connect to MICROSOFT ACCESS DATASOURCE Iam getting the following ERROR-
Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver
specified, SQL state IM002 in SQLConnect in D:\coldShim\access.php on line 2.

When I uncommented( remove the preceding 😉 ;extension=php_mssql70.dll in PHP.ini file, I got an WARNING when .php file loaded on the browser-
unable to load dynamic Library '/php-mssql70.dll'- The specified module could not be found.

                 So Sir please help me in this matter .Iam very keen to hear solution for my problems.

THANKING YOU,
Shimju David.