ODBC path

[PhillyMike]

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)

[joelnet]

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

[PhillyMike]

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=" &amp; 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: registration@discountasp.net [mailto:registration@discountasp.net (registration@discountasp.net)]


Sent: Sunday, December 03, 2006 1:50 AM


To: mike.haftel@cox.net


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.

[joelnet]

can you provide a url to an example of the problem?


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

[PhillyMike]

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.

[PhillyMike]

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 ID:D3889380-LROR
Domain Name:POTOMACAREAROADRIDERS.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 Name:Potomac Area Road Riders
Registrant Organization:Potomac 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:warasoc1@comcast.net
Admin ID:25850874-NSI
Admin Name:null null
Admin Street1:Potomac 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:PARR@POTOMACAREAROADRIDERS.ORG
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:customerservice@networksolutions.com
Name Server:NS2.DISCOUNTASP.NET
Name Server:NS1.DISCOUNTASP.NET

[vvsharma]

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/ (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 (http://www.discountasp.net/)

[PhillyMike]

What do mean it works? I tried that url and received the following error message:


"Error- Internal server error." How do I correct that?

[vvsharma]

I still dont get any such error after I click http://www.potomacarearoadriders.org/wwwroot/portal/ (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 (http://www.discountasp.net/)

Post Edited (vvsharma) : 12/7/2006 11:45:31 PM GMT

[PhillyMike]

Try this: http://potomacarea.web140.discountasp.net/

[vvsharma]

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 (http://www.discountasp.net/)

[PhillyMike]

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?

[vvsharma]

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 (http://www.discountasp.net/)

[PhillyMike]

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?

[vvsharma]

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 (http://www.discountasp.net/)

[bruce]

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 (http://www.DiscountASP.NET)

[PhillyMike]

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.

[PhillyMike]

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.

[vvsharma]

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 (http://www.discountasp.net/)