Professional Web Applications Themes

Multiple connections problems - Macromedia Dreamweaver

> I have multiple recordsets on a page that use the same connection file to How many recordsets? I would advise to use the one connection for multiple recordsets, but do understand that it takes away from your DW productivity. I can't test this out, but heres what I'd try: - Modify the connMydb.asp file like so: Dim MM_connMydb_STRING ' for local development MM_connMydb_STRING = "Provider=Microsoft.Jet....." ' for remote server, comment out the above line, uncomment the below lines ' Set MM_connMydb_STRING = Server.CreateObject( "ADODB.Connection" ) ' MM_connMydb_STRING.ConnectionString = "Provider=Microsoft.Jet...." ' MM_connMydb_STRING.Open So, when your testing locally, you'd use the ...

  1. #1

    Default Re: Multiple connections problems

    > I have multiple recordsets on a page that use the same connection file to

    How many recordsets?

    I would advise to use the one connection for multiple recordsets, but do
    understand that it takes away from your DW productivity. I can't test this
    out, but heres what I'd try:

    - Modify the connMydb.asp file like so:

    Dim MM_connMydb_STRING
    ' for local development
    MM_connMydb_STRING = "Provider=Microsoft.Jet....."
    ' for remote server, comment out the above line, uncomment the below lines
    ' Set MM_connMydb_STRING = Server.CreateObject( "ADODB.Connection" )
    ' MM_connMydb_STRING.ConnectionString = "Provider=Microsoft.Jet...."
    ' MM_connMydb_STRING.Open

    So, when your testing locally, you'd use the string version of
    MM_connMydb_STRING, and being sure that the ADO Connection version of the
    same variable is commented out. When deploying...just comment out the string
    version, uncomment the Connection version.

    --
    Ron


    Ron Guest

  2. #2

    Default Re: Multiple connections problems

    Maybe its the permissions again....

    sometime the page is fine then next hit it isn't - especially with one rs.

    Hmmm

    BTW just for my own learning how does setting and opening the connection on
    the connection file help/change things?

    Thanks again
    Shane

    "Shane Anderson" <shane.andersonbtinternet.com> wrote in message
    news:beoqfu$2j8$1forums.macromedia.com...
    > Thanks Ron
    >
    > There are 5 recordsets in all.
    >
    > This solution seems to work fine on pages where there are multilple
    > recordsets but if there is only one then there are problems
    > Microsoft JET Database Engine error '80004005'
    >
    > Unspecified error
    >
    > on the .open line of connMydb.asp
    >
    > Do I need to create a different connection file for multiples and singles?
    >
    > Thanks
    > Shane
    >
    >

    Shane Anderson Guest

Similar Threads

  1. Multiple connections for Contribute?
    By WhiteClaw48 in forum Macromedia Contribute Connection Administrtion
    Replies: 1
    Last Post: May 8th, 12:06 AM
  2. Multiple Connections on Contribute?
    By WhiteClaw48 in forum Macromedia Contribute General Discussion
    Replies: 1
    Last Post: May 7th, 08:12 PM
  3. Multiple connections to same server
    By kristo2 in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: April 2nd, 07:58 AM
  4. Multiple Connections to same site
    By grodrigu in forum Macromedia Contribute Connection Administrtion
    Replies: 2
    Last Post: November 30th, 08:05 PM
  5. Thoth and Multiple Server Connections
    By Mark Edwards in forum Mac Applications & Software
    Replies: 5
    Last Post: July 2nd, 04:41 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139