Post reply

.Net application development with SQL Server 2005

  • March 13, 2009 at 4:55 am

    #128966

    Hello there,

    I want to develop a .net application using SQL Server as backend.

    For this, I have downloaded SQL Server Compact Edition and SQL Server Management Studio.

    However, I am not able to find the server name when trying for "New Server Registration".

    Any idea on what server name should i enter? or

    Do i need to download any other software as well?

    Please help.

    Thanks in advance.

  • March 13, 2009 at 5:34 am

    #959005

    Have you installed SQL server on a server or on your local machine?

    If this is a application running on a server or a local machine then you may consider downloading

    SQL Server express, as SQL server compact is really suited for mobile devices.

  • March 13, 2009 at 5:39 am

    #959009

    Hi

    It is possible to access Compact Edition from .Net on windows OS. For detailed information about the connection string see http://www.connectionstrings.com/.

    But it has quiet less features. As steveb already stated you should consider the Express Edition.

    Greets

    Flo

  • March 13, 2009 at 7:20 am

    #959077

    Hello Steve,

    Thanks for your reply.

    Both application and SQL Server are on local machine and I was just simply trying to start some test application.

    Now, I have downloaded SQL Server Express Edition and was able to get Local Serve Name to connect with. However, I still wonder why SQL Server Management Studio was not finding any local server when i was having SQL Server Compact Edition?

  • March 13, 2009 at 7:32 am

    #959087

    Hello Flo,

    Thanks for your reply too.

    I am able to get the server name after installing Express Edition.

    But I wonder why Management Studio was not able to get local sql server name earlier with Compact Edition?

  • March 13, 2009 at 7:46 am

    #959106

    Hi

    Did you try to browse for the database file location?

    "Object Explorer" -> "Connect -> "SQL Server Compact" -> "Database file" -> "Browse for more..."

    Greets

    Flo

  • March 13, 2009 at 8:07 am

    #959119

    Yes, I tried browsing for available servers.

  • March 13, 2009 at 8:15 am

    #959128

    Available Servers? If you select "Connnect SQL Server Compact" and Select "Browse for more..." option from drop-down list there should appear a dialog to directly browse for the file; not a server.

    Greets

    Flo

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply