Hi Bart, Okay, but I thought that the wrapper was just for working with the SQLite database and then later when you wanted to use the database as a data source that you would then still use the ODBC driver.
But are you saying that you are use the wrapper itself as a data source in Excel? And if so, how do you specify the wrapper as a data source? /Frank > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Bart Smissaert > Sent: 14 October 2011 02:21 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables and > pivottables) > > Hi Frank, > > This VB wrapper is not an ODBC driver, so there is no DSN. > The database file is set in the connection string: > > Function OpenDB([FileName As String], > [EncrKey As String], > [EnableVBFunctions As Boolean = True]) As Boolean > > Member of vbRichClient4.cConnection > > > RBS > > > On Thu, Oct 13, 2011 at 7:11 PM, Frank Missel <i...@missel.sg> wrote: > > Bart, thanks for the offer, but we found the cause of the problems in > > the data type naming of the columns. > > > > Have you found a way to avoid having to define DSN's for each > > individual database? > > > > /Frank > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users