Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.

ID: 15575, Problem with Stored Procedure Names using SQLServer 7

by David Watt Email: Anonymous

I am getting an error when upgrading from SQLServer 6.5 to 7.
Download Details
FTP  download also available 0 bytes
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For Delphi, Version 4.0  to 5.0 19 downloads
Copyright: No significant restrictions

Size: 0 bytes
Updated on Tue, 06 Feb 2001 07:07:26 GMT
Originally uploaded on Tue, 06 Feb 2001 07:07:26 GMT
We are trying to upgrade an application form using a SQLServer 6.5 database to version 7.
The project build runs successfully. However, when I try to run the new application I get a meeage of the form:
'General SQL Error Could not find stored procedure dbo.LgnByName;1'

It appears this is something to do with the ';1' suffix. I have tried renaming the procedures in the database to include the suffix, however if I then use the SQL Explorer tool, it shows the procedure names with a suffix of ';1;1' !

What is the preffered method of converting SQL 6.5 procedures to SQL 7?

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Could not retrieve comments. Please try again later.

Server Response from: ETNACDC04