RE: [sqlite] sqlite with visual basic?

[Reid Thompson]

Scott Chapman wrote:
> Thanks Steve.
> 
> Anyone have guidance on which of these will work (well) with
> the latest
> version of VB and SQLite?
> 
> Steve O'Hara wrote:
>> Check out the WIKI, there's a myriad of possibilities.
>> 
>> 
>> -Original Message-
>> From:
>> [EMAIL PROTECTED]
>> 
> [mailto:sqlite-users-return-7016-sohara=pivotal-solutions.co.u
> [EMAIL PROTECTED] rg]On Behalf Of Scott Chapman Sent: 11 August 2005 18:43
> To: sqlite-users@sqlite.org
> Subject: [sqlite] sqlite with visual basic?
> 
> 
> I am having a look at Visual Basic Express 2005 Beta.  I haven't
> programmed VB since version 3.0 on Windows 3.1 many years ago.  I
> didn't do any database with it then. 
> 
> All of my programming these days is in Python with Postgresql or
> SQLite. 
> 
> Has anyone gotten VB and SQLite working together?
> 
> Are there some examples of this available?
> 
> Scott

http://sourceforge.net/projects/adodotnetsqlite

google on finisar sqlite.net 

reid

Re: [sqlite] sqlite with visual basic?

[Gregory Letellier]

use ags sqlite wrapper it works fine with .net

Scott Chapman a écrit :

I am having a look at Visual Basic Express 2005 Beta.  I haven't 
programmed VB since version 3.0 on Windows 3.1 many years ago.  I 
didn't do any database with it then.


All of my programming these days is in Python with Postgresql or SQLite.

Has anyone gotten VB and SQLite working together?

Are there some examples of this available?

Scott

Re: [sqlite] sqlite with visual basic?

[Scott Chapman]

Thanks Steve.

Anyone have guidance on which of these will work (well) with the latest 
version of VB and SQLite?


Steve O'Hara wrote:

Check out the WIKI, there's a myriad of possibilities.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of Scott Chapman
Sent: 11 August 2005 18:43
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite with visual basic?


I am having a look at Visual Basic Express 2005 Beta.  I haven't 
programmed VB since version 3.0 on Windows 3.1 many years ago.  I didn't 
do any database with it then.


All of my programming these days is in Python with Postgresql or SQLite.

Has anyone gotten VB and SQLite working together?

Are there some examples of this available?

Scott

RE: [sqlite] sqlite with visual basic?

[Steve O'Hara]

Check out the WIKI, there's a myriad of possibilities.


-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
rg]On Behalf Of Scott Chapman
Sent: 11 August 2005 18:43
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite with visual basic?


I am having a look at Visual Basic Express 2005 Beta.  I haven't 
programmed VB since version 3.0 on Windows 3.1 many years ago.  I didn't 
do any database with it then.

All of my programming these days is in Python with Postgresql or SQLite.

Has anyone gotten VB and SQLite working together?

Are there some examples of this available?

Scott

RE: [sqlite] sqlite with Visual Basic

[Frederic Faure]

At 13:15 19/06/2004, you wrote:
The previous version included the SQLite code in the DLL. This version 
loads the SQLite DLL at runtime and calls into it - that way there is no 
built-in dependency on the SQLite version.
Very cool :-)
Fred.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Steve O'Hara]

The previous version included the SQLite code in the DLL.
This version loads the SQLite DLL at runtime and calls into it - that way
there is no built-in dependency on the SQLite version.

Steve

-Original Message-
From: Frederic Faure [mailto:[EMAIL PROTECTED]
Sent: 19 June 2004 11:52
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic


"Steve O'Hara" >> If you can think of improvements, let me know.

I noticed that the output DLL shrank yet again to 45KB :-) What did you do
to make it so small?

Fred.


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Frederic Faure]

"Steve O'Hara" >> If you can think of improvements, let me know.
I noticed that the output DLL shrank yet again to 45KB :-) What did you do 
to make it so small?

Fred.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Steve O'Hara]

I think you've missed the point...

The VB wrapper allows VB programmers (this includes ASP) to interface
directly to SQLite.
No half way houses, no strange connection of disparate apps, just
straight-forward Windows code.

As you say, if you're talking VB then you're obviously talking Windows, so
why propose a solution that isn't even proven on Windows?  JavaScript and
KDE, you're having a laugh?

Steve


-Original Message-
From: Hihn, Jason [mailto:[EMAIL PROTECTED]
Sent: 18 June 2004 18:52
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic


Again, I'm coming to this late...

While not VisualBasic, you could theoretically do it in JavaScript (just
as easy) using KJSEmbed.

KJSEmbed is a project that binds JavaScript to KDE. Now not Everyone is
KDE users, and since you're asking for VB, I'll assume you're on
windows. Well good news. There is a qt-only port that binds against Qt
(www.trolltech.com) (Qt includes a SQLite driver) so you can, with Qt,
use SQLite. Now this is still not 100%, because it only works under
Linux, and you need the CVS version ATM. BUT shortly (days - weeks
maximally) they will be releasing Win32-Qt-Only-KJSEmbed. It'll be a
couple DLLs and an EXE to run the script.

http://xmelegance.org/kjsembed/
http://xmelegance.org/kjsembed/examples/sql/sql.js

Currently, I am using KJSEmbed to create and run dialogs
platform-independently. There are glitches, but they usually get
everything fixed or added with 7 days (1 week)

-Original Message-
From: Jorge [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 17, 2004 4:41 PM
To: Jalil Vaidya; Jorge; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite with Visual Basic

No, no...

there is not mentioned VBWrapper.zip


1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from
Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.ht
ml

isn't active

Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't VBWrapper.zip

SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 &
VB6; Get both pssql.zip and psvbutls32.zip )
I am not yahoo group member

SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL).
http://www.sqliteplus.com ($$)
it isn't my favourite price!!!

