Re: Access SQL Server Express over the Internet
- From: nilson001@xxxxxxxxx
- Date: Sat, 27 Oct 2007 21:53:11 -0700
On Oct 27, 10:14 am, Helmut Woess <use...@xxxxxxxx> wrote:
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
Humm...
I'm developing a system with Delphi, ADO and SQL2005. My main problem
is: how to reduce the ADO/OleDB/SqlNativeClient traffic and delay -
for each query the MS Layer generates:
1. SET NO_BROWSETABLE ON [TDS RPC format]
Some response (ack)
2. SET FMTONLY YES / ORIGINAL_QUERY / SET FMTONLY NO (wait-for-
response) [TDS RPC format]
Some response (columns names and types)
3. SET NO_BROWSETABLE ON (wait-for-response) [TDS Query format]
Some response ()
4. ORIGINAL_QUERY (again) [TDS Query format]
Desired Response (Data finally)
Running on local network the total cycle is very fast because of LAN
low latency.
But with a medium latency/low speed VPN the total time to receive
response became too slow, although server response is very fast.
Any suggestions, solutions?
Additional Info: CursorLocation: Client, CursorType: ForwardOnly,
LockType: ReadOnly.
.
- References:
- Access SQL Server Express over the Internet
- From: PeteDaMeat
- Re: Access SQL Server Express over the Internet
- From: danny heijl
- Re: Access SQL Server Express over the Internet
- From: Helmut Woess
- Access SQL Server Express over the Internet
- Prev by Date: Stored proc timeout issue
- Next by Date: Inserting and accessig Image (bmp) data in an SQL 2005 database.
- Previous by thread: Re: Access SQL Server Express over the Internet
- Next by thread: Re: Access SQL Server Express over the Internet
- Index(es):
Relevant Pages
|
|
