Professional Web Applications Themes

please help, I'm having a DSN breakdown - Macromedia Dreamweaver

Hi guys, I've created a dynamic site that uses a simple access database. When I test it on my computer, it works great. I uploaded it to my remote server, and I can't submit forms anymore. I get this error: Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified /midwayst/pages/index.asp, line 14 The tech support guy got back to me and said "You must upload the database and setup a DSN to point to it. After doing that you must configure your ASP script to connect to ...

  1. #1

    Default please help, I'm having a DSN breakdown

    Hi guys,

    I've created a dynamic site that uses a simple access database. When I test it on my computer, it works great. I uploaded it to my remote server, and I can't submit forms anymore. I get this error:

    Microsoft OLE DB Provider for ODBC Drivers error '80004005'
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    /midwayst/pages/index.asp, line 14



    The tech support guy got back to me and said "You must upload the database and setup a DSN to point to it. After doing that you must configure your ASP script to connect to the DSN you set up."

    I uploaded the database and setup a DSN to point to it, now what? I have to congifure my ASP script to connect to the DSN? How do I do that?

    In dreamweaver, I setup my remote server as the testing server. Then in the database area, I tried to connect "using DSN on testing server". I thought I'd see this DSN pop up in the list but, it didn't. There is no list, the box is empty. Does this prove anything?

    Please help me.

    artane


    artane webforumsuser@macromedia.com Guest

  2. #2

    Default Re:please help, I'm having a DSN breakdown

    Hi nancy,

    The tech support guy got back to me this morning with this:

    "I see that you have a DSN set up already in the control panel which is great, in your ASP script there should be an area where it asks for a source name or a path, you would either type in your DSN or the path that is right next to the DSN in the control panel "E:/web......."."

    Now, my "ASP scipt" means the code? Am I supposed to change the code for each and every page in my site? I've got to do this every time I upload a site?

    I still can't see the DSN on the remote/testing server through Dreamweaver. The tech support guy seems to be dodging this question.

    Thanks alot for your help,

    artane



    artane webforumsuser@macromedia.com Guest

Similar Threads

  1. loadMovie to breakdown larger movie
    By alphamale_no1 in forum Macromedia Flash Actionscript
    Replies: 0
    Last Post: February 7th, 11:05 PM
  2. Week breakdown to days
    By Gary Nelson in forum Microsoft Access
    Replies: 1
    Last Post: July 14th, 05:48 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