Multiple connections problems

[Ron]

> 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

[Shane Anderson]

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.anderson@btinternet.com> wrote in message
news:beoqfu$2j8$1@forums.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
>
>