Error HELP!!

Results 1 to 4 of 4

Thread: Error HELP!!

  1. #1
    Join Date
    Dec 1969
    Posts
    146

    Default Error HELP!!

    hi,<BR>I have made a script that works fine on my HDD running IIS, when I go to run it on my host I get the following error<BR><BR>Microsoft OLE DB Provider for ODBC Drivers error &#039 80004005&#039 <BR><BR>[Microsoft][ODBC Microsoft Access Driver] &#039(unknown)&#039 is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. <BR><BR>/topsites/index.asp, line 3 <BR><BR><BR>You can check it out for yourself by going to http://tt.wwgamez.com/topsites/<BR><BR>My code is below. Please help I really need this to work, thanks<BR>I have checked the server location of the file DSN multiple times and it is absolutely correct.<BR><BR><BR><BR>&#060;%<BR>Set MyConn = Server.CreateObject("ADODB.Connection")<BR>MyConn. Open "FILEDSN=f:hosted_siteswwgamez t opsitesMyTable_dsn.dsn"<BR>%&#062;<BR>&#060;%<BR>D im Voted<BR>voted = request.cookies("voted")<BR><BR>%&#062;<BR><BR>&#0 60;HTML&#062;<BR>&#060;HEAD&#062;<BR>&#060;TITLE&# 062;Top20 Gaming Sites - A TTN Production&#060;/TITLE&#062;<BR>&#060;style&#062;<BR>&#060;!--<BR>A:link {text-decoration: none}<BR>A:visited {text-decoration: none}<BR>A:active {text-decoration: none}<BR>A:hover {color:#646464}<BR>{ font-family: OCR A Extended }<BR>--&#062;<BR>&#060;/style&#062;<BR><BR>&#060;META NAME="resource-type" CONTENT="document"&#062;<BR>&#060;META NAME="generator" CONTENT="Russell Proud"&#062;<BR>&#060;META NAME="author" CONTENT="Lightning"&#062;<BR>&#060;META NAME="description" CONTENT="The Tiberian Twilight Nation, your 1 stop resource for all things Tiberian Twilight"&#062;<BR>&#060;META NAME="keywords" CONTENT="command, and, conquer, tiberian, twilight, red, alert, westwood, lightning, flash, tiberium, sun, c&c, gold, nation, tt, tanks, guns, infantry, orca, gdi, nod, power, plant, games, rts, real, time, strategy, covert, operations, competitions, new, game, zone, tib, maps, ccmap, units, virgin, ea, sierra, electronic, arts, interactive"&#062;<BR>&#060;META NAME="distribution" CONTENT="Global"&#062;<BR><BR><BR><BR><BR>&#060;/HEAD&#062;<BR>&#060;BODY BGCOLOR="#000000" TEXT="#646464" VLINK="#FF9800" ALINK="#FF9800" LINK="#FF9800" LANG="en-AUS"&#062;<BR><BR><BR><BR><BR><BR><BR><BR><BR>&#06 0;%<BR>SQL_query = "SELECT TOP 20 * FROM topsites"<BR>Set RS = MyConn.Execute(SQL_query)<BR><BR>%&#062; <BR>&#060;CENTER&#062; <BR>&#060;TABLE CELLSPACING="0" CELLPADDING="0" BORDER="0"&#062;<BR> &#060;TR&#062;<BR> &#060;TD BACKGROUND="images/topleft.gif"&#062;&#060;/TD&#062;<BR> &#060;TD BACKGROUND="images/top.gif"&#062;&#060;FONT FACE="Copperplate Gothic Bold" SIZE="+2"&#062;&#060;CENTER&#062;TOP 20 GAMING SITES&#060;/CENTER&#062;&#060;/FONT&#062;&#060;P&#062;&#060;/TD&#062;<BR> &#060;TD BACKGROUND="images/circle.gif" WIDTH="20"&#062;&#060;/TD&#062;<BR> &#060;/TR&#062;<BR> &#060;TR&#062;<BR> &#060;TD WIDTH="170" BACKGROUND="images/tback.jpg" VALIGN="TOP"&#062;&#060;IMG SRC="images/users.gif" BORDER="0"&#062;<BR>&#060;TABLE WIDTH="160" ALIGN="CENTER" VALIGN="TOP"&#062;<BR> &#060;TR&#062;<BR> &#060;TD&#062;&nbsp;<BR>&#060;A HREF="join.asp"&#062;&#060;SMALL&#062;Join&#060;/A&#062;<BR>&#060;A HREF="mailto:lightning@tiberianzone.com"&#062;E-Mail Me&#060;/A&#062;&#060;/SMALL&#062;&#060;/A&#062;&#060;P&#062;&#060;/TD&#062;<BR> &#060;/TR&#062;<BR>&#060;/TABLE&#062;<BR>&#060;IMG SRC="images/members.gif" BORDER="0"&#062;<BR>&#060;TABLE WIDTH="160" ALIGN="CENTER" VALIGN="TOP" CELLSPACING="0" CELLPADDING="0"&#062;<BR> &#060;TR&#062;<BR> &#060;TD&#062;&nbsp;<BR>&#060;A HREF="edit.asp"&#062;&#060;SMALL&#062;Edit Your Site&#060;/SMALL&#062;&#060;/A&#062;<BR><BR><BR> &#060;A HREF="delete.asp"&#062;&#060;SMALL&#062;Delete Your Site&#060;/SMALL&#062;&#060;/A&#062;&#060;P&#062;&#060;/TD&#062;<BR> &#060;/TR&#062;<BR>&#060;/TABLE&#062;<BR><BR>&#060;/TD&#062;<BR> &#060;TD VALIGN="TOP"&#062;&#060;TABLE WIDTH="550" BORDER="1" BORDERCOLOR="Navy" CELLPADDING="0" CELLSPACING="0" VALIGN="TOP"&#062;<BR>&#060;TR&#062;<BR> &#060;TD HEIGHT="25"&#062; &#060;CENTER&#062;Site Name&#060;/CENTER&#062; &#060;/TD&#062;<BR> &#060;TD Width="30" HEIGHT="25"&#062; &#060;CENTER&#062;Votes&#060;/CENTER&#062; &#060;/TD&#062;<BR> &#060;TD WIDTH="30" HEIGHT="25"&#062; &#060;CENTER&#062;Info&#060;/CENTER&#062; &#060;/TD&#062;<BR><BR> &#060;TD WIDTH="30" HEIGHT="25"&#062; &#060;CENTER&#062;Vote&#060;/CENTER&#062; &#060;/TD&#062;<BR><BR><BR>&#060;/TR&#062;<BR>&#060;%<BR>WHILE NOT RS.EOF<BR>%&#062; <BR><BR><BR><BR> &#060;TR&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;A HREF="&#060;%=RS("URL")%&#062;"&#062;&#060;%=RS("N ame")%&#062;&#060;/A&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR><BR> &#060;TD&#062;&#060;CENTER&#062;&#060;%=RS("Votes" )%&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR> &#060;TD&#062;&#060;CENTER&#062;&#060;A HREF="/topsites/info.asp?ID=&#060;%=RS("ID")%&#062;" Target="_blank"&#062;&#060;IMG SRC="images/info.gif" BORDER="0"&#062;&#060;/A&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR><BR><BR> &#060;TD&#062;&#060;CENTER&#062;&#060;A HREF="/topsites/vote.asp?ID=&#060;%=RS("ID")%&#062;"&#062;&#060;IM G SRC="images/vote.gif" BORDER="0"&#062;&#060;/A&#062;&#060;/CENTER&#062;&#060;/TD&#062;<BR><BR><BR><BR> &#060;/TR&#062;<BR><BR>&#060;%<BR>RS.MoveNext<BR>Wend<BR> %&#062;<BR>&#060;/TABLE&#062;&#060;/TD&#062;<BR> &#060;TD&#062;&#060;/TD&#062;<BR> &#060;/TR&#062;<BR> &#060;TR&#062;<BR> &#060;TD BACKGROUND="images/bottomleft.gif" Height="50"&#062;&#060;/TD&#062;<BR> &#060;TD BACKGROUND="images/bottom.gif"&#062;&#060;/TD&#062;<BR> &#060;TD BACKGROUND="images/bottomcircle.gif" WIDTH="20"&#062;&#060;/TD&#062;<BR> &#060;/TR&#062;<BR><BR>&#060;/TABLE&#062;<BR><BR>&#060;SMALL&#062;&#060;SMALL&#0 62;&#060;!--#include file="footer.txt"--&#062;&#060;/SMALL&#062;&#060;/SMALL&#062;<BR><BR><BR>&#060;/CENTER&#062;<BR>&#060;/BODY&#062;<BR>&#060;/HTML&#062;

  2. #2
    Join Date
    Dec 1969
    Posts
    10

    Default RE: Error HELP!!

    does the web server have a dive mapped to F like your local computer does? and if so is it right!?!? thats just the first thing i noticed.<BR>MyConn.Open "FILEDSN=f:hosted_siteswwgamez t opsitesMyTable_dsn.dsn"<BR>

  3. #3
    Join Date
    Dec 1969
    Posts
    146

    Default RE: Error HELP!!

    That is the location of the DSN on the server. Is there anyway of making a system DSN on the server?? Would you what is the problem. It runs fine on ym PC running IIS 5.0

  4. #4
    Join Date
    Dec 1969
    Posts
    10

    Default RE: Error HELP!!

    That is the only way i have ever done it, to actualy get on the web server and create the DSN, supposeably you can refrence system DSN like that but i dont think you can use a MAPPED drive, i think you have to use //COMPUTERNAME/DRIVE/etc... but if you can make the DNS on the actual web server and eleminate that as the problem. best of luck!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •