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



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

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
.



Relevant Pages

  • Re: Create Storedprocedure with VB6? Is this possible?
    ... VB6 and ADO no .NET ... can SQL Server Management Studio." ... Can VB6 create a stored procedure on the fly. ... something similar) exactly what you're sending to the db engine (via ADO), ...
    (microsoft.public.vb.database.ado)
  • Re: T-SQL and OLE Automation
    ... A library created as type ActiveX.exe will run out of the SQL Server ... To deploy a .dll, you make it, using the VB6 file/make command, then copy to ... Creating COM libraries with VB6 is probably better discussed in a VB ... > OLE automation and I'm not sure how to write the application on the VB6 ...
    (microsoft.public.sqlserver.programming)
  • Re: T-SQL and OLE Automation
    ... components from VB6 now that VB.Net is so well established as that code will ... Choose a path to save the .dll & remember where it is. ... If you are running your SQL Server on that machine, ... >> Greg Linwood ...
    (microsoft.public.sqlserver.programming)
  • Re: Compact SQL Database and ADO
    ... SQL Server 3.5 Compact 3.5 SP1 Database ... Set prmID = .CreateParameter("plngID", adInteger, ... Set prmText = .CreateParameter("pstrText", adVarWChar, ... VB6 to crash. ...
    (microsoft.public.data.ado)
  • Re: Im very confused about the different databases!
    ... I'm confused about the different databases. ... There's DAO, ADO, ADO.NET, Jet, SQL, SQL Server ... SQL Server 2005 with VB6 LE. ... to convert their VB6 code to VB.Net, or even another language. ...
    (microsoft.public.vb.general.discussion)