>>I just wonder how are the Access, Paradox, Clarion and other guys coping with this. I guess they also have their ways to hook into ODBC.
>
>AFAIK Access has had good integration with SQL Server for at least 10 years, dunno about the other guys.
Not so good. I've had to work with SQL data coming from several Access apps, and they simply don't seem to have a way (or the guys who wrote them didn't know how) to do SPT. This leads to creating loads of views for each occasion. They just seem to apply a wizard and live happily ever after not even having to notice it's not a Jet db in the background.
It's a good thing for them, they don't really have to do much work when switching, but I wouldn't call that integration. It's rather a bridge.