-
Connection to Remote MDB
Hi all. I am trying to connect to a remote mdb database ( on the internet http:// ) via ADO but cant do it.
I tried nearly 100000 codes :) but none of them worked :((
i read the conneciton string at this site http://www.able-consulting.com/ado_conn.htm
but again nothing happened
Can some one write here a small exampla please. I Can do everything on a local database but can not connect to a remote mdb :((((
I really need help
For example i used this code (copied from this forum)
Set adoCon = Server.CreateObject("ADODB.Connection")
Set rsAddNewRecord = Server.CreateObject("ADODB.Recordset")
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("../dbroot/Names.mdb")
adoCon.Open strCon
This time it said Server Variable nor defined.
Shorlty I tried everything . Someone please Help :)
Also i tried an other code
Dim rs As New ADODB.Recordset
Dim cn As New ADODB.Connection
cn.Open "Provider=MS Remote;Data Source=thyvadb.mdb;" & _
"Remote Server=http://www.tlkclan.com/dokunmatufan/"
rs.Open "SELECT * FROM uye", cn
This time it said on this pðart : rs.open "select * fron uye" , cn
Object module not found
I also found many about remote mdb on early posts but couldnt do anything
Thanks very much for the hlep
-
-
