Search Again: SQL and ODBC Revisited From: Daniel J. Luke Date: Tuesday, May 2, 2000 Time: 8:32:34 am OK, I have Optigold set as an ODBC datasource, and I have an application that can connect and pass SQL queries on (and theoretically return results too). Now my problem is not only can I not get a table list (perhaps a limitation in the FMPro ODBC plugin?), but any query I try results in "Unknown error (State: S1000, Native Code: 4006). I'm using WinSQL and the simplest query I'm trying is: select * from Main_Menu Any ideas? -- Daniel J. Luke Database Programmer Voyager.net - East Lansing Office +========================================================+

Messages In This Thread: SQL and ODBC Revisited by Daniel J. Luke on May 2, 2000 at 8:32:34 am Re: SQL and ODBC Revisited by Shawn Hogan on May 2, 2000 at 9:13:39 am Re: SQL and ODBC Revisited by Daniel J. Luke on May 2, 2000 at 9:16:00 am Re: SQL and ODBC Revisited by Shawn Hogan on May 2, 2000 at 9:24:20 am Re: SQL and ODBC Revisited by Daniel J. Luke on May 2, 2000 at 9:37:13 am Re: SQL and ODBC Revisited by Shawn Hogan on May 2, 2000 at 9:49:25 am Re: SQL and ODBC Revisited by Daniel J. Luke on May 2, 2000 at 9:52:56 am Re: SQL and ODBC Revisited by Shawn Hogan on May 2, 2000 at 9:54:26 am