mssql_connect question

[andyraah]

I have mysql ver 3.23 with PHP 4.2.3 and want to connect to a MS SQL 2008 database. Can this be done without downloading 2008 client tools from MS? Having a hard time here. Thanks, anyone!

[gurmeet]

give more detail

[andyraah]

When I do this:

$server="q:/directory/data,3306";
$con=mssql_connect($server,$username,$password) or die (NOPE);

I get this error:

Fatal error: Call to undefined function: mssql_connect() in c:\phpdev\www\worker.php on line 9

When I do this:

$server="q:/directory/data,3306";
$con=odbc_connect($server,$username,$password) or die (NOPE);

I get this error:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\phpdev\www\worker.php on line 9
NOPE

Any ideas??

[djr33]

Are you using MySQL or MSSQL? You wrote both in your first post, and that is important.