[Virtuoso-users] Non-PDO Failed Query Attempt

[Matthew Tedder]

Here's my PHP code:


<?php

$dbc = odbc_connect('virtuoso','dba','dba');
if(!$dbc) { exit("Failed!"); }

odbc_exec($dbc,"USE studies;");

$sql = "SELECT * FROM studies;";
$rs=odbc_exec($dbc,$sql);


And here's the errors:

Warning: odbc_exec(): SQL error: [unixODBC][OpenLink][Virtuoso iODBC
Driver][Virtuoso Server]SQ074: Line 1: syntax error, SQL state 37000 in
SQLExecDirect in /var/www/studies/test.php on line 6

Warning: odbc_exec(): SQL error: [unixODBC][OpenLink][Virtuoso iODBC
Driver][Virtuoso Server]SQ074: Line 1: No table studies in * reference at ';'
before ';', SQL state S0002 in SQLExecDirect in /var/www/studies/test.php on
line 9