Re: Access SQL Server Express over the Internet

Am Fri, 26 Oct 2007 17:15:34 +0200 schrieb danny heijl:

....
Every tutorial will or should tell you not to do it.

You should use webservices or something equivalent, not ADO.
....

Very interesting - any reasons why not ADO?
I have a big application (written with Delphi, using ADO) running with
clients in different countries in Europe and hanging all together on one
central server - everything works like a charm since two years.
The server is SQL2005 and we are using certification and a special port and
name for the instance. Never had any safety-, speed- or ressource problems.

bye,
Helmut
.

Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)
  • Re: slow ADO refresh, ending in error message
    ... It seems to me that if the feature works fine with some implementations ... with Delphi 7) and poorer with other implementations (the Delphi 7 ... >>Is ADO only for small databases then? ... > You can use any size database with ADO but if you want good performance you ...
    (borland.public.delphi.database.ado)