Solved

Need recommendations for communication between program and server

Posted on 2016-10-11
1
90 Views
Last Modified: 2016-10-18
Register program written in VB with Visual Studio 2012 needs to communicate with Windows Server 2012.  Will not be running credit card data.  Just local accounts. Current communication is with the standard execute reader and data adapter using a connection string.

I want to create services on server to receive input from programs. The services would run stored procedures or do select statements that would return either a string or file located on server (Stored Procedures) or data table (Select Statements)

I was thinking of sending the data like so:
CreateTable(select * from TABLE where COLUMN1= @PARA1 and COLUMN2=@PARA2, {"@PARA1","@PARA2"}, {PARA1,PARA2})

RunStoredProcedure(STOREDPROCEDURENAME, {"@PARA1","@PARA2"}, {PARA1,PARA2})

Data sent/received is AES 256 encrypted.

I have looked into creating services before and was not sure how to start. Would the above be a good way to describe a project to a potential programmer?  Where would be a good place to find someone? Is there any thing I am overlooking?
0
Comment
Question by:Millkind
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 39

Accepted Solution

by:
Aaron Tomosky earned 500 total points
ID: 41839458
What you need is a web service. Lots of examples abound but here is on that is pretty easy to follow with sample code
http://www.codeproject.com/Articles/495839/Single-web-service-for-NET-web 
Additionally you need a DAL (data access layer) to reside in this web service
https://www.asp.net/web-forms/overview/getting-started/getting-started-with-aspnet-45-web-forms/create_the_data_access_layer

So instead of a dal directly feeding your application, it feeds a web service and your app calls the web service to add delete or query things.

I hope this gets your started, I don't actually code but I used to manage the infrastructure for a bunch of guys that did this stuff regularly so I'm familiar with the high level structure.
1

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The following article is comprised of the pearls we have garnered deploying virtualization solutions since Virtual Server 2005 and subsequent 2008 RTM+ Hyper-V in standalone and clustered environments.
I don't know if many of you have made the great mistake of using the Cisco Thin Client model with the management software VXC. If you have then you are probably more then familiar with the incredibly clunky interface, the numerous work arounds, and …
In this Micro Tutorial viewers will learn how to use Boot Corrector from Paragon Rescue Kit Free to identify and fix the boot problems of Windows 7/8/2012R2 etc. As an example is used Windows 2012R2 which lost its active partition flag (often happen…
This tutorial will walk an individual through the process of installing of Data Protection Manager on a server running Windows Server 2012 R2, including the prerequisites. Microsoft .Net 3.5 is required. To install this feature, go to Server Manager…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question