Re: Getting ODBC openlink 37000 in odbc_do($conn,"$sql") butodbc_tables($conn) works? Help!

["Jennifer Goodie" <jengoodie@att.net>]

> But when I try
> 
> $sql="select * form tblJobStatus";
> $results = odbc_do($conn,$sql) or die("<p> captured ".odbc_errormsg());
> 
> I get 
> 
> Warning :  odbc_do(): SQL error: [OpenLink][ODBC][Driver]Syntax error or
> access, SQL state 37000 in SQLExecDirect in
> /Library/WebServer/Documents/tests/odbc.php on line 6

That is because you have a syntax error.  Try SELECT FROM not SELECT FORM.

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php