[ASK] Koneksi MSSQL dengan PHP

[SinggahDapur]

mohon bantuannya gan, ane udh nyari source code nya semua nya error.. gtau ane yg salah setting ato gmn mungkin ada yg bisa bantu?



koneksi mssql ada 2 cara, dengan ODBC ato tembak langsung koneksi CMIIW



Begini yg ane tau klo pake ODBC


Quote:





$server = "servername";

$user = "username";

$pass = "";

$db = "databse";



$conn = odbc_connect($server,$user,$pass);

$query = "select * from tableapa";

$result=odbc_exec($conn, $query);





tapi errornya begini


Quote:





Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\release\index.php on line 10



Warning: odbc_exec() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\release\index.php on line 12





Padahal pas setting ODBC udh ok semuanya dan test connection udh sukses.



Atau tembak koneksi langsung


Quote:





$server = "servername";

$user = "username";

$pass = "";

$db = "databse";



mssql_connect ($server, $user, $pass);

mssql_select_db($db);






klo tembak koneksi errornya bgini


Quote:





Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\release\index.php on line 7





$server itu diisi pake nama server waktu konek pake SQL server di komputer kan? (soalnya ane localhost)

$username itu pake nama komputer kita

$password yah password kompi



Trus ane cari katanya mesti donlod php_mssql.dll trus tambahin di folder xampp\php\ext udh ane lakuin gitu jga sama aja errornya gitu lagi



ADA YANG BISA BANTU ANE CARI SOLUSI?