Re: ADP: Can't use stored procedure on remote SQL server
- From: "Marcus" <marcus@xxxxxxxxxxxxxxxxxx>
- Date: Sun, 13 Jul 2008 12:54:36 +0200
I'm using a port only when accessing over the internet.
"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:577484a7-0a00-4812-987b-46301b1bf779@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
are you using a different port?
Do you need to be?
try removing the port
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
.
- References:
- ADP: Can't use stored procedure on remote SQL server
- From: Marcus
- 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
- ADP: Can't use stored procedure on remote SQL server
- Prev by Date: Re: ADP: Can't use stored procedure on remote SQL server
- Next by Date: Re: ADP: Can't use stored procedure on remote SQL server
- Previous by thread: Re: ADP: Can't use stored procedure on remote SQL server
- Next by thread: ADP Check Boxes not deselecting
- Index(es):
Relevant Pages
|
Loading
