>>
>>If you use IIS rather than the built in provider - it doesn't work well. If you use IIS you'd be best off adding the database as a fixed SQL Express database rather than a file access one because of permissions settings.
>>
>>
http://west-wind.com/WebLog/posts/5063.aspx>
>Thanks for the info Rick. Right now I'm just trying to get the Mere Mortals Business Object Generator to see my database in the app_data folder. I'm getting an exception in the Business Object Generator wizard when I put in the connection string that's in my web.config. The format of the connection string is different when you're just using an .mdf file rather than a regular database and I'm guessing that MM doesn't know how to use that type of connection.
It's just a connection string. The format should look like this:
Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\AjaxAspNet_Data.mdf;Integrated Security=True;User Instance=True
As long as the connection string is valid the SQL provider will just work with it.
+++ Rick ---
>
>Regards,
>
>E.R.