Home > Archive > MS Access project with SQL Server > April 2006 > Procedure names ;1









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Procedure names ;1
onyx dave

2006-03-06, 7:30 pm

Just upgraded database from SQL 2000 to 2005. All works fine on development
computer. Other users computers are showing different problems. The
strangest is that the stored procedures are showing up as

procedure_name;1 (dbo)

When you run the procdure it prompts for required paramaters but then says
it can not find it.

What dll's are used to access SQL database?

Sylvain Lafontaine

2006-03-06, 7:30 pm

This is an old bug: you didn't upgrade these systems with the latest service
packs.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"onyx dave" < onyxdave@discussions
.microsoft.com> wrote in message
news:ED00489C-BEFB-41A9-9062- EC042A9B2B00@microso
ft.com...
> Just upgraded database from SQL 2000 to 2005. All works fine on
> development
> computer. Other users computers are showing different problems. The
> strangest is that the stored procedures are showing up as
>
> procedure_name;1 (dbo)
>
> When you run the procdure it prompts for required paramaters but then says
> it can not find it.
>
> What dll's are used to access SQL database?
>



onyx dave

2006-03-06, 7:30 pm

Thks

"Sylvain Lafontaine" wrote:

> This is an old bug: you didn't upgrade these systems with the latest service
> packs.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "onyx dave" < onyxdave@discussions
.microsoft.com> wrote in message
> news:ED00489C-BEFB-41A9-9062- EC042A9B2B00@microso
ft.com...
>
>
>

Nikola Milic

2006-04-06, 3:29 am

Hi Sylvain,
I have similar problem like described below. I did update my computers with
latest SPs. Some of computers can see procedures properly, some not.

Can you please send more info.

Thanks in advance
Nikola Milic


"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:uslls0BPGHA.2924@TK2MSFTNGP11.phx.gbl...
> This is an old bug: you didn't upgrade these systems with the latest
> service packs.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
>
> "onyx dave" < onyxdave@discussions
.microsoft.com> wrote in message
> news:ED00489C-BEFB-41A9-9062- EC042A9B2B00@microso
ft.com...
>
>



Sylvain Lafontaine

2006-04-06, 3:29 am

Are you sure that every machine has been upgraded to the latest service pack
and that they have been rebooted after that?

If there is still a problem, then maybe you will have to install the latest
MDAC as well; see at the right of the following page:

http://msdn.microsoft.com/data/Default.aspx

If you still have a problem after that, then please state the configuration
of the machine with this problem.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Nikola Milic" <hotmnikola@hotmail.com> wrote in message
news:elZxVvTWGHA.3496@TK2MSFTNGP05.phx.gbl...
> Hi Sylvain,
> I have similar problem like described below. I did update my computers
> with latest SPs. Some of computers can see procedures properly, some not.
>
> Can you please send more info.
>
> Thanks in advance
> Nikola Milic
>
>
> "Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
> wrote in message news:uslls0BPGHA.2924@TK2MSFTNGP11.phx.gbl...
>
>



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com