ADP: Can't use stored procedure on remote SQL server

I'm happily using a remote SQL server over the internet using Sylvain Lafontaine's suggestion:

"use a comma to specify the port number as in a.b.c.d,1433"

Unfortunatelly I have noticed that stored procedures have some problems, that is
they don't execute at all when launched remotely... is there a particular
reason, in your opinion, why this happens? While in LAN, they work perfectly....

The error is:


"Run-time error '2812' Could not find stored procedure 'SPInc'.


here's the offending code:
***********************

spstring = "exec SPInc '" & _
fGDataFine & _
"' , '" & _
fGDataInizio & _
"'," & _
Me.Anno & "," & _
Me.Mese & "," & _
AnnoPrec & "," & _
MesePrec & "," & _
spOrderBy


Me.RecordSource = spstring
**************************

I

.

Relevant Pages

  • Re: Cant use stored procedure on remote SQL server
    ... "use a comma to specify the port number as in a.b.c.d,1433" ... fGDataFine & _ ...
    (microsoft.public.access.adp.sqlserver)
  • Re: New transaction cannot enlist in the specified transaction coordinator
    ... receive data from table in receive port from remote SQL server. ... The adapter "SQL" raised an error message. ... The SQL Server machine is running on remote Windows 2000 with cluster ...
    (microsoft.public.biztalk.general)
  • Opening Ports on Cisco 806 Router
    ... I think I need to change the access list of ou cisco 806 router, ... that I can connect to a remote sql server on port 1433. ...
    (comp.dcom.sys.cisco)
  • WCF-SQL call a SQL Server behind VPN
    ... The remote SQL Server 2005 only has port 80 and port 443 open, ... a Biztalk 2009 server on another lab which has to access the data. ...
    (microsoft.public.biztalk.general)
  • Database Timeout error
    ... I am trying to coonect to a remote SQL Server (they ... changed the default port to some 8080). ... aliasing in Client Network Utility of SQL with IP:Port, ...
    (microsoft.public.inetserver.iis)
Loading