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/ .