TIA

Jorge



- Original Message -
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:50 PM
Subject: Re: [sqlite] sqlite with Visual Basic


Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
>
> TIA
>
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Hihn, Jason]

Again, I'm coming to this late...

While not VisualBasic, you could theoretically do it in JavaScript (just
as easy) using KJSEmbed.

KJSEmbed is a project that binds JavaScript to KDE. Now not Everyone is
KDE users, and since you're asking for VB, I'll assume you're on
windows. Well good news. There is a qt-only port that binds against Qt
(www.trolltech.com) (Qt includes a SQLite driver) so you can, with Qt,
use SQLite. Now this is still not 100%, because it only works under
Linux, and you need the CVS version ATM. BUT shortly (days - weeks
maximally) they will be releasing Win32-Qt-Only-KJSEmbed. It'll be a
couple DLLs and an EXE to run the script. 

http://xmelegance.org/kjsembed/
http://xmelegance.org/kjsembed/examples/sql/sql.js

Currently, I am using KJSEmbed to create and run dialogs
platform-independently. There are glitches, but they usually get
everything fixed or added with 7 days (1 week)

-Original Message-
From: Jorge [mailto:[EMAIL PROTECTED] 
Sent: Thursday, June 17, 2004 4:41 PM
To: Jalil Vaidya; Jorge; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite with Visual Basic

No, no...

there is not mentioned VBWrapper.zip


1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from
Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.ht
ml

isn't active

Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't VBWrapper.zip

SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 &
VB6; Get both pssql.zip and psvbutls32.zip )
I am not yahoo group member

SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL).
http://www.sqliteplus.com ($$)
it isn't my favourite price!!!

TIA

Jorge



- Original Message - 
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:50 PM
Subject: Re: [sqlite] sqlite with Visual Basic


Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
>
> TIA
>
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Jérôme VERITE]

If you search a wrapper for VB6, I did one with a VB6 COM DLL which permit
to use classes which look like the DAO classes for access (Database and
Recordset). I have made little change to the C Dll to avoid create a
SAFEARRAY and need less memory for big select statements.

If you want it, I can mail you or it may be linked since the wiki pages (but
I don't know how to do it)

Excuse me for my english.

Jérôme



-Message d'origine-
De : Steve O'Hara [mailto:[EMAIL PROTECTED] 
Envoyé : vendredi 18 juin 2004 14:05
À : [EMAIL PROTECTED]
Objet : RE: [sqlite] sqlite with Visual Basic


This is what you're looking for I think.

http://www.pivotal-solutions.co.uk/downloads/vbwrapper.zip

This is a wrapper that calls the sqlite.dll dynamically so that you can
transplant any version of the DLL you like.
The compiled DLL is included along with source and a sample VB project (Make
sure that pssqlite.dll and sqlite.dll are in the path).

If you can think of improvements, let me know.

Steve



-Original Message-
From: Jorge [mailto:[EMAIL PROTECTED]
Sent: 17 June 2004 22:41
To: Jalil Vaidya; Jorge; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite with Visual Basic


No, no...

there is not mentioned VBWrapper.zip


1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html

isn't active

Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't VBWrapper.zip

SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 &
VB6; Get both pssql.zip and psvbutls32.zip )
I am not yahoo group member

SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL).
http://www.sqliteplus.com ($$)
it isn't my favourite price!!!

TIA

Jorge



- Original Message -
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:50 PM
Subject: Re: [sqlite] sqlite with Visual Basic


Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
>
> TIA
>
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Steve O'Hara]

This is what you're looking for I think.

http://www.pivotal-solutions.co.uk/downloads/vbwrapper.zip

This is a wrapper that calls the sqlite.dll dynamically so that you can
transplant any version of the DLL you like.
The compiled DLL is included along with source and a sample VB project (Make
sure that pssqlite.dll and sqlite.dll are in the path).

If you can think of improvements, let me know.

Steve



-Original Message-
From: Jorge [mailto:[EMAIL PROTECTED]
Sent: 17 June 2004 22:41
To: Jalil Vaidya; Jorge; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite with Visual Basic


No, no...

there is not mentioned VBWrapper.zip


1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html

isn't active

Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't VBWrapper.zip

SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 &
VB6; Get both pssql.zip and psvbutls32.zip )
I am not yahoo group member

SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL).
http://www.sqliteplus.com ($$)
it isn't my favourite price!!!

TIA

Jorge



- Original Message -
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:50 PM
Subject: Re: [sqlite] sqlite with Visual Basic


Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
>
> TIA
>
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Jalil Vaidya]

Seems like the only thing that can help you is in
yahoo group's file section ;-)

