|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
|
|||
|
|||
OK, I'm sorry about this, but I'm just getting confused...I am trying to connect PHP to MSSQL, but I don't know where to setup (find) the MSSQL server name, username and password that is needed by the function mssql_connect(). Is there a manual/tutorial that tells me how to do this (complete with the MSSQL Server 2000 setup for connectivity with PHP/Other programming languages)? Thanks
__________________
JP Last edited by jaypeesol : May 26th, 2004 at 05:27 PM. |
|
#2
|
||||
|
||||
|
for all the mssql functions:
http://us4.php.net/mssql for the mssql_connect: http://us4.php.net/manual/en/function.mssql-connect.php |
|
#3
|
|||
|
|||
|
Quote:
Yes, I know that functions (thanks anyways). But I am looking for where to find the server name, username and password that I will pass into the msssql_connect function. In mysql, it was simply hostname (localhost), and the username and password are found in the my.ini file.Is there a file in MSSQL SERVER 2000 where I can find/set-up these values (servername, username, function)? Should I create a "connection"? Maybe there is a tutorial that tells me how a programming language can connect to MSSQL? My only experience with MSSQL was with SERVER 7 and VB6, that's it. I was developing webbies w/ PHP/MySQL before I was asked to do PHP/MSSQL. Thanks for every help that you can give me! ![]() |
|
#4
|
|||
|
|||
|
I fixed it now! Whew....
1. I right clicked the Server, then selected Properties... 2. I clicked on the Security tab 3. In Authentication, I clicked SQL Server and Windows. That's it! What I have going is $ServerName = ""; $dbuser = "sa"; $dbpass = ""; and it's connecting, and displaying data. Hope this all work well! ![]() |
|
#5
|
||||
|
||||
|
I would highly recommend not using a blank password for the sa account.....
|
|
#6
|
|||
|
|||
|
Quote:
OK. But I only used 'sa' for testing purposes... Thanks anyways. |
|
#7
|
||||
|
||||
|
I seem to have the same problem as you jaypeesol: I can't connect to MSSQL from php.
Don't know what to do next, tried everything. Where do you set-up users in MSSQL ? Can these users then be used to make a connectoin using php ????????
__________________
:P
|
![]() |
| Viewing: Dev Shed Forums > Databases > MS SQL Development > How to setup PHP to connect to MSSQL SERVER 2000 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|