Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-19 : 07:45:40
|
| George writes "I want to practice developing C# programs that connect and manipulate data in a database. I am running windows XP Pro. I, of course, have the enterprise architect .NET on my PC. My problem is, can I install SQL Server 2000 on the same PC as my .NET, or do I have to build a "server", connect it to my PC, and install SQL on the server? Is there any other software that I can write databases in SQL language on the same PC that I write my C# program? Thank you for your time." |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-03-19 : 07:49:18
|
quote:
I, of course, have the enterprise architect .NET on my PC.
Why is that of course ? You don't need Visual Studio to write .NET code. In fact some people prefer not to.quote:
My problem is, can I install SQL Server 2000 on the same PC as my .NET, or do I have to build a "server", connect it to my PC, and install SQL on the server?
Yes you can. Or, on your Visual Studio DVD (or did you buy as a shipping crate load of normal CDs ) you have MSDB which is the developer edition of SQL Server. Works the same, with a limitation to 5 connections. It will do you fine.Damian |
 |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-03-19 : 07:50:48
|
| You can install sql on the same machine as .net, but I like another machine if you have one available. 2 machines lets you work through the permissions and security issues of connecting to sql server.Lance Harra |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-03-19 : 11:13:21
|
quote:
Yes you can. Or, on your Visual Studio DVD (or did you buy as a shipping crate load of normal CDs ) you have MSDB which is the developer edition of SQL Server. Works the same, with a limitation to 5 connections. It will do you fine
Damian, I thought MSDB was for holding scheduled jobs etc..  J/KMerkin was referring to MSDE George. quote:
You can install sql on the same machine as .net, but I like another machine if you have one available. 2 machines lets you work through the permissions and security issues of connecting to sql server.
You will still have to connect to SQL regardles of where it is located, so there shouldn't be any different security for a remote SQL Server.George, you can definitely have both on one machine, I have both on all of my machines. -Chad |
|
|
|
yakoo
Constraint Violating Yak Guru
312 Posts |
Posted - 2003-03-19 : 11:30:26
|
quote:
Is there any other software that I can write databases in SQL language on the same PC that I write my C# program
You should be able to use any database program. Examples are Oracle, mySQL, Access, SQL Server... just to name a few.As for writing .NET applications with C# you never need the enterprise architect. I have always written Java, C, C++, and VB with a basic text editor. All you then need is a compiler to compile your source code.Got SQL? |
|
|
|
|
|
|
|
|
SQL and C#