January 20, 2009 at 3:50 am
Hi friends,
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". The application is working just fine with the database.
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?
January 21, 2009 at 7:56 am
I'd like to see the exact code you used to create the database. No need for any application code - only the specific statements needed to create the connection to SQL Server and the ones that actually create the database.
Steve
(aka smunson)
:):):)
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
June 3, 2013 at 10:43 am
hey guys i want to know what u did? i have problems like this. please reply my topic
June 3, 2013 at 11:01 am
Re-opening a 3 year old post isn't really the right way to go about this, but the bottom line is that I suspected that any reply from the original poster might reveal that the database they "created" doesn't actually exist within their SQL instance, but is instead perhaps something VS allows you to do which simulates SQL Server. As I don't use VS by any means other than SSMS or BIDS, I don't know if such a feature exists. Given that the original poster failed to ever respond, I have no way to know. If I were you, I would use SSMS to look at the SQL instance you are interested in, and see if the table and/or database exists there. If it doesn't, then you'll know what the issue is.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply