note 89328 modified in function.mssql-connect by danbrown
| From: | danbrown@php.net | Date: | Tue, 03 Mar 2009 19:12:16 +0000 |
| Subject: | note 89328 modified in function.mssql-connect by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-151411@lists.php.net to get a copy of this message | ||
Finally i did it.
I could make the connection with MS-SQL:
1 - I downloaded the new version of ntwdblib.dll like we already saw at the others posts.
2 - I actived the php_mssql.dll in php.ini (the DLL must be in your extension dir)
3 - Restarted apache.
4 - Got my MS-SQL name instance (in my case was SQLEXPRESS because i was using MS-SQL Express
Version and didn't change the default configuration).
5 - I did my connection file.
#################
<?php
$conn = mssql_connect("ADMIN-PC\SQLEXPRESS", "usuario", "senha") or
die ("erro ao conectar");
// Admin-PC is the name of my computer and SQLExpress is the name of MS-SQL Instance).
// usuario is a user that i created on SQL server with this command.
// SP_AddLogin 'user', 'password'
// after that i used this onde SP_AddUser 'user'
// you can change fot the user you want.
// I cound't use the defaullt user of MS-SQL, but with this one the connection worked.
?>
I hope this can help you.
Sorry for the english.
I'm brasilian.
Venâncio
--was--
Finally i did it.
I could make the connection with MS-SQL:
1 - I downloaded the new version of ntwdblib.dll like we already saw at the others posts.
2 - I actived the php_mssql.dll in php.ini (the DLL must be in your extension dir)
3 - Restarted apache.
4 - Got my MS-SQL name instance (in my case was SQLEXPRESS because i was using MS-SQL Express
Version and didn't change the default configuration).
5 - I did my connection file.
#################
<?php
$conn = mssql_connect("ADMIN-PC\SQLEXPRESS", "usuario", "senha") or
die ("erro ao conectar");
// Admin-PC is the name of my computer and SQLExpress is the name of MS-SQL Instance).
// usuario is a user that i created on SQL server with this command.
// SP_AddLogin 'user', 'password'
// after that i used this onde SP_AddUser 'user'
// you can change fot the user you want.
// I cound't use the defaullt user of MS-SQL, but with this one the connection worked.
?>
I hope this can help you.
Sorry for the english.
I'm brasilian.
Venâncio
http://php.net/manual/en/function.mssql-connect.php