> I am not yahoo group member
Become a member, its free. Get the files and then
unsubscribe.

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> No, no...
> 
> there is not mentioned VBWrapper.zip
> 
> 
> 1) DLL for VB 6/5/4 like as ADO free!! by Javier
> Bermudez from Argentina.
>
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html
> 
> isn't active
> 
> Visual Basic 6
> http://www.ag-software.com/SQLite/default.asp
> it's OK, but it isn't VBWrapper.zip
> 
> SQLHelper:
> http://groups.yahoo.com/group/sqlite/files/ (Works
> with VB5 &
> VB6; Get both pssql.zip and psvbutls32.zip )
> I am not yahoo group member
> 
> SQLitePlus COM DLL wrapper for SQLite (coded with
> C++/ATL).
> http://www.sqliteplus.com ($$)
> it isn't my favourite price!!!
> 
> TIA
> 
> Jorge
> 
> 
> 
> - Original Message - 
> From: "Jalil Vaidya" <[EMAIL PROTECTED]>
> To: "Jorge" <[EMAIL PROTECTED]>; "Carlos
> Garces"
> <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Thursday, June 17, 2004 5:50 PM
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> Check out COM Wrappers / Visual Basic DLLs section
> in
> the wiki:
> http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
> 
> HTH,
> 
> Jalil Vaidya
> 
> --- Jorge <[EMAIL PROTECTED]> wrote:
> > Hi,
> >
> > Are there any site whehe can I found the mentioned
> > VBWrapper.zip?
> >
> > I have tried in http://f4.grp.yahoofs.com/..., but
> > this URL isn't OK
> >
> > TIA
> >
> > Jorge Colaccini
> 
> 
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
> 
> 
> 
> 
> __
> Do you Yahoo!?
> New and Improved Yahoo! Mail - 100MB free storage!
> http://promotions.yahoo.com/new_mail
> 
>
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 
> 
> 
>
-
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
> 
> 


=
01001010
0111
01101100
01101001
01101100

__
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Jorge]

No, no...

there is not mentioned VBWrapper.zip


1) DLL for VB 6/5/4 like as ADO free!! by Javier Bermudez from Argentina.
http://free.hostdepartment.com/j/javierbermudez/archivos/sqlite/index.html

isn't active

Visual Basic 6 http://www.ag-software.com/SQLite/default.asp
it's OK, but it isn't VBWrapper.zip

SQLHelper: http://groups.yahoo.com/group/sqlite/files/ (Works with VB5 &
VB6; Get both pssql.zip and psvbutls32.zip )
I am not yahoo group member

SQLitePlus COM DLL wrapper for SQLite (coded with C++/ATL).
http://www.sqliteplus.com ($$)
it isn't my favourite price!!!

TIA

Jorge



- Original Message - 
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Jorge" <[EMAIL PROTECTED]>; "Carlos Garces"
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, June 17, 2004 5:50 PM
Subject: Re: [sqlite] sqlite with Visual Basic


Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
>
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
>
> TIA
>
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Jalil Vaidya]

Check out COM Wrappers / Visual Basic DLLs section in
the wiki:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

HTH,

Jalil Vaidya

--- Jorge <[EMAIL PROTECTED]> wrote:
> Hi,
> 
> Are there any site whehe can I found the mentioned
> VBWrapper.zip?
> 
> I have tried in http://f4.grp.yahoofs.com/..., but
> this URL isn't OK
> 
> TIA
> 
> Jorge Colaccini


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Jorge]

Hi,

Are there any site whehe can I found the mentioned VBWrapper.zip?

I have tried in http://f4.grp.yahoofs.com/..., but this URL isn't OK

TIA

Jorge Colaccini


- Original Message - 
From: "Jalil Vaidya" <[EMAIL PROTECTED]>
To: "Carlos Garces" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, May 13, 2004 10:13 PM
Subject: Re: [sqlite] sqlite with Visual Basic


There is a VBWrapper.zip in the old SQLite yahoo
group's file section. The archive contains wrapper
over the SQLite API so that it can be used from VB.
The API declarations for VB are also in the archieve.
Get it from here:

http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-4gKNXEFX9QQmKIvHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper

If you cannot download from the link above then you
will have to join the group to get it.

HTH,

Jalil Vaidya

Disclaimer: I have never used this wrapper myself.

--- Carlos Garces <[EMAIL PROTECTED]> wrote:
> Hi!
> I can use SQLLite with Visual Basic without using
> other external DLL
> Any sample of using sqlite.dll API?
>
> Thanks
> Carlos Garcés


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Raymond Irving]

Hi,
 
I've recently downloaded and used the ODBC driver and have not seen any problems with 
it thus far. It works great with ADO. In fact I was able to use it as a drop-in 
replacement for an MS SQL Server connection using ADO
 
It's very easy to install. You just simple copy the files with your installation 
program: 
 
inst.exe
sqliteodbc.dll
sqliteodbcu.dll
uninst.exe
 
The next thing to do is to run the inst.exe file to install and uninst.exe to 
uninstall the ODBC drivers.
 
PS. I think the dlls should go inside the "windows\system32" or "windows\system" 
folder.

__
Raymond Irving

Steve O'Hara <[EMAIL PROTECTED]> wrote:
Hi Murray,

Installshield has a method for creating ODBC configurations as part of the
setup.
If I remember, I think that there is an MS API for interacting with the ODBC
setup - if all else fails, do it yourself by writing to the appropriate
places in the registry.

Steve

