note 89328 added to function.mssql-connect
| From: | jonatasvenancio at gmail dot com | Date: | Tue, 03 Mar 2009 19:07:24 +0000 |
| Subject: | note 89328 added to function.mssql-connect | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-151409@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
----
Server IP: 200.185.109.13
Probable Submitter: 189.74.157.34
----
Manual Page -- http://www.php.net/manual/en/function.mssql-connect.php
Edit -- https://master.php.net/note/edit/89328
Del: integrated -- https://master.php.net/note/delete/89328/integrated
Del: useless -- https://master.php.net/note/delete/89328/useless
Del: bad code -- https://master.php.net/note/delete/89328/bad+code
Del: spam -- https://master.php.net/note/delete/89328/spam
Del: non-english -- https://master.php.net/note/delete/89328/non-english
Del: in docs -- https://master.php.net/note/delete/89328/in+docs
Del: other reasons-- https://master.php.net/note/delete/89328
Reject -- https://master.php.net/note/reject/89328
Search -- https://master.php.net/manage/user-notes.php