CANT GET MS Remote Provider to work with Access help!!
$10-15 USD
完了済み
投稿日: 18年以上前
$10-15 USD
完了時にお支払い
help on error:
The amount on bid is basically a tip for anyone who can get on windows messenger and help me fix this problem. I am trying to connect from my site hosted in one place to a database setup on a different server(ip). This might be a permissions issue, but I have no idea how to setup the permission properly in IIs for this, the database is in access and Ive read about remote host, but its not working and if I use a regular connection string just with an ip and http it says cant find database, because someone told me something about the protocol cant accept the http.
Microsoft ADO/RDSerror '800a20ff'
Internet Server Error.
/[login to view URL], line 5
<%
dim cn, rs
set cn = CreateObject("[login to view URL]")
[login to view URL] "Provider=MS Remote;Remote Server=http://ip:65000;Microsoft.Jet.OLEDB.4.0;Data Source=c:\ups\uows\[login to view URL]"
set rs = [login to view URL]("SELECT * FROM calpkgagent")
[login to view URL]
set rs = nothing
[login to view URL]
set cn = nothing
%>i know on the code provided i put the " in the wrong place and moved it over now it gives me a:
Microsoft OLE DB Provider for ODBC Driverserror '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/[login to view URL], line 4
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ASP/MSAccess/MDB/IIs on winxp