ADO Connection and Microsoft OLE DB Remoting Provider

zHugeCode7

Delphi Developer

ADO Connection and Microsoft OLE DB Remoting Provider

2007-01-06 12:33:36 AM
delphi165
Hi,
I make a MS Access database and a ODBC DSN on server (for example:
www.myserver.com) by my site control panel.
Now, i want to connect to my remote database by ADO connection
component (TADOConnection) using BCB or Delphi.
I think that, i need a proper OLE DB Provider for remoting connection
by ADO, but in my OLE DB Provider list does not exist any proper
provider.
I think that Microsoft OLE DB Remoting Provider is a proper provider,
but i dont have it.
Maybe, i need a source code or project example!
Thanks.

Guillem

Delphi Developer

2007-01-08 06:54:27 PM

Re:ADO Connection and Microsoft OLE DB Remoting Provider

XXXX@XXXXX.COM writes:

Quote

Hi,
I make a MS Access database and a ODBC DSN on server (for example:
www.myserver.com) by my site control panel.
Now, i want to connect to my remote database by ADO connection
component (TADOConnection) using BCB or Delphi.
I think that, i need a proper OLE DB Provider for remoting connection
by ADO, but in my OLE DB Provider list does not exist any proper
provider.
AFAIK this is not possible with Access. Keep in mind it is a desktop

database, not a RDBMS.

Quote

I think that Microsoft OLE DB Remoting Provider is a proper provider,
but i dont have it.
can't speak about this product, though

Quote

Maybe, i need a source code or project example!
my suggestion would be to either move onto an RDBMS or if you really

need to stay with Access then get the server to send you a copy of the
database.
Sorry I couldn't be of more help.
--
Best regards :)
Guillem Vicens Meier
Dep. Informática Green Service S.A.
www.clubgreenoasis.com
Contribute to the Indy Docs project: docs.indyproject.org
In order to contact me remove the -nospam