>From what I know of, the ODBC for VFP to get connected to MS SQL
>Server has 2 version. One is Ver 2.5(from SQL CD), and another
>which is from Windows(pre-installed) Ver 3.6.
>
>When making queries from SQL Server table of about 100,000 records.
>Using Ver 3.6 ODBC connected driver seems to have error
>(Illegal Operation, Page Fault...)
>But, when I installed the ODBC driver Ver 2.5 (from SQL CD), it's
>fine.
>
>I wonder, is there any other more reliable ODBC Drivers around?
>Or, could I use other drivers to get connected to SQL Server?
>Maybe OLE DB(not quite sure about this technology)? Thanks.
If you install SQL Server 7 you will get ODBC version 3.7. I don't know if it will fix the proble you are having?
DLC