C# and SQL Project
-
Hi everybody, I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table. I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first: 1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password? 2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server :) Thanks for entertaining a complete noob about SQL. Take care, Michael Fritzius
-
Hi everybody, I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table. I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first: 1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password? 2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server :) Thanks for entertaining a complete noob about SQL. Take care, Michael Fritzius
-
Hi everybody, I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table. I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first: 1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password? 2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server :) Thanks for entertaining a complete noob about SQL. Take care, Michael Fritzius
Michael Fritzius wrote:
if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password?
One way is to build a three-tiered application or if you want to do this like client-server, you would need (secure) ip-connection through the firewall. Connection string is exactly what you described: ip,port (or server name), username and password.
Michael Fritzius wrote:
How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server
If you mean how would you get a database, you could use for example SQL Server Express Edition[^].
The need to optimize rises from a bad design.My articles[^]
-
- There are many options. Today the most notable is to place one or more web services behind the firewall and use them to interface with from the client. 2) I don't understand the question. How do you get a server?
led mike
led mike wrote:
- I don't understand the question. How do you get a server?
I meant how to get an SQL server running someplace. Something with a database on it that I can run my program against to check and see that the correct info is being added/read at the server. What would you recommend?
-
led mike wrote:
- I don't understand the question. How do you get a server?
I meant how to get an SQL server running someplace. Something with a database on it that I can run my program against to check and see that the correct info is being added/read at the server. What would you recommend?
-
led mike wrote:
- I don't understand the question. How do you get a server?
I meant how to get an SQL server running someplace. Something with a database on it that I can run my program against to check and see that the correct info is being added/read at the server. What would you recommend?
For testing any workstation can operate as a server for just about everything other than load/stress testing. In many cases I have everything running on my developer workstation for developing. Then things get installed in test labs for real testing. You probably want to start digging into Security issues sooner rather than later.
led mike
-
Hi everybody, I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table. I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first: 1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password? 2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server :) Thanks for entertaining a complete noob about SQL. Take care, Michael Fritzius
Ok, so I'm trying to get SQL Express on my home machine. Already tried downloading and installing it on the work machine, but for whatever reason it didn't work. This is fine, because I don't really want to develop this project on the work PC anyway. ...and it looks like I might be over my head on this. Is SQL supposed to be this hard to install? Has anyone been successful with getting some version of the server installed and functioning properly that would be willing to walk me through the process OR point me to a tutorial on how to do it? Thanks muchly, Michael Fritzius
-
Hi everybody, I've got a potential customer that would like a C# GUI that interfaces with an SQL server somewhere. So, I'm trying to figure out where to start. Don't know a ton about SQL, but it looks like this guy is just wanting some basic INSERT and SELECT functions done on a table. I took a look at this article http://www.codeproject.com/KB/database/sql_in_csharp.aspx[^] and see that it's a good start. However, I've got some questions that need to be addressed first: 1) No idea if this makes a difference, but if the SQL server is running behind a firewall or a router, how do I get to it? Is it something like inputting an IP address/port combination, username and password? 2) How can I get a server to test my program on locally that I have control of? I don't want to be using a (hopefully not) buggy program on someone else's server :) Thanks for entertaining a complete noob about SQL. Take care, Michael Fritzius
Hi all, and thanks for all the help so far. I've successfully gotten SQL Server 2008 running on my home machine, and can make databases, add rows/columns, everything I would need for this project. Also, the program written to interface with the server at the local level works great. Now I'm trying to log onto the same server and use the program to access the server remotely, from a computer on the same network, but having no success. It gives me the following error: Login failed for user XXXX/Guest. I know the info is getting to the server just fine, because of the nature of the error, and because I ran Wireshark to see if info was getting passed, and it was. And, I've looked on Google and on here for a solution, but nothing seems to help. I know that there needs to be a username/password on the SQL server itself so it knows if it can accept the incoming connection. Already tried this, but it didn't work, so I know I did something wrong... just don't know what. If you know the answer, please help. Thanks for all your suggestions so far and take care, Michael Fritzius