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
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
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
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
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
>>
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
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!
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
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
9 matches
Mail list logo