Crystal Reporting Database
I store my database in the APP_DATA folder of my application.
I have added a crystal report to my application. I mentioned. \ SQLEXPRESS as my server.
In the database dropdown, I only see these databases - Master, Model, msdb, tempdb
My dabase name is "Database.mdf". Why can't I see it?
My connection string: Data source =. \ SQLEXPRESS; AttachDbFilenam e = C: \ Inetpub \ wwwroot \ test \ App_Data \ Database. mdf; Integrated Security = True; Custom Instance = True I am using localhost. VS 2005.NET 2.0
This is kind of an older post (in SO terms), but I figured that I would comment on some things anyway that you can try.
First, you don't need to include AttachDBFilename in your configuration connection string when connecting to a SQL Server database. If the database is connected to a local SQLEXPRESS instance, you should be able to reference it this way. You must specify "home directory = [your database name]" in the connection string so that it knows which database to look for.
Also, instead of putting the absolute path to the filename if you are going to connect by filename, I believe you can put "| DataDirectory |" which belongs to the App_Data folder. So this part will look like "AttachDbFilename = | DataDirectory | \ Datbase.mdf".
I'm sure you get the idea that the problem has already been cleared up, but if not, I hope this helps.
a source to share