I am using ODBC 3.70.06.23 to connect to SS6.5 and SS7.0.
You might want to check out http://www.swynk.com for SQL Server information.


>We have upgraded SQL 6.5 to 7.0 on above server which is replica of our existing live server (SQL 6.5).
>Now when we are trying to run the existing applications (which are running fine on 6.5) on the new 7.0 server we are facing following problems...
>
>1. Using ODBC 2.65.0201/0240, our acces to SQL 7.0 is very slow
> ( we installed ODBC 3.7x.xxx to connect to SQL 7.0, our finding are still very slow and we could not connect to SQL 6.5)
>2. Our view's and form's loading are extremly slow
>3. We are facing problems with one particular form which is having a view with following SQL statement...
>
>*********
>SELECT Mm_srvhead.iYear, Mm_srvhead.iSrvNo, Mm_srvhead.cStore,;
>Mm_srvhead.dDateRecvd, Mm_srvhead.dDocDate, Mm_srvhead.iPoYear,;
>Mm_srvhead.iPoSerial, Mm_srvhead.cPoInd,;
>SUM(Mm_srvitem.rDhValue) AS rdhvalue, Mm_srvhead.lDocCommit;
>FROM dbo.MM_SrvHead Mm_srvhead, dbo.MM_SrvItem Mm_srvitem;
>WHERE Mm_srvhead.iYear = Mm_srvitem.iYear;
>AND Mm_srvhead.iSrvNo = Mm_srvitem.iSrvNo;
>AND (Mm_srvhead.iPoYear = ?v_POyear;
>AND Mm_srvhead.iPoSerial = ?v_POSerial;
>AND Mm_srvhead.iYear BETWEEN ?v_frYear AND ?v_toYear);
>GROUP BY Mm_srvhead.iYear, Mm_srvhead.iSrvNo;
>ORDER BY Mm_srvhead.iYear, Mm_srvhead.iSrvNo
>*********
>we run this view on the SQL 7.0 query analyzer, it gave us error related to TRACE flag 204, and the query was aborted.
>
>4. Speed of data acces to the server is our main concern
>
>Please advice us how to overcome these problems, and which ODBC driver is best suited for our environment.