.sdf databasse and programming

i need to access an .sdf database using microsfot visual forpro

what drivers/connection strings do i need?

If Foxpro supports ADO you can use the oledb provider, for a sample see http://blogs.msdn.com/sqlservereverywhere/archive/2006/08/08/691894.aspx