Solved

what is difference between these two......

Posted on 2003-11-27
6
301 Views
Last Modified: 2012-05-04
what is difference between these two
dim cn as connection
or
dim db as database

Help!!!!!
0
Comment
Question by:samarjit_de
  • 2
6 Comments
 
LVL 8

Accepted Solution

by:
SNilsson earned 25 total points
ID: 9833512
In most cases...

Dim db as database
This can refer to a Access database.

Dim cn as connection
This can refer to a ADO connection

Since you dont type it out explicitly the 'connection' could refer to a DAO connection.

Dim cn as ADODB.connection   (this would tell for sure what type it is)

0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 25 total points
ID: 9833979
The difference is in the function they perform.

A database is a file on the computer that is managed by a database program.
    For instance the MS Access sample database NorthWinds.mdb

A connection is a programming object that is used to gain access to a file generally a database but not always.
For VB to open and use a database a connectioin to the database must be established.

mlmcc
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 10319469
Split
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is about my first experience with programming Arduino.
Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question