I was fooling around with some server.mappath strings and now my old 

connection string won't work any longer. Any reason for this?



set rst = Server.CreateObject("ADODB.Recordset")

	rst.open strSQL, Connect, 3,1,1



...



Error Type:

ADODB.Recordset (0x800A0E7D)

Operation is not allowed on an object referencing a closed or invalid 

connection.





Thanks. 



- Frode.

Connect is not a valid, open connection object, nor a valid connection

string.



Is Connect supposed to be an object? (you should probably look at a naming

scheme, so that objects, for example, are prefixed obj, or o, eg objConn or

oConn), or is it supposed to be a string? (eg strConnect). If the later,

response.write(connect) to see what is really in the connection string.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

----- Original Message -----

From: "Frode StrXmme" <fstroemm@o...>

To: "ASP Database Setup" <asp_database_setup@p...>

Sent: Friday, June 15, 2001 6:09 PM

Subject: [asp_database_setup] Problem connecting, same code worked before.





:

: I was fooling around with some server.mappath strings and now my old

: connection string won't work any longer. Any reason for this?

:

: set rst = Server.CreateObject("ADODB.Recordset")

: rst.open strSQL, Connect, 3,1,1

:

: ...

:

: Error Type:

: ADODB.Recordset (0x800A0E7D)

: Operation is not allowed on an object referencing a closed or invalid

: connection.