SQL Server Connection string

Arc

Anyone used SQL server with PHP? I need to know the COnnection string and the basic commands... But the connection string mainly thanks!😃

planetsim

Which Database SQL server doesnt mean anything..
Is a MySQL Database, MSSQL Database ODBC Database

mysql_connect("host","user","pass");
thats for mysql

mssql_connect();

i think is pretty much the same.

Arc

Err the Database is SQL Server... the Microsoft DB..Windows Based. IT has nothing to do with MYSQL or any of those..

mhoward

The connection string and other strings infact are very similar to MySQL...

$conn = mssql_connect($sql_server,$sql_user,$sql_pass); 
		if(!$conn)
		{
		mssql_error();
		}

mssql_select_db($sql_dbase) or die("Database table unavailable. Please contact the I.T Helpdesk on ext $ext or <a href=\"mailto:$email\">$email</a> with this error.");

Check out http://www.php.net/manual/en/function.mssql-connect.php

mhoward

But make sure you have the MS SQL extension loaded on your web server by enabling it in the PHP.INI and copying it to the directory with all your other .dll's in.

Arc

I see so it is MSSQL...In VB We just call it SQL Server.

I was just reading in this book it says the connection string is mssql_pconnect(servername,user,password)

You didnt add the "p". So which one is right?

Also this book doesnt say anything about closing the connection. Is it mssql_close($Connection) ?

Thanks!😃

Arc

anyone? beuler? Thanks!

barand

mssql_connect is fine. [man]mssql_pconnect[/man] gives a persistent connection, for which I have yet to find a use".

[man]mssql_close/man closes the connection, but not if persistent.

hth

Arc

OK thanks!.. This book i have isn't real clear on MSSQL stuff.