SQL Server

NZ_Kiwis

http://webcheatsheet.com/php/connect_mssql_database.php
http://www.triconsole.com/php/php-com.php

I'm trying to connect to my SQL Server using "Connect without a DSN (using a connection string)"

The two above links work, where can I get more info on how to do searches and compare results etc. These are great basic examples but want more info

Weedpacket

Why do you want to use COM instead of the driver PHP provides for connecting to SQL Server ([man]pdo-sqlsrv[/man])?

As for how it's used, it's like the other interfaces to SQL databases:

Write SQL query.
Send to server
Get results
???
Profit!

Are you asking about resources for learning SQL? The specific dialect of SQL used by SQL Server is covered in its documentation?

("Connect without a DSN (using a connection string)" - of course, the connection string is a DSN....)

NZ_Kiwis

I can't install anything on my server :-(

OKay, so how do you do something like this using COM?

$query = "SELECT * FROM Users WHERE username = '$UserName'";
$result = odbc_exec($connection, $query) or die ("Error: ". odbc_error());
$rPassword = odbc_result($result, 3);
$Sine = odbc_result($result, 2);

Weedpacket

See (for example) the articles you linked to. Apply a bit of logical thought.

What precisely is the problem you're having?

NZ_Kiwis

AS my post said, i'm after more information, more functions etc. I thought there may have been a manual or something.

Weedpacket

For what? SQL Server? There is. ADO? There is. PHP? There is. Generally you can find manuals for software these days by going to the manufacturer's web site. That's assuming the software doesn't ship with a manual already which - for example - SQL Server does.