SQL Server 7.0 versus SQL Server 6.5

SQL Server 7.0 versus SQL Server 6.5

Post by Richard Bergman » Tue, 16 Jun 1998 04:00:00



Dear,

SQL Server 6.5 has a system table called SysProcedures. When programming in
Delphi using the component TStoredProc it is possible to select a stored
procedure. The component uses the system table SysProcedures to show all the
stored procedures.

On SQL Server 7.0 this system table SysProcedures no longer exists. This
causes an error with the component TStoredProc, this component can't show
all stored procedures and returns the error that de table SysProcedures
don't exists and therefore can't find the stored procedures.

Does someone know a solution to my problem ?

Thanx for your reactions,
    Richard Bergmans

 
 
 

SQL Server 7.0 versus SQL Server 6.5

Post by Neil Pik » Tue, 16 Jun 1998 04:00:00


Richard,

 You'll need to talk to Borland about that - many of the system tables
are different under SQL 7.

 Neil Pike MVP/MCSE
 Protech Computing Ltd

 
 
 

1. Use of SQL Server 7.0 Client with SQL Server 6.5 Server

My company has acquired an application that runs better under SQL Server
7.0 Client than SQL Server 6.5 Client. Seeing as we have not yet
migrated to SQL Server 7.0, can I install the 7.0 Client and run the
application with the SQL 6.5 Databases. Are there any problems
associated with this manoeuver ? What should I be careful of ? Is SQL 7
Client completely backward compatible with SQL Server 6.5 ?

2. Help! DAO Error 3196 when compacting database

3. migrating sql databases sever 6.5 from sql server 6.5 to another sql server 6.5

4. Help

5. Registering a SQL Server 6.5 from SQL Server 7.0

6. Help with Stream read error,please.

7. Upgrade from SQL Server 6.5 +SP5a (in french) to SQL Server 7.0 (US)

8. Job opportunities in sunny Florida

9. HEEEEEEELPPPPP!!! Sql Server 7.0 / Sql Server 6.5

10. ERROR 16940 IN SQL SERVER 7.0 BUT NOT IN SQL SERVER 6.5

11. Converting SQL Server 7.0 Scripts to SQL Server 6.5

12. ERROR 16940 IN SQL SERVER 7.0 BUT NOT IN SQL SERVER 6.5

13. How to configure the SQL Server 6.5 Publisher to use a SQL Server 7.0 Distributor