I have created a local SQL database using Visual Studio 2005 (not by SQL Server Management Studio), and located it in the same VB project folder: "E:\MyProject\MyDB.mdf".
Now I'm trying to design reports using Crystal Reports 2008, but for SQL Server, it doesn't browse this DB created by visual studio. It can only browse the ones created by the SQL Management Studio.
I tried using the providers SQL Native Client and Microsoft OLE DB Provider for SQL Server under the OLE DB (ADO) data source, but neither could browse my database.
Any idea how to solve this?