-Original Message-
From: Murray Moffatt [mailto:[EMAIL PROTECTED]
Sent: 17 May 2004 05:14
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic


I'm interested in using SQLite from within a Visual Basic 6 app that I'm
writing. I need reporting features and so was looking at using Crystal
Reports.

I'm guessing that it would be easiest to use SQLite ODBC for accessing the
SQLite database, as the VB tools and Crystal Reports support ODBC.

When I downloaded SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ and
looked at the readme file I was a bit concerned when I read that this was
still "experimental". Obviously if I want to distribute my app to others I
want something that isn't going to bomb out every so often! If anyone else
is using SQLite ODBC in an app I'd like to hear how stable it is?

Also the readme file says that it has to be installed and databases set up
by using the ODBC Control Panel applet. Obviously I don't want to have to
tell people that they have to set all this up themselves by hand after they
install my app, so is there any way I can programmatically set up the ODBC
connection? Either via my installation program or within the main app
itself?


At 20:32 16/05/2004 +0200, you wrote:


Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code
for
you):

Dim db as ADOSQLite
Set db = new ADOSQLite

db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if

Of course this runs "in-memory" so if this is a concern for you, then try
to
narrow down your selects.

Cheers!
Chris

> -Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> I use SQLite ODBC with ADO to access databases from VB. It
> works like a charm.
>
> http://www.ch-werner.de/sqliteodbc/
>
> __
> Raymond Irving
>
>
> Jérôme_VERITE wrote:
> I use this wrapper and to simplify again the code, I created
> littles classes which are very simple and look like the DAO
> classes. It permits to transform Simply a VB application
> using DAO to SQLITE
>
> Jérôme
>
> -Message d'origine-
> De : Steve O'Hara [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
>
>
> Here's the SQLite wrapper for VB from the Yahoo groups
>
> Steve
>
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
>
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
>
> If you cannot download from the link above then you
> will have to join the group to get it.
>
> HTH,
>
> Jalil Vaidya
>
> Disclaimer: I have never used this wrapper myself.
>
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
>
>
> =
> 01001010
> 0111
> 01101100
> 01101001
> 0110

RE: [sqlite] sqlite with Visual Basic

[Steve O'Hara]

Hi Murray,

Installshield has a method for creating ODBC configurations as part of the
setup.
If I remember, I think that there is an MS API for interacting with the ODBC
setup - if all else fails, do it yourself by writing to the appropriate
places in the registry.

Steve

-Original Message-
From: Murray Moffatt [mailto:[EMAIL PROTECTED]
Sent: 17 May 2004 05:14
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic


I'm interested in using SQLite from within a Visual Basic 6 app that I'm
writing. I need reporting features and so was looking at using Crystal
Reports.

I'm guessing that it would be easiest to use SQLite ODBC for accessing the
SQLite database, as the VB tools and Crystal Reports support ODBC.

When I downloaded SQLite ODBC from http://www.ch-werner.de/sqliteodbc/ and
looked at the readme file I was a bit concerned when I read that this was
still "experimental". Obviously if I want to distribute my app to others I
want something that isn't going to bomb out every so often! If anyone else
is using SQLite ODBC in an app I'd like to hear how stable it is?

Also the readme file says that it has to be installed and databases set up
by using the ODBC Control Panel applet. Obviously I don't want to have to
tell people that they have to set all this up themselves by hand after they
install my app, so is there any way I can programmatically set up the ODBC
connection? Either via my installation program or within the main app
itself?


At 20:32 16/05/2004 +0200, you wrote:


  Personally, I use my own wrapper (attached) with Greg Obleshchuk's
  AGS_SQLite.dll. It is very simple to use (it will generate the SQL code
for
  you):

  Dim db as ADOSQLite
  Set db = new ADOSQLite

  db.Connect "database.db"
  db.Table = "mytable"
  db.Action = ActionSelect
  db.Sort = "id"
  db.Where = "id < 100"
  db.Exec
  If Not db.Err Then
  do while not db.EOF
  debug.print db.field("id")
  db.MoveNext
  Loop
  End if

  Of course this runs "in-memory" so if this is a concern for you, then try
to
  narrow down your selects.

  Cheers!
  Chris

  > -Original Message-
  > From: Raymond Irving [mailto:[EMAIL PROTECTED]
  > Sent: 14 May 2004 17:50
  > To: [EMAIL PROTECTED]
  > Subject: Re: [sqlite] sqlite with Visual Basic
  >
  >
  > I use SQLite ODBC with ADO to access databases from VB. It
  > works like a charm.
  >
  > http://www.ch-werner.de/sqliteodbc/
  >
  > __
  > Raymond Irving
  >
  >
  > Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
  > I use this wrapper and to simplify again the code, I created
  > littles classes which are very simple and look like the DAO
  > classes. It permits to transform Simply a VB application
  > using DAO to SQLITE
  >
  > Jérôme
  >
  > -Message d'origine-
  > De : Steve O'Hara [mailto:[EMAIL PROTECTED]
  > Envoyé : vendredi 14 mai 2004 10:35
  > À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
  > Objet : RE: [sqlite] sqlite with Visual Basic
  >
  >
  > Here's the SQLite wrapper for VB from the Yahoo groups....
  >
  > Steve
  >
  > -Original Message-
  > From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
  > Sent: 14 May 2004 02:13
  > To: Carlos Garces; [EMAIL PROTECTED]
  > Subject: Re: [sqlite] sqlite with Visual Basic
  >
  >
  > There is a VBWrapper.zip in the old SQLite yahoo
  > group's file section. The archive contains wrapper
  > over the SQLite API so that it can be used from VB.
  > The API declarations for VB are also in the archieve.
  > Get it from here:
  >
  > http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
  > 4gKNXEFX9QQmKI
  > vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
  >
  > If you cannot download from the link above then you
  > will have to join the group to get it.
  >
  > HTH,
  >
  > Jalil Vaidya
  >
  > Disclaimer: I have never used this wrapper myself.
  >
  > --- Carlos Garces wrote:
  > > Hi!
  > > I can use SQLLite with Visual Basic without using
  > > other external DLL
  > > Any sample of using sqlite.dll API?
  > >
  > > Thanks
  > > Carlos Garcis
  >
  >
  > =
  > 01001010
  > 0111
  > 01101100
  > 01101001
  > 01101100
  >
  >
  >
  >
  > __
  > Do you Yahoo!?
  > Yahoo! Movies - Buy advance tickets for 'Shrek 2'
  > http://movies.yahoo.com/showtimes/movie?mid=1808405861
  >
  > -
  > To unsubscribe, e-mail: [EMAIL PROTECTED]
  > For additional commands, e-mail: [EMAIL PROTECTED]
  >
  >

RE: [sqlite] sqlite with Visual Basic

[Murray Moffatt]

Hi David,
Many thanks for your suggestion regarding ddoc.  I had a look at the
site and the price is right and it certainly looks like a great way to
programmatically create a report.
I'll download the evaluation version and give it a try.
Thanks again!
At 15:17 17/05/2004 +1000, you wrote:
Hi Murray
 
You might want to check out:
http://dickinson.basicguru.com/
and navigate /software.htm and ddoc at US$25, which works with three
languages.  
If you use Powerbasic, then you get source code as well. 
Don also has a PB interface to SQLite
 
David
>>> Murray Moffatt <[EMAIL PROTECTED]> 17/05/04
15:06:19 >>>
Hi Greg,
Many thanks for your reply to my questions.
I had a quick look at ActiveReports but once I saw the $499 price tag I

didn't bother going any further.  That's way too much to spend on my
little 
freeware program!  The only reason I was looking at Crystal Reports
is 
because I already have it from another (paying) project.
I wonder if it's possible to use VB's DataReport with SQLite?  It
should be 
if I went down the ODBC path, but like you I'm not really comfortable
with 
that.  I wonder if I can programmatically pass the data to
DataReport...
I'll look into using your wrapper too.


Regards
Murray


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[wind li]

Murray Moffatt wrote:
Hi Wind,
At 13:02 17/05/2004 +0800, you wrote:
You have two choose:
1. search the windows register for the datasource that you 
created using ODBC Control Panel, you can create the same register 
entry programmatically.
2. You can just use such a string as your ConnectionString 
"Driver={Microsoft Access Driver 
(*.mdb)};Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;"
  Please replace the Driver,Dbq and so on to the real values 
used by SQLite ODBC, as in choose 1 you can get them from the register.

I like the sound of your option 2.  Is this what is known as a "DNS 
Less" connection?
Yes. You can have a look at HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ for 
requested informations.
Regards
Wind

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Murray Moffatt]

Hi Wind,
At 13:02 17/05/2004 +0800, you wrote:
You have two choose:
1. search the windows register for the datasource that you created 
using ODBC Control Panel, you can create the same register entry 
programmatically.
2. You can just use such a string as your ConnectionString 
"Driver={Microsoft Access Driver 
(*.mdb)};Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;"
  Please replace the Driver,Dbq and so on to the real values used 
