The connection is set within the ActiveX script as follows:

Set oConnection = goPackage.Connections.New("SQLOLEDB.1")

oConnection.DataSource ="COMPUTERNAME"

where COMPUTERNAME is the name of the computer on which SQL Server is located. ...

bkelley,

I may ultimately be placing my application onto a different system from SQL Server, so I really appreciate that extra tip.

Thanks again!

bkelley & Steve,

Thank you both SO much. I gave user:

<COMPUTERNAME>\IWAM_<COMPUTERNAME>

the appropriate permissions to SQL Server, and it worked like a charm!!!

With great appreciation,

cherii