By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,653 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

c# express edition and sql server2005 workgroup

P: n/a
Is it possible to connect to SQL Server 2005 Workgroup using C# Express
edition ?

Thanks for your help,

Roelof

Jan 13 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

Jan 14 '07 #2

P: n/a
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.

Jan 14 '07 #3

P: n/a
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@vankootenschreef in bericht
news:45*********************@textreader.nntp.hccne t.nl...
Is it possible to connect to SQL Server 2005 Workgroup using C# Express
edition ?

Thanks for your help,

Roelof

Jan 14 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.