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


Thanks for clarifying this. I went to Borders yesterday & browsed thru books
on ADO.NET & SQL Server. I understand databases better now. I found out from
browsing around the newsgroups, that I can use SQL Server with VB6. I believe
that I read that SQL Server uses the .NET runtime. Is that correct? So, then,
if I want to distribute a VB6 program that uses SQL Server, I'd have to
include the .NET runtime, wouldn't I? I also found out in MSDN that I can use
the .NET classes in VB6. I didn't completely understand the technobabble.
Something about COM objects & wrappers. I found out from my reading that
ADO.NET is a bunch of classes & libraries. Therefore, I should be able to use
ADO.NET with VB6, correct?

Thank you. David

"Ralph" wrote:


"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.

What database & version comes with VB6 LE?

What databases can I use with VB6 LE?

What is the most current database that I can use with VB6 LE?

How do I uninstall the ones that I don't want?

What are the differences between the various databases?

I have XP Pro with service pack 2. When I check Add-Remove Programs, the
only database that I see is SQL Server 2005.

Why isn't Jet or whatever VB6 LE uses listed in Add-Remove Programs?

How do I remove Jet?

Thank you. David

Wow!

A couple of zillion questions there. <g>

AFAIK, the LE edition is only limited in the ability to compile executables,
but I'm not that sure. (Someone else will gladly fill in the gap.)

Before routing you to a bunch of URLs and Help Articles, here is 40,000 foot
view that may help.

Database access takes several layers of components. You access the services
of these components thru Data Access and Object Libraries or APIs,
providers, and drivers.
So you always have something like this whether you are using VB, C++,
Delphi, etc....
Your Code (VB, VB.Net) - talks to ->
A Data Access Library (DAO, ADO, OO4O, ADO.Net, ...) - talks to ->
Provider/Driver (ODBC, OLEDB, SQL.Net) - talks to ->
Database Engine/Server (SQL Server, MS Jet, MySQL, ...) - talks to ->
The Data

[I include VB.Net and ADO.Net for completeness, but since you are using VB I
won't mention it again.]

You can have a variety of configurations dependent on what "Data Access
Library" and the Database you chose to use .

So you can use any database, in your case it makes sense to just use
SQLServer.
Note: SQLServer is a RDBMS "server". Thus it is a running application.
MSAccess on the other hand is file-based and thus uses the Jet engine - but
is not a "running" application. That is why you don't see it has an
application.

You do not need to remove Jet. Usually you will need it for other MS
applications. In fact at the moment don't mess with anything just attempt to
connect your VB code with SQL Server.

For your situation as presented, just concentrate on the following tools.
1) Use ADO as your Data Access Library
Select it in References
2) Use the "Microsoft OLE DB Provider for SQL Server"
Select it in your connection string.
Get a connection string from here.
http://www.connectionstrings.com/

Just ignore the other technologies for now.

There are tons of source code, examples, and tutorials on the web. But I
recommend getting a good book, just so all the dots are covered.
Give you something to play with...
http://www.programmersheaven.com/download/36232/download.aspx

If you get stuck post back with code.


hth
-ralph







.

Relevant Pages

  • Re: Im very confused about the different databases!
    ... There's DAO, ADO, ADO.NET, Jet, SQL, SQL Server ... What database & version comes with VB6 LE? ... What is the most current database that I can use with VB6 LE? ... Why isn't Jet or whatever VB6 LE uses listed in Add-Remove Programs? ...
    (microsoft.public.vb.general.discussion)
  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: MS Access DAO -> ADO.NET Migration
    ... full SQL Server and I see the logic you explained in a multi user ... allow two users to access the same database file Read/Write at any given ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... Hitchhiker's Guide to Visual Studio and SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MS Access DAO -> ADO.NET Migration
    ... For that it is much harder to handle the incremental identifier, ... database but although they have the data, they are not connected at the same ... The book was a pleasure to read after the gibberish that Microsoft 'puts ... SQL Server Management Studio is nowhere to be found on my ...
    (microsoft.public.dotnet.framework.adonet)
Loading