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 ; or ;2 after the name. If you have a procedure with a ; after it you should be able to remove the ; 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.