30 Replies Latest reply on Jan 6, 2009 5:51 PM by mtrueblood

    Urgent Help With Connections File Needed Please

    mtrueblood Level 1
      Hello All!

      I am getting the following error when I attempt to test my live site. I am testing database connectivity within my site that is hosted by GoDaddy. All pages are ASP and the database is stored in the root directory in GoDaddy's folder called "access_db". The folder has read/write access.

      Here is the error:
      Microsoft JET Database Engine error '80040e4d'
      Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
      /sitename/requestquote/index.asp, line 130

      Here is the code from the connections file:
      <%
      ' FileName="Connection_ado_conn_string.htm"
      ' Type="ADO"
      ' DesigntimeType="ADO"
      ' HTTP="false"
      ' Catalog=""
      ' Schema=""
      Dim MM_connNAME_STRING
      MM_connNAME_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=username\access_db\filename.mdb;UserId=usern ame;Password=password;"
      %>

      The error above refrences "/sitename/requestquote/index.asp, line 130", and here is the code:
      rs_quote.ActiveConnection = MM_connNAME_STRING

      Please help.

      Thanks - Matt
        • 1. Re: Urgent Help With Connections File Needed Please
          Level 7
          Just so you'll know, I'm several years out of ASP/VBScript and Access (moved
          to PHP/MySQL), so I'm mighty rusty. I was hoping someone else would be able
          to help out here. It's an unfortunate time to wait for this, I know....

          --
          Murray --- ICQ 71997575
          Adobe Community Expert
          (If you *MUST* email me, don't LAUGH when you do so!)
          ==================
          http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
          http://www.dwfaq.com - DW FAQs, Tutorials & Resources
          ==================


          "mtrueblood" <webforumsuser@macromedia.com> wrote in message
          news:gjlqr5$mk3$1@forums.macromedia.com...
          > Hello All!
          >
          > I am getting the following error when I attempt to test my live site. I am
          > testing database connectivity within my site that is hosted by GoDaddy.
          > All
          > pages are ASP and the database is stored in the root directory in
          > GoDaddy's
          > folder called "access_db". The folder has read/write access.
          >
          > Here is the error:
          > Microsoft JET Database Engine error '80040e4d'
          > Cannot start your application. The workgroup information file is missing
          > or
          > opened exclusively by another user.
          > /sitename/requestquote/index.asp, line 130
          >
          > Here is the code from the connections file:
          > <%
          > ' FileName="Connection_ado_conn_string.htm"
          > ' Type="ADO"
          > ' DesigntimeType="ADO"
          > ' HTTP="false"
          > ' Catalog=""
          > ' Schema=""
          > Dim MM_connNAME_STRING
          > MM_connNAME_STRING =
          > "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=username\access_db\filename.mdb;Use
          > rId=username;Password=password;"
          > %>
          >
          > The error above refrences "/sitename/requestquote/index.asp, line 130",
          > and
          > here is the code:
          > rs_quote.ActiveConnection = MM_connNAME_STRING
          >
          > Please help.
          >
          > Thanks - Matt
          >

          • 2. Re: Urgent Help With Connections File Needed Please
            mtrueblood Level 1
            Oh not a problem. Thanks for helping out. I am a bit new to web development, figured I would start out with ASP, then work my way up from there. Every page worked like a charm on my machine, but when I upload the site, the dynamic pages no longer display. I just don't understand. I have read through so many forums and blogs, and none really seem to be working. Hopefully someone out there knows something.

            Thanks - Matt
            • 3. Re: Urgent Help With Connections File Needed Please
              Level 7
              There are two things working against you here -

              1. GoDaddy as a host
              2. Your selection of ASP/VBScript and Access

              Can GD help you?

              --
              Murray --- ICQ 71997575
              Adobe Community Expert
              (If you *MUST* email me, don't LAUGH when you do so!)
              ==================
              http://www.projectseven.com/go - DW FAQs, Tutorials & Resources
              http://www.dwfaq.com - DW FAQs, Tutorials & Resources
              ==================


              "mtrueblood" <webforumsuser@macromedia.com> wrote in message
              news:gjlvkc$sj6$1@forums.macromedia.com...
              > Oh not a problem. Thanks for helping out. I am a bit new to web
              > development,
              > figured I would start out with ASP, then work my way up from there. Every
              > page
              > worked like a charm on my machine, but when I upload the site, the dynamic
              > pages no longer display. I just don't understand. I have read through so
              > many
              > forums and blogs, and none really seem to be working. Hopefully someone
              > out
              > there knows something.
              >
              > Thanks - Matt
              >

              • 4. Re: Urgent Help With Connections File Needed Please
                Level 7
                HI!
                You dsn connection string should look more like this one, than the one you
                have.

                <%
                ' FileName="Connection_odbc_conn_dsn.htm"
                ' Type="ADO"
                ' DesigntimeType="ADO"
                ' HTTP="true"
                ' Catalog=""
                ' Schema=""
                Dim MM_Name of your connection_STRING
                MM_Name of your connection_STRING = "dsn=Name of your connection;uid=your
                user name;pwd=your password;"
                %>

                Good luck
                Dave
                "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                news:gjlqr5$mk3$1@forums.macromedia.com...
                > Hello All!
                >
                > I am getting the following error when I attempt to test my live site. I
                am
                > testing database connectivity within my site that is hosted by GoDaddy.
                All
                > pages are ASP and the database is stored in the root directory in
                GoDaddy's
                > folder called "access_db". The folder has read/write access.
                >
                > Here is the error:
                > Microsoft JET Database Engine error '80040e4d'
                > Cannot start your application. The workgroup information file is missing
                or
                > opened exclusively by another user.
                > /sitename/requestquote/index.asp, line 130
                >
                > Here is the code from the connections file:
                > <%
                > ' FileName="Connection_ado_conn_string.htm"
                > ' Type="ADO"
                > ' DesigntimeType="ADO"
                > ' HTTP="false"
                > ' Catalog=""
                > ' Schema=""
                > Dim MM_connNAME_STRING
                > MM_connNAME_STRING =
                >
                "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=username\access_db\filename.mdb
                ;Use
                > rId=username;Password=password;"
                > %>
                >
                > The error above refrences "/sitename/requestquote/index.asp, line 130",
                and
                > here is the code:
                > rs_quote.ActiveConnection = MM_connNAME_STRING
                >
                > Please help.
                >
                > Thanks - Matt
                >


                • 5. Re: Urgent Help With Connections File Needed Please
                  mtrueblood Level 1
                  Thank you for your help. I have changed my connection.asp file to read:

                  <%
                  ' FileName="Connection_odbc_conn_dsn.htm"
                  ' Type="ADO"
                  ' DesigntimeType="ADO"
                  ' HTTP="true"
                  ' Catalog=""
                  ' Schema=""
                  Dim MM_connNAME_STRING
                  MM_connNAME_STRING = "dsn=access_sitex.dsn;uid=your
                  user name;pwd=your password;"
                  %>

                  Now I am getting 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
                  /sitename/contactus/index.asp, line 130

                  line 30 - rs_contactus.ActiveConnection = MM_connNAME_STRING

                  Please Help!

                  Thanks - Matt
                  • 6. Re: Urgent Help With Connections File Needed Please
                    mtrueblood Level 1
                    That's line *130, not line 30.

                    Thanks - Matt
                    • 7. Re: Urgent Help With Connections File Needed Please
                      Level 7
                      Hi!
                      Try some thing like this.

                      <%
                      ' FileName="Connection_odbc_conn_dsn.htm"
                      ' Type="ADO"
                      ' DesigntimeType="ADO"
                      ' HTTP="true"
                      ' Catalog=""
                      ' Schema=""
                      Dim MM_access_sitex.dsn_STRING
                      MM_access_sitex.dsn_STRING = "dsn=access_sitex.dsn;uid=your
                      user name;pwd=your password;"
                      %>

                      I hope that access_sitex.dsn is not the real name of your DSN
                      Dave

                      "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                      news:gjmhu5$lmk$1@forums.macromedia.com...
                      > Thank you for your help. I have changed my connection.asp file to read:
                      >
                      > <%
                      > ' FileName="Connection_odbc_conn_dsn.htm"
                      > ' Type="ADO"
                      > ' DesigntimeType="ADO"
                      > ' HTTP="true"
                      > ' Catalog=""
                      > ' Schema=""
                      > Dim MM_connNAME_STRING
                      > MM_connNAME_STRING = "dsn=access_sitex.dsn;uid=your
                      > user name;pwd=your password;"
                      > %>
                      >
                      > Now I am getting 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
                      > /sitename/contactus/index.asp, line 130
                      >
                      > line 30 - rs_contactus.ActiveConnection = MM_connNAME_STRING
                      >
                      > Please Help!
                      >
                      > Thanks - Matt
                      >
                      >


                      • 8. Re: Urgent Help With Connections File Needed Please
                        mtrueblood Level 1
                        I used the code you gave me, but inserted the necessary info...

                        <%
                        ' FileName="Connection_odbc_conn_dsn.htm"
                        ' Type="ADO"
                        ' DesigntimeType="ADO"
                        ' HTTP="true"
                        ' Catalog=""
                        ' Schema=""
                        Dim MM_access_trueblood_STRING
                        MM_access_trueblood_STRING = "dsn=access_trueblood.dsn;uid=userid;pwd=password;"
                        %>

                        *Where do I plug in my connection name of "connTrueblood" (the data source name is "access_trueblood.dsn)?

                        Then I get this error message:
                        ADODB.Recordset error '800a0bb9'
                        Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
                        /sitename/contactus/index.asp, line 130

                        Line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING

                        Thanks - Matt
                        • 9. Re: Urgent Help With Connections File Needed Please
                          Level 7
                          Matt,
                          If your DSN is access_trueblood.dsn then use that name instead of
                          MM_access_trueblood_STRING make it
                          Dim MM_access_trueblood.dsn_STRING
                          MM_access_trueblood.dsn_STRING =
                          dsn=access_trueblood.dsn; and so on

                          Dave


                          "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                          news:gjo520$pns$1@forums.macromedia.com...
                          > I used the code you gave me, but inserted the necessary info...
                          >
                          > <%
                          > ' FileName="Connection_odbc_conn_dsn.htm"
                          > ' Type="ADO"
                          > ' DesigntimeType="ADO"
                          > ' HTTP="true"
                          > ' Catalog=""
                          > ' Schema=""
                          > Dim MM_access_trueblood_STRING
                          > MM_access_trueblood_STRING =
                          > "dsn=access_trueblood.dsn;uid=userid;pwd=password;"
                          > %>
                          >
                          > *Where do I plug in my connection name of "connTrueblood" (the data
                          source
                          > name is "access_trueblood.dsn)?
                          >
                          > Then I get this error message:
                          > ADODB.Recordset error '800a0bb9'
                          > Arguments are of the wrong type, are out of acceptable range, or are in
                          > conflict with one another.
                          > /sitename/contactus/index.asp, line 130
                          >
                          > Line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                          >
                          > Thanks - Matt
                          >
                          >


                          • 10. Re: Urgent Help With Connections File Needed Please
                            mtrueblood Level 1
                            I used the following code (as you mentioned):

                            <%
                            ' FileName="Connection_odbc_conn_dsn.htm"
                            ' Type="ADO"
                            ' DesigntimeType="ADO"
                            ' HTTP="true"
                            ' Catalog=""
                            ' Schema=""
                            Dim MM_access_trueblood.dsn_STRING
                            MM_access_trueblood.dsn_STRING = "dsn=access_trueblood.dsn;"
                            %>

                            Here is the error that I get:
                            Microsoft VBScript compilation error '800a0401'
                            Expected end of statement
                            /sitename/Connections/connTrueblood.asp, line 8
                            Dim MM_access_trueblood.dsn_STRING
                            -----------------------^

                            I appreciate your help!

                            Thanks - Matt
                            • 11. Re: Urgent Help With Connections File Needed Please
                              Level 7
                              Matt,
                              Do this, Open a new asp page go to application click databases then the +
                              sign in upper left-hand corner. Pick Data Source Name (DSN)
                              Type in TEST for connection name then put access_trueblood.dsn in the Data
                              source name (DSN) then your user name and password.
                              Dreamweaver should connect Pick Using DSN on testing server then click Test
                              button and let me know what happens. That's about as easy as it gets.

                              Dave


                              "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                              news:gjqv2r$jml$1@forums.macromedia.com...
                              > I used the following code (as you mentioned):
                              >
                              > <%
                              > ' FileName="Connection_odbc_conn_dsn.htm"
                              > ' Type="ADO"
                              > ' DesigntimeType="ADO"
                              > ' HTTP="true"
                              > ' Catalog=""
                              > ' Schema=""
                              > Dim MM_access_trueblood.dsn_STRING
                              > MM_access_trueblood.dsn_STRING = "dsn=access_trueblood.dsn;"
                              > %>
                              >
                              > Here is the error that I get:
                              > Microsoft VBScript compilation error '800a0401'
                              > Expected end of statement
                              > /sitename/Connections/connTrueblood.asp, line 8
                              > Dim MM_access_trueblood.dsn_STRING
                              > -----------------------^
                              >
                              > I appreciate your help!
                              >
                              > Thanks - Matt
                              >
                              >


                              • 12. Re: Urgent Help With Connections File Needed Please
                                Level 7
                                Baxter wrote:
                                > Matt,
                                > Do this, Open a new asp page go to application click databases then the +
                                > sign in upper left-hand corner. Pick Data Source Name (DSN)
                                > Type in TEST for connection name then put access_trueblood.dsn in the Data
                                > source name (DSN) then your user name and password.
                                > Dreamweaver should connect Pick Using DSN on testing server then click Test
                                > button and let me know what happens. That's about as easy as it gets.

                                Its a file based DSN, so won't work the same way, use:

                                MM_connNAME_STRING = "FILEDSN=c:\myDsnFile.dsn;Uid=myUsername;Pwd=;"

                                Dooza
                                • 13. Re: Urgent Help With Connections File Needed Please
                                  mtrueblood Level 1
                                  Baxter - I get "Connection was Made Successfully" with the credentials you gave me. My site works just fine on my local machine with access_trueblood.dsn (it also worked with the dsn I initally created for the site). All pages display and I get no errors. I think where the issue may be, now I am guessing here, is that my connection refrences a database located in the folder C:\Users\Administrator\Websites\Sitename\access_db, but once I upload my site, the database still sits in access_db, but the root folder possibly has changed (maybe causing the connection to fail).

                                  Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once I upload my site, "c:myDsnFile.dsn" would then not be the location of my dsn. "c:myDsnFile.dsn" refrences a file on my computer. I am using an online hosting company. Am I not understanding you correctly? See note above. I did use your information and got the following browser error:

                                  Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                  General error: Invalid file dsn ''
                                  /sitename/contactus/index.asp, line 130

                                  line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING

                                  I am researching on how to do a dsn-less connection, unless I can get this figured out.

                                  Thanks - Matt
                                  • 14. Re: Urgent Help With Connections File Needed Please
                                    Level 7
                                    mtrueblood wrote:
                                    > Baxter - I get "Connection was Made Successfully" with the credentials you gave
                                    > me. My site works just fine on my local machine with access_trueblood.dsn (it
                                    > also worked with the dsn I initally created for the site). All pages display
                                    > and I get no errors. I think where the issue may be, now I am guessing here, is
                                    > that my connection refrences a database located in the folder
                                    > C:\Users\Administrator\Websites\Sitename\access_db, but once I upload my site,
                                    > the database still sits in access_db, but the root folder possibly has changed
                                    > (maybe causing the connection to fail).
                                    >
                                    > Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once I upload
                                    > my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                    > "c:myDsnFile.dsn" refrences a file on my computer. I am using an online hosting
                                    > company. Am I not understanding you correctly? See note above. I did use your
                                    > information and got the following browser error:
                                    >
                                    > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                    > General error: Invalid file dsn ''
                                    > /sitename/contactus/index.asp, line 130
                                    >
                                    > line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                    >
                                    > I am researching on how to do a dsn-less connection, unless I can get this
                                    > figured out.

                                    Your right, you need to enter the correct path to the DSN file if you
                                    want to use it.

                                    The advantage of using a DSN is that you only need the name (if its a
                                    system or user DSN) or the file (including path) as it contains all the
                                    information to get you connected. Here is some useful information about
                                    them: http://www.kamath.com/tutorials/tut005_filedsn.asp

                                    One thing to note from the above link is that it doesn't contain the
                                    path to the database, which I assumed it would. They still pass the path
                                    and security credentials in the connection string.

                                    I don't know if this helps, but have you seen this:
                                    http://help.godaddy.com/article/260

                                    Dooza
                                    • 15. Re: Urgent Help With Connections File Needed Please
                                      bregent Most Valuable Participant
                                      >"c:myDsnFile.dsn" refrences a file on my computer. I am using an online hosting
                                      > company. Am I not understanding you correctly?

                                      If GD has given you a file dsn (rather than a system dsn), then you need to include the complete path on the server, including the drive letter. Dooza was just giving an example. If you don't know the complete path, then you can use the Server.Mappath function for the dsn, the same way I instructed you for the database file path in a dsn-less connection.

                                      Do you know the actual path to the dsn file?

                                      >I am researching on how to do a dsn-less connection, unless I can get this figured out.

                                      IMO, you are better off using dsn-less even if you do get this figured out.
                                      • 16. Re: Urgent Help With Connections File Needed Please
                                        Level 7
                                        Hi! Matt
                                        If you want to try a DSN less connection here is what I use to connect to a
                                        access data base.
                                        Pick Custom connection and a name for the connection,
                                        then you would use this
                                        Provider=MSDASQL; Driver={Microsoft Access Driver (*.mdb)};
                                        DBQ=C:\Users\Administrator\Websites\Sitename\access_db\filename.mdb; if the
                                        data base needs a username and password you would insert it after the
                                        database name. this has to bee all on one line.

                                        Dave

                                        "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                        news:gjt5hp$jfj$1@forums.macromedia.com...
                                        > Baxter - I get "Connection was Made Successfully" with the credentials you
                                        gave
                                        > me. My site works just fine on my local machine with access_trueblood.dsn
                                        (it
                                        > also worked with the dsn I initally created for the site). All pages
                                        display
                                        > and I get no errors. I think where the issue may be, now I am guessing
                                        here, is
                                        > that my connection refrences a database located in the folder
                                        > C:\Users\Administrator\Websites\Sitename\access_db, but once I upload my
                                        site,
                                        > the database still sits in access_db, but the root folder possibly has
                                        changed
                                        > (maybe causing the connection to fail).
                                        >
                                        > Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once I
                                        upload
                                        > my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                        > "c:myDsnFile.dsn" refrences a file on my computer. I am using an online
                                        hosting
                                        > company. Am I not understanding you correctly? See note above. I did use
                                        your
                                        > information and got the following browser error:
                                        >
                                        > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                        > General error: Invalid file dsn ''
                                        > /sitename/contactus/index.asp, line 130
                                        >
                                        > line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                        >
                                        > I am researching on how to do a dsn-less connection, unless I can get
                                        this
                                        > figured out.
                                        >
                                        > Thanks - Matt
                                        >


                                        • 17. Re: Urgent Help With Connections File Needed Please
                                          Level 7
                                          Baxter - I get "Connection was Made Successfully" if connection to the
                                          database was made Successfully not sure what's going on here? When you look
                                          at your site files in Dreamwerer on the server is there a folder named
                                          access_db? If so is your data base in that folder? The database needs
                                          permissions set to read and write to that file. Have you checked permissions
                                          on the site? does GD give you a control panel so that you can set the
                                          permissions your self? I have never used GD but have seen where people have
                                          had lots of problems with them when using a scripting language. I don't know
                                          what else it could be at this point.
                                          Dave
                                          "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                          news:gjt5hp$jfj$1@forums.macromedia.com...
                                          > Baxter - I get "Connection was Made Successfully" with the credentials you
                                          gave
                                          > me. My site works just fine on my local machine with access_trueblood.dsn
                                          (it
                                          > also worked with the dsn I initally created for the site). All pages
                                          display
                                          > and I get no errors. I think where the issue may be, now I am guessing
                                          here, is
                                          > that my connection refrences a database located in the folder
                                          > C:\Users\Administrator\Websites\Sitename\access_db, but once I upload my
                                          site,
                                          > the database still sits in access_db, but the root folder possibly has
                                          changed
                                          > (maybe causing the connection to fail).
                                          >
                                          > Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once I
                                          upload
                                          > my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                          > "c:myDsnFile.dsn" refrences a file on my computer. I am using an online
                                          hosting
                                          > company. Am I not understanding you correctly? See note above. I did use
                                          your
                                          > information and got the following browser error:
                                          >
                                          > Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                          > General error: Invalid file dsn ''
                                          > /sitename/contactus/index.asp, line 130
                                          >
                                          > line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                          >
                                          > I am researching on how to do a dsn-less connection, unless I can get
                                          this
                                          > figured out.
                                          >
                                          > Thanks - Matt
                                          >


                                          • 18. Re: Urgent Help With Connections File Needed Please
                                            Level 7
                                            Hello,

                                            Sorry if some of this is repetitive in respect to what others have advised
                                            in this thread.
                                            It's an answer I gave someone with similar problems a while ago.
                                            It does answer your question about the successful path on your local server
                                            being different than the path on GDs server.
                                            There are also instructions on how to find the path on GD's server if needed
                                            for DNS-Less connection.


                                            Option 1:
                                            You can try using a map path function like this in your connection string:
                                            access_db is the folder the database is in and mydatabase.mdb is the access
                                            file.
                                            Substitute your names.

                                            STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
                                            Server.MapPath("access_db") & "\mydatabase.mdb;User Id=admin;Password="

                                            -or-

                                            Option 2:
                                            You could try an OLEDB DSN-Less connection instead of using a DSN. It's not
                                            hard to do.

                                            Step 1 is to figure out the location of the root directory on the host's
                                            server..That's very easy to do yourself.

                                            Just make an asp page (I named mine "findit.asp"), and put the following
                                            code between the <body> tags, like so:
                                            <body>
                                            <%
                                            Response.Write("The location of this page is:<br>")
                                            Response.Write(Request.ServerVariables("PATH_TRANSLATED") & "<br>")
                                            Response.Write("The location of my root directory is:<br>")
                                            Response.Write(Server.MapPath("\"))
                                            Response.Write Path
                                            %>
                                            </body>


                                            Upload it to the same location as your site's home page.
                                            Once your new asp page is uploaded, just navigate to that page in your
                                            browser.

                                            For a site on GD the "findit.asp" page displays something like this:

                                            The location of this page is:
                                            d:\hosting\mysite\findit.asp
                                            The location of my root directory is:
                                            d:\hosting\mysite

                                            Now that you know the root directory location on their server, you can
                                            figure out the path to your database.
                                            Let's say that the folder your database is in is named _private, and it
                                            happens to be in the root
                                            directory along with your home page.

                                            Next, just add the database folder name (_private) and the database
                                            inside's name (mydatabase.mdb) to the root directory location:

                                            d:hosting\mysite\_private\mydatabase.mdb

                                            That's your Data Source path.

                                            The connection string would look something like this:

                                            = "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                            Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"

                                            (the code above may appear wrapped (two lines) in the forum/ng but it's one
                                            line with no return within)

                                            IMPORTANT: If you are using a local testing server, make a copy of your
                                            connection asp page as a backup.
                                            The reason? The connection information you are going to put in this file
                                            will only work on the host's server.
                                            Once you upload the new connection.asp page with the changes for the host,
                                            you'll need to change your local copy back to your local connection so it
                                            will work on
                                            your local testing server.

                                            Upload to server.

                                            Please note: From now on, when you upload (or "put" if you're using DW)
                                            files that refer to your connection asp page you're going to get a warning
                                            that your connection asp on the host is different than your local copy.
                                            Always say "No" to updating it, or you'll replace the GD DSN-Less connection
                                            with your local one.


                                            Did you set the appropriate read/write permissions on the directory(folder)
                                            your database is in?
                                            You can do that in GD's control panel. Hosting> Select your site > Manage to
                                            open it.

                                            I hope this helps.

                                            For what it's worth, I only use GD for domain names now.
                                            I had numerous problems with some sites hosted there, switched them to
                                            HostMySite and haven't had any.

                                            Take care,
                                            Tim





                                            "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                            news:gjtvq2$ntf$1@forums.macromedia.com...
                                            > Baxter - I get "Connection was Made Successfully" if connection to the
                                            > database was made Successfully not sure what's going on here? When you
                                            > look
                                            > at your site files in Dreamwerer on the server is there a folder named
                                            > access_db? If so is your data base in that folder? The database needs
                                            > permissions set to read and write to that file. Have you checked
                                            > permissions
                                            > on the site? does GD give you a control panel so that you can set the
                                            > permissions your self? I have never used GD but have seen where people
                                            > have
                                            > had lots of problems with them when using a scripting language. I don't
                                            > know
                                            > what else it could be at this point.
                                            > Dave
                                            > "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                            > news:gjt5hp$jfj$1@forums.macromedia.com...
                                            >> Baxter - I get "Connection was Made Successfully" with the credentials
                                            >> you
                                            > gave
                                            >> me. My site works just fine on my local machine with access_trueblood.dsn
                                            > (it
                                            >> also worked with the dsn I initally created for the site). All pages
                                            > display
                                            >> and I get no errors. I think where the issue may be, now I am guessing
                                            > here, is
                                            >> that my connection refrences a database located in the folder
                                            >> C:\Users\Administrator\Websites\Sitename\access_db, but once I upload my
                                            > site,
                                            >> the database still sits in access_db, but the root folder possibly has
                                            > changed
                                            >> (maybe causing the connection to fail).
                                            >>
                                            >> Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once I
                                            > upload
                                            >> my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                            >> "c:myDsnFile.dsn" refrences a file on my computer. I am using an online
                                            > hosting
                                            >> company. Am I not understanding you correctly? See note above. I did use
                                            > your
                                            >> information and got the following browser error:
                                            >>
                                            >> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                            >> General error: Invalid file dsn ''
                                            >> /sitename/contactus/index.asp, line 130
                                            >>
                                            >> line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                            >>
                                            >> I am researching on how to do a dsn-less connection, unless I can get
                                            > this
                                            >> figured out.
                                            >>
                                            >> Thanks - Matt
                                            >>
                                            >
                                            >


                                            • 19. Re: Urgent Help With Connections File Needed Please
                                              Level 7
                                              Tim,
                                              Very good reply! I have no experience with GD other than the complaints I
                                              have read here about connections to databases etc. I think that if his
                                              connection test is ok that it has to be a permissions issue? What do you
                                              think?
                                              Dave
                                              "TC2112" <nospam@nospam.com> wrote in message
                                              news:gju9nr$70n$1@forums.macromedia.com...
                                              > Hello,
                                              >
                                              > Sorry if some of this is repetitive in respect to what others have advised
                                              > in this thread.
                                              > It's an answer I gave someone with similar problems a while ago.
                                              > It does answer your question about the successful path on your local
                                              server
                                              > being different than the path on GDs server.
                                              > There are also instructions on how to find the path on GD's server if
                                              needed
                                              > for DNS-Less connection.
                                              >
                                              >
                                              > Option 1:
                                              > You can try using a map path function like this in your connection string:
                                              > access_db is the folder the database is in and mydatabase.mdb is the
                                              access
                                              > file.
                                              > Substitute your names.
                                              >
                                              > STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
                                              > Server.MapPath("access_db") & "\mydatabase.mdb;User Id=admin;Password="
                                              >
                                              > -or-
                                              >
                                              > Option 2:
                                              > You could try an OLEDB DSN-Less connection instead of using a DSN. It's
                                              not
                                              > hard to do.
                                              >
                                              > Step 1 is to figure out the location of the root directory on the host's
                                              > server..That's very easy to do yourself.
                                              >
                                              > Just make an asp page (I named mine "findit.asp"), and put the following
                                              > code between the <body> tags, like so:
                                              > <body>
                                              > <%
                                              > Response.Write("The location of this page is:<br>")
                                              > Response.Write(Request.ServerVariables("PATH_TRANSLATED") & "<br>")
                                              > Response.Write("The location of my root directory is:<br>")
                                              > Response.Write(Server.MapPath("\"))
                                              > Response.Write Path
                                              > %>
                                              > </body>
                                              >
                                              >
                                              > Upload it to the same location as your site's home page.
                                              > Once your new asp page is uploaded, just navigate to that page in your
                                              > browser.
                                              >
                                              > For a site on GD the "findit.asp" page displays something like this:
                                              >
                                              > The location of this page is:
                                              > d:\hosting\mysite\findit.asp
                                              > The location of my root directory is:
                                              > d:\hosting\mysite
                                              >
                                              > Now that you know the root directory location on their server, you can
                                              > figure out the path to your database.
                                              > Let's say that the folder your database is in is named _private, and it
                                              > happens to be in the root
                                              > directory along with your home page.
                                              >
                                              > Next, just add the database folder name (_private) and the database
                                              > inside's name (mydatabase.mdb) to the root directory location:
                                              >
                                              > d:hosting\mysite\_private\mydatabase.mdb
                                              >
                                              > That's your Data Source path.
                                              >
                                              > The connection string would look something like this:
                                              >
                                              > = "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                              > Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"
                                              >
                                              > (the code above may appear wrapped (two lines) in the forum/ng but it's
                                              one
                                              > line with no return within)
                                              >
                                              > IMPORTANT: If you are using a local testing server, make a copy of your
                                              > connection asp page as a backup.
                                              > The reason? The connection information you are going to put in this file
                                              > will only work on the host's server.
                                              > Once you upload the new connection.asp page with the changes for the host,
                                              > you'll need to change your local copy back to your local connection so it
                                              > will work on
                                              > your local testing server.
                                              >
                                              > Upload to server.
                                              >
                                              > Please note: From now on, when you upload (or "put" if you're using DW)
                                              > files that refer to your connection asp page you're going to get a warning
                                              > that your connection asp on the host is different than your local copy.
                                              > Always say "No" to updating it, or you'll replace the GD DSN-Less
                                              connection
                                              > with your local one.
                                              >
                                              >
                                              > Did you set the appropriate read/write permissions on the
                                              directory(folder)
                                              > your database is in?
                                              > You can do that in GD's control panel. Hosting> Select your site > Manage
                                              to
                                              > open it.
                                              >
                                              > I hope this helps.
                                              >
                                              > For what it's worth, I only use GD for domain names now.
                                              > I had numerous problems with some sites hosted there, switched them to
                                              > HostMySite and haven't had any.
                                              >
                                              > Take care,
                                              > Tim
                                              >
                                              >
                                              >
                                              >
                                              >
                                              > "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                              > news:gjtvq2$ntf$1@forums.macromedia.com...
                                              > > Baxter - I get "Connection was Made Successfully" if connection to the
                                              > > database was made Successfully not sure what's going on here? When you
                                              > > look
                                              > > at your site files in Dreamwerer on the server is there a folder named
                                              > > access_db? If so is your data base in that folder? The database needs
                                              > > permissions set to read and write to that file. Have you checked
                                              > > permissions
                                              > > on the site? does GD give you a control panel so that you can set the
                                              > > permissions your self? I have never used GD but have seen where people
                                              > > have
                                              > > had lots of problems with them when using a scripting language. I don't
                                              > > know
                                              > > what else it could be at this point.
                                              > > Dave
                                              > > "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                              > > news:gjt5hp$jfj$1@forums.macromedia.com...
                                              > >> Baxter - I get "Connection was Made Successfully" with the credentials
                                              > >> you
                                              > > gave
                                              > >> me. My site works just fine on my local machine with
                                              access_trueblood.dsn
                                              > > (it
                                              > >> also worked with the dsn I initally created for the site). All pages
                                              > > display
                                              > >> and I get no errors. I think where the issue may be, now I am guessing
                                              > > here, is
                                              > >> that my connection refrences a database located in the folder
                                              > >> C:\Users\Administrator\Websites\Sitename\access_db, but once I upload
                                              my
                                              > > site,
                                              > >> the database still sits in access_db, but the root folder possibly has
                                              > > changed
                                              > >> (maybe causing the connection to fail).
                                              > >>
                                              > >> Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once
                                              I
                                              > > upload
                                              > >> my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                              > >> "c:myDsnFile.dsn" refrences a file on my computer. I am using an online
                                              > > hosting
                                              > >> company. Am I not understanding you correctly? See note above. I did
                                              use
                                              > > your
                                              > >> information and got the following browser error:
                                              > >>
                                              > >> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                              > >> General error: Invalid file dsn ''
                                              > >> /sitename/contactus/index.asp, line 130
                                              > >>
                                              > >> line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                              > >>
                                              > >> I am researching on how to do a dsn-less connection, unless I can get
                                              > > this
                                              > >> figured out.
                                              > >>
                                              > >> Thanks - Matt
                                              > >>
                                              > >
                                              > >
                                              >
                                              >


                                              • 20. Re: Urgent Help With Connections File Needed Please
                                                Level 7
                                                It could be, you'd have to check in the control panel to make sure
                                                permissions are set to read and write.
                                                Have you tried changing the path in your connection string to the GoDaddy
                                                path and uploading the file?
                                                The info I posted tells you how to find out what the path on GoDaddy is.

                                                Tim


                                                "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                                news:gjuc2n$9rr$1@forums.macromedia.com...
                                                > Tim,
                                                > Very good reply! I have no experience with GD other than the complaints I
                                                > have read here about connections to databases etc. I think that if his
                                                > connection test is ok that it has to be a permissions issue? What do you
                                                > think?
                                                > Dave
                                                > "TC2112" <nospam@nospam.com> wrote in message
                                                > news:gju9nr$70n$1@forums.macromedia.com...
                                                >> Hello,
                                                >>
                                                >> Sorry if some of this is repetitive in respect to what others have
                                                >> advised
                                                >> in this thread.
                                                >> It's an answer I gave someone with similar problems a while ago.
                                                >> It does answer your question about the successful path on your local
                                                > server
                                                >> being different than the path on GDs server.
                                                >> There are also instructions on how to find the path on GD's server if
                                                > needed
                                                >> for DNS-Less connection.
                                                >>
                                                >>
                                                >> Option 1:
                                                >> You can try using a map path function like this in your connection
                                                >> string:
                                                >> access_db is the folder the database is in and mydatabase.mdb is the
                                                > access
                                                >> file.
                                                >> Substitute your names.
                                                >>
                                                >> STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
                                                >> Server.MapPath("access_db") & "\mydatabase.mdb;User Id=admin;Password="
                                                >>
                                                >> -or-
                                                >>
                                                >> Option 2:
                                                >> You could try an OLEDB DSN-Less connection instead of using a DSN. It's
                                                > not
                                                >> hard to do.
                                                >>
                                                >> Step 1 is to figure out the location of the root directory on the host's
                                                >> server..That's very easy to do yourself.
                                                >>
                                                >> Just make an asp page (I named mine "findit.asp"), and put the following
                                                >> code between the <body> tags, like so:
                                                >> <body>
                                                >> <%
                                                >> Response.Write("The location of this page is:<br>")
                                                >> Response.Write(Request.ServerVariables("PATH_TRANSLATED") & "<br>")
                                                >> Response.Write("The location of my root directory is:<br>")
                                                >> Response.Write(Server.MapPath("\"))
                                                >> Response.Write Path
                                                >> %>
                                                >> </body>
                                                >>
                                                >>
                                                >> Upload it to the same location as your site's home page.
                                                >> Once your new asp page is uploaded, just navigate to that page in your
                                                >> browser.
                                                >>
                                                >> For a site on GD the "findit.asp" page displays something like this:
                                                >>
                                                >> The location of this page is:
                                                >> d:\hosting\mysite\findit.asp
                                                >> The location of my root directory is:
                                                >> d:\hosting\mysite
                                                >>
                                                >> Now that you know the root directory location on their server, you can
                                                >> figure out the path to your database.
                                                >> Let's say that the folder your database is in is named _private, and it
                                                >> happens to be in the root
                                                >> directory along with your home page.
                                                >>
                                                >> Next, just add the database folder name (_private) and the database
                                                >> inside's name (mydatabase.mdb) to the root directory location:
                                                >>
                                                >> d:hosting\mysite\_private\mydatabase.mdb
                                                >>
                                                >> That's your Data Source path.
                                                >>
                                                >> The connection string would look something like this:
                                                >>
                                                >> = "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                                >> Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"
                                                >>
                                                >> (the code above may appear wrapped (two lines) in the forum/ng but it's
                                                > one
                                                >> line with no return within)
                                                >>
                                                >> IMPORTANT: If you are using a local testing server, make a copy of your
                                                >> connection asp page as a backup.
                                                >> The reason? The connection information you are going to put in this file
                                                >> will only work on the host's server.
                                                >> Once you upload the new connection.asp page with the changes for the
                                                >> host,
                                                >> you'll need to change your local copy back to your local connection so it
                                                >> will work on
                                                >> your local testing server.
                                                >>
                                                >> Upload to server.
                                                >>
                                                >> Please note: From now on, when you upload (or "put" if you're using DW)
                                                >> files that refer to your connection asp page you're going to get a
                                                >> warning
                                                >> that your connection asp on the host is different than your local copy.
                                                >> Always say "No" to updating it, or you'll replace the GD DSN-Less
                                                > connection
                                                >> with your local one.
                                                >>
                                                >>
                                                >> Did you set the appropriate read/write permissions on the
                                                > directory(folder)
                                                >> your database is in?
                                                >> You can do that in GD's control panel. Hosting> Select your site > Manage
                                                > to
                                                >> open it.
                                                >>
                                                >> I hope this helps.
                                                >>
                                                >> For what it's worth, I only use GD for domain names now.
                                                >> I had numerous problems with some sites hosted there, switched them to
                                                >> HostMySite and haven't had any.
                                                >>
                                                >> Take care,
                                                >> Tim
                                                >>
                                                >>
                                                >>
                                                >>
                                                >>
                                                >> "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                                >> news:gjtvq2$ntf$1@forums.macromedia.com...
                                                >> > Baxter - I get "Connection was Made Successfully" if connection to the
                                                >> > database was made Successfully not sure what's going on here? When you
                                                >> > look
                                                >> > at your site files in Dreamwerer on the server is there a folder named
                                                >> > access_db? If so is your data base in that folder? The database needs
                                                >> > permissions set to read and write to that file. Have you checked
                                                >> > permissions
                                                >> > on the site? does GD give you a control panel so that you can set the
                                                >> > permissions your self? I have never used GD but have seen where people
                                                >> > have
                                                >> > had lots of problems with them when using a scripting language. I don't
                                                >> > know
                                                >> > what else it could be at this point.
                                                >> > Dave
                                                >> > "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                                >> > news:gjt5hp$jfj$1@forums.macromedia.com...
                                                >> >> Baxter - I get "Connection was Made Successfully" with the credentials
                                                >> >> you
                                                >> > gave
                                                >> >> me. My site works just fine on my local machine with
                                                > access_trueblood.dsn
                                                >> > (it
                                                >> >> also worked with the dsn I initally created for the site). All pages
                                                >> > display
                                                >> >> and I get no errors. I think where the issue may be, now I am guessing
                                                >> > here, is
                                                >> >> that my connection refrences a database located in the folder
                                                >> >> C:\Users\Administrator\Websites\Sitename\access_db, but once I upload
                                                > my
                                                >> > site,
                                                >> >> the database still sits in access_db, but the root folder possibly has
                                                >> > changed
                                                >> >> (maybe causing the connection to fail).
                                                >> >>
                                                >> >> Dooza - I don't understand how I can use "c:myDsnFile.dsn", when once
                                                > I
                                                >> > upload
                                                >> >> my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                                >> >> "c:myDsnFile.dsn" refrences a file on my computer. I am using an
                                                >> >> online
                                                >> > hosting
                                                >> >> company. Am I not understanding you correctly? See note above. I did
                                                > use
                                                >> > your
                                                >> >> information and got the following browser error:
                                                >> >>
                                                >> >> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                                >> >> General error: Invalid file dsn ''
                                                >> >> /sitename/contactus/index.asp, line 130
                                                >> >>
                                                >> >> line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                                >> >>
                                                >> >> I am researching on how to do a dsn-less connection, unless I can get
                                                >> > this
                                                >> >> figured out.
                                                >> >>
                                                >> >> Thanks - Matt
                                                >> >>
                                                >> >
                                                >> >
                                                >>
                                                >>
                                                >
                                                >


                                                • 21. Re: Urgent Help With Connections File Needed Please
                                                  Level 7
                                                  Sorry Tim? This is Dave. Did you read what said? I'm not Matt.
                                                  Dave
                                                  "TC2112" <nospam@nospam.com> wrote in message
                                                  news:gjude2$bk5$1@forums.macromedia.com...
                                                  > It could be, you'd have to check in the control panel to make sure
                                                  > permissions are set to read and write.
                                                  > Have you tried changing the path in your connection string to the GoDaddy
                                                  > path and uploading the file?
                                                  > The info I posted tells you how to find out what the path on GoDaddy is.
                                                  >
                                                  > Tim
                                                  >
                                                  >
                                                  > "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                                  > news:gjuc2n$9rr$1@forums.macromedia.com...
                                                  > > Tim,
                                                  > > Very good reply! I have no experience with GD other than the complaints
                                                  I
                                                  > > have read here about connections to databases etc. I think that if his
                                                  > > connection test is ok that it has to be a permissions issue? What do you
                                                  > > think?
                                                  > > Dave
                                                  > > "TC2112" <nospam@nospam.com> wrote in message
                                                  > > news:gju9nr$70n$1@forums.macromedia.com...
                                                  > >> Hello,
                                                  > >>
                                                  > >> Sorry if some of this is repetitive in respect to what others have
                                                  > >> advised
                                                  > >> in this thread.
                                                  > >> It's an answer I gave someone with similar problems a while ago.
                                                  > >> It does answer your question about the successful path on your local
                                                  > > server
                                                  > >> being different than the path on GDs server.
                                                  > >> There are also instructions on how to find the path on GD's server if
                                                  > > needed
                                                  > >> for DNS-Less connection.
                                                  > >>
                                                  > >>
                                                  > >> Option 1:
                                                  > >> You can try using a map path function like this in your connection
                                                  > >> string:
                                                  > >> access_db is the folder the database is in and mydatabase.mdb is the
                                                  > > access
                                                  > >> file.
                                                  > >> Substitute your names.
                                                  > >>
                                                  > >> STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
                                                  > >> Server.MapPath("access_db") & "\mydatabase.mdb;User Id=admin;Password="
                                                  > >>
                                                  > >> -or-
                                                  > >>
                                                  > >> Option 2:
                                                  > >> You could try an OLEDB DSN-Less connection instead of using a DSN. It's
                                                  > > not
                                                  > >> hard to do.
                                                  > >>
                                                  > >> Step 1 is to figure out the location of the root directory on the
                                                  host's
                                                  > >> server..That's very easy to do yourself.
                                                  > >>
                                                  > >> Just make an asp page (I named mine "findit.asp"), and put the
                                                  following
                                                  > >> code between the <body> tags, like so:
                                                  > >> <body>
                                                  > >> <%
                                                  > >> Response.Write("The location of this page is:<br>")
                                                  > >> Response.Write(Request.ServerVariables("PATH_TRANSLATED") & "<br>")
                                                  > >> Response.Write("The location of my root directory is:<br>")
                                                  > >> Response.Write(Server.MapPath("\"))
                                                  > >> Response.Write Path
                                                  > >> %>
                                                  > >> </body>
                                                  > >>
                                                  > >>
                                                  > >> Upload it to the same location as your site's home page.
                                                  > >> Once your new asp page is uploaded, just navigate to that page in your
                                                  > >> browser.
                                                  > >>
                                                  > >> For a site on GD the "findit.asp" page displays something like this:
                                                  > >>
                                                  > >> The location of this page is:
                                                  > >> d:\hosting\mysite\findit.asp
                                                  > >> The location of my root directory is:
                                                  > >> d:\hosting\mysite
                                                  > >>
                                                  > >> Now that you know the root directory location on their server, you can
                                                  > >> figure out the path to your database.
                                                  > >> Let's say that the folder your database is in is named _private, and
                                                  it
                                                  > >> happens to be in the root
                                                  > >> directory along with your home page.
                                                  > >>
                                                  > >> Next, just add the database folder name (_private) and the database
                                                  > >> inside's name (mydatabase.mdb) to the root directory location:
                                                  > >>
                                                  > >> d:hosting\mysite\_private\mydatabase.mdb
                                                  > >>
                                                  > >> That's your Data Source path.
                                                  > >>
                                                  > >> The connection string would look something like this:
                                                  > >>
                                                  > >> = "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                                  > >> Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"
                                                  > >>
                                                  > >> (the code above may appear wrapped (two lines) in the forum/ng but it's
                                                  > > one
                                                  > >> line with no return within)
                                                  > >>
                                                  > >> IMPORTANT: If you are using a local testing server, make a copy of your
                                                  > >> connection asp page as a backup.
                                                  > >> The reason? The connection information you are going to put in this
                                                  file
                                                  > >> will only work on the host's server.
                                                  > >> Once you upload the new connection.asp page with the changes for the
                                                  > >> host,
                                                  > >> you'll need to change your local copy back to your local connection so
                                                  it
                                                  > >> will work on
                                                  > >> your local testing server.
                                                  > >>
                                                  > >> Upload to server.
                                                  > >>
                                                  > >> Please note: From now on, when you upload (or "put" if you're using DW)
                                                  > >> files that refer to your connection asp page you're going to get a
                                                  > >> warning
                                                  > >> that your connection asp on the host is different than your local copy.
                                                  > >> Always say "No" to updating it, or you'll replace the GD DSN-Less
                                                  > > connection
                                                  > >> with your local one.
                                                  > >>
                                                  > >>
                                                  > >> Did you set the appropriate read/write permissions on the
                                                  > > directory(folder)
                                                  > >> your database is in?
                                                  > >> You can do that in GD's control panel. Hosting> Select your site >
                                                  Manage
                                                  > > to
                                                  > >> open it.
                                                  > >>
                                                  > >> I hope this helps.
                                                  > >>
                                                  > >> For what it's worth, I only use GD for domain names now.
                                                  > >> I had numerous problems with some sites hosted there, switched them to
                                                  > >> HostMySite and haven't had any.
                                                  > >>
                                                  > >> Take care,
                                                  > >> Tim
                                                  > >>
                                                  > >>
                                                  > >>
                                                  > >>
                                                  > >>
                                                  > >> "Baxter" <baxter(RemoveThe :-)@gtlakes.com> wrote in message
                                                  > >> news:gjtvq2$ntf$1@forums.macromedia.com...
                                                  > >> > Baxter - I get "Connection was Made Successfully" if connection to
                                                  the
                                                  > >> > database was made Successfully not sure what's going on here? When
                                                  you
                                                  > >> > look
                                                  > >> > at your site files in Dreamwerer on the server is there a folder
                                                  named
                                                  > >> > access_db? If so is your data base in that folder? The database needs
                                                  > >> > permissions set to read and write to that file. Have you checked
                                                  > >> > permissions
                                                  > >> > on the site? does GD give you a control panel so that you can set the
                                                  > >> > permissions your self? I have never used GD but have seen where
                                                  people
                                                  > >> > have
                                                  > >> > had lots of problems with them when using a scripting language. I
                                                  don't
                                                  > >> > know
                                                  > >> > what else it could be at this point.
                                                  > >> > Dave
                                                  > >> > "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                                  > >> > news:gjt5hp$jfj$1@forums.macromedia.com...
                                                  > >> >> Baxter - I get "Connection was Made Successfully" with the
                                                  credentials
                                                  > >> >> you
                                                  > >> > gave
                                                  > >> >> me. My site works just fine on my local machine with
                                                  > > access_trueblood.dsn
                                                  > >> > (it
                                                  > >> >> also worked with the dsn I initally created for the site). All pages
                                                  > >> > display
                                                  > >> >> and I get no errors. I think where the issue may be, now I am
                                                  guessing
                                                  > >> > here, is
                                                  > >> >> that my connection refrences a database located in the folder
                                                  > >> >> C:\Users\Administrator\Websites\Sitename\access_db, but once I
                                                  upload
                                                  > > my
                                                  > >> > site,
                                                  > >> >> the database still sits in access_db, but the root folder possibly
                                                  has
                                                  > >> > changed
                                                  > >> >> (maybe causing the connection to fail).
                                                  > >> >>
                                                  > >> >> Dooza - I don't understand how I can use "c:myDsnFile.dsn", when
                                                  once
                                                  > > I
                                                  > >> > upload
                                                  > >> >> my site, "c:myDsnFile.dsn" would then not be the location of my dsn.
                                                  > >> >> "c:myDsnFile.dsn" refrences a file on my computer. I am using an
                                                  > >> >> online
                                                  > >> > hosting
                                                  > >> >> company. Am I not understanding you correctly? See note above. I did
                                                  > > use
                                                  > >> > your
                                                  > >> >> information and got the following browser error:
                                                  > >> >>
                                                  > >> >> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
                                                  > >> >> General error: Invalid file dsn ''
                                                  > >> >> /sitename/contactus/index.asp, line 130
                                                  > >> >>
                                                  > >> >> line 130 - rs_contactus.ActiveConnection = MM_connTrueblood_STRING
                                                  > >> >>
                                                  > >> >> I am researching on how to do a dsn-less connection, unless I can
                                                  get
                                                  > >> > this
                                                  > >> >> figured out.
                                                  > >> >>
                                                  > >> >> Thanks - Matt
                                                  > >> >>
                                                  > >> >
                                                  > >> >
                                                  > >>
                                                  > >>
                                                  > >
                                                  > >
                                                  >
                                                  >


                                                  • 22. Re: Urgent Help With Connections File Needed Please
                                                    mtrueblood Level 1
                                                    Tim and Dave,

                                                    Thank you very much for your help. I am going to try Tim's options right now and let report back my findings. Thanks again, I really appreciate your help!

                                                    FYI - I took my site down and uploaded a very basic 2 page website onto GD server to help narrow-down the issue.

                                                    Thanks - Matt
                                                    • 23. Re: Urgent Help With Connections File Needed Please
                                                      mtrueblood Level 1
                                                      So pages with dynamic content now display, but I am getting a different error. I think we are almost there. Here's what I did.

                                                      I started with your option 2 (OLEDB DSN-less connection). I found the location of the "findit.asp" file:

                                                      The location of this page is:
                                                      d:\hosting\myname\findit.asp
                                                      The location of my root directory is:
                                                      d:\hosting\myname

                                                      Following your input, my "Data Source Path" is then:
                                                      d:\hosting\myname\access_db\database.mdb

                                                      From there I went back to "Custom Connection String" dialog box (basically the Connection.asp page) and entered: <-- "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=d:\hosting\myname\access_db\database.mdb;Use rID=;Password=;" -->

                                                      I then uploaded the updated Connection.asp file to my GD hosted account and browsed to my site. My contact form loads, which is good as it didn't before, but when I input the information and click send, I get the following error:

                                                      Microsoft JET Database Engine error '80004005'
                                                      Could not find installable ISAM.
                                                      /sitename/contact.asp, line 21

                                                      line 21
                                                      MM_editCmd.ActiveConnection = MM_conn_trueblood_STRING

                                                      "conn_trueblood" is what I entered as the Connection Name in the "Custom Connection String" dialog box. Also, do I want to check "Using driver on testing server"? Or "this machine"?

                                                      The "access_db" folder does have read/write access as I have checked that a few times now. The file itself doesn't have to have any permissions to it, does it?

                                                      Again, I appreciate all of your help.

                                                      Thanks - Matt
                                                      • 24. Re: Urgent Help With Connections File Needed Please
                                                        Level 7
                                                        mtrueblood wrote:
                                                        > So pages with dynamic content now display, but I am getting a different error.
                                                        > I think we are almost there. Here's what I did.
                                                        >
                                                        > I started with your option 2 (OLEDB DSN-less connection). I found the location
                                                        > of the "findit.asp" file:
                                                        >
                                                        > The location of this page is:
                                                        > d:\hosting\myname\findit.asp
                                                        > The location of my root directory is:
                                                        > d:\hosting\myname
                                                        >
                                                        > Following your input, my "Data Source Path" is then:
                                                        > d:\hosting\myname\access_db\database.mdb
                                                        >
                                                        > From there I went back to "Custom Connection String" dialog box (basically the
                                                        > Connection.asp page) and entered: <--
                                                        > "Provider=Microsoft.Jet.OLEDB.4.0;DataSource=d:\hosting\myname\access_db\databas
                                                        > e.mdb;UserID=;Password=;" -->
                                                        >
                                                        > I then uploaded the updated Connection.asp file to my GD hosted account and
                                                        > browsed to my site. My contact form loads, which is good as it didn't before,
                                                        > but when I input the information and click send, I get the following error:
                                                        >
                                                        > Microsoft JET Database Engine error '80004005'
                                                        > Could not find installable ISAM.
                                                        > /sitename/contact.asp, line 21
                                                        >
                                                        > line 21
                                                        > MM_editCmd.ActiveConnection = MM_conn_trueblood_STRING
                                                        >
                                                        > "conn_trueblood" is what I entered as the Connection Name in the "Custom
                                                        > Connection String" dialog box. Also, do I want to check "Using driver on
                                                        > testing server"? Or "this machine"?
                                                        >
                                                        > The "access_db" folder does have read/write access as I have checked that a
                                                        > few times now. The file itself doesn't have to have any permissions to it, does
                                                        > it?
                                                        >
                                                        > Again, I appreciate all of your help.

                                                        There is a possibility that your server doesn't have Jet or MDAC
                                                        installed
                                                        ( http://databases.aspfaq.com/database/how-do-i-solve-could-not-find-installable-isam-errors .html),
                                                        or the right components to let you do it this way.

                                                        Dooza
                                                        • 25. Re: Urgent Help With Connections File Needed Please
                                                          mtrueblood Level 1
                                                          It seems as if my site is working properly now... My contact form displays (which it hadn't done in the past), I can input information and click submit, then my info is displayed on another page.

                                                          1 question I have though is where do I apply my username and password? I noticed that your "connection string" example contains a username and password. Where do you create a username and password? When I supply a username and password, I get the following error:

                                                          Microsoft JET Database Engine error '80040e4d'
                                                          Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
                                                          /sitename/contact.asp, line 21

                                                          But when I omit the username and password, the site works fine. Do I need a username and password within my "connection string"?

                                                          Thanks - Matt
                                                          • 26. Re: Urgent Help With Connections File Needed Please
                                                            Level 7
                                                            mtrueblood wrote:
                                                            > It seems as if my site is working properly now... My contact form displays
                                                            > (which it hadn't done in the past), I can input information and click submit,
                                                            > then my info is displayed on another page.
                                                            >
                                                            > 1 question I have though is where do I apply my username and password? I
                                                            > noticed that your "connection string" example contains a username and password.
                                                            > Where do you create a username and password? When I supply a username and
                                                            > password, I get the following error:
                                                            >
                                                            > Microsoft JET Database Engine error '80040e4d'
                                                            > Cannot start your application. The workgroup information file is missing or
                                                            > opened exclusively by another user.
                                                            > /sitename/contact.asp, line 21
                                                            >
                                                            > But when I omit the username and password, the site works fine. Do I need a
                                                            > username and password within my "connection string"?
                                                            >
                                                            > Thanks - Matt

                                                            You set the username and password in Access, then when its uploaded you
                                                            will put it in the connection string. I am not sure if you need to worry
                                                            about it if your database is in a folder that outside of the public part
                                                            of your website.

                                                            Dooza
                                                            • 27. Re: Urgent Help With Connections File Needed Please
                                                              bregent Most Valuable Participant
                                                              >The connection string would look something like this:
                                                              >
                                                              >= "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                                              >Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"

                                                              Tim, the only thing I would suggest is to set the path dynamically in the connect string using Server.Mappath, rather than hardcoding it. This will make it more portable if they change hosts or if the host ever changes server paths.
                                                              • 28. Re: Urgent Help With Connections File Needed Please
                                                                Level 7
                                                                Glad you got everything sorted. You don't have to worry about the password
                                                                part if you did not set the access database up with one.
                                                                Good Luck Matt.
                                                                "mtrueblood" <webforumsuser@macromedia.com> wrote in message
                                                                news:gjvvbf$gpu$1@forums.macromedia.com...
                                                                > It seems as if my site is working properly now... My contact form displays
                                                                > (which it hadn't done in the past), I can input information and click
                                                                submit,
                                                                > then my info is displayed on another page.
                                                                >
                                                                > 1 question I have though is where do I apply my username and password? I
                                                                > noticed that your "connection string" example contains a username and
                                                                password.
                                                                > Where do you create a username and password? When I supply a username and
                                                                > password, I get the following error:
                                                                >
                                                                > Microsoft JET Database Engine error '80040e4d'
                                                                > Cannot start your application. The workgroup information file is missing
                                                                or
                                                                > opened exclusively by another user.
                                                                > /sitename/contact.asp, line 21
                                                                >
                                                                > But when I omit the username and password, the site works fine. Do I need
                                                                a
                                                                > username and password within my "connection string"?
                                                                >
                                                                > Thanks - Matt
                                                                >
                                                                >


                                                                • 29. Re: Urgent Help With Connections File Needed Please
                                                                  Level 7
                                                                  Good point, bregent.
                                                                  I usually use mappath and should have noted that benefit where I referred to
                                                                  it as an option.

                                                                  Take care,
                                                                  Tim


                                                                  "bregent" <webforumsuser@macromedia.com> wrote in message
                                                                  news:gk056v$od4$1@forums.macromedia.com...
                                                                  > >The connection string would look something like this:
                                                                  > >
                                                                  > >= "Provider=Microsoft.Jet.OLEDB.4.0;Data
                                                                  > >Source=d:hosting\mysite\_private\mydatabase.mdb;User ID=;Password=;"
                                                                  >
                                                                  > Tim, the only thing I would suggest is to set the path dynamically in the
                                                                  > connect string using Server.Mappath, rather than hardcoding it. This will
                                                                  > make
                                                                  > it more portable if they change hosts or if the host ever changes server
                                                                  > paths.
                                                                  >


                                                                  • 30. Re: Urgent Help With Connections File Needed Please
                                                                    mtrueblood Level 1
                                                                    Dave and Tim,

                                                                    Thank you so much for your help! The site is working great now. I am not going to worry about setting a username and password.

                                                                    Thanks - Matt