Re: ADP: Can't use stored procedure on remote SQL server
- From: "a a r o n . k e m p f @ g m a i l . c o m" <aaron.kempf@xxxxxxxxx>
- Date: Fri, 11 Jul 2008 07:24:17 -0700 (PDT)
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
.
- Follow-Ups:
- References:
- ADP: Can't use stored procedure on remote SQL server
- From: Marcus
- ADP: Can't use stored procedure on remote SQL server
- Prev by Date: Re: Can't use stored procedure on remote SQL server
- Next by Date: Re: ADP Check Boxes not deselecting
- Previous by thread: Re: Can't use stored procedure on remote SQL server
- Next by thread: Re: ADP: Can't use stored procedure on remote SQL server
- Index(es):
Relevant Pages
|
