help writing a multiple table query

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #76
    Originally posted by mbatestblrock
    trying to post to get the straight text!
    Click reply on the original post from Mark with the code.

    Comment

    • mbatestblrock
      New Member
      • Sep 2007
      • 164

      #77
      well If I paste exactly what you gave in the CODE I get this error

      Microsoft VBScript runtime error '800a004c'

      Path not found

      /terminalerrors. asp, line 8



      I was trying to do a reply, so I could get the straight text and it didnt work, as you can see my blank posts???

      Comment

      • mbatestblrock
        New Member
        • Sep 2007
        • 164

        #78
        Originally posted by mmccarthy
        Click reply on the original post from Mark with the code.
        thats what I am doing, for some reason it is just a blank post??

        Comment

        • MMcCarthy
          Recognized Expert MVP
          • Aug 2006
          • 14387

          #79
          Here is the code in straight text. Let me know when you've posted it and I'll delete it again.

          Mary

          [code deleted]

          Comment

          • mbatestblrock
            New Member
            • Sep 2007
            • 164

            #80
            got it. thank you for doing that!

            Comment

            • MMcCarthy
              Recognized Expert MVP
              • Aug 2006
              • 14387

              #81
              Originally posted by mbatestblrock
              got it. thank you for doing that!
              No problem, I'm going to delete the code now.

              Comment

              • markrawlingson
                Recognized Expert Contributor
                • Aug 2007
                • 346

                #82
                And if you are getting "Path not found" error on line 8 that means that you haven't specified a correct folder path to the folder where the files are kept.

                Sincerely,
                Mark

                Comment

                • mbatestblrock
                  New Member
                  • Sep 2007
                  • 164

                  #83
                  dangit, I still have the same error


                  Microsoft VBScript runtime error '800a004c'

                  Path not found

                  /terminalerrors. asp, line 8

                  Comment

                  • mbatestblrock
                    New Member
                    • Sep 2007
                    • 164

                    #84
                    It most certainly is the correct path though. I am in file explorer and I am copy what is in the address bar. I even tried making a new one right where the .asp file was. still didnt work

                    Comment

                    • markrawlingson
                      Recognized Expert Contributor
                      • Aug 2007
                      • 346

                      #85
                      What is the path?

                      Mark

                      Comment

                      • mbatestblrock
                        New Member
                        • Sep 2007
                        • 164

                        #86
                        Originally posted by markrawlingson
                        What is the path?

                        Mark

                        F:\IMPORT\manpo ll\FTP\misc


                        It is a mapped network drive I dont think that should matter, but I thought I would throw it out there.

                        Comment

                        • markrawlingson
                          Recognized Expert Contributor
                          • Aug 2007
                          • 346

                          #87
                          It seems like an IIS security/authentication issue - IIS can't see the mapped drive.

                          I've never accessed a mapped drive myself while using the FSO so I wouldn't be able to give you any competant advice there - however I am reading up on the subject - i will see what I can find, Unless of course someone knows the answer already ?

                          Sincerely,
                          Mark

                          Comment

                          • mbatestblrock
                            New Member
                            • Sep 2007
                            • 164

                            #88
                            Originally posted by markrawlingson
                            It seems like an IIS security/authentication issue - IIS can't see the mapped drive.

                            I've never accessed a mapped drive myself while using the FSO so I wouldn't be able to give you any competant advice there - however I am reading up on the subject - i will see what I can find, Unless of course someone knows the answer already ?

                            Sincerely,
                            Mark

                            for the time being, i set up a folder in my root director to test this out, and sure enough it works beautifully!

                            I just hope we can get this network drive thing figured out, I am searching for it as well.

                            Comment

                            • markrawlingson
                              Recognized Expert Contributor
                              • Aug 2007
                              • 346

                              #89
                              It would certainly be good if we can, I've read a couple work arounds on the web regarding setting proper permissions to the mapped drive inside IIS. Not sure about it though.

                              Even if we can't get that figured out, if you have to move the contents of the folder from the mapped drive to a physical folder on the server itself 5 times a day, that's a whole lot easier than opening each file and reading them yourself line by line.

                              I'd like it to automate the procedure 100% for you, but if we can't get this last thing figured out at least we've made it 95% automated :)

                              I'm glad it worked for you somewhat though!

                              I'm wondering if Mary could ask some of the IIS experts to come take a look at this thread for you. I'm no IIS expert and this issue seems to be in regard to how IIS is looking at the mapped drive. I'll send her a PM and ask her if she wouldn't mind doing that.

                              Sincerely,
                              Mark

                              Comment

                              • mbatestblrock
                                New Member
                                • Sep 2007
                                • 164

                                #90
                                that sounds perfect! thank you for all the help you've provided me, I am searching on this issue as well, but having an extremely rough time trying to even figure out a search phrase..

                                Hopefully the IIS gurus can lend a hand!

                                I am running verison 6 if that helps.

                                again i dont even know how much I could thank everyone for this. It kinda took a total 180 from where it started, but we got it!

                                Ill keep checking for the iis updates.


                                -mike

                                Comment

                                Working...