ASP Script to access a remote MS Access database [Archive]

View Full Version : ASP Script to access a remote MS Access database

bruce

08-21-2003, 02:26 AM

Microsoft remote provide is not supported. MS Remote provider uses Remote Data Service (RDS).

It is considered obsolete by Microsoft, see this

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledb_deprecated.asp

[b]quote:Originally posted by Peppitto

Hi,

I have a chalenging question; I would really apreciate any feedback,

Let us suppose that you have two websites, and they both have two seperate databases, and suppose you want those two database to talk to each others everytime an event is trigered on one of the websites ..

For example if you have a website 'A', that has many pages and that is accesable by the public. And you also have another website 'B', that has a MS Access DB, which collects data from website 'A', about how many people loged on to website 'A', and which pages they have viewed, and analyses it ....

So basicaly you need to run some script code on web site 'A', that when ever someone clicks on a link on website 'A', it increments a counter in the MS Access database on website 'B' ....

I have tried this typipcal code, but without any luck:

<%

set conn = Server.CreateObject("ADODB.Connection")

conn.open "Provider=MS Remote;" &_
"Remote Server=http://www.website 'A'.com;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source= \HitCounter.mdb;"

set rs = conn.Execute("SELECT * FROM tabella")

%>

.................................................. ..............

Please Advice
Thank You

</blockquote id="quote">

Peppitto

08-21-2003, 10:22 AM

Hi,

I have a chalenging question; I would really apreciate any feedback,

Let us suppose that you have two websites, and they both have two seperate databases, and suppose you want those two database to talk to each others everytime an event is trigered on one of the websites ..

For example if you have a website 'A', that has many pages and that is accesable by the public. And you also have another website 'B', that has a MS Access DB, which collects data from website 'A', about how many people loged on to website 'A', and which pages they have viewed, and analyses it ....

So basicaly you need to run some script code on web site 'A', that when ever someone clicks on a link on website 'A', it increments a counter in the MS Access database on website 'B' ....

I have tried this typipcal code, but without any luck:

<%

set conn = Server.CreateObject("ADODB.Connection")

conn.open "Provider=MS Remote;" &_
"Remote Server=http://www.website 'A'.com;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source= \HitCounter.mdb;"

set rs = conn.Execute("SELECT * FROM tabella")

%>

.................................................. ..............

Please Advice
Thank You

Peppitto

08-22-2003, 07:25 AM

Thank you for your feedback,

What about a remote SQL server DB??? Is that not supported as well??
And if not, please tell about any thoughts on a way for achieving this task, I am sure there is a way to it, and I really appreciate your help,
Thank You