Connection Object
This object is the one used to connect to database, which is then used to execute commands against the database or retrieve a Recordset. The object has the ConnectionString property that is used to specify the database you want to connect to. The Open method establishes the database connection. The Close method releases the connection and the memory used by the object.
The Connection String can be generated at run time using the DataLinks. Please see the topic Building Database Connection String Programmatically.
Connection String Attributes:
Provider – The provider name or driver name that ADO will use to access the database.
User ID – When needed, it is used by the provider to establish the proper rights for accessing the database.
Password – To validate the user, the user’s password is needed by the provider.
Integrated Security – Setting this value to SSPI, the driver will use the Windows NT Integrated
Security. User ID and Password are not used when this is done.
Data Source – If you are connecting to an Access database, this should be set to the file and complete path of the file. This should have the machine name when connecting SQL Server.
Initial Catalog – This attribute should have the database name when connecting to SQL Server.
Recordset Object
This object is important because it is used to manipulate databases. It is a memory allocation in a client computer or server that has a set of rows of one table or more of the database. With Recordset, you can add, edit, delete and update records of the actual table in the database.
Command Object
This object has the information about the command to be executed. The command object could have a Query (SQL) command, Table, View or Stored Procedure.
| Click here to subscribe and receive Pro-business Excel VBA Programming tips. |
1 comments:
I'm glad to have visited your blog and good to know you! I find it interesting and informative.
Post a Comment