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

RE: .NET/ODBC queries Via the Internet by surturz

surturz
Mon Jul 14 02:00:01 CDT 2008

Erm, ASP.NET? :-)

--
David Streeter
Synchrotech Software
Sydney Australia


"Samuel" wrote:

>
> 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
>
>
>

Re: .NET/ODBC queries Via the Internet by Samuel

Samuel
Mon Jul 14 12:14:13 CDT 2008

I find your comment quite rude

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





"SurturZ" <surturz@newsgroup.nospam> wrote in message
news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
> Erm, ASP.NET? :-)
>
> --
> David Streeter
> Synchrotech Software
> Sydney Australia
>
>
> "Samuel" wrote:
>
>>
>> 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
>>
>>
>>



Re: .NET/ODBC queries Via the Internet by Lloyd

Lloyd
Mon Jul 14 12:24:14 CDT 2008


"Samuel" <samuel.shulman@ntlworld.com> wrote in message
news:uXJAJUd5IHA.1204@TK2MSFTNGP04.phx.gbl...
>I find your comment quite rude
>
> You under no obligation to reply and some people will ignore this message
> because it had a reply
>
>
>
>
>
> "SurturZ" <surturz@newsgroup.nospam> wrote in message
> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
>> Erm, ASP.NET? :-)
>>
>> --
>> David Streeter
>> Synchrotech Software
>> Sydney Australia
>>
>>
>> "Samuel" wrote:
>>
>>>
>>> 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 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


Re: .NET/ODBC queries Via the Internet by Samuel

Samuel
Mon Jul 14 14:55:13 CDT 2008

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

"Lloyd Sheen" <a@b.c> wrote in message
news:edFOAad5IHA.2544@TK2MSFTNGP04.phx.gbl...
>
> "Samuel" <samuel.shulman@ntlworld.com> wrote in message
> news:uXJAJUd5IHA.1204@TK2MSFTNGP04.phx.gbl...
>>I find your comment quite rude
>>
>> You under no obligation to reply and some people will ignore this message
>> because it had a reply
>>
>>
>>
>>
>>
>> "SurturZ" <surturz@newsgroup.nospam> wrote in message
>> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
>>> Erm, ASP.NET? :-)
>>>
>>> --
>>> David Streeter
>>> Synchrotech Software
>>> Sydney Australia
>>>
>>>
>>> "Samuel" wrote:
>>>
>>>>
>>>> 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 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



Re: .NET/ODBC queries Via the Internet by Lloyd

Lloyd
Mon Jul 14 15:04:04 CDT 2008


"Samuel" <samuel.shulman@ntlworld.com> wrote in message
news:uwQAHue5IHA.3588@TK2MSFTNGP05.phx.gbl...
>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
>
> "Lloyd Sheen" <a@b.c> wrote in message
> news:edFOAad5IHA.2544@TK2MSFTNGP04.phx.gbl...
>>
>> "Samuel" <samuel.shulman@ntlworld.com> wrote in message
>> news:uXJAJUd5IHA.1204@TK2MSFTNGP04.phx.gbl...
>>>I find your comment quite rude
>>>
>>> You under no obligation to reply and some people will ignore this
>>> message because it had a reply
>>>
>>>
>>>
>>>
>>>
>>> "SurturZ" <surturz@newsgroup.nospam> wrote in message
>>> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
>>>> Erm, ASP.NET? :-)
>>>>
>>>> --
>>>> David Streeter
>>>> Synchrotech Software
>>>> Sydney Australia
>>>>
>>>>
>>>> "Samuel" wrote:
>>>>
>>>>>
>>>>> 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 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
>
>

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


Re: .NET/ODBC queries Via the Internet by Samuel

Samuel
Mon Jul 14 16:40:04 CDT 2008

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





