Data source name too long (asp)

Ask a Question related to Dreamweaver AppDev, Design and Development.

  1. #1

    Default Data source name too long (asp)

    I am using asp and I am trying to set up a custom connection string using the
    Dreamweaver menus. I have entered the following into the Connection String
    textbox on the Custom Connection String dialog:
    'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &
    Server.MapPath('\Resources\Resources.mdb');' When I click the test button I
    get the error: [Microsoft][ODBC Driver Manager] Data source name too long I
    have moved the database to make the path shorter, but this has not worked. I
    have ticked the 'Using driver on test server ' button. The full path to the
    database on the test server (which is on my local machine) is:
    C:\Inetpub\wwwroot\Kulika\Resources\Resources.mdb which doesn't seem too long
    to me. Can anybody see what I am doing wrong? Ian

    Blim Guest

  2. Similar Questions and Discussions

    1. Error:data Source Name too long
      When trying to set up a custom connection string by entering: \\Ib27s17\data\Production Databases\Contact Info Database\Contact Information...
    2. moving data from one data source to another
      I'm trying to move data from one data source to another. I don't want to loop - because it will kill performance. A simple Select into or Insert...
    3. Error - Data source name too long
      Hello, Well I'm finally switching to DSN-Less connection! But, of course, the transition has not been without error :+) Here is my error:...
    4. inserting into a long data type
      > I don't have the access or authority to change the data type from long Unlikely. Try using SQL*Loader for this. Too bad you can't change the...
    5. max size of data in a LONG column
      Hi Deepak, Max size is 2G. Length(long) is invalid. Don't know which version you're on but look at using a clob instead. Longs should be...
  3. #2

    Default Re: Data source name too long (asp)

    I think I have spotted my deliberate error, the extra set of quotes at the end.
    However, I still have a problem. My string now reads:
    'Provider=Microsoft.Jet.OLEDB.4.0;Data Source=' &
    Server.MapPath('\Resources\Resources.mdb') This produces the following error:
    C:\inetpub\wwwroot\Resources\Resources.mdb is not a valid path. It looks as
    though the MapPath command is missing out the root folder of the site. The
    database is actually on C:\inetpub\wwwroot\Kulika\Resources\Resources.mdb
    (i.e. in a subfolder of the main IIS area called Kulika I am confused. The
    location of the test site is set up as C:\inetpub\wwwroot\Kulika\.

    Blim Guest

Posting Permissions

  • You may not post new threads
  • You may 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