Hi all!


I am getting a problem in the following code(in an active-x script task) which connects to sql server to get the count of records in a table.

cn.Provider = "sqloledb"
cn.Properties("Data Source&#34.Value = "."
cn.Properties("Initial Catalog&#34.Value = "dbname"
cn.Properties("Integrated Security&#34.Value = "SSPI"
cn.Open

The error message i am getting is

error code = 0
error source = Micorsodt OLE DB provider for SQL Server
error description = [dbmssocn].General network error.Check your network documentation.


The same code was working previously.Service pack-2 was applied to the server recently.i am wondering whether that could make a difference?