Client-Server Database Application - Remote Connection

From: "zHugeCode7" <zHugeCode7@xxxxxxxxx>
Date: 3 Jan 2007 12:04:42 -0800

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.
Please, tell me how i can connect to the remote database.
Maybe, i need a source code example!
.

Prev by Date: Re: ADO Master Detail: disable temporary
Next by Date: Re: Refreshing a current record in a DataSet
Previous by thread: ncarchar update issue
Next by thread: Re: Refreshing a current record in a DataSet
Index(es):
- Date
- Thread

Relevant Pages

Re: question about mining external databases and exporting mining models into pmml
... have a provider that we can work with (OLE DB provider or .Net data ... I think Oracle has both an OLE DB provider and a managed ... On the second question: models' PMML may be exported with a statement like: ... database on sql server database engine. ...
(microsoft.public.sqlserver.datamining)
Re: question about mining external databases and exporting mining models into pmml
... have a provider that we can work with (OLE DB provider or .Net data ... I think Oracle has both an OLE DB provider and a managed ... On the second question: models' PMML may be exported with a statement like: ... database on sql server database engine. ...
(microsoft.public.sqlserver.datamining)
Cant query linked Access database specified by UNC
... I link Access database to sql server 2000 with ole db 4 provider; ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
(microsoft.public.sqlserver.security)
Cant query linked Access database specified by UNC
... I link Access database to sql server 2000 with ole db 4 provider; ... OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. ...
(microsoft.public.sqlserver.server)
Linked server to as400 - for the love of god please help.
... i'm trying to setup a linked server between SQL Server and an AS400/DB2/IBM ... OLE DB provider 'MSDASQL' reported an error. ... OLE DB error trace [OLE/DB Provider 'IBMDA400' IColumnsInfo::MapColumnIDs ...
(microsoft.public.sqlserver.server)