Results 1 to 6 of 6

Thread: [RESOLVED] Need help with creating and connecting to a database server

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Oct 2013
    Posts
    200

    Resolved [RESOLVED] Need help with creating and connecting to a database server

    Hi, I'm using Visual Studio Community 2015 and trying to create a server. I couldn't find a way to do this: I tried using SQL Management Studio some time ago however couldn't connect it, and my system became distorted.

    How can I create an sql server (using sql server compact or something stable) and connect to it?

  2. #2
    Frenzied Member KGComputers's Avatar
    Join Date
    Dec 2005
    Location
    Cebu, PH
    Posts
    2,020

    Re: Need help with creating and connecting to a database server

    How can I create an sql server (using sql server compact or something stable) and connect to it?
    Do you mean to say, create SQL Server DB using code? If yes, see link below.

    How To Create a SQL Server Database Programmatically by Using ADO.NET and Visual C# .NET
    CodeBank: VB.NET & C#.NET | ASP.NET
    Programming: C# | VB.NET
    Blogs: Personal | Programming
    Projects: GitHub | jsFiddle
    ___________________________________________________________________________________

    Rating someone's post is a way of saying Thanks...

  3. #3

    Thread Starter
    Addicted Member
    Join Date
    Oct 2013
    Posts
    200

    Re: Need help with creating and connecting to a database server

    Thank you for your reply. It's a link for creating databases, it gave me error. I don't need to create a server?

  4. #4
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    Re: Need help with creating and connecting to a database server

    What do you mean create a server? Did you install SQL Server? What version?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  5. #5

    Thread Starter
    Addicted Member
    Join Date
    Oct 2013
    Posts
    200

    Re: Need help with creating and connecting to a database server

    What I'm trying to do is connecting to sql and running some commands properly. However I'm getting errors about opening connection.

    No, I didn't install any version of SQL Server. That's what I wonder. Do I have to install sql server and / or create a server? I mean SQL Server Compact Edition comes with Visual Studio; I have it. I don't want any conflicts if installing another one would cause. Sorry for my English.

    Regards,
    Can

  6. #6
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,495

    Re: Need help with creating and connecting to a database server

    That is not set to run you need to connect it and is only avail in VS not in management studio. You should down load SQL Server Express and install that.
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width