>What was the exact error message that you were receiving? Also did you change the ODBC driver that was on the computer running the client?
>
>-Mike
It was Ole DB provider error 80004005 Unexpected ODBC error
Yes, we used new ODBC driver for MS SQL7, old one for 6.5 does not work
with MS SQL7. Before I have seen similar message, when worked directly inside MS SQL interprise manager adn tested import of hude Oracle and VFP tables with data into MS SQL7.
Very often the table was created, but no data was there and it was very similar message. I tested import of 55-60 Oracle tables and 40-50 VFP tables, some had near 12000 records.
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.