"Lloyd Sheen" <a@b.c> wrote in message
news:uMEaTze5IHA.4344@TK2MSFTNGP03.phx.gbl...
>
> "Samuel" <samuel.shulman@ntlworld.com> wrote in message
> news:uwQAHue5IHA.3588@TK2MSFTNGP05.phx.gbl...
>>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
>>
>> "Lloyd Sheen" <a@b.c> wrote in message
>> news:edFOAad5IHA.2544@TK2MSFTNGP04.phx.gbl...
>>>
>>> "Samuel" <samuel.shulman@ntlworld.com> wrote in message
>>> news:uXJAJUd5IHA.1204@TK2MSFTNGP04.phx.gbl...
>>>>I find your comment quite rude
>>>>
>>>> You under no obligation to reply and some people will ignore this
>>>> message because it had a reply
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "SurturZ" <surturz@newsgroup.nospam> wrote in message
>>>> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
>>>>> Erm, ASP.NET? :-)
>>>>>
>>>>> --
>>>>> David Streeter
>>>>> Synchrotech Software
>>>>> Sydney Australia
>>>>>
>>>>>
>>>>> "Samuel" wrote:
>>>>>
>>>>>>
>>>>>> 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 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
>>
>>
>
> 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



Re: .NET/ODBC queries Via the Internet by surturz

surturz
Mon Jul 14 20:03:02 CDT 2008

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.

--
David Streeter
Synchrotech Software
Sydney Australia


"Samuel" wrote:

> I find your comment quite rude
>
> You under no obligation to reply and some people will ignore this message
> because it had a reply
>
>
>
>
>
> "SurturZ" <surturz@newsgroup.nospam> wrote in message
> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
> > Erm, ASP.NET? :-)
> >
> > --
> > David Streeter
> > Synchrotech Software
> > Sydney Australia
> >
> >
> > "Samuel" wrote:
> >
> >>
> >> 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
> >>
> >>
> >>
>
>
>

Re: .NET/ODBC queries Via the Internet by surturz

surturz
Mon Jul 14 20:05:02 CDT 2008

Are you worried about SQL injection attacks? Sending naked SQL Queries across
the internet is not very safe.

--
David Streeter
Synchrotech Software
Sydney Australia


"Samuel" wrote:

> 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
>
>
>
>
>
> "Lloyd Sheen" <a@b.c> wrote in message
> news:uMEaTze5IHA.4344@TK2MSFTNGP03.phx.gbl...
> >
> > "Samuel" <samuel.shulman@ntlworld.com> wrote in message
> > news:uwQAHue5IHA.3588@TK2MSFTNGP05.phx.gbl...
> >>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
> >>
> >> "Lloyd Sheen" <a@b.c> wrote in message
> >> news:edFOAad5IHA.2544@TK2MSFTNGP04.phx.gbl...
> >>>
> >>> "Samuel" <samuel.shulman@ntlworld.com> wrote in message
> >>> news:uXJAJUd5IHA.1204@TK2MSFTNGP04.phx.gbl...
> >>>>I find your comment quite rude
> >>>>
> >>>> You under no obligation to reply and some people will ignore this
> >>>> message because it had a reply
> >>>>
> >>>>
> >>>>
> >>>>
> >>>>
> >>>> "SurturZ" <surturz@newsgroup.nospam> wrote in message
> >>>> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
> >>>>> Erm, ASP.NET? :-)
> >>>>>
> >>>>> --
> >>>>> David Streeter
> >>>>> Synchrotech Software
> >>>>> Sydney Australia
> >>>>>
> >>>>>
> >>>>> "Samuel" wrote:
> >>>>>
> >>>>>>
> >>>>>> 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 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
> >>
> >>
> >
> > 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
>
>
>

Re: .NET/ODBC queries Via the Internet by Samuel

Samuel
Tue Jul 15 07:52:55 CDT 2008

np


"SurturZ" <surturz@newsgroup.nospam> wrote in message
news:9E3141B9-95B8-45A7-B8E5-C6F3E93C9BE3@microsoft.com...
> 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.
>
> --
> David Streeter
> Synchrotech Software
> Sydney Australia
>
>
> "Samuel" wrote:
>
>> I find your comment quite rude
>>
>> You under no obligation to reply and some people will ignore this message
>> because it had a reply
>>
>>
>>
>>
>>
>> "SurturZ" <surturz@newsgroup.nospam> wrote in message
>> news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@microsoft.com...
>> > Erm, ASP.NET? :-)
>> >
>> > --
>> > David Streeter
>> > Synchrotech Software
>> > Sydney Australia
>> >
>> >
>> > "Samuel" wrote:
>> >
>> >>
>> >> 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
>> >>
>> >>
>> >>
>>
>>
>>



Re: .NET/ODBC queries Via the Internet by Jason

Jason
Thu Jul 17 05:42:01 CDT 2008

Samuel wrote:
> 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
>

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.