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

As Sylvain said, you need to use the *correct* schema prefix. dbo is only
an example, which I gave because it's the default. It's not necessarily the
one you should be using, you need to check the object.


"Marcus" <marcus@xxxxxxxxxxxxxxxxxx> wrote in message
news:db2dnWWpa4ZPwurVnZ2dnUVZ_uqdnZ2d@xxxxxxxxxxxxxxxx
No.. same error....



"bcap" <bcap@xxxxxxxxxxxxxx> wrote in message
news:48770e92$0$2918$fa0fcedb@xxxxxxxxxxxxxxxxx
You might try qualifying the SP name with the schema name e.g.

exec dbo.SPInc


"Marcus" <marcus@xxxxxxxxxxxxxxxxxx> wrote in message
news:HY-dnTZcKYPu6uvVRVnyiwA@xxxxxxxxxxxxxxxx
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" ... 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 wondering if some other ports need to be accessed from the Internet or if some credentials are passed automatically while in the Domain.... ... 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)
Loading