by Hi, everyboday! Please help me!
I have the following error when I run the asp page in which I call COM
component. This COM component accesses the SQL server through ADO.
The error is:
pubserver.titleupdate.Post error '80004005'
[Microsoft][ODBC SQL Server Driver][DBNMPNTW]ConnectionOpen (CreateFile()).
The SQLServer Security is configured as Integrated Securtiy. The user
account, admin, is assigned as privilege "sa" using SQL Server Security
Manager.
The SQLServer sits in different machine from the IIS. The SQLServer used
Named Pipe protocol.
<%
Set obj = Server.CreateObject("pubserver.titleupdate")
strtitle = "BU1032"
amount = 1
strdsn = "tryjiangsu"
id="admin"
pwd="author"
'call the COM component
result = obj.Post(strtitle,amount,strdsn,id,pwd)
%>
Com component written in VB5:
Public Function Post( ) As String
On Error GoTo ErrorHandler
' obtain the ADO environment and connection
Dim adoConn As New ADODB.Connection
Dim varRows As Variant
adoConn.ConnectionString = "driver={SQL
Server};server=140.184.132.199;uid=admin;pwd=author;database=pubs"
adoConn.ConnectionTimeout = 60
adoConn.Open
' update the price
Dim strSQL As String
strSQL = "UPDATE titles SET price = price + " + Str$(amount) + " WHERE
title_id ='" + title + "'"
adoConn.Execute strSQL, varRows
...
If I use the Standard Security of SQL Server and user ID as "sa", password
as "", everything is fine.