[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?
Re: Need help with creating and connecting to a database server
Quote:
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
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?
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?
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
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.