I am new to PHP. I am running win NT and PHP4 with IIS. PHP is running and a test page works.
I have tried the following connection to the DB which the ODBC is set up:
<?php
// create connection
$connection = odbc_connect("../0master/database/Master","","")
or die("Couldn't connect to datasource.");
// create SQL statement
$sql = "SELECT AdCatID, Category,
FROM adcategories
ORDER BY Category";
// prepare SQL statement
$sql_result = odbc_prepare($connection,$sql)
or die("Couldn't prepare query.");
// execute SQL statement and get results
odbc_execute($sql_result)
or die("Couldn't execute statement.");
// format result in HTML table
odbc_result_all($sql_result,"border=1");
// free resources and close connection
odbc_free_result($sql_result);
odbc_close($connection);
?>
The Error I get is in the Connection:
<br>
<b>Warning</b>: Failed opening 'C:\InetPub\wwwroot\0masterfile\classads\classadsPHP.php' for inclusion (include_path='') in <b>Unknown</b> on line <b>0</b><br>
