Главная страница | назад





Article #20590: Stored Procedures not working in MS-SQL 7

Question:

Why can't I use my MS-SQL 6.5 stored procedures in MS-SQL 7.0?

Answer:

Although the BDE can be used to connect to MS-SQL 7 tables, it only supports MS-SQL 6.5 features. Here's why.

In this case the new feature in MS-SQL 7 that is not supported is the ability to have two stored procedures with the same name and different parameters. You will notice Stored Procedures in MS-SQL 7 have a ;1 or ;2 after the name. If you have a procedure with a ;1 after it you should be able to remove the ;1 and use it without a problem. If it has a ;2 or higher after it you should rename the procedures which have the same name, and remove the ;# and then it should work okay.

Last Modified: 11-OCT-00