I have been searching the web for days looking for a solution to a
problem I am having with a DataView WebPart(DVWP). I am hoping maybe
you can help. I will try to explain this as best as I can.

I am creating a webpart that will read from a View on my SQL Server. I
need to limit what each user sees to only their own records, I have a
field for the users login which is what I am trying to filter
by "Current User".

I have created this DVWP, connected it to the SQL Server and the view.
I am using Single Sign-On through SharePoint to connect to the View,
set up as a group with the permissions set as owner rights. I have
tried to filter it in FrontPage by [Current User] which gives me no
data return. If I filter by a specific login it displays correctly the
information for that user. Or if I remove the filter it shows
everything. So I am lead to believe I am not filtering correctly.