View a windows format DVD on Mac
There's no such thing as a "Windows formatted" DVD. DVD and CD-ROMs have their own format which is supported by Windows, Mac, Linux and all sorts of appliances, media players, etc.

I will recommend testing:

1) Can the Mac play other DVDs than the problematic one?

2) Does the problematic DVD play on another PC?

If test 1 is negative, try to resolve the problem with the DVD drive on the Mac - for example cleaning the lens, etc. Maybe consider buying an external USB DVD-drive.

If test 2 is negative, try cleaning the DVD disc itself and check it for scratches, etc. It might not be possible to fully recover all the data from it.

If both tests are positive you might have a DVD that is in the process of being filled up with data - i.e. it is not finalized yet. You would then need to finalize the disc - most easily done using the original software you used for burning data to the disc.