Problem with an ASP poll 3

[GUJUm0deL]

Hi guys, if you go here:

http://www.missbollywoodusa.com

under the "login" box there is supposed to be a weekly poll, but for some reason I 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 0x7b0 Thread 0x928 DBC 0x10289eac Jet'.

/common.inc, line 103

My hosting company guys tell me that the problem is not with the server, but with the path. And I checked all the ASP files, and can't seem to locate where the path directory is declared. How can I fix this problem?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[glenmac]

He Did!! the help was genuinely appreciated.

 

[onpnt]

Dud3 sorry I didn't see your post earlier. here's the site

http://www.webwizguide.info/asp/sample_scripts/weekly_poll_script.asp

I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

glenmac, I really hope I didn't put you in the spotlight or anything...that wasn't my intention...

Dud3, that ASP poll is a winner...a few little editing here and there, but it works likes a charm......i'm also sorry I didn't see your post till now, and by this time onpnt had already given you the link... I have not failed; I merely found 100,000 different ways of not succeding...

 

[Dud3]

thanks guys.

would any of you mind helping me with this post? thread333-329482 I would appreciate it. btw, here's a star for the poll

​

 

[GUJUm0deL]

onpnt, I have a problem again with the poll...
For some reason again the vote will not go through...if you go to the site and try to vote, a popup appears but instead of the vote going through, I get this error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.

/weekly_poll.asp, line 309

I checked all the files and its all the way we had it set yesterday...the common.inc is calling the driver as: strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/weekly_poll.mdb&quot and the dB is in the correct directory, all the ASP files are in the right directory...I even used the Access2000 drivers and still the same message...any ideas?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[GUJUm0deL]

Dud3, wish I could help you...but I have just as much knowledge in ASP as you...lol... I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

there's only one reason for this happening. the permissions on the directory are not set to writable. get intouch with the hosting service and ask them to make it so or ask them if you need to place it in a specific directory in which you can write to a file (DB) I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

Guess what?? Now I get this error again:

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 0x7a0 Thread 0x9a8 DBC 0x9da4954 Jet'.

/common.inc, line 103


I did not change any of the files, it still follows the same lineup as yesterday:

1) Upload all the files in the root directory
2) Upload the dB in the database directory
3) In the "common.inc", I am using this driver: strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/database/weekly_poll.mdb&quot
4) In the index.asp file, I added this: <% Server.Execute &quot;weekly_poll.inc&quot; %>

The guys at the hosting company tell me that the &quot;database&quot; directory has the read/write permissions (as it should) and they reconfigured the IIS permissions...
And now I get this error...
Does this make any sense?? I'm stumped... I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

does not make a bit of sense to me. seeing as it worked yesterday but the fact you couldn't write to the DB.

some things you can try. Change the string in use to test for results with the others.

Try just opening the default.asp supplied by the poll and see if it works independently.

sorry I can't be of more help as I didn't write the program. I'll look thru it and see if I can determine something better. The odd thing is the fact I have it working fine here.

try the different connection strings and let me know what they result in. You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com

 

[GUJUm0deL]

Ok I looked at the defalt.asp and my version of index.asp...and the only diff. was that the default.asp used: <!--#include file=&quot;weekly_poll.inc&quot; -->...and I had it as Server.Execute...
So I changed it to <!--#include file=&quot;weekly_poll.inc&quot; --> and it works...for now, lol...
Take a look, if you have time and tell me what you think??
I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

Glad to hear it's working. I tried to go to the link but it states
Sorry, site under construction... You cannot mandate productivity, you must provide the tools to let people become their best.
-Steve Jobs
admin@onpntwebdesigns.com