Hi Guys.
I need abit of help with some website that i seem to have had dumped on me
it looks like it was done with MS Frontpage and has connections to MS Access and SQL
I have uploaded the site to a new MS Hosting with 1&1 but get this error:
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 0x254c Thread 0x2144 DBC 0x1a26f54 Jet'.
path/path/default.asp, line 154
line 154 is just this: oConn.Open?
I have changed the DSN of the global.asa file to point to the location of the database (access) the sql is hosted by another provider and that connection string appears correct
the settings from the global.asa are:
FrontPage Generated - startspan==
Dim FrontPage_UrlVars(2)
'--Project Data Connection1
Application("ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:\kunden\homepages\xx\xxxxxxx\db\fpdb\database.mdb";UID=username;PWD=password
Application("airadio_ConnectionTimeout") = 15
Application("airadio_CommandTimeout") = 30
Application("airadio_CursorLocation") = 3
Application("airadio_RuntimeUserName") = "username"
Application("airadio_RuntimePassword") = "password"
and the connection string from the default.asp page:
dim oConn
dim oRS
dim strSource
dim iRowCounter
Set oConn = Server.CreateObject("ADODB.connection")
strSource = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.mapPath("./db/fpdb/database.mdb")
'response.Write strsource
'response.Flush
oConn.ConnectionString = strSource
oConn.Open
Any ideas?
Cheers
richand
I need abit of help with some website that i seem to have had dumped on me
it looks like it was done with MS Frontpage and has connections to MS Access and SQL
I have uploaded the site to a new MS Hosting with 1&1 but get this error:
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 0x254c Thread 0x2144 DBC 0x1a26f54 Jet'.
path/path/default.asp, line 154
line 154 is just this: oConn.Open?
I have changed the DSN of the global.asa file to point to the location of the database (access) the sql is hosted by another provider and that connection string appears correct
the settings from the global.asa are:
FrontPage Generated - startspan==
Dim FrontPage_UrlVars(2)
'--Project Data Connection1
Application("ConnectionString") = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:\kunden\homepages\xx\xxxxxxx\db\fpdb\database.mdb";UID=username;PWD=password
Application("airadio_ConnectionTimeout") = 15
Application("airadio_CommandTimeout") = 30
Application("airadio_CursorLocation") = 3
Application("airadio_RuntimeUserName") = "username"
Application("airadio_RuntimePassword") = "password"
and the connection string from the default.asp page:
dim oConn
dim oRS
dim strSource
dim iRowCounter
Set oConn = Server.CreateObject("ADODB.connection")
strSource = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.mapPath("./db/fpdb/database.mdb")
'response.Write strsource
'response.Flush
oConn.ConnectionString = strSource
oConn.Open
Any ideas?
Cheers
richand
