This would indicate the optical drive has a 4 pin Molex connector, you would need a Molex to SATA converter.
The only format which is compatible with both OS-X (Mac) and Windows is FAT32. If formatted on a Mac you can use Disk Utility to create a single partition for the whole drive. This is technically too big but does work. However it would mean that if successful the Master Boot Record would have been reset to a standard layout so in theory it could then be reformatted again as NTFS once connected to the PC. Oversized FAT32 partitions can be seen and used by Windows but has an appreciable performance hit.