Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[warna]

source of my setup.asp
==================================
Dim oCn, sConnString, oFs, sDBPath
sDBPath = Server.MapPath(sPath)
Set oCn = Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & sDBPath & "\warnav3\db\main.mdb" & sDBName & "main.mdb"
oCn.Open sConnString
==================================
when i wanna running setup asp :
==================================
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0x958 Thread 0xa0 DBC 0x1048935c Jet'.

/warnav3/asp/setup.asp, line 14
==================================
this line 14 [/warnav3/asp/setup.asp, line 14 ]
==================================
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; " & "DBQ=" & sDBPath & "\warnav3\db\main.mdb" & sDBName & "main.mdb"
==================================
help me plz
my host at brinksterfree account

[vishu_gupt]

HI,
This problem occurs when the Temporary folder either does not exists or the environment variable "TMP" is pointing to a wrong location. Please ask your host about it and tell him to check whether the TMP environment variable is pointing to a right location. If not then he have to set it and then restart the m/c. I am afraid, you can not do much in that, its HOSt who can do something.

[tasneem]

Hi
I get the same error, but not on my host's server. I get it right on my testing server, so what do I do?

[vishu_gupt]

Originally posted by tasneem
Hi
I get the same error, but not on my host's server. I get it right on my testing server, so what do I do?

First check the TMP environment variable value under "system" ( you can check it under control settings/system). If this is pointing to a folder which is not available physicaly then either change this value to a available folder or create the folder at that location. Save it and then restart your system.