by SQLite ODBC, as in choose 1 you can get them from the register.
I like the sound of your option 2.  Is this what is known as a "DNS Less" 
connection?


Regards
Murray

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[wind li]

Murray Moffatt wrote:
I'm interested in using SQLite from within a Visual Basic 6 app that 
I'm writing. I need reporting features and so was looking at using 
Crystal Reports.

I'm guessing that it would be easiest to use SQLite ODBC for accessing 
the SQLite database, as the VB tools and Crystal Reports support ODBC.

When I downloaded SQLite ODBC from 
_http://www.ch-werner.de/sqliteodbc/_ and looked at the readme file I 
was a bit concerned when I read that this was still "experimental". 
Obviously if I want to distribute my app to others I want something 
that isn't going to bomb out every so often! If anyone else is using 
SQLite ODBC in an app I'd like to hear how stable it is?

Also the readme file says that it has to be installed and databases 
set up by using the ODBC Control Panel applet. Obviously I don't want 
to have to tell people that they have to set all this up themselves by 
hand after they install my app, so is there any way I can 
programmatically set up the ODBC connection? Either via my 
installation program or within the main app itself?

You have two choose:
   1. search the windows register for the datasource that you created 
using ODBC Control Panel, you can create the same register entry 
programmatically.
   2. You can just use such a string as your ConnectionString 
"Driver={Microsoft Access Driver 
(*.mdb)};Dbq=c:\\DatabasePath\\dbaccess.mdb;Uid=;Pwd=;"
 Please replace the Driver,Dbq and so on to the real values 
used by SQLite ODBC, as in choose 1 you can get them from the register.

At 20:32 16/05/2004 +0200, you wrote:
Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL 
code for
you):

Dim db as ADOSQLite
Set db = new ADOSQLite
db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if
Of course this runs "in-memory" so if this is a concern for you, then 
try to
narrow down your selects.

