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".Value = "."
cn.Properties("Initial Catalog".Value = "dbname"
cn.Properties("Integrated Security".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?