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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement