Re: [sqlite] Testing the ODBC link
Just following up: The problem getting the "catalog name" was a minor one - the ODBC link for SQLite only supported early versions of the ODBC call for doing this. When I reverted to an earlier-model API call, poof, it worked. And it kept working for all the other DB's I tried too. So we're uploading shortly. -- View this message in context: http://sqlite.1065341.n5.nabble.com/Testing-the-ODBC-link-tp62605p63537.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Example database with lots of "types"?
Hey Dan, thanks for that link, it was just what I was looking for. Yes indeed, someone, somewhere in my software stack is incorrectly mapping out BLOBs as text. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Example database with lots of "types"?
I'm working on getting the Mac version of the SQLite ODCB connector fully functional. I'm having some problems getting examples of lots of different data types - for instance, my northwind copy has a decimal stored as a varchar. Does anyone have a small test DB they would be willing to part with so I could see lots of different data types and what happens when they come through the adaptor? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing the ODBC link
I swear I did nothing... and it's working perfectly. Ahhh... However, the ODBC driver does not properly return the "current catalog" from its connection info, which I use to drive the schema download/unfold. Nothing major, it's a minor annoyance only, but I'll keep poking at it and maybe I can get that working too. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing the ODBC link
On 2012-06-20, at 12:01 PM, Pavel Ivanov wrote: >> Well that looks like your library is loading, the connection with ODBC is >> working, but it isn't accessing your database file. I agree with your other >> post. >> >> It may not be finding your database in the folder where you think it's >> looking. When you tell it which database to open try specifying the full >> path, from 'C:\' onwards, just for testing purposes. Ok, is there a way to do *this* via a PRAGMA or such, through the ODBC connection? IE, is there an analog of "USE"? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing the ODBC link
On 2012-06-20, at 12:01 PM, Pavel Ivanov wrote: > Meaning "from '/' onwards" as OP works on OS X. ;-) Indeed! :-) ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing the ODBC link
On 2012-06-20, at 11:50 AM, Simon Slavin wrote: > SELECT sqlite_version() > PRAGMA database_list Ahhh, thanks Simon, this is precisely the sort of thing I was looking for. And the results are... > SELECT sqlite_version() 3.7.7 > PRAGMA database_list Onward! ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Testing the ODBC link
My apologies, I failed to mention this potentially important point: select * from sqlite_master returns columns in the result set, but no rows of data. So I *am* connected, but it just doesn't seem to see any data. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Testing the ODBC link
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