LocalDB

well as far as I know the transaction log (ldf) has to exist so I would assume you have to include that in the connection string, but I'm sure its easy enough to check that.

Dont know why you thibnk you dont need it but if its due to size then this link might help http://dba.stackexchange.com/questions/31838/how-to-disable-ldf-file-or-limit-its-size

found this link
http://blog.sqlauthority.com/2010/04/26/sql-server-attach-mdf-file-without-ldf-file-in-database/

Yes it because of size, the .ldf file is big and
if I can get rid of it, it will be great.

Well take a look at the link which explains how you can keep size to a minimum

Thanks Terry

your welcome, happy I could help