Re: .NET/ODBC queries Via the Internet

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@xxx> wrote in message
news:uMEaTze5IHA.4344@xxxxxxxxxxxxxxxxxxxxxxx

"Samuel" <samuel.shulman@xxxxxxxxxxxx> wrote in message
news:uwQAHue5IHA.3588@xxxxxxxxxxxxxxxxxxxxxxx
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@xxx> wrote in message
news:edFOAad5IHA.2544@xxxxxxxxxxxxxxxxxxxxxxx

"Samuel" <samuel.shulman@xxxxxxxxxxxx> wrote in message
news:uXJAJUd5IHA.1204@xxxxxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxx> wrote in message
news:EB1525BE-7FBC-43F3-BC21-E1592945E03D@xxxxxxxxxxxxxxxx
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



.

Relevant Pages

  • Re: Cost of ownership: MV vs. SQL Server
    ... been developed over 20 years can not be converted to SQL in three. ... > enforcement of of RI in a multi-value system is created at the ... >> I would think that at least a weekly application of security patches ... > "exposed" to the Internet. ...
    (comp.databases.pick)
  • RE: Blank page when logging request via the web
    ... > hyperlink in Internet Explorer. ... > quotation marks), and then click OK. ... > successful registration of this file, ... > | We have a system log through the internal web interface, ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Licensing
    ... employees will be accessing the sql backend, ... Licesing Mode dialog box when installing SQL 2000. ... the Internet or extranet), then the Per Processor license would be ideal. ...
    (microsoft.public.sqlserver.setup)
  • Re: Connecting to DB with Static IP over the internet
    ... I was getting mental over this because the settings on the sql server i did ... item on the connection string. ... stuff from the internet. ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL to combine columns
    ... Let me pull some imaginary money out of my ... Internet, as wonderful as it is, has its limitations. ... Yes, CELKO is a Master at RDBMS, I have just started out and have done ... advanced, in regards to SQL and RDBMS, recent copyright date please? ...
    (comp.databases.ms-sqlserver)