Site Tools


Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
developer:scriptsamples:database [2015/11/11]
sandy
developer:scriptsamples:database [2015/11/11] (current)
sandy
Line 7: Line 7:
 The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using the utilities supplied with the server. The first thing you need is the database, of course. A variety of programs can be used to create it, but probably the most popular is Microsoft Access. You can also use FoxPro or create it directly in an SQL Server using the utilities supplied with the server.
  
-In this example, we will connect to a simple Microsoft Access database. You can download the database used in this demonstration here:+In this example, we connect to a simple Microsoft Access database. You can download the database used in this demonstration here:
  
 http://​en.wiki.mcneel.com/​content/​upload/​files/​test_access_mdb.zip http://​en.wiki.mcneel.com/​content/​upload/​files/​test_access_mdb.zip
  
-Most VBScript developers use Microsoft'​s ADO (ActiveX database objects) to get data from database. ADODB is comprised of three main objects: Connection, RecordSet, and Command. We will demonstrate the first two objects.+Most VBScript developers use Microsoft'​s ADO (ActiveX database objects) to get data from the database. ADODB is comprised of three main objects: Connection, RecordSet, and Command. We will demonstrate the first two objects.
  
 =====Connecting to a database===== =====Connecting to a database=====
developer/scriptsamples/database.txt ยท Last modified: 2015/11/11 by sandy