So the PHP odbc_connect() method seems to connect, because I get SQL errors.
Can anyone tell me how to at least select from these tables.. I created them using isql like this: USE studies; CREATE TABLE studies ( ...); But the following variations give SQL errors: USE studies; SELECT * FROM studies; SELECT * FROM studies.studies; SELECT * FROM studies..studies; SELECT * FROM DB.studies; SELECT * FROM DB.studies.studies; To keep working, I made a mirror of these tables in MySQL and so that's what I am working with now. I am already past my deadline. As a last resort I might end up setting up a PHP ARC -based SPARQL endpoint and dumping to that, periodically from the tables. But that won't scale and has other limitations. But I kinda feel not so good. I got excited reading about Virtuoso and now everyone's looking at me. We're looking at possibly moving a lot over to it, including VIVO (researchers and their publications-currently using Sesame/Jena), a huge clinical data repository, and others. I feel so close to breaking the egg-shell that can open up a huge new world of uses.. but also stressed with a very short timeline. Matthew C. Tedder Software Engineer Clinical and Translational Research Informatics Program (CTRIP) University of Florida 1329 SW 16th St. RM 5026 Gainesville, FL 32608 352.265.0111 Ext. 86107 (desk) 509-432-5520 (cell) UF Campus Mail: Box 100147/ICHP USPS Mail: PO Box 100177, Gainesville, FL 32610
