>Hi all,
>
>I'm trying to access a mainframe database which has CA-Server on it. It works in Access, it works in MS Query, but I can't get it to work in VFP. I can get a connection handle, but I always get an error when trying to retreive a result set -- as a remote view. I've tried a couple of queries in SQL pass-through and only get errors on them too, but they are different errors.
>
>Has anybody had any experience with this CA-Server and VFP? Any insight is greatly appreciated.
>
>Thanks,
I don't have any experience with CA-Server, but these sorts of things are usually related to the ODBC driver. What kind of errors are you getting?
"It is an important and popular fact that things are not always what they seem. For instance, on the planet Earth, man had always assumed that he was more intelligent than dolphins because he had achieved so much -- the wheel, New York, wars and so on -- whilst all the dolphins had ever done was muck about in the water having a good time. But conversely, the dolphins had always believed that they were far more intelligent than man -- for precisely the same reasons." - Douglas Adams