Re: asp - db problem with connection.
From: Peter Foti (peter_at_Idontwantnostinkingemailfromyou.com)
Date: 04/09/04
- Next message: Robin: "Dynamic selct box from another select box"
- Previous message: Peter Foti: "Re: asp login"
- In reply to: Brian: "asp - db problem with connection."
- Next in thread: Aaron Bertrand [MVP]: "Re: asp - db problem with connection."
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Apr 2004 13:42:56 -0400
"Brian" <quigleyb@iol.ie> wrote in message
news:c56n2b$1fb$1@kermit.esat.net...
> hi. ive recently put XP on my system which was running Win 2k. ever since
> this, i cant seem to get my asp stuff to interact with a database. even
with
> code which wasn't changed since 2k.
>
> the error im getting each time i try to access a database is as
follows....
>
> Error Type:
> Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
> [Microsoft][ODBC Microsoft Access Driver]General error Unable to open
> registry key 'Temporary (volatile) Jet DSN for process 0xf40 Thread 0xaa8
> DBC 0x15f8024 Jet'.
> /Brian/functions.asp, line 27
>
> line 27 is the 3rd line of the code below.... any ideas would
definately
> help......
>
>
> DatabasePath = Server.MapPath("photoalbum.mdb")
> Set Conn1 = Server.CreateObject("ADODB.Connection")
> Conn1.Open = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
> DatabasePath & ""
Use the Jet drivers instead.
DatabasePath = Server.MapPath("photoalbum.mdb")
Set Conn1 = Server.CreateObject("ADODB.Connection")
ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DatabasePath &
";"
Conn1.Open ConnStr
Regards,
Peter Foti
- Next message: Robin: "Dynamic selct box from another select box"
- Previous message: Peter Foti: "Re: asp login"
- In reply to: Brian: "asp - db problem with connection."
- Next in thread: Aaron Bertrand [MVP]: "Re: asp - db problem with connection."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
