I tried several connection methods without success?

Sqlserver

direct access to access database.

sample " add key="SouthwindSQL\Connection" value="server=(local);Initial;uid=sa;pwd=;database=SouthwindSQL;" / "



I seem to be spending more time debugging errors than moving forward!