Re: I'm very confused about the different databases!

"pcnerd" <pcnerd@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:36BDB91F-42FE-4CF7-8820-923FC0E0283F@xxxxxxxxxxxxxxxx
I have VB6 Learning Edition(hereafter, referred to as VB6 LE). I don't know
what databse came with it. I'm confused about the different databases.
There's DAO, ADO, ADO.NET, Jet (in its various versions), SQL, SQL Server
2005. You can see why I'm confused! I've browsed around VB6 LE & I see
different version numbers. I browsed around MSDN & found out that I can
use
SQL Server 2005 with VB6 LE. I have SQL Server 2005 installed on my PC. I
don't want to have a bunch of databases on my PC. So, I have some
questions.

Are you a student or planning to work as a software developer in the future?
If so, why not learn VB.Net instead(As much as I don't like it). Many
companies now offer jobs for dotnet compared to VB6(I already searched for
US jobs), and by the time you graduate, you may find yourself having to
learn another language. There are many differences between VB6 and VB.Net,
in particular in multithreading, db access, graphics, and Unicode support.
Although you could use 3rd party Unicode controls with VB6. VB6 was released
in 1998, 8 years ago. VB.Net was first released in late 2002.

Even if you learn VB.Net, you will still encounter companies that want you
to convert their VB6 code to VB.Net, or even another language. Converting
VB6 code is a full time job, the upgrade tool in VB.Net fills your VB6
project with all sorts of TODO lines, which require manual conversion and
often a re-write. For instance, VarPtr() is not supported in dotnet, so if
you use many API calls, then a rewrite is the only option.

Here is a link that shows the differences between the 2 languages:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcn7/html/vaconDifferencesBetweenVB6AndVB7.asp

This is more about a career choice than anything else.

VB.Net 2005 can be downloaded off the web for free:

http://msdn.microsoft.com/vstudio/express/default.aspx

Link to quick start guides, start with "The Common Tasks QuickStart" here:
http://samples.gotdotnet.com/quickstart/

Note: *.vb.* groups are for VB6 or prior only. Microsoft broke compatibility
between VB6 and VB7(VB.Net) and after. Answers that you get in these groups
maybe incorrect, or not the recommended way in dotnet.



.

Relevant Pages

  • Re: Create SQL Server database from VB6.
    ... Any version of VB6 can execute the correct DDL commands to SQL Server to ... Some versions of VB6 can do it right in the IDE. ... can create databases etc. ...
    (microsoft.public.vb.database)
  • Re: Create SQL Server database from VB6.
    ... > Any version of VB6 can execute the correct DDL commands to SQL Server to ... Some versions of VB6 can do it right in the IDE. ... > at it) it can create databases etc. ... >> Is it possible to create a Sql Server database from a VB6 application via ...
    (microsoft.public.vb.database)
  • 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
    ... 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)