Re: Connect over internet
- From: "Ian Hinson" <pparagon@xxxxxxxxxxxxxx>
- Date: Wed, 21 Jun 2006 20:40:58 +1000
"Edwin Walker" <1enwalker@xxxxxxxxxx> wrote in message
news:44959e40@xxxxxxxxxxxxxxxxxxxxxxxxx
If that is what you are trying to do, I would suggest that you look at a
Thin solution like ASTA, RemObjects, RealThinClient and KbmMW.
You could do it with just ADO, but ADO is very fat and slow over the net.
I used ADO to connect to a MySQL database over the Net.
I set up the "MyODBC" driver on the client machine then used the
"Microsoft OLEDB Provider for ODBC" for the ADO connection.
While the program was in development I naturally set up a MySQL
server running locally on my LAN first with a database with the same
structure (and similar data) to the target server so I could test the
application before deploying against the "real" mySQL server.
MySQL provides a neat capability to optionally start it using a log file
which logs every command sent to it. It made fascinating reading.
What I learnt from this was:
1) Everything you do with the ADO dataset ultimately is transmitted
across the network as "pure text" SQL command, ie. either a
SELECT query or an INSERT, UPDATE, or DELETE query.
2) Something going on behind the scenes (either the ODBC driver
or the OLEDB provider or somewhere else) is very clever in its
construction of the appropriate SQL command for each operation.
eg. it automatically identifies the keys to the table so an UPDATE
SQL command can uniquely identify which row to update.
3) It automatically does its own caching. I found that, when stepping
through the rows of a large table (eg using DBNavigator), the
SELECT statement requests a *few* rows at a time, not just one,
but not all of the rows in the table.
So, although working with a database across the 'Net may be slow,
I can't see how anything can do it better than ADO does. In the
end it is transmitting its requests across the wire as pure SQL stmts.
How efficiently the returned data is packaged (for SELECT stmts)
is not dependent on the access technology, but by the server itself.
Ian.
Edwin
"Alan T" <alanpltseNOSPAM@xxxxxxxxxxxx> wrote in message
news:44954435@xxxxxxxxxxxxxxxxxxxxxxxxx
Yes, what I am trying to do is writting an application using TADOcomponent
to connect to a remote server via internet.
"Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx> wrote in message
news:xn0enkzax5lwyd000@xxxxxxxxxxxxxxxxxxxxxxxxx
Edwin Walker wrote:
Maybe he is asking if you can connect using ADO over the internet.
good point :)
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
.
- Follow-Ups:
- Re: Connect over internet
- From: Edwin Walker
- Re: Connect over internet
- References:
- Connect over internet
- From: Alan
- Re: Connect over internet
- From: Guillem
- Re: Connect over internet
- From: Edwin Walker
- Re: Connect over internet
- From: Guillem
- Re: Connect over internet
- From: Alan T
- Re: Connect over internet
- From: Edwin Walker
- Connect over internet
- Prev by Date: Re: prepared command (or instruction) S000002 not found error
- Next by Date: Re: ADOX - Create new query in Access Database
- Previous by thread: Re: Connect over internet
- Next by thread: Re: Connect over internet
- Index(es):
Relevant Pages
|
