is it possible to use the seek method when connecting to an SQL DB?

I have the following connection properties:

        rstKLX.CursorLocation = adUseServer
        rstKLX.Open "_SMDBA_._INVENTOR_", cnxSQL, adOpenKeyset,
adLockReadOnly, adCmdTableDirect

yet the .supports method still returns false?!

Help appreciated.

Matt.