Cheers!
Chris
> -Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> I use SQLite ODBC with ADO to access databases from VB. It
> works like a charm.
> 
> http://www.ch-werner.de/sqliteodbc/
> 
> __
> Raymond Irving
>
>
> Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
> I use this wrapper and to simplify again the code, I created
> littles classes which are very simple and look like the DAO
> classes. It permits to transform Simply a VB application
> using DAO to SQLITE
>
> Jérôme
>
> -Message d'origine-
> De : Steve O'Hara [mailto:[EMAIL PROTECTED]
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
>
>
> Here's the SQLite wrapper for VB from the Yahoo groups
>
> Steve
>
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
>
>
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
>
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
>
> If you cannot download from the link above then you
> will have to join the group to get it.
>
> HTH,
>
> Jalil Vaidya
>
> Disclaimer: I have never used this wrapper myself.
>
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
>
>
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
>
>
>
>
> __
> Do you Yahoo!?
> Yahoo! Movies - Buy advance tickets for 'Shrek 2'
> http://movies.yahoo.com/showtimes/movie?mid=1808405861
>
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip
> ---

RE: [sqlite] sqlite with Visual Basic

[Murray Moffatt]

Hi Greg,
Many thanks for your reply to my questions.
I had a quick look at ActiveReports but once I saw the $499 price tag I 
didn't bother going any further.  That's way too much to spend on my little 
freeware program!  The only reason I was looking at Crystal Reports is 
because I already have it from another (paying) project.

I wonder if it's possible to use VB's DataReport with SQLite?  It should be 
if I went down the ODBC path, but like you I'm not really comfortable with 
that.  I wonder if I can programmatically pass the data to DataReport...

I'll look into using your wrapper too.
At 14:35 17/05/2004 +1000, you wrote:
Hi Murray,
Can I make a suggestion or two.  Firstly I wouldn't use Crystal Report.  It
sucks and I hate it , have a look at ActiveReports from DataDynamics
Version 2.0 is fantastic and very light on it's feet (small).  The price is
great as well.
Also ActiveReport supports ADO , DAO, RDO and XML.  You can pragmatically
send it a array and bind to that.
With the ODBC driver, I'm not a big fan of installing drivers (ODBC) during
setup or supplying them with the application.  That's why the wrapper I
wrote doesn't use them.

A & G Software
Quality software with Style
Greg Obleshchuk
Partner
A & G Software
Victoria
Australia
[EMAIL PROTECTED]
http://www.ag-software.com 
MSN: [EMAIL PROTECTED]

  Document any Microsoft
database in minutes
  Generate Cross tab
results from Microsoft SQL Server 2000

Regards
Murray

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Greg Obleshchuk]

Hi Murray,
Can I make a suggestion or two.  Firstly I wouldn't use Crystal Report.  It
sucks and I hate it , have a look at ActiveReports from DataDynamics 
Version 2.0 is fantastic and very light on it's feet (small).  The price is
great as well. 
 
Also ActiveReport supports ADO , DAO, RDO and XML.  You can pragmatically
send it a array and bind to that.
 
With the ODBC driver, I'm not a big fan of installing drivers (ODBC) during
setup or supplying them with the application.  That's why the wrapper I
wrote doesn't use them.
 
 
 
A & G Software   
Quality software with Style

Greg Obleshchuk
Partner  
A & G Software
Victoria
Australia

[EMAIL PROTECTED]
http://www.ag-software.com <http://www.ag-software.com/> 
MSN: [EMAIL PROTECTED]  
 


 <http://www.ag-software.com/ags_scribe_index.aspx> Document any Microsoft
database in minutes
 <http://www.ag-software.com/xp_ags_crosstab.aspx> Generate Cross tab
results from Microsoft SQL Server 2000

 


  _  

From: Murray Moffatt [mailto:[EMAIL PROTECTED] 
Sent: Monday, 17 May 2004 2:14 PM
To: [EMAIL PROTECTED]
Subject: RE: [sqlite] sqlite with Visual Basic


I'm interested in using SQLite from within a Visual Basic 6 app that I'm
writing. I need reporting features and so was looking at using Crystal
Reports.

I'm guessing that it would be easiest to use SQLite ODBC for accessing the
SQLite database, as the VB tools and Crystal Reports support ODBC.

When I downloaded SQLite ODBC from  <http://www.ch-werner.de/sqliteodbc/>
http://www.ch-werner.de/sqliteodbc/ and looked at the readme file I was a
bit concerned when I read that this was still "experimental". Obviously if I
want to distribute my app to others I want something that isn't going to
bomb out every so often! If anyone else is using SQLite ODBC in an app I'd
like to hear how stable it is?

Also the readme file says that it has to be installed and databases set up
by using the ODBC Control Panel applet. Obviously I don't want to have to
tell people that they have to set all this up themselves by hand after they
install my app, so is there any way I can programmatically set up the ODBC
connection? Either via my installation program or within the main app
itself?


At 20:32 16/05/2004 +0200, you wrote:



Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for
you):

Dim db as ADOSQLite
Set db = new ADOSQLite

db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if

Of course this runs "in-memory" so if this is a concern for you, then try to
narrow down your selects.

Cheers!
Chris

> -----Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED] 
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> I use SQLite ODBC with ADO to access databases from VB. It 
> works like a charm.
>  
> http://www.ch-werner.de/sqliteodbc/
>  
> __
> Raymond Irving
> 
> 
> Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
> I use this wrapper and to simplify again the code, I created 
> littles classes which are very simple and look like the DAO 
> classes. It permits to transform Simply a VB application 
> using DAO to SQLITE
> 
> Jérôme
> 
> -Message d'origine-
> De : Steve O'Hara [mailto:[EMAIL PROTECTED] 
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
> 
> 
> Here's the SQLite wrapper for VB from the Yahoo groups
> 
> Steve
> 
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
> 
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
> 
> If you cannot download from the link above then you
> will have to join the group to get it.
> 
> HTH,
> 
> Jalil Vaidya
> 
> Disclaimer: I have never used this wrapper myself.
> 
> --- Carlos Garces wrote:
> > Hi!
> > I

RE: [sqlite] sqlite with Visual Basic

[Murray Moffatt]

I'm interested in using SQLite from within a Visual Basic 6 app that I'm
writing. I need reporting features and so was looking at using Crystal
Reports.
I'm guessing that it would be easiest to use SQLite ODBC for accessing
the SQLite database, as the VB tools and Crystal Reports support
ODBC.
When I downloaded SQLite ODBC from
http://www.ch-werner.de/sqliteodbc/
and looked at the readme file I was a bit concerned when I read that this was still "experimental". Obviously if I want to distribute my app to others I want something that isn't going to bomb out every so often! If anyone else is using SQLite ODBC in an app I'd like to hear how stable it is?
Also the readme file says that it has to be installed and databases set up by using the ODBC Control Panel applet. Obviously I don't want to have to tell people that they have to set all this up themselves by hand after they install my app, so is there any way I can programmatically set up the ODBC connection? Either via my installation program or within the main app itself?

At 20:32 16/05/2004 +0200, you wrote:
Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for
you):
Dim db as ADOSQLite
Set db = new ADOSQLite
db.Connect "database.db"
db.Table = "mytable"
db.Action = "">
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if
Of course this runs "in-memory" so if this is a concern for you, then try to
narrow down your selects.

Cheers!
Chris
> -Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED]] 
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> I use SQLite ODBC with ADO to access databases from VB. It 
> works like a charm.
>  
> http://www.ch-werner.de/sqliteodbc/
>  
> __
> Raymond Irving
> 
> 
> Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
> I use this wrapper and to simplify again the code, I created 
> littles classes which are very simple and look like the DAO 
> classes. It permits to transform Simply a VB application 
> using DAO to SQLITE
> 
> Jérôme
> 
> -Message d'origine-
> De : Steve O'Hara [mailto:[EMAIL PROTECTED]] 
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
> 
> 
> Here's the SQLite wrapper for VB from the Yahoo groups
> 
> Steve
> 
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
> 
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
> 
> If you cannot download from the link above then you
> will have to join the group to get it.
> 
> HTH,
> 
> Jalil Vaidya
> 
> Disclaimer: I have never used this wrapper myself.
> 
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
> 
> 
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
> 
> 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Movies - Buy advance tickets for 'Shrek 2' 
> http://movies.yahoo.com/showtimes/movie?mid=1808405861
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004
>  
> 
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/0

RE: [sqlite] sqlite with Visual Basic

[Chris Carter]

Personally, I use my own wrapper (attached) with Greg Obleshchuk's
AGS_SQLite.dll. It is very simple to use (it will generate the SQL code for
you):

Dim db as ADOSQLite
Set db = new ADOSQLite

db.Connect "database.db"
db.Table = "mytable"
db.Action = ActionSelect
db.Sort = "id"
db.Where = "id < 100"
db.Exec
If Not db.Err Then
do while not db.EOF
debug.print db.field("id")
db.MoveNext
Loop
End if

Of course this runs "in-memory" so if this is a concern for you, then try to
narrow down your selects.

Cheers!
Chris

> -Original Message-
> From: Raymond Irving [mailto:[EMAIL PROTECTED] 
> Sent: 14 May 2004 17:50
> To: [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> I use SQLite ODBC with ADO to access databases from VB. It 
> works like a charm.
>  
> http://www.ch-werner.de/sqliteodbc/
>  
> __
> Raymond Irving
> 
> 
> Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
> I use this wrapper and to simplify again the code, I created 
> littles classes which are very simple and look like the DAO 
> classes. It permits to transform Simply a VB application 
> using DAO to SQLITE
> 
> Jérôme
> 
> -Message d'origine-----
> De : Steve O'Hara [mailto:[EMAIL PROTECTED] 
> Envoyé : vendredi 14 mai 2004 10:35
> À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
> Objet : RE: [sqlite] sqlite with Visual Basic
> 
> 
> Here's the SQLite wrapper for VB from the Yahoo groups....
> 
> Steve
> 
> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
> Sent: 14 May 2004 02:13
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> 
> There is a VBWrapper.zip in the old SQLite yahoo
> group's file section. The archive contains wrapper
> over the SQLite API so that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
> 
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKI
> vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper
> 
> If you cannot download from the link above then you
> will have to join the group to get it.
> 
> HTH,
> 
> Jalil Vaidya
> 
> Disclaimer: I have never used this wrapper myself.
> 
> --- Carlos Garces wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using
> > other external DLL
> > Any sample of using sqlite.dll API?
> >
> > Thanks
> > Carlos Garcis
> 
> 
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
> 
> 
> 
> 
> __
> Do you Yahoo!?
> Yahoo! Movies - Buy advance tickets for 'Shrek 2' 
> http://movies.yahoo.com/showtimes/movie?mid=1808405861
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 
> > ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> ---
> Incoming mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.684 / Virus Database: 446 - Release Date: 13/05/2004
>  
> 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.686 / Virus Database: 447 - Release Date: 14/05/2004
 
  

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Raymond Irving]

I use SQLite ODBC with ADO to access databases from VB. It works like a charm.
 
http://www.ch-werner.de/sqliteodbc/
 
__
Raymond Irving


Jérôme_VERITE <[EMAIL PROTECTED]> wrote:
I use this wrapper and to simplify again the code, I created littles classes
which are very simple and look like the DAO classes. It permits to transform
Simply a VB application using DAO to SQLITE

Jérôme

-Message d'origine-
De : Steve O'Hara [mailto:[EMAIL PROTECTED] 
Envoyé : vendredi 14 mai 2004 10:35
À : Jalil Vaidya; Carlos Garces; [EMAIL PROTECTED]
Objet : RE: [sqlite] sqlite with Visual Basic


Here's the SQLite wrapper for VB from the Yahoo groups

Steve

-Original Message-
From: Jalil Vaidya [mailto:[EMAIL PROTECTED]
Sent: 14 May 2004 02:13
To: Carlos Garces; [EMAIL PROTECTED]
Subject: Re: [sqlite] sqlite with Visual Basic


There is a VBWrapper.zip in the old SQLite yahoo
group's file section. The archive contains wrapper
over the SQLite API so that it can be used from VB.
The API declarations for VB are also in the archieve.
Get it from here:

http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-4gKNXEFX9QQmKI
vHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper

If you cannot download from the link above then you
will have to join the group to get it.

HTH,

Jalil Vaidya

Disclaimer: I have never used this wrapper myself.

--- Carlos Garces wrote:
> Hi!
> I can use SQLLite with Visual Basic without using
> other external DLL
> Any sample of using sqlite.dll API?
>
> Thanks
> Carlos Garcis


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



> ATTACHMENT part 2 application/x-zip-compressed name=VBSQLite.zip
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Greg Obleshchuk]

Hi Carlos,
Sorry mate I didn't point out the wrappers on Sqlite.Org
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers

Greg 

> -Original Message-
> From: Jalil Vaidya [mailto:[EMAIL PROTECTED] 
> Sent: Friday, 14 May 2004 11:13 AM
> To: Carlos Garces; [EMAIL PROTECTED]
> Subject: Re: [sqlite] sqlite with Visual Basic
> 
> There is a VBWrapper.zip in the old SQLite yahoo group's file 
> section. The archive contains wrapper over the SQLite API so 
> that it can be used from VB.
> The API declarations for VB are also in the archieve.
> Get it from here:
> 
> http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-
> 4gKNXEFX9QQmKIvHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%
> 20Wrapper
> 
> If you cannot download from the link above then you will have 
> to join the group to get it.
> 
> HTH,
> 
> Jalil Vaidya
> 
> Disclaimer: I have never used this wrapper myself.
> 
> --- Carlos Garces <[EMAIL PROTECTED]> wrote:
> > Hi!
> > I can use SQLLite with Visual Basic without using other 
> external DLL 
> > Any sample of using sqlite.dll API?
> > 
> > Thanks
> > Carlos Garcis
> 
> 
> =
> 01001010
> 0111
> 01101100
> 01101001
> 01101100
> 
> 
>   
>   
> __
> Do you Yahoo!?
> Yahoo! Movies - Buy advance tickets for 'Shrek 2'
> http://movies.yahoo.com/showtimes/movie?mid=1808405861 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: [sqlite] sqlite with Visual Basic

[Jalil Vaidya]

There is a VBWrapper.zip in the old SQLite yahoo
group's file section. The archive contains wrapper
over the SQLite API so that it can be used from VB.
The API declarations for VB are also in the archieve.
Get it from here:

http://f4.grp.yahoofs.com/v1/EBqkQKgMWwt8clzVakFnZ6GAGVancQ9q-4gKNXEFX9QQmKIvHaVaTJ9rp1fz-XHaFxRIq46etnp1v_WDUrQPABeSNps/VB%20Wrapper

If you cannot download from the link above then you
will have to join the group to get it.

HTH,

Jalil Vaidya

Disclaimer: I have never used this wrapper myself.

--- Carlos Garces <[EMAIL PROTECTED]> wrote:
> Hi!
> I can use SQLLite with Visual Basic without using
> other external DLL
> Any sample of using sqlite.dll API?
> 
> Thanks
> Carlos Garcés


=
01001010
0111
01101100
01101001
01101100




__
Do you Yahoo!?
Yahoo! Movies - Buy advance tickets for 'Shrek 2'
http://movies.yahoo.com/showtimes/movie?mid=1808405861 

-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

RE: [sqlite] sqlite with Visual Basic

[Greg Obleshchuk]

Carlos,
No you can't the call-back API and the API that’s returns a C style array
aren't supported in VB

Regards
Greg  

> -Original Message-
> From: Carlos Garces [mailto:[EMAIL PROTECTED] 
> Sent: Friday, 14 May 2004 6:00 AM
> To: [EMAIL PROTECTED]
> Subject: [sqlite] sqlite with Visual Basic
> 
> Hi!
> I can use SQLLite with Visual Basic without using other 
> external DLL Any sample of using sqlite.dll API?
> 
> Thanks
> Carlos Garcés
> 
> 
> .
> 
> 
> 
> -
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 


-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]