Hi

Has anybody come across the following problem.

We have a foxpro 6.0 remote view that randomly returns some obscure non alpha-numeric characters, using foxpro these characters equate to chr(0).

We are connecting to SQL server 2000 and I've updated the sql server odbc driver to mdac 2.7, and still the problem occurs.

I've checked the view definition and all the views dbsetprop appears to be correct.

These characters appear as small square graphically boxes in the views field.

Anybody got any clues?

Any suggestions greatly appreciated

Thanks, Mark