.NET/ODBC queries Via the Internet

  • Thread starter Thread starter Samuel
  • Start date Start date
S

Samuel

Hi

I need to add a web interface to my VB.NET application

At the moment I use standard ODBC .NET driver but now I need to install the
program for someone who is offsite and can connect only via the internet.

What is the method that's used generally (encryption is not necessary)

Thank you,
Samuel
 
I find your comment quite rude

You under no obligation to reply and some people will ignore this message
because it had a reply
 
Samuel said:
I find your comment quite rude

You under no obligation to reply and some people will ignore this message
because it had a reply
Click to expand...

I really don't think that is rude. Asp.net is the Web Interface that is
dot.net based.

Do you want an interface that can be used thru a browser or one that will
allow your winforms app to be able to access the data thru the internet?

In the first case you would use Asp.Net to create the interface (too much to
go into for the amount of details we have). The second case again you would
use Asp.Net but create web service that your winforms app can use to get
data from your database.

If you could narrow it down we could help.

LS
 
I thought that it is possible without a Web Service using regular ASP pages
with XML content

I wonder if there is a way to transfer the errors and other data

The datatable content is not a problem as there is standard methods to
create and read the XML data

The main point is to minimize the required amount of work as we have exiting
tested application

Thank you,
Samuel
 
Samuel said:
I thought that it is possible without a Web Service using regular ASP pages
with XML content

I wonder if there is a way to transfer the errors and other data

The datatable content is not a problem as there is standard methods to
create and read the XML data

The main point is to minimize the required amount of work as we have
exiting tested application

Thank you,
Samuel
Click to expand...

The two components you would need as a minimum are:

1. A method to send requests (includes query/update and request status)
2. A method to recieve those requests and process them

If you already have the winforms app created do you have a data layer?

LS
 
I have the data layer

I think that I can create an object that has the follwoing members

Datatable
Inetegr to store the error number so i can check the status
String for any error message


Then I make a normal ASP page that doesn't require a special service running

Using the GET method I will send the SQl statement

The content of the ASP page will include the serelized version of the this
object

On the client side I deserialize the content of the asp page
 
My apologies if you were offended, that was not my intent. I was genuinely
trying to answer your query, but your original post was a bit too broad to
answer more specifically.
 
Are you worried about SQL injection attacks? Sending naked SQL Queries across
the internet is not very safe.
 
np


SurturZ said:
My apologies if you were offended, that was not my intent. I was genuinely
trying to answer your query, but your original post was a bit too broad to
answer more specifically.
Click to expand...
 
Samuel said:
I have the data layer

I think that I can create an object that has the follwoing members

Datatable
Inetegr to store the error number so i can check the status
String for any error message


Then I make a normal ASP page that doesn't require a special service running

Using the GET method I will send the SQl statement

The content of the ASP page will include the serelized version of the this
object

On the client side I deserialize the content of the asp page
Click to expand...

It would be unusual for a .NET WinForms application to call ASP, rather
than ASP.NET. ASP would probably have to use ADO, rather than ADO.NET to
access any database - probably not what your existing data layer uses.

It is also more difficult to create bug free code in ASP compared with
ASP.NET, as there's no intellisense.

A Web Service written using ASP.NET technology that passes datasets as
(serialised) XML is the simplest method. Although, it sound like you
wish to retrieve DTOs.

You have not explained what your existing data layer does - how do you
perform CRUD operations? Do you use datasets, data readers,...?

Is your code object-oriented, or data(set) oriented? Etcetera, etcetera.
 
Back
Top