Ted, I tried using
SELECT * FROM studies.studies And now SELECT * FROM studies..studies But it gives the error: 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 9 That's even without the "USE studies;" line ever being executed... See anything else that might be wrong? Matthew -----Original Message----- From: Ted Thibodeau Jr [mailto:[email protected]] Sent: Thursday, August 05, 2010 11:16 AM To: Matthew Tedder Cc: [email protected] Subject: Re: [Virtuoso-users] Non-PDO Failed Query Attempt Hi, Matthew -- On Aug 5, 2010, at 11:10 AM, Matthew Tedder wrote: > Here's my PHP code: > > > <?php > > $dbc = odbc_connect('virtuoso','dba','dba'); > if(!$dbc) { exit("Failed!"); } > > odbc_exec($dbc,"USE studies;"); This suggests that you have create a catalog, studies.. (parallel to the default catalog, DB..). > $sql = "SELECT * FROM studies;"; > $rs=odbc_exec($dbc,$sql); Because of your USE statement above, this is implicitly -- SELECT * FROM studies..studies -- which may clarify the errors which follow. > 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 Hopefully that helps? Ted -- A: Yes. http://www.guckes.net/faq/attribution.html | Q: Are you sure? | | A: Because it reverses the logical flow of conversation. | | | Q: Why is top posting frowned upon? Ted Thibodeau, Jr. // voice +1-781-273-0900 x32 Evangelism & Support // mailto:[email protected] // http://twitter.com/TallTed OpenLink Software, Inc. // http://www.openlinksw.com/ 10 Burlington Mall Road, Suite 265, Burlington MA 01803 http://www.openlinksw.com/weblogs/uda/ OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/ http://www.openlinksw.com/blog/~kidehen/ Universal Data Access and Virtual Database Technology Providers
