Thanks Bill That worked....
BUT In my form when I go to "DataBindings" I get a Pop-up to "Add Project Datasource" then the 2 screens to choose Datasource Type( I select Database) then I choose DataSet. This is where it breaks down."Choose Data Connection there are 4 choices "Access" and 3 server types, then there is <Other> which I select. And that leaves me with a single "Data provider" Microsoft OLE DB simple provider This connection works, but is it correct? The connection is MSDAOSP Then I get to the screen "Choose your database objects" and an ERROR "Selecting Objects of type 'Table' is not supported. Then we get to the next part of the problem. I am in my late 70's and have not done any SQL for over 15 years ( I was pretty good at one time.) Where do I go from here. Jay On Sat, Apr 25, 2015 at 5:12 PM, Drago, William @ CSG - NARDA-MITEQ < William.Drago at l-3com.com> wrote: > I don't know what error you're getting so I can't offer specific help. > > This is what works for us: > > Open your project in Visual Studio. > > Click Tools > NuGet Package Manager > Manage NuGet Packages for Solution... > > Select Online > nugget.org > > In the search box enter system.data.sqlite > > A list of packages should be displayed after a short wait. > > Select System.Data.SQLite Core (x86/x64) or, if you need LINQ and Entity > Framework support, select System.Data.SQLite (x86/x64), then click Install > (we use Core here) > > After installation you should see a little green checkmark next to the > package you selected. > > Click Close and you're done. Check on line for VB.NET code samples using > SQLITE. > > Good luck, > > -- > Bill Drago > Senior Engineer > L3 Narda-MITEQ > 435 Moreland Road > Hauppauge, NY 11788 > 631-272-5947 / William.Drago at L-3COM.com > > > > > -----Original Message----- > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith > > Sent: Saturday, April 25, 2015 3:50 PM > > To: General Discussion of SQLite Database > > Subject: Re: [sqlite] building SQLite DLL with Visual C++ > > > > Hi Bill > > > > I have been trying for 2 days and I am totally lost. > > > > I have NuGet Package Manager. I don't know how to use it. > > > > From the PM> System.Data.SQLite I get an error. > > > > Can you be a little more specific. > > > > Jay > > > > On Thu, Apr 23, 2015 at 4:08 PM, Drago, William @ CSG - NARDA-MITEQ < > > William.Drago at l-3com.com> wrote: > > > > > > -----Original Message----- > > > > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite- > > > > users-bounces at mailinglists.sqlite.org] On Behalf Of Jay Smith > > > > Sent: Thursday, April 23, 2015 3:47 PM > > > > To: General Discussion of SQLite Database > > > > Subject: Re: [sqlite] building SQLite DLL with Visual C++ > > > > > > > > Thank you Adam for responding to my post. I have the windows > > > > binaries downloaded. > > > > > > > > At this point I am just following the instructions in the book. And > > > > I really am not sure what I need the dll for. > > > > > > > > Here's the scenario. I have created a program in vb2012. The > > program > > > > stores less than 20 fields of data. I am currently saving the data > > > > in a html format. I just recently discovered SQLite. I am now in > > the > > > > process of changing over to a database to store data. I studied SQL > > > > and Oracle > > > > 10 years ago. I have almost completed the database for the project. > > > > My problem is how to integrate the SQL db into my VB program. > > > > > > Your subject line says C++, but the line above says VB, so is your > > > program written in C++ or VB? > > > If it's VB just get SQLite with NuGet (Tools > NuGet Package Manager, > > > then search for System.Data.SQLite Core). > > > > > > -Bill > > > > > > > > > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and > > > any attachments are solely for the use of the addressee and may > > > contain information that is privileged or confidential. Any > > > disclosure, use or distribution of the information contained herein > > is > > > prohibited. In the event this e-mail contains technical data within > > > the definition of the International Traffic in Arms Regulations or > > > Export Administration Regulations, it is subject to the export > > control > > > laws of the U.S.Government. The recipient should check this e-mail > > and > > > any attachments for the presence of viruses as L-3 does not accept > > any > > > liability associated with the transmission of this e-mail. If you > > have > > > received this communication in error, please notify the sender by > > > reply e-mail and immediately delete this message and any attachments. > > > _______________________________________________ > > > sqlite-users mailing list > > > sqlite-users at mailinglists.sqlite.org > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users at mailinglists.sqlite.org > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any > attachments are solely for the use of the addressee and may contain > information that is privileged or confidential. Any disclosure, use or > distribution of the information contained herein is prohibited. In the > event this e-mail contains technical data within the definition of the > International Traffic in Arms Regulations or Export Administration > Regulations, it is subject to the export control laws of the > U.S.Government. The recipient should check this e-mail and any attachments > for the presence of viruses as L-3 does not accept any liability associated > with the transmission of this e-mail. If you have received this > communication in error, please notify the sender by reply e-mail and > immediately delete this message and any attachments. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
