The error happens when the prepareCall method is called.
I listed all the stored procedures and the prc_GetRES_LegalAddr procedure does not appear as part of the list.
There's an ASP which uses the same procedure and it works,
I think I need to pass additional info to the URL info, passed in the getConnetion() method???
With cmd.ActiveConnection =
"Provider=SQLOLEDB.1,Password=passw,Persist Security Info =True;
User ID=user;Initial Catalog=FSLegal;Network Address=172.17.192.51:1433;Network Library=DBMSSOCN;Application Name=FAST WEB"
Should I maybe pass the Network Library (i.e., DBSMSCON) in my URL?
since the stored prcedure does not exist as part of this connection.
Maybe it is located on this Network Library (different Path).