<?php
-
- /**
- * @author UUMiss
- * @copyright 2007
- * php使用mssql库,连接sql server数据库实例
- */
-
-
- $server='ip地址或服务器名';
- $username='数据库用户名';
- $password='数据库密码';
- $database='数据库名';
-
- $conn=mssql_connect($server,$username,$password)
- or die("Couldn't connect to SQL Server on $server");
- $db=mssql_select_db($database) or die("Couldn't open database $database");
-
- ?>
---------------------------------------------------------
-
- /**
- * @author UUMiss
- * @copyright 2007
- * php使用ODBC连接sql server数据库实例
- */
-
- $server='ip地址或服务器名';
- $username='数据库用户名';
- $password='数据库密码';
- $database='数据库名';
-
- $connstr = "Driver={SQL Server};Server=$server;Database=$database";
-
- if ( !odbc_connect($connstr,$username,$password,SQL_CUR_USE_ODBC)){
- echo "Couldn't connect to SQL Server on $server";
- }else{
- echo "Connect successfully!<br>";
- }
- ?>
评论