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
>
>> -----Original Message-----
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of Bart Smissaert
>> Sent: 14 October 2011 01:35
>> To: General Discussion of SQLite Database
>> Subject: Re: [sqlite] How to use SQLite as a data source in Excel (tables
> and
>> pivottables)
>>
>> I use SQLite extensively as a data source in Excel and have never come
> across
>> this problem.
>> Is use Olaf Schmidt's VB wrapper vbRichClient4 and vb_cairo_sqlite.
>> If you can send me a workbook that clearly demonstrates the problem then I
>> can see if I can deal with it with the above wrapper. I am sure there will
> be no
>> problem at all.
>>
>> RBS
>>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
