javascript asp教程创建数据库连接(2)

var myConnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="; 
myConnect += Server.MapPath("\\ASP") 
myConnect += "\\GlobalScripts\\htmlColor.mdb;";

That does look different than a VBScript connection string. As a matter of fact, let's compare.

Dim myVBconnect;
myVBconnect = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=";
myVBconnect += Server.MapPath("\ASP") 
myVBconnect += "\GlobalScripts\htmlColor.mdb;";

We already talked about escape characters in lesson 02. We won't revisit them here. Down below you'll see that we use myConnect as an argument in the Open() method.

Managing the Connection:

I want you to pay attention to the next four lines of code that I reprinted below. First we instanciate a Connection Object.

var ConnectObj = Server.CreateObject("ADODB.Connection");

Then we open the Connection.

ConnectObj.Open (myConnect);

Then the Connection Object becomes the second argument in the Recordset Open() method.

RS.Open(sql,ConnectObj,adOpenForwardOnly,adLockReadOnly,adCmdText);

And lastly, when we are finished with the Connection, we close it.

ConnectObj.Close();

Next Up:

There is a lot of code left unexplained in this example. We'll repeat the same script in lesson 17 and go over most of what we left out the first time through.