Procedure names ;1

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
This is an old bug: you didn't upgrade these systems with the latest service
packs.
 
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Invalid Column Name Sql-Error :Executing a stored procedure 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
dbo schema problem and permissions 1
Stored Procedure call issue from Access Project 1
PS name problem 3
Access 2000 ADP and SQL Server 2005 2
Stored procedure as row source for a combo box 4
How do I execute a stored procedure 4

Back
Top