Hi Yes I did look at that, but I was wanting to use ODBC to access SQLite as that is what I and my students are used to. In VB you can use the same programming commands (ADO) to access any ODBC database. My students are used to this and I'd like to carry on using this if possible. I will, however, investigate the link you gave me in more detail when I am at home.
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 WHERE type='table' ORDER BY name; - which apparantly is the same as the .tables command. However, when I try the query SELECT name FROM sqlite_master; it gives no results - even though a much more complex query with WHERE clauses gives some results. Any ideas 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 many wrappers for SQLite http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers this one in particular mentions "any ActiveX language such Visual Basic" http://vfornazin.ipdz.com/ hope this is of help to you john On 22/05/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi > > I thought it wasn't permissions. The VB interface I'm using is ActiveX > Data > Objects, which works through ODBC and the SQLite ODBC driver. Might there > be some problem with this driver? > > Robin > > Original Message: > ----------------- > From: John Stanton [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 - 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 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 from VB the SQL query "SELECT * FROM > > sqlite_master;" does not return any records, but when I run that from > > the sqlite3 command line program with the same db file it returns 1 row. > > > > Is this some kind of permissions problem? If this happened elsewhere I > > would assume it was, but I remember reading on your website that > > permissions aren't implemented in SQLite. > > > > Does anyone have any ideas? > > > > Cheers, > > > > Robin > > > > P.S. I hope this is the right list, and that it is ok to just butt in > > etc... > > > -------------------------------------------------------------------- > mail2web - Check your email from the web at > http://mail2web.com/ . > > > -------------------------------------------------------------------- mail2web - Check your email from the web at http://mail2web.com/ .
