MS SQL 7.0 and Delphi 4 - stored procedures

ptickler

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

MS SQL 7.0 and Delphi 4 - stored procedures

We have just installed MS SQL 7.0, using Delphi 4, but get error messages
when trying to connect to existing Stored procedures ('Could note find
stored procedure <name>'). This seems to be because Delphi is looking for a
sysprocedures table, but this has been removed in SQL 7.0 and replaced by
syscomments table. How do I get round this? Help!!

Kevin Frever

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MS SQL 7.0 and Delphi 4 - stored procedures

ptickler,

Upgrade to BDE 5.10. It has the latest SQL links for MSSQL 7.0.

Good luck,
krf

Quote

ptickler wrote in message <80oo0c$p...@forums.borland.com>...
>We have just installed MS SQL 7.0, using Delphi 4, but get error messages
>when trying to connect to existing Stored procedures ('Could note find
>stored procedure <name>'). This seems to be because Delphi is looking for a
>sysprocedures table, but this has been removed in SQL 7.0 and replaced by
>syscomments table. How do I get round this? Help!!

Wayne Sheffiel

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:MS SQL 7.0 and Delphi 4 - stored procedures

Quote

ptickler wrote:

> We have just installed MS SQL 7.0, using Delphi 4, but get error messages
> when trying to connect to existing Stored procedures ('Could note find
> stored procedure <name>'). This seems to be because Delphi is looking for a
> sysprocedures table, but this has been removed in SQL 7.0 and replaced by
> syscomments table. How do I get round this? Help!!

Your problem is likely to be that your StoredProcedureName is set to
dbo.xxx;1. Apparently, the SQL 7 driver {*word*88}s on the ";1" part, just
remove it and see if it works then.

HTH,
Wayne
--
Bogus email address - use wgshef instead, keep the domain.

Other Threads

1. DELPHI 4 C/S, MS SQL 7.0 and Stored Procedures

2. Calling a stored procedure in another stored procedure in SQL Server 7.0

3. How to create extended stored procedures for MS SQL 7.0

4. How to create extended stored procedure for MS SQL 7.0

5. MS SQL 7.0 Stored Procedures

6. MS SQL Server 7.0 stored procedure

7. MS SQL 7.0 Extended Stored Procedures

8. SQL Server 7.0 with Delphi 5.0 - stored procedures with parameters - Native BDE driver

9. Delphi 5.0 + SQL Server 7.0 + Stored Procedure

10. Delphi ODBC API-SQL 7.0 Store Procedure Problem