K Manley 15.Mar.07 03:28 PM a Web browser LEI LEI - All Releases Windows 2000
Description: [DBNMPNTW]Specified SQL server not found.
Trying to connect to SQL server 2000 using agent.runonserver method
agent is called from a button using [Call agent.RunOnServer] no paramaters are being passed to the agent
Set con = New LCConnection("oledb")
con.Provider = "SQLOLEDB"
con.Metadata = "dbo.rp_wrd"
con.Database = "DB_Name"
con.Userid = "User_ID"
con.Password = "PW"
Agent performs as expected when run manually. This error only happens when using agent.runonserver
I have verified agent execution privileges
Verified network libraries installed on SQL server (both tcpip & named pipes) is using DBNETLIB.dll ver 8.0.341
Performed DCTest.exe successfully from Domino Server
I have verified SQL is listening on correct tcpip port (default port) verified through registry
I have logged into Domino server and run the agent with server id (Manually agent works, run with runonserver agent throws error)
I have created an ODBC connection from my laptop to sql server and have connected