PDA

View Full Version : Can't connect to .MDB remotely


rrhandle
12-10-2004, 04:50 AM
I am not able to connect to a .mdb at our DiscountASP site from another website.
I have used the code below to do this successfully in the past, but it does not work with database at DiscountASP.
Any suggestions?

CBD_Pricing = 'Provider=MS Remote;' & _
'Remote Server=HTTP://WWW.CAGESBYDESIGN.COM;' & _
'Remote Provider=Microsoft.Jet.OLEDB.4.0;' & _
'Data Source=[physical path here],' & _
'[username here], [password here]'

Thanks for any help you can offer.

--Rob

bruce
12-10-2004, 10:42 AM
Remote Data Service is required for this to work. RDS is not supported on our server because

1) RDS is considered obsolete by Microsoft, ie. no support from MS. See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/mdacsdk/htm/mdac_deprecated_components.asp

2) RDS is insecure. See http://www.microsoft.com/technet/security/bulletin/ms99-025.mspx

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)

rrhandle
12-11-2004, 02:18 AM
OK. Thanks, Bruce. So how do I write the connection string?

bruce
12-12-2004, 10:42 AM
this depends on what you want to do.

do you want to connect your webapp to an access db?

Bruce

DiscountASP.NET
www.DiscountASP.NET (http://www.DiscountASP.NET)