PC Review


Reply
Thread Tools Rate Thread

c# express edition and sql server2005 workgroup

 
 
Roelof van Kooten
Guest
Posts: n/a
 
      13th Jan 2007
Is it possible to connect to SQL Server 2005 Workgroup using C# Express
edition ?

Thanks for your help,

Roelof



 
Reply With Quote
 
 
 
 
=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=
Guest
Posts: n/a
 
      14th Jan 2007
You should be able to connect to any edition of Sql Server using the
SqlClient class.
This includes handy things like SqlConnection, SqlCommand, SqlParameter, etc.
Peter

--
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short urls & more: http://ittyurl.net




"Roelof van Kooten" wrote:

> Is it possible to connect to SQL Server 2005 Workgroup using C# Express
> edition ?
>
> Thanks for your help,
>
> Roelof
>
>
>
>

 
Reply With Quote
 
ForrestPhoto@gmail.com
Guest
Posts: n/a
 
      14th Jan 2007
> Is it possible to connect to SQL Server 2005 Workgroup using C# Express
> edition ?


I'm not sure what SQL Workgroup is, but if you can get a connection to
the box it runs on, say in Windows Explorer, than you can get to it
through .net code. Just make a note of the server name ( or IP address
) and if there are more than one instance of SQL Server running on the
server, which one, then write up a connection string.

 
Reply With Quote
 
Roelof van Kooten
Guest
Posts: n/a
 
      14th Jan 2007
When making a new Connection in C# Express Edition I can choose from
following data sources:
- Microsoft SQL Server Database File (SQLClient)
- Microsoft Access Database File

When looking at sample application in C# more data sources are available.
The one I think I need is "Microsoft SQL Server". Through Database Explorer
in C# Express I can not add data sources. This makes me think C# Express can
only be used with the SQL Server 2005 Express Edition and probably I have to
change to another (Standard or Professional) version of Visual Studio 2005
to make a connection with SQL Server 2005 for Workgroups.

Any comments/help are welcome.

Thanks in advance,
Roelof


"Roelof van Kooten" <roelof@vankooten> schreef in bericht
news:45a9444c$0$738$(E-Mail Removed)...
> Is it possible to connect to SQL Server 2005 Workgroup using C# Express
> edition ?
>
> Thanks for your help,
>
> Roelof
>
>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to install SQL server2005 express on XPE SP2 helloxpe Windows XP Embedded 0 11th Jun 2009 03:54 PM
Confusion: VB Express/VC Express/Sql Server Express Edition Patrice Microsoft Dot NET 3 18th Jan 2006 01:21 PM
Confusion: VB Express/VC Express/Sql Server Express Edition Patrice Microsoft C# .NET 3 18th Jan 2006 01:21 PM
Confusion: VB Express/VC Express/Sql Server Express Edition Patrice Microsoft VB .NET 3 18th Jan 2006 01:21 PM
accessing workgroup from XP Home Edition clint Windows XP Networking 0 9th Sep 2003 04:50 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:36 AM.