Board index » delphi » Sql Server 2000 & Sql Server 7.0

leon

Delphi Developer
Fri, 05 Nov 2004 10:11:47 GMT

Sql Server 2000 & Sql Server 7.0

Hi, I transfered my application database from sqlserver 7.0 to
sqlserver2000, and found it is very slow when open a dataset(when 7.0 it is
fairly fast). This application was developed by c++builder5.0+bde5.11, I
have no idea about that.Anybody can help me?
thanks!

Leon

 
Granier Jean-Miche

Delphi Developer
Sun, 07 Nov 2004 22:32:16 GMT

Re:Sql Server 2000 & Sql Server 7.0


No idea, in D5 C/S, it is strictly the same

Care : Alias is NATIVE MSSQL, NOT ODBC NOR ADO.

We experienced that the supplied MS ODBC driver is a {*word*99}.

Jean-Michel

"leon" <l...@desunsoft.com> a crit dans le message news:
3ce8597e_2@dnews...

Quote
> Hi, I transfered my application database from sqlserver 7.0 to
> sqlserver2000, and found it is very slow when open a dataset(when 7.0 it
is
> fairly fast). This application was developed by c++builder5.0+bde5.11, I
> have no idea about that.Anybody can help me?
> thanks!

> Leon

Granier Jean-Miche

Delphi Developer
Sun, 07 Nov 2004 22:58:37 GMT

Re:Sql Server 2000 & Sql Server 7.0


No idea, in D5 C/S, it is strictly the same

Care : Alias is NATIVE MSSQL, NOT ODBC NOR ADO.
BDE 5.11 or 5.2

We experienced that the supplied MS ODBC driver is a {*word*99}.

Jean-Michel

"leon" <l...@desunsoft.com> a crit dans le message news:
3ce8597e_2@dnews...

Quote
> Hi, I transfered my application database from sqlserver 7.0 to
> sqlserver2000, and found it is very slow when open a dataset(when 7.0 it
is
> fairly fast). This application was developed by c++builder5.0+bde5.11, I
> have no idea about that.Anybody can help me?
> thanks!

> Leon

Other Threads

1. Connection between SQL Server 7.0 on win98 and SQL Server 7.0 on Win2000 advanced server

2. Access 2000 & Sql Server 7.0

3. Disadvantages?: Delphi ADO and MS SQL Server 7.0/2000

4. Ms-SQL server 2000 cause MIDAS/DCOM Server Error

5. Controlling of Cache with SQL Server 7 and Delphi on Windows 2000 server

6. windows 2000 server to connect SQL server 6.5

7. SQL server 2000 SQL problem - TOP doesn't work

8. MS SQL Server 2000 with sql links

9. SQL Links and SQL Server 2000

10. SQL Links and SQL Server 2000