Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread [EMAIL PROTECTED]
Hi That is what I thought. Who should I report the bug to? Cheers, Robin Original Message: - From: [EMAIL PROTECTED] Date: Mon, 22 May 2006 08:14:12 -0400 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC Robin Wilson &l

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread drh
Robin Wilson <[EMAIL PROTECTED]> wrote: > > I have had a few problems though. At the moment I am accessing SQLite > through ODBC from Visual Basic 6. This means the students can carry on > using the ADO commands that they are familier with (from working with > Access DBs). However, when working

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread Nemanja Corlija
On 5/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: I was playing with the problem a bit more last night, and found that some queries worked (for example the one specified on your example page: SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WH

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread [EMAIL PROTECTED]
on this? Cheers, Robin Original Message: - From: John Newby [EMAIL PROTECTED] Date: Mon, 22 May 2006 10:39:54 +0100 To: sqlite-users@sqlite.org, [EMAIL PROTECTED] Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC Hi Robin, have you looked here, there are

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread John Newby
EMAIL PROTECTED] Date: Mon, 22 May 2006 09:07:17 +1000 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC It is not permissions, more like a VB interface problem. Robin Wilson wrote: > Hi all, > > I've just started looking at SQLite -

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-22 Thread [EMAIL PROTECTED]
2006 09:07:17 +1000 To: sqlite-users@sqlite.org Subject: Re: [sqlite] Can't access sqlite_master from VB6 via ODBC It is not permissions, more like a VB interface problem. Robin Wilson wrote: > Hi all, > > I've just started looking at SQLite - and think it is really impres

Re: [sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-21 Thread John Stanton
It is not permissions, more like a VB interface problem. Robin Wilson wrote: Hi all, I've just started looking at SQLite - and think it is really impressive. It would be just the thing to use with my students for teaching them about RDBMS's (especially with some of the nice Windows UIs which

[sqlite] Can't access sqlite_master from VB6 via ODBC

2006-05-21 Thread Robin Wilson
Hi all, I've just started looking at SQLite - and think it is really impressive. It would be just the thing to use with my students for teaching them about RDBMS's (especially with some of the nice Windows UIs which are available for the students who can't cope with command line tools!). I h