RE: Visual Basic and SQLite

  • From: Jamal Mazrui <empower@xxxxxxxxx>
  • To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
  • Date: Fri, 5 Jun 2009 10:04:50 -0400 (EDT)

Hi Jim,
You can either repeat the /r parameter for each DLL, or use /r once and
seperate the DLLs with a semicolon character (;).

Since SQLite is a 3rd party DLL, it must be explicitly referenced.  Some
.NET Framework DLLs are referenced automatically, while others require
a reference.  The MSDN documentation says what DLL contains each
namespace.  If the VBC compiler cannot find a namespace, it will say
so, indicating that a reference to a DLL may be needed.  DLLs that are
part of the .NET Framework do not need to be distributed.  Others do.
Inno Setup lets you specify what files to include in the setup program
it creates.

Jamal

DLLs are referenced
 (those in the global assembly cache)
On Fri, 5 Jun 2009,
Homme, James wrote:

> Date: Fri, 5 Jun 2009 07:54:26 -0400
> From: "Homme, James" <james.homme@xxxxxxxxxxxx>
> Reply-To: programmingblind@xxxxxxxxxxxxx
> To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
> Subject: RE: Visual Basic and SQLite
>
> Hi,
> The command EdSharp uses to compile a VB.net program is this.
> vbc.exe /nologo /t:winexe /r:Microsoft.VisualBasic.dll "%Source%" 2>&1
>
> Do I list each dll after the /r: or do I have to repeat the /r: for each dll 
> I need. And, how do I know if I need a particular dll? What would happen if 
> the dll listed were not listed?
>
> Thanks.
>
> Jim
>
> ----------
> Jim Homme, Usability Engineering.
> 412-544-1810.
>
> Note: I will reply to email and voice mail within four hours.
>
> "Nothing in this world can take the place of persistence.
>
> "Talent will not; nothing is more common than unsuccessful people with talent.
>
> "Genius will not; unrewarded genius is almost a proverb.
>
> "Education will not; the world is full of educated derelicts.
>
> "Persistence and determination alone are omnipotent."
> - Calvin Coolidge (1872-1933)
>
>
> -----Original Message-----
> From: programmingblind-bounce@xxxxxxxxxxxxx 
> [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jamal Mazrui
> Sent: Thursday, June 04, 2009 4:18 PM
> To: programmingblind@xxxxxxxxxxxxx
> Subject: RE: Visual Basic and SQLite
>
> Hi Jim,
> No. A .NET DLL either has to be installed in the global assembly cache (a
> special folder) or put in the same directory as the .exe that uses it.
> I suggest copying System.Data.SqLite.dll to your program directory.
> Then use the /r command line parameter to reference the DLL.  Look at
> the batch file in db_fruit.zip for an example.
>
> Jamal
>
> On Thu, 4 Jun 2009, Homme,
> James wrote:
>
> > Date: Thu, 4 Jun 2009 14:43:17 -0400
> > From: "Homme, James" <james.homme@xxxxxxxxxxxx>
> > Reply-To: programmingblind@xxxxxxxxxxxxx
> > To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
> > Subject: RE: Visual Basic and SQLite
> >
> > Hi Jamal,
> > If I install SQLite will the compiler just find it?
> >
> > Thanks.
> >
> > Jim
> >
> > ----------
> > Jim Homme, Usability Engineering.
> > 412-544-1810.
> >
> > Note: I will reply to email and voice mail within four hours.
> >
> > "Nothing in this world can take the place of persistence.
> >
> > "Talent will not; nothing is more common than unsuccessful people with 
> > talent.
> >
> > "Genius will not; unrewarded genius is almost a proverb.
> >
> > "Education will not; the world is full of educated derelicts.
> >
> > "Persistence and determination alone are omnipotent."
> > - Calvin Coolidge (1872-1933)
> >
> > -----Original Message-----
> > From: programmingblind-bounce@xxxxxxxxxxxxx 
> > [mailto:programmingblind-bounce@xxxxxxxxxxxxx] On Behalf Of Jamal Mazrui
> > Sent: Thursday, June 04, 2009 11:08 AM
> > To: programmingblind@xxxxxxxxxxxxx
> > Subject: Re: Visual Basic and SQLite
> >
> > Hi Jim,
> > Here is a fruit basket program using SQLite with the C# command-line
> > compiler.  The command-line syntax is the same for VBNET (except the
> > compiler is vbc.exe rather than cs.exe).
> > http://EmpowermentZone.com/db_fruit.zip
> >
> > Another fruit basket program in VBNET, using its command-line compiler
> > (but not SQLite) is at
> > http://EmpowermentZone.com/vb_fruit.zip
> >
> > Hope this helps,
> > Jamal
> >
> > On Thu, 4 Jun 2009, Homme, James
> > wrote:
> >
> > > Date: Thu, 4 Jun 2009 08:03:21 -0400
> > > From: "Homme, James" <james.homme@xxxxxxxxxxxx>
> > > Reply-To: programmingblind@xxxxxxxxxxxxx
> > > To: "programmingblind@xxxxxxxxxxxxx" <programmingblind@xxxxxxxxxxxxx>
> > > Subject: Visual Basic and SQLite
> > >
> > > Hi,
> > > The below tutorial tells you how to get SQLite and use it with Visual 
> > > Studio Express. Here’s my question. I don’t want to use Visual 
> > > Studio. How do I take that knowledge, write VB in a text editor, and 
> > > still include SQLite? I guess I’m asking what Visual Studio does behind 
> > > the scenes that I would have to recreate.
> > > http://www.kirupa.com/net/sqllite_vb_pg1.htm
> > >
> > > Thanks.
> > >
> > > Jim
> > > ----------
> > > Jim Homme, Usability Engineering.
> > > 412-544-1810.
> > >
> > > Note: I will reply to email and voice mail within four hours.
> > >
> > > "Nothing in this world can take the place of persistence.
> > >
> > > "Talent will not; nothing is more common than unsuccessful people with 
> > > talent.
> > >
> > > "Genius will not; unrewarded genius is almost a proverb.
> > >
> > > "Education will not; the world is full of educated derelicts.
> > >
> > > "Persistence and determination alone are omnipotent."
> > > - Calvin Coolidge (1872-1933)
> > >
> > >
> > > ________________________________
> > > This e-mail and any attachments to it are confidential and are intended 
> > > solely for use of the individual or entity to whom they are addressed. If 
> > > you have received this e-mail in error, please notify the sender 
> > > immediately and then delete it. If you are not the intended recipient, 
> > > you must not keep, use, disclose, copy or distribute this e-mail without 
> > > the author's prior permission. The views expressed in this e-mail message 
> > > do not necessarily represent the views of Highmark Inc., its 
> > > subsidiaries, or affiliates.
> > >
> > __________
> > View the list's information and change your settings at
> > //www.freelists.org/list/programmingblind
> >
> >
> > This e-mail and any attachments to it are confidential and are intended 
> > solely for use of the individual or entity to whom they are addressed.  If 
> > you have received this e-mail in error, please notify the sender 
> > immediately and then delete it.  If you are not the intended recipient, you 
> > must not keep, use, disclose, copy or distribute this e-mail without the 
> > author's prior permission.  The views expressed in this e-mail message do 
> > not necessarily represent the views of Highmark Inc., its subsidiaries, or 
> > affiliates.
> > V'�����l�w�f���ڝ�!jxʋ���m�x,j�m����
> 0~���+-����X���k�
> ښh���b�
> __________
> View the list's information and change your settings at
> //www.freelists.org/list/programmingblind
>
>
> This e-mail and any attachments to it are confidential and are intended 
> solely for use of the individual or entity to whom they are addressed.  If 
> you have received this e-mail in error, please notify the sender immediately 
> and then delete it.  If you are not the intended recipient, you must not 
> keep, use, disclose, copy or distribute this e-mail without the author's 
> prior permission.  The views expressed in this e-mail message do not 
> necessarily represent the views of Highmark Inc., its subsidiaries, or 
> affiliates.
> V'�����l�w��f���ڝ�!jxʋ���m�x,j�m����0~���+-����X���k�
ښh���b�
__________
View the list's information and change your settings at
//www.freelists.org/list/programmingblind

Other related posts: