Hi
My site has been running for a few months with no problems at all.
However yesterday any pages with more than one recordset on them are creating errors.
Different errors on each attempt. e.g

80004005|[Microsoft][ODBC_Microsoft_Access_Driver]General_error_Unable_to_open_registry_key_'Temporary_(volatile)_Jet_DSN_for_process_0x660_Thread_0x7b4_DBC_0xb2fafec_Jet'

or

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

/home.asp, line 51

or

Provider error '80004005'

Unspecified error

/home.asp, line 51

If I try to go to a page with only one recordset everything is fine.

Everything is fine here at home on my testing server but not on my remote server, I have contacted tech support at my server but had no response from them yet, perhaps they need to update the ODBC drivers or something but it seems weird that it should suddenly stop working when no changes have been made.
Any ideas/comments?

examples:-

working (one recordset) - www.reunite.co.uk/latest.asp

not working (multiple recordsets) - www.reunite.co.uk/home.asp


ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome

home page seems to be ok now dave, maybe they were updating there ADO or DB system.

all the best m8


Regards,
Dave

UD4 | Flash 5/MX | Studio MX | SQL | Access | ASP/VBScript | XP-Pro

Hi Dave

Yes , forgot to update everyone.

My host couldn't find out what the problem was, so they moved the site to a different server and everything is now fine.

cheers

Dave

ASP|VBScript|IIS5.1|Access|WinXPPro & WinXPHome