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

Reply via email to