Re: I'm very confused about the different databases!
- From: "Ralph" <nt_consulting64@xxxxxxxxx>
- Date: Sat, 12 Aug 2006 11:43:21 -0500
"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'tknow
what databse came with it. I'm confused about the different databases.use
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
SQL Server 2005 with VB6 LE. I have SQL Server 2005 installed on my PC. Iquestions.
don't want to have a bunch of databases on my PC. So, I have some
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
.
- Follow-Ups:
- Re: I'm very confused about the different databases!
- From: pcnerd
- Re: I'm very confused about the different databases!
- From: pcnerd
- Re: I'm very confused about the different databases!
- Prev by Date: Re: I'm very confused about the different databases!
- Next by Date: Re: What's the difference between a MAK file & a VBP file?
- Previous by thread: Re: I'm very confused about the different databases!
- Next by thread: Re: I'm very confused about the different databases!
- Index(es):
Relevant Pages
|
