I moved a web site to a new host and cannot bring it back up. Error messages point to an incorrect ODBC path. How can I correct this problem and bring the web page back up? Philly Mike Potomac Area Road Riders (PARR)
put the correct ODBC path in? can you be more specific? error message? maybe a url to an example of the problem? Joel Thoms DiscountASP.NET http://www.DiscountASP.NET
Thanks for your help. Below is the last message I received in the thread from my host's support desk. The files and database they added (to give me a suggestion on how to create a valid ODBC path) are as follows: Testdb.mdb: ID fname lname 1 DASP Support 2 John Dow Testdasp.asp: <% Dim cnnSimple ' ADO connection Dim rstSimple ' ADO recordset Set cnnSimple = Server.CreateObject("ADODB.Connection") ' DSNLess cnnSimple.Open ("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\db\testdasp.mdb")) Set rstSimple = cnnSimple.Execute("SELECT * FROM tbltest") %> <P> Connecting to Access with Ole connection </P> <table border="1"> <% Do While Not rstSimple.EOF %> <tr> <td><%= rstSimple.Fields(0).Value %></td> <td><%= rstSimple.Fields(1).Value %></td> </tr> <% rstSimple.MoveNext Loop %> </table> <% rstSimple.Close Set rstSimple = Nothing cnnSimple.Close Set cnnSimple = Nothing %> In response, my ODBC path: \db\ua_portal.mdb; my DSN name is: potomacarea_ua_porta -----Original Message----- From: [email protected] [mailto:[email protected]] Sent: Sunday, December 03, 2006 1:50 AM To: [email protected] Subject: [TECH-DASP #510737]: Uploading problems Dear Customer, The path you have inputted to the database is incorrect. I have created a simple db call testdasp.mdb and uploaded it to your db folder. I have then created a simple asp script call testdasp.asp and uploaded it to your portal folder. potomacarearoadriders.org/portal/testdasp.asp Please review to code for the proper server path to your Access db's.
can you provide a url to an example of the problem? Joel Thoms DiscountASP.NET http://www.DiscountASP.NET
Then the DNS pointer must be incorrect, because I uploaded potomacarearoadriders.org to the web host server and there is a portal directory. The directory named portal is a subdirectory under wwwroot. The url is the same as when we ran the web page on another host server, and it worked well there. To test the problem, I moved "portal" our of wwwroot and still received the same error message.
Here isthe "Whois" record for Potomacroadriders.org: WHOIS information for: potomacarearoadriders.org: [whois.publicinterestregistry.net] NOTICE: Access to .ORG WHOIS information is provided to assist persons in determining the contents of a domain name registration record in the Public Interest Registry registry database. The data in this record is provided by Public Interest Registry for informational purposes only, and Public Interest Registry does not guarantee its accuracy. This service is intended only for query-based access. You agree that you will use this data only for lawful purposes and that, under no circumstances will you use this data to: (a) allow, enable, or otherwise support the transmission by e-mail, telephone, or facsimile of mass unsolicited, commercial advertising or solicitations to entities other than the data recipient's own existing customers; or (b) enable high volume, automated, electronic processes that send queries or data to the systems of Registry Operator or any ICANN-Accredited Registrar, except as reasonably necessary to register domain names or modify existing registrations. All rights reserved. Public Interest Registry reserves the right to modify these terms at any time. By submitting this query, you agree to abide by this policy. Domain ID3889380-LROR Domain NameOTOMACAREAROADRIDERS.ORG Created On:25-Feb-1999 05:00:00 UTC Last Updated On:29-Nov-2006 01:44:13 UTC Expiration Date:25-Feb-2008 05:00:00 UTC Sponsoring Registrar:Network Solutions LLC (R63-LROR) Status:CLIENT TRANSFER PROHIBITED Registrant ID:25850871-NSI Registrant Nameotomac Area Road Riders Registrant Organizationotomac Area Road Riders Registrant Street1:Box 358 Registrant Street2: Registrant Street3: Registrant City:McLean Registrant State/Province:VA Registrant Postal Code:22101 Registrant Country:US Registrant Phone:+1.70324125 Registrant Phone Ext.: Registrant FAX: Registrant FAX Ext.: Registrant Email:[email protected] Admin ID:25850874-NSI Admin Name:null null Admin Street1otomac Area Road Riders Admin Street2:Box 358 Admin Street3: Admin City:McLean Admin State/Province:VA Admin Postal Code:22101 Admin Country:US Admin Phone:+1.70324125 Admin Phone Ext.: Admin FAX: Admin FAX Ext.: Admin Email[email protected] Tech ID:5358805-NSI Tech Name:Network Solutions, LLC. Tech Organization:Network Solutions, LLC. Tech Street1:13200 Woodland Park Drive Tech Street2: Tech Street3: Tech City:Herndon Tech State/Province:VA Tech Postal Code:20171-3025 Tech Country:US Tech Phone:+1.188864296 Tech Phone Ext.: Tech FAX:+1.5714344620 Tech FAX Ext.: Tech Email:[email protected] Name Server:NS2.DISCOUNTASP.NET Name Server:NS1.DISCOUNTASP.NET
According to the information you provided ,there is sub-folder wwwroot>portal ,but the url is pointing to http://www.potomacarearoadriders.org/portal/.I tried http://www.potomacarearoadriders.org/wwwroot/portal/ and it works.I am not sure whether you intended to have the wwwroot ? Vikram DiscountASP.NET www.DiscountASP.NET
What do mean it works? I tried that url and received the following error message: "Error- Internal server error." How do I correct that?
I still dont get any such error after I click http://www.potomacarearoadriders.org/wwwroot/portal/ .There is surely a DB related error on the page,which could be due to the fact that the mdb path specified is incorrect or the application does not have appropriate permissions to the specified mdb. Attached a screenshot of the page i see. Vikram DiscountASP.NET www.DiscountASP.NET Post Edited (vvsharma) : 12/7/2006 11:45:31 PM GMT
The link doesnt show up anything.I believe it redirects to 'http://www.potomacarearoadriders.org/portal/' which doesnt exist. Vikram DiscountASP.NET www.DiscountASP.NET
I don't understand why you see the header to our web page, yet I still receive a DNS errror. I added discountASP.net's DNS server names to our DNS records. Should I request a new domain?
Could send me a screenshot of the error you get? Does this happen even if you click on the link i provided? Vikram DiscountASP.NET www.DiscountASP.NET
Another mystery: why can't I reach http://potomacarea.web140.discountasp.net ? I receive the same DNS error. Perhaps there is a permissions problem since this is the alternative path provided by the web host to the web page. Why don't they just give me an ip address so it doesn't need DNS translation?
You cant reach the the link you provided because it redirects you to 'http://www.potomacarearoadriders.org/portal/ ' .Now you have placed 'portal' within 'wwwroot' subfolder as you said ,so 'http://www.potomacarearoadriders.org/wwwroot/portal/' pulls the page. (http://potomacarea.web140.discountasp.net should work irrespecitve of the DNS resoultion,which I can see from your whois info, is pointing to DASP) Resoultion: Either place the portal subfolder outside the wwwroot or change the redirect path to http://www.potomacarearoadriders.org/wwwroot/portal/ and not http://www.potomacarearoadriders.org/portal/ Vikram DiscountASP.NET www.DiscountASP.NET
this could be a permission issue too. submit a support ticket and ask support to check permission on the database file or directory. Bruce DiscountASP.NET www.DiscountASP.NET
I have multiple Access data bases and I am pointing to System.mdb. Is there a specific data base I should point to? Also, is there a rule about the name? I have created many other ODBC drivers before and never had this problem.
Why am I still receiving DNS errors: "Cannot find www.potomacroadriders.org" ? I checked the DNS listing on the control panel and there is the ip address.It looks like it should work.
I dont think,there is an issue with your DNS entries.Its just your path.See my previous post. Vikram DiscountASP.NET www.DiscountASP.NET
