What is the error in php?

In this php program:

// connect to DSN MSSQL with a user and password
$connect = odbc_connect("DSNNAME", "miki", "84139") or die ("couldn't connect");
odbc_exec($connect, "use SwitchCenterDB");
$result = odbc_exec($connect, 'show tables');
?>[Mon Mar 03 11:49:59 2008] [error] [client] PHP Warning: odbc_exec() [function.odbc-exec]: SQL error: [unixODBC][FreeTDS][SQL Server]Could not find stored procedure 'show'., SQL state 37000 in SQLExecDirect in /srv/www/htdocs/hu/Proj1/ttc.php on line ...

there is an error:

The error

AaronHorne's picture

$result = odbc_exec($connect, 'show tables');

This is where the error is. I don't think 'show tables' is a valid parameter here.

Geek Guide
The DevOps Toolbox

Tools and Technologies for Scale and Reliability
by Linux Journal Editor Bill Childers

Get your free copy today

Sponsored by IBM

8 Signs You're Beyond Cron

Scheduling Crontabs With an Enterprise Scheduler
On Demand
Moderated by Linux Journal Contributor Mike Diehl

Sign up and watch now

Sponsored by Skybot