| Author |
What database is best for standalone apps?
|
|
| jonescv@gw.ccsd.net 2006-01-09, 9:53 pm |
| I'm writing a Point of Sale app for my fathers business. It is
single-user, standalone. I'm using VS 2003.
Would Jet (Access) engine be best? Make an Mdb file and use that for
the database? Will MS Access have to be installed on that machine?
Any pointers or suggestions will be appreciated.
| |
| Jim Rand 2006-01-09, 9:53 pm |
| Take a look at Sybase SQL Anywhere version 9. It's easy to use and never
breaks. I've been using it since it was Watcom version 4.
The developer license is $0.00 which includes everything.
http://www.provantage.com/sql-anywh...-x~22082934.htm
<jonescv@gw.ccsd.net> wrote in message
news:1136400553.827717.79810@o13g2000cwo.googlegroups.com...
> I'm writing a Point of Sale app for my fathers business. It is
> single-user, standalone. I'm using VS 2003.
> Would Jet (Access) engine be best? Make an Mdb file and use that for
> the database? Will MS Access have to be installed on that machine?
> Any pointers or suggestions will be appreciated.
>
| |
| tdavisjr 2006-01-09, 9:53 pm |
| You can look at :
MSDE
SQL Express 2005
MySql
ALL are FREE!
| |
|
|
| dortoh 2006-01-15, 9:18 pm |
| Does SQL Express or MySQL have to be installed and configured on each end user prior to my program working OR are they embeded into the packaged.exe file from VB.
I currently have an Application that pulls data from an Access DB requiring the end user to have MS Access prior to my program working... I want to get away from anyone needing anything but to install my program with database capabilities.
Thanks for your help.
quote:
Originally posted by tdavisjr
You can look at :
MSDE
SQL Express 2005
MySql
ALL are FREE!
| |
| tdavisjr 2006-01-16, 7:05 pm |
| You can package MSDE and SQL Express into an installer package. There
are articles on MSDN on how to do this. There was on last w on how
to package SQL Express into an installer see:
http://msdn.microsoft.com/sql/expre...qlexcustapp.asp
And I read on a few years back on how to embed MSDE with your apps. As
far as MySQL goes, I have no clue.
| |
| Phil Cairns 2006-01-17, 7:06 pm |
| dortoh wrote:
> Does SQL Express or MySQL have to be installed and configured on each
> end user prior to my program working OR are they embeded into the
> packaged.exe file from VB.
With MySQL, you don't have to install and configure the whole database
on the client machine, but you do have to have one of the connectors
installed. Have a look here: http://dev.mysql.com/downloads.
Find the connector appropriate to your environment (I'm using the ODBC
one), and set it up appropriately in your installation package. In my
case, this consists of copying the DLL to an accessible directory, and
adding the ODBC datasource information to the registry. I got the
registry entries by configuring the data source, then exporting
HKLM\SOFTWARE\ODBC and extract the bits of interest.
Phil
| |
| dortoh 2006-01-17, 7:40 pm |
| Is sql express easier to use for deploying with vb.net? I've been looking at that and it seems a bit easier... There are not many references out there on the net that cover the subject of MySQL and VB.NET. I have looked high and low on the net and at local book stores. However I have just located a lot of books on the SQL Express and VB.NET deployment.
Thank you all for your assistance, great ideas... I have been researching all. Yesturday I installed and configured MySQL and had it up and running. I tested it out in the CMD window and everything worked great... Just didn't find out how to establish a connection in VB.NET environment. No worries I took the advise of checking out SQL Express and just downloaded it and installed it tonight. I'll give it a run and see how easily it interacts with VB.NET.
The Upside: I'm learning a lot, Thanks all. | |
|
|
| dortoh 2006-01-17, 7:45 pm |
| Looks like a great product but cost $. I'm believe SQL Express is the way to go at least I know it's free and am working on it working for me. Thanks for the hand.
quote:
Originally posted by Peter Macej
Try VistaDB from http://www.vistadb.net/
--
Peter Macej
Helixoft - http://www.vbdocman.com
VBdocman - Automatic generator of technical documentation for VB, VB
...NET and ASP .NET code
|
|
|
|