Re: Which Back-End Affordable Database do you RECOMMEND???



On Mon, 21 Aug 2006 18:54:52 GMT, Alan Mailer <clarityassoc@xxxxxxxxxxxxx> wrote:

¤ I need to hear from you experts what database system you prefer to use
¤ when you're creating a VB6 app that is going to need an *affordable*
¤ (relatively low budget) back-end database. The system might have at
¤ most 15 users at any one time.
¤
¤ To give you a bit of a benchmark, though I have used SQL Server in the
¤ past, I think SQL Server is too high-end for this current job.
¤ 'Access' might do (you tell me), or even MySQL, or something else you
¤ might mention.
¤
¤ My priority is keeping costs down, but, most importantly, finding a
¤ database that works well with VB6.
¤
¤ Thank you in advance for any/all feedback that you'd care to share.

From Microsoft I would recommend SQL Server Express. From a third party source any of the following
would probably work for you:

http://www.vistadb.net/vistadb_server.asp
http://www.firebirdsql.org/
http://www.mysql.com/


Paul
~~~~
Microsoft MVP (Visual Basic)
.



Relevant Pages

  • Re: Load Picture from MS Access to VB6
    ... in code to compact the database via a menu option. ... there is a chance the filename of the photo itself can ... > ¤ Well, I figured it out I think. ... loaded images into the database directly through Access (so that I could ...
    (microsoft.public.vb.general.discussion)
  • Re: Please Help Me in Visual Basic 6.0 SP6
    ... Dim dbPath As String ... Above is my programming where in this programming, ... how can i indicate myself which one i'm gonna insert to the database. ... > ¤ solution where as somebody can help me where to start. ...
    (microsoft.public.vb.database)
  • Re: Any reason why accessing Access should slowdown?
    ... On the MSACCESS / JET OLEDB front, you responded to a query I had about the ... Declared connection to Access database using string based on Jet OLDB ... Set up recordset filter in response to earlier input / selection ... ¤ I am writing a VB6 App using an Access database backend ...
    (microsoft.public.vb.database)
  • Re: Copy database schema from Access to SQL Server
    ... It can import a JET database in a single stroke. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ¤ projects to SQL Server, ... schema and then use DDL code to create the corresponding objects in SQL Server. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Dynamic MDB creation for specific formats 2000-2007
    ... If the specific format could be created from the outset - ... the resulting database - if they were - wouldn't care about any of this. ... ¤ If the database is being created on one system which by default creates ... It doesn't matter when accessing the database through Jet ADO or DAO. ...
    (microsoft.public.vb.database.ado)