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

Yes, as I've said it works perfectly when in LAN.... I'm wondering if some other ports need to be accessed from the Internet or if some credentials are passed automatically while in the Domain....
The strange is that everything works (SQL Queries, etc)


"a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@xxxxxxxxx> wrote in message news:7ef0e47d-511a-4806-a44a-1b35d81e1740@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
do you have permissions to the sproc?



On Jul 10, 1:56 pm, "Marcus" <mar...@xxxxxxxxxxxxxxxxxx> wrote:
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
    ... dbo is only ... Unfortunatelly I have noticed that stored procedures have some problems, ... "Run-time error '2812' Could not find stored procedure 'SPInc'. ... fGDataFine & _ ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cant use stored procedure on remote SQL server
    ... "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, ... "Run-time error '2812' Could not find stored procedure 'SPInc'. ... fGDataFine & _ ...
    (microsoft.public.access.adp.sqlserver)
  • Re: ADP: Cant use stored procedure on remote SQL server
    ... I'm using a port only when accessing over the internet. ... Unfortunatelly I have noticed that stored procedures have some problems, ... "Run-time error '2812' Could not find stored procedure 'SPInc'. ... fGDataFine & _ ...
    (microsoft.public.access.adp.sqlserver)
  • Re: BizTalk 2004 SQL Adapter
    ... I received a second sample that only uses ports. ... it does call multiple stored procedures. ... >Everett Yang ...
    (microsoft.public.biztalk.general)