I'm working on a OSX10.7 ODBC query interface - type SQL, get results. It uses the open-source iODBC library set. I've got this working fairly well with MySQL (including major public servers on the 'net, cool!) and Firebird.
I'd like to test it against SQLite as well, as this is obviously a common DB on the Mac. I downloaded a version of the Northwind DB that was converted to SQLite format, and to make sure that worked, I also downloaded a wonderful (but SQLite-only) DB viewer known as "Base". Everything is working well. However, when I attempt to connect to the DB using the ODBC driver, I connect fine but the database is not selected. This may be nothing more than the driver reporting the connection wrong, but I can't be sure... So can anyone suggest any SQLite command I might send in through the SQL interface that should return something even if there is no active DB connection? With MySQL I'd use "show databases" or "use mysql", is there an equivalent in SQLite? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
