Professional Web Applications Themes

[Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error - ASP

This is probably an old problem that most of you know how to fix (I hope!). The scenario is that I have a web server running an ASP site that needs to access a database on another server. The web servers ODBC connection are set to access the database and this is confirmed by running Excel and pulling back some data. The ASP scripts are set to use the same DSN but I get the above error when the script runs. If I move the database local to the web site ASP pages, then I get no problems. I'm therefore ...

  1. #1

    Default [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    This is probably an old problem that most of you know how to fix (I hope!).
    The scenario is that I have a web server running an ASP site that needs to
    access a database on another server. The web servers ODBC connection are
    set to access the database and this is confirmed by running Excel and
    pulling back some data. The ASP scripts are set to use the same DSN but I
    get the above error when the script runs. If I move the database local to
    the web site ASP pages, then I get no problems.

    I'm therefore assuming that this is some sort of permissions problem, but I
    don't see what I need to change. If Excel is able to read the data via the
    same DSN, then why can't my ASP web site ?

    Thanks in advance


    Mystery Guest

  2. #2

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    > I'm therefore assuming that this is some sort of permissions problem, but
    I
    > don't see what I need to change. If Excel is able to read the data via
    the
    > same DSN, then why can't my ASP web site ?
    Because Excel is an application, started by YOU. ASP is run as an anonymous
    user. I am assuming the database is located on a network share?

    [url]http://www.aspfaq.com/2168[/url]

    Also, please STOP uisng a DSN!

    [url]http://www.aspfaq.com/2126[/url]

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]


    Aaron Bertrand [MVP] Guest

  3. #3

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    Aaron,

    Maybe we should reserve dsnisbad.com and devote the whole
    site to why DSN's are a bad thing!

    John



    >-----Original Message-----
    >> I'm therefore assuming that this is some sort of
    permissions problem, but
    >I
    >> don't see what I need to change. If Excel is able to
    read the data via
    >the
    >> same DSN, then why can't my ASP web site ?
    >
    >Because Excel is an application, started by YOU. ASP is
    run as an anonymous
    >user. I am assuming the database is located on a network
    share?
    >
    >[url]http://www.aspfaq.com/2168[/url]
    >
    >Also, please STOP uisng a DSN!
    >
    >[url]http://www.aspfaq.com/2126[/url]
    >
    >--
    >Aaron Bertrand
    >SQL Server MVP
    >[url]http://www.aspfaq.com/[/url]
    >
    >
    >.
    >
    John Beschler Guest

  4. #4

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    Well its all Dreamweavers fault!! It only seems to like creating DSN's !!
    (but I'm probably doing that wrong as well then huh ?!! :-)

    "John Beschler" <gilesgeewhiz.com> wrote in message
    news:f26301c3bd9c$2ad55e00$a601280aphx.gbl...
    > Aaron,
    >
    > Maybe we should reserve dsnisbad.com and devote the whole
    > site to why DSN's are a bad thing!
    >
    > John
    >
    >
    >
    >
    > >-----Original Message-----
    > >> I'm therefore assuming that this is some sort of
    > permissions problem, but
    > >I
    > >> don't see what I need to change. If Excel is able to
    > read the data via
    > >the
    > >> same DSN, then why can't my ASP web site ?
    > >
    > >Because Excel is an application, started by YOU. ASP is
    > run as an anonymous
    > >user. I am assuming the database is located on a network
    > share?
    > >
    > >[url]http://www.aspfaq.com/2168[/url]
    > >
    > >Also, please STOP uisng a DSN!
    > >
    > >[url]http://www.aspfaq.com/2126[/url]
    > >
    > >--
    > >Aaron Bertrand
    > >SQL Server MVP
    > >[url]http://www.aspfaq.com/[/url]
    > >
    > >
    > >.
    > >

    Mystery Guest

  5. #5

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    > (but I'm probably doing that wrong as well then huh ?!! :-)

    If you mean using Dreamweaver at all, then IMHO, yes.

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]


    Aaron Bertrand - MVP Guest

  6. #6

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    LOL.
    I know he meant that he was using Dreamweaver wrong (and you know too).
    But I still like your answer.
    Let's get these people using sissy tools to create Web pages.
    Real men (and women) use Notepad. :-)

    "Aaron Bertrand - MVP" <aaronTRASHaspfaq.com> wrote in message
    news:%23SjL8UbvDHA.3224tk2msftngp13.phx.gbl...
    > > (but I'm probably doing that wrong as well then huh ?!! :-)
    >
    > If you mean using Dreamweaver at all, then IMHO, yes.
    >
    > --
    > Aaron Bertrand
    > SQL Server MVP
    > [url]http://www.aspfaq.com/[/url]
    >
    >

    Raymond D'Anjou \(raydan\) Guest

  7. #7

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    > Let's get these people using sissy tools to create Web pages.
    > Real men (and women) use Notepad. :-)
    I touch on this here:
    [url]http://www.aspfaq.com/2500[/url]

    --
    Aaron Bertrand
    SQL Server MVP
    [url]http://www.aspfaq.com/[/url]


    Aaron Bertrand - MVP Guest

  8. #8

    Default Re: [Microsoft][ODBC Microsoft Access Driver]'(unknown)' is not a valid path error

    "Raymond D'Anjou (raydan)" <raydancanatrade.nospamcom> wrote in message
    news:OcVHy5bvDHA.2080TK2MSFTNGP10.phx.gbl...
    > LOL.
    > I know he meant that he was using Dreamweaver wrong (and you know
    too).
    > But I still like your answer.
    > Let's get these people using sissy tools to create Web pages.
    > Real men (and women) use Notepad. :-)
    Real men tap out the code in binary on their keyboard port.


    Chris Hohmann Guest

Similar Threads

  1. Replies: 6
    Last Post: September 2nd, 01:22 PM
  2. Replies: 2
    Last Post: July 20th, 11:36 AM
  3. Replies: 1
    Last Post: December 13th, 02:59 AM
  4. [Microsoft][ODBC Visual FoxPro Driver]Cannot update the cursor.
    By Mariano Fernandao in forum ASP.NET Web Services
    Replies: 0
    Last Post: December 10th, 06:30 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139