October 12, 2009 at 11:54 am
I’ve just installed Visual Studio 2008 with SQL Server Business Intelligence Development Studio. I wrote my standard “Hello World” in C#, but as I sip my coffee and click Debug on the pull down menu something horrible happens. Mostly nothing, the button is grayed out and there is no option to compile or run the application.
Is it just my imagination or did the development studio install without a C# complier?
This has me flummoxed?
:ermm:
I don't think it's important but this is the code.
// Hello1.cs
public class Hello1
{
public static void Main()
{
System.Console.WriteLine("Hello, World!");
}
}
A nod is as good as a wink to a blind bat.
October 12, 2009 at 11:59 am
Did you install Visual Studio 2008, or did you install BIDS from the SQL installer?
If you just installed BIDS, there's no C# projects included.
If you have full-blown visual studio installed then chek what type of project you created.
There's a command-line C# compiler that's included with the .net framework if you need. I think it's called cs.exe
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2009 at 12:19 pm
I installed SQL Server 2008 and BIDS.
When I select New – Project I am presented with a New Project Box. On the left of the box is Project Types and on the right is Templates. My only selection under Project type is Business Intelligence Projects or Visual Studio Solution. The Template selections are, respectively.
Analysis Service Project
Integration Services Connection Project
Report Server Project Wizard
Report Server Project
Import Analysis Services 2008 Data
Integration Service Project
Report Model Project
And
Blank Solution
I was selecting Blank Solution.
I was unable to find the cs.exe.
I'm thinking it's time to install the VB and C# portions of the Dev Studio 2008.
A nod is as good as a wink to a blind bat.
October 12, 2009 at 12:37 pm
gking-756277 (10/12/2009)
I installed SQL Server 2008 and BIDS.
So you have not purchased and installed Visual Studio?
BIDS is only the business intelligence projects. Unless you have also purchased and installed Visual Studio, you will not have the C# or VB components. This is intentional. Otherwise people could install BIDS and get the features of a separate product.
If you want the C# projects you need to either purchase and install the full Visual Studio product or you need to download and install Visual Studio Express.
Without one of those, the only way you can do C# is to use an editor and the command line complier. You do have it, it's part of the .NET framework.
It's called csc.exe and you'll find it in one of the subfolders of C:\Windows\Microsoft.NET\Framework\
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 12, 2009 at 12:48 pm
Gila -
Thanks for helping me clear this up, and I apologize for the ranting. I'm going to install C# Express and see where that gets me.
A nod is as good as a wink to a blind bat.
October 16, 2009 at 7:22 am
The Express version will allow you to write and compile code, but don't be disappointed when you find that there are no SQL-Server-specific templates (for CLR stored procedures, functions, triggers, aggregates, types) or when you find that there is no integration to SQL Server for automatic deployment or debugging. You would need one of the pay-for versions to get that good stuff.
That said, I quite happily use the Express versions to develop stuff at home - it's perfectly straightforward, just not quite as convenient as with the retail distributions.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply