Groups > microsoft.public.scripting.vbscript > #11411

Re: SQLite with VBScript UDF?

Newsgroups	microsoft.public.scripting.vbscript
Date	2016-11-21 09:14 -0800
References	<e855aa28-46da-4f1e-846a-fb7b87a40bf0@googlegroups.com> <1mupvqk2qamm6$.1gfcuc2hiqray.dlg@40tude.net>
Message-ID	<ac770678-2a9c-439f-bab8-3d31560a9545@googlegroups.com> (permalink)
Subject	Re: SQLite with VBScript UDF?
From	bart.smissaert@gmail.com

Show all headers | View raw

When I use it with Excel 64 bits the dll is loaded via a COM exe and that works fine, so I can use it with Excel 64 bits. There only is a problem with UDF's in the 64 bit Excel as the dll can't handle the 64 bit address pointers of the UDF.
I was hoping that 32 bit VBscript could help me out here.

RBS


On Monday, 21 November 2016 16:17:13 UTC, JJ  wrote:
> On Mon, 21 Nov 2016 02:04:10 -0800 (PST), bart.smissaert@gmail.com wrote:
> > Using SQLite with a home-grown VB6 wrapper. Use this in Excel via this wrapper (an ActiveX dll) and in a .xlam add-in. Now in 32 bit Excel I can write SQLite UDF's in VBA and this is very useful. In 64 bit Excel I can't do this though as VB6 is 32 bits. So, I was thinking I could use VBScript.
> > Is there anybody in this group who has done this or do you think this is possible?
> > I know VBScript has the GetRef function, but not sure I can use that to pass the address of the UDF to SQLite.
> > All a bit complex, but maybe somebody could advise here and thanks in advance.
> > 
> > RBS
> 
> I'm not an expert at COM and ActiveX, and I might mention the wrong
> technical terms here... but I think the SQLite wrapper should be made as a
> DLL server, so that processes which have different "bitness" than the COM
> object, can use it.
> 
> It's like Office Excel. When the Excel process is 32-bit, 64-bit process can
> communicate with it for e.g. open a workbook, calculate and fill some cells,
> then save it. i.e. mixing "bitness". This is because Excel itself is a DLL
> server.
> 
> The diagram is something like this:
> 
> +----------------------+
> |     32-bit Excel     |
> | +------------------+ |
> | | 32-bit Excel COM | |
> | +--------+---------+ |
> +          |           |
> +----------|-----------+
>            |
>           IPC
>            |
> +----------|-----------+
> +          |           |
> | +--------+---------+ |
> | | 64-bit Excel COM | |
> | +------------------+ |
> |     64-bit App       |
> +----------------------+
> 
> The IPC between two COM objects are handled transparently by the COM
> library. Using RPC, I believe.

Back to microsoft.public.scripting.vbscript | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 02:04 -0800
  Re: SQLite with VBScript UDF? JJ <jj4public@vfemail.net> - 2016-11-21 23:17 +0700
    Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 09:14 -0800
  Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 15:21 -0500
    Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:03 -0800
      Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 16:11 -0500
        Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:19 -0800
          Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-21 16:31 -0500
            Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-21 13:40 -0800
              Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 12:30 -0500
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 12:43 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 11:02 -0800
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-22 14:19 -0500
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 15:27 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 14:12 -0800
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 17:34 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 15:22 -0800
                Re: SQLite with VBScript UDF? "Mayayana" <mayayana@invalid.nospam> - 2016-11-22 20:06 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-22 17:42 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-26 15:23 +0100
                Re: SQLite with VBScript UDF? GS <gs@v.invalid> - 2016-11-26 15:21 -0500
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-27 08:11 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-27 12:59 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-28 07:39 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-28 18:28 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 05:59 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-29 22:01 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 13:35 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 06:31 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-29 13:01 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 06:51 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-30 00:17 -0800
                Re: SQLite with VBScript UDF? Schmidt <ng@vbRichClient.com> - 2016-11-30 10:50 +0100
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-11-30 02:45 -0800
                Re: SQLite with VBScript UDF? bart.smissaert@gmail.com - 2016-12-01 02:40 -0800

csiph-web