Please help!!!!
I am trying to get PHP to connect to MS Access db on a win2000 server, but
only getting following errors:
Warning: SQL error: , SQL state 00000 in SQLConnect in
d:\websites\~nit\hello.php on line 7
Warning: Supplied argument is not a valid ODBC-Link resource in
d:\websites\~nit\hello.php on line 9
Warning: Supplied argument is not a valid ODBC result resource in
d:\websites\~nit\hello.php on line 12
Warning: Supplied argument is not a valid ODBC result resource in
d:\websites\~nit\hello.php on line 14
Warning: Supplied argument is not a valid ODBC-Link resource in
d:\websites\~nit\hello.php on line 25
I have set up this database in odbc datasources in windows (Both UserDSN and
SystemDSN) and am able to access it perfectly using JSP, but will not work
with PHP.
This is the PHP code I'm using:
<html>
<body>
<p align="center">
<?PHP
$Link = odbc_connect("Test", "Admin", "xxxxx");
$Result = odbc_exec ($Link, "SELECT * FROM test");
print(odbc_result($Result,1) . "<br>");
while (odbc_fetch_row($Result) != 0){
print(odbc_result($Result,1) . "<br>");
}
odbc_close($Link);
?>
</p>
</body>
</html>
The strange thing is that I have actually got all this working perfectly
using apache, PHP on a win98 machine.
I'm only new to PHP so any assistance or suggestions would be greatfully
accepted.
Thanks
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
