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 uploa
On 22 Jun 2012, at 2:17am, Kyle McKay wrote:
> I have successfully used the SQLite ODBC Driver available from:
>
> http://www.ch-werner.de/sqliteodbc/
Hey, thanks for that, Kyle. I always wondered whether I could make ODBC do
SQLite but had no idea how to make it happen. Your instructions w
On June 20, 2012 08:43:31 PDT, Maury Markowitz wrote:
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
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 20 Jun 2012, at 5:12pm, Maury Markowitz wrote:
> 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 fi
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
>> l
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 20 Jun 2012, at 5:01pm, Pavel Ivanov wrote:
> On Wed, Jun 20, 2012 at 11:57 AM, Simon Slavin wrote:
>>
>> 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 f
On Wed, Jun 20, 2012 at 11:57 AM, Simon Slavin wrote:
>
> On 20 Jun 2012, at 4:53pm, Maury Markowitz wrote:
>
>> 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.
>
On 20 Jun 2012, at 4:53pm, Maury Markowitz wrote:
> 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.
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
sqlite-
On 20 Jun 2012, at 4:43pm, Maury Markowitz wrote:
> 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?
Your interface may do its own checking for a DB and refuse to process a SQLite
com
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 comm
14 matches
Mail list logo
