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

Tech-Archive recommends: Fix windows errors by optimizing your registry

Stefan Berglund wrote:
On Mon, 21 Aug 2006 Alan Mailer 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.

SQL Server works great. I'm in the process of migrating all my VB6 DB
apps from SQL Server to PostgreSQL which also works great and is ~FREE~.
If you try PostgreSQL make sure you get the OLEDB driver. Then you can
switch back and forth (assuming you're using the SS OLEDB driver) by
simply changing the connection string. All the rest of your code
remains the same.
I'm migrating because I think it's only a matter of time before the MSDE
I'm currently using won't install on a future m$ OS such as Vista. The
SS Express or whatever it's called is out of the question because it's
infected with all that .NET crap and runs like molasses compared to
MSDE.
Hope this helps,
Stefan Berglund

Thanks Stefan,

I was interested in alternatives to MS and PostgreSQL looks really good.

Mike
.

Relevant Pages

  • Trying to choose database topology for new application
    ... My first real question is what to use as the back-end database engine. ... Seems like a version of MSDE for workstations, w/ SQL server on the ... I have not worked with replication on SQL servers and am not sure what ...
    (microsoft.public.sqlserver.replication)
  • Re: Selecting Date in SQL statement
    ... > Dim oConn ... The Field Ende is a Date- ... If the back-end database is Access try ... For anything else I'd first try the SQL Server style and if that fails post ...
    (microsoft.public.vb.database)
  • best use of vb.net and multithreading
    ... I'm going to rewrite a VB6 app to VB.net and I need some pointers. ... ActiveX.exe 'workers' which query a SQL Server database and BCP a load ...
    (microsoft.public.dotnet.languages.vb)
  • How to kill a connection left behind?
    ... I have a VB6 app to do some data import from a SQL server to an Access ... be an ado connection left behind, tried to restart the machine, ... The access file is saved on server so instead of restarting it, ...
    (microsoft.public.vb.general.discussion)
  • Re: Recommended Approach
    ... Have the vb6 app do a xmlhttp post to your web server and have it do the ... The SQL Server resides locally behind the company's firewall. ... > make a direct ADO connection from the user's PC to our SQL Server. ... > Both alternatives require opening up a port on our firewall to allow SQL ...
    (microsoft.public.sqlserver.security)