run time error 8209 : object not found

[Alexandre ARASTE]

I made a connection whith Ms Remote to an Access 2000 database whith vb 6.

the connection string looks like that : "Provider = MS Remote; Remote
Server=http://serveur1; Remote Provider=MSDASQL;Data Source=MyTag;"
My msdfmap.ini file is correctly writen and it works perfectly on my lan
network

When I replace then Remote Server = http://serveur1 (which is my local
server whith nt 4.0 sp5 + iis 4.0) by Remote Server=http://MyProviderServer
(which as got the same configuration), I've got the following error :

run time error 8209 : object or module can't be found...

I can't undersand

Thanks for you help.

Alexandre, Lille, France

[Carl Prothman]

Alexandre ARASTE <aar...@goweb.fr> wrote in message
news:eV1NsG2O$GA.212@cppssbbsa05...

> I made a connection whith Ms Remote to an Access 2000 database whith vb 6.
>
> the connection string looks like that : "Provider = MS Remote; Remote
> Server=http://serveur1; Remote Provider=MSDASQL;Data Source=MyTag;"
> My msdfmap.ini file is correctly writen and it works perfectly on my lan
> network
>
> When I replace then Remote Server = http://serveur1 (which is my local
> server whith nt 4.0 sp5 + iis 4.0) by Remote
Server=http://MyProviderServer
> (which as got the same configuration), I've got the following error :
>
> run time error 8209 : object or module can't be found...
>

Try using the OLE DB Provider for JET and the RDS DataFactory Custom
Handler as follows:

oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://carl2;" & _
"Handler=MSDFMAP.Handler;" & _
"Data Source=MyAdvworksOLEDBConnectTag;"

The corresponding entry in the \winnt\Msdfmap.ini file would be:

[connect MyAdvworksOLEDBConnectTag]
Access = ReadWrite
Connect = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=mydb.mdb;" & _
"User Id=admin;" & _
"Password=;"

http://www.able-consulting.com/ADO_Conn.htm#MSRemoteAccess

--

Thanks,
Carl Prothman, MVP, CCP
http://www.able-consulting.com

ADO FAQ: http://www.able-consulting.com/ado_faq.htm
RDS FAQ: http://www.able-consulting.com/rds_faq.htm