|
|
| Post Number: 1
|
ShakerMaker 
Mad For It
Group: Members
Posts: 103
Joined: Sep. 2001
|
 |
Posted on: Feb. 26 2002,07:01 |
|
   |
Having trouble with some ASP poll. (Yes, I'm a newbie.) 
This is the 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 0x470 Thread 0x490 DBC 0x3215d2c Jet'.
I'm using brinkster and they suggest to insert this code
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\UserName\db\dbname.mdb")
I have NO idea where they want me to put this.
Any ideas?
Edited by ShakerMaker on Jan. 01 1970,01:00
|
 |
|
|
| Post Number: 2
|
damien_s_lucifer
Emperor of Detnet
Group: Members
Posts: 33
Joined: Jan. 1970
|
|
Posted on: Feb. 26 2002,09:08 |
|
 |
No, except that ASP sucks.
Good luck.
|
|
|
|
| Post Number: 3
|
ShakerMaker
Mad For It
Group: Members
Posts: 103
Joined: Sep. 2001
|
|
Posted on: Feb. 26 2002,09:38 |
|
|
| Quote (damien_s_lucifer @ 26 Feb. 2002,01:08) | No, except that ASP sucks.
Good luck. |
Ok. What should I use instead of ASP?
I'll I need is a poll. And I aint gonna use those shitty free ones with banners all over them.
|
|
|
|
| Post Number: 4
|
Wiley
©0®ÞØ®4+3 whØ®3
Group: Members
Posts: 1268
Joined: Oct. 2001
|
 |
Posted on: Feb. 26 2002,15:51 |
|
|
Just to be clear, you are trying to use MS Access as your backend right? Have you setup a DSN for your database through the ODBC control panel?
--------------
There's a sucker born every minute ...but swallowers are hard to find.
|
|
|
|
| Post Number: 5
|
Anztac
Ronin
Group: Members
Posts: 1294
Joined: May 2000
|
|
Posted on: Feb. 26 2002,23:56 |
|
|
/me shivers
--------------
~[b]Anztac[/b][ [i]All Who Grok are God[/i] ]
|
|
|
|
| Post Number: 6
|
ShakerMaker
Mad For It
Group: Members
Posts: 103
Joined: Sep. 2001
|
|
Posted on: Feb. 27 2002,11:11 |
|
|
| Quote (Wiley @ 26 Feb. 2002,07:51) | | Have you setup a DSN for your database through the ODBC control panel? |
I have no fucking idea mate. Most likely not.
Edited by ShakerMaker on Jan. 01 1970,01:00
|
|
|
|
| Post Number: 7
|
Wiley
©0®ÞØ®4+3 whØ®3
Group: Members
Posts: 1268
Joined: Oct. 2001
|
 |
Posted on: Feb. 27 2002,15:26 |
|
|
DBQ=" & Server.MapPath("\UserName\db\dbname.mdb")
First things first, do you know the relative path to your database to use? Or the absolute path to the database (something like C:\inetpub\wwwroot\yourwebsite\database\poll.mdb)
Basically anytime you see the ODBC error it's just Microsoft saying "Dude, where the fuck is your database?".
--------------
There's a sucker born every minute ...but swallowers are hard to find.
|
|
|
|
| Post Number: 8
|
ShakerMaker
Mad For It
Group: Members
Posts: 103
Joined: Sep. 2001
|
|
Posted on: Feb. 28 2002,05:25 |
|
|
| Quote (Wiley @ 27 Feb. 2002,07:26) | DBQ=" & Server.MapPath("\UserName\db\dbname.mdb")
First things first, do you know the relative path to your database to use? Or the absolute path to the database (something like C:\inetpub\wwwroot\yourwebsite\database\poll.mdb)
Basically anytime you see the ODBC error it's just Microsoft saying "Dude, where the fuck is your database?". |
Ahh! I get it. So where bouts in my script do I throw that line?
|
|
|
|
| Post Number: 9
|
Wiley
©0®ÞØ®4+3 whØ®3
Group: Members
Posts: 1268
Joined: Oct. 2001
|
|
Posted on: Mar. 01 2002,03:46 |
|
|
| Quote (ShakerMaker @ 27 Feb. 2002,21:25) | | Ahh! I get it. So where bouts in my script do I throw that line? |
At the very top ...above the <HTML> line even. I would talk to your ISP though and see if they can setup a DSN for you, you'll get better performance and not have to reley on a path (virtual or absolute) to the database.
Here are some different ways to connect to your MS Access file.
MS Access 97 with virtual path
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/files/database.mdb")
MS Access 97 with absolute path
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\wwwroot\yoursite\files\database.mdb"
MS Access 2000 with virtual path
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/files/database.mdb")
--------------
There's a sucker born every minute ...but swallowers are hard to find.
|
|
|
|
| Post Number: 10
|
Anztac
Ronin
Group: Members
Posts: 1294
Joined: May 2000
|
|
Posted on: Mar. 01 2002,09:29 |
|
|
Gahhhhh! Make it stop!! It hurts my virgin eyes!!!
--------------
~[b]Anztac[/b][ [i]All Who Grok are God[/i] ]
|
|
|
|
|
|
