Professional Web Applications Themes

Whats Wrong With Second Connection String ! - ASP Database

Dear Friends Hope you all doing great. I am facing a problem connecting to my database after uploading the files to webserver. They work fine on my IIS6 server I am at home, but they dont work online. I am having following folder structure rootfolder (which containcs all the website fiels) rootfolder/dbdata (which containes the access mdb file) rootfolder/admin (which contains admin asp files) for the files in rootfolder I am using: objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("dbdata/datafile.mdb") for the files in rootfolder/admin I am using objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../dbdata/datafile.mdb") These string work fine ...

  1. #1

    Default Whats Wrong With Second Connection String !

    Dear Friends
    Hope you all doing great.

    I am facing a problem connecting to my database after uploading the
    files to webserver. They work fine on my IIS6 server I am at home, but
    they dont work online.

    I am having following folder structure

    rootfolder (which containcs all the website fiels)
    rootfolder/dbdata (which containes the access mdb file)
    rootfolder/admin (which contains admin asp files)

    for the files in rootfolder I am using:

    objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
    Server.MapPath("dbdata/datafile.mdb")

    for the files in rootfolder/admin I am using

    objConn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
    Server.MapPath("../dbdata/datafile.mdb")

    These string work fine when using on my homeserver but after uploading
    them on the online webserver they are not working.

    Please let me know where am I going wrong. And If do I need any special
    settings on the online webserver.

    Waiting for your reply.

    Love
    Lovely

    ______________________________




    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Lovely Guest

  2. #2

    Default Re: Whats Wrong With Second Connection String !

    What does "not working" mean? Do you get an error message? If so, what is
    it?

    Also, why not use

    Server.MapPath("/dbdata/datafile.mdb")

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Lovely Angel" <com> wrote in message
    news:uL#phx.gbl... 


    Aaron Guest

  3. #3

    Default Re: Whats Wrong With Second Connection String !

    Hi

    It was just that the Parent Path was not enabled on the server. Got it
    done by asking the service provider to do it.

    Thanks

    Love
    Lovely



    *** Sent via Developersdex http://www.developersdex.com ***
    Don't just participate in USENET...get rewarded for it!
    Lovely Guest

Similar Threads

  1. hmm whats wrong ??
    By mak999 in forum Macromedia Flash Flashcom
    Replies: 0
    Last Post: February 16th, 10:05 PM
  2. whats wrong with my sql?
    By loofa in forum Coldfusion Database Access
    Replies: 3
    Last Post: July 25th, 08:47 AM
  3. [PHP] Whats wrong?
    By Ryan A in forum PHP Development
    Replies: 0
    Last Post: September 13th, 01:07 PM
  4. whats wrong with this SQL string
    By Mike M in forum ASP
    Replies: 5
    Last Post: August 22nd, 09:44 PM
  5. Replies: 0
    Last Post: August 12th, 09:56 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