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...

 

[onpnt]

hey GUJUm0deL, making me feel bad sense I gave sent you to this one.

do this
open notepad first
open the common.inc from file -- open etc.
in there you should see the connection string all commented out with the quote '
within that set of lines you will see the connection string. it will look like this
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("weekly_poll.mdb&quot

change it to the path you need for the writable directory.

let me know if you did this already or it doesn't work I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

Hi onpnt, sorry that did not work... I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

try using this string instead of the current one.
'strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("weekly_poll.mdb&quot
if that doesn't work do the access 97 one. I can't remember which version I sent.

jsut take out the quote and place it in the other string. I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

When I try the driver for Access2000, I get this error:


Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

/common.inc, line 103
I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

that's odd. I did the same steps and it works fine. Are you calling the poll like this
<% Server.Execute &quot;weekly_poll.inc&quot; %> I'm trying, really I am!
admin@onpntwebdesigns.com

 

[onpnt]

just to double check. you have this set up this way correct
all files are in the root directory and the database is in the writable directory.
If you are places all the files into the root with the database that is fine, or if you are placing the database in a seperate directory like most services ask to be done that if also fone BUT the all the files must be in the root directory in order for it to work. the only file you can palce in other directories is the DB I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

I am calling the file like this:
<!--#include file=&quot;weekly_poll.inc&quot; -->
This is in the index.asp page...should it be: <% Server.Execute &quot;weekly_poll.inc&quot; %> ?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

yes! it should be
<% Server.Execute &quot;weekly_poll.inc&quot; %> I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

Now 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 0x438 DBC 0x10119d4c Jet'.

/common.inc, line 91


This is what I did:
1) Upload all the files on one directory, the root
2) Upload the dB in the database directory
3) In the common.inc, I am using this driver: strCon = &quot;DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=&quot; & Server.MapPath(&quot;weekly_poll.mdb&quot (I don't know what to change here, so I left it the way it is)
4) In the index.asp file, I added this: <% Server.Execute &quot;weekly_poll.inc&quot; %>
So, what am I doing wrong?? I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

everything looks good but use this string instead of the one you have up there
strCon = &quot;Provider=Microsoft.Jet.OLEDB.4.0; Data Source=&quot; & Server.MapPath(&quot;/dbase/weekly_poll.mdb&quot

see where I changed the path info to get the db from my database directory. that's all you need to change. This is for the 2000 version. I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

YES!! YES!! YES!! YES!!
You are good...such a simple mistake, yet overlooked... I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

I see you got it. Sorry it took so long to figure it out I'm trying, really I am!
admin@onpntwebdesigns.com

 

[onpnt]

We must have hit submit at the same time
changing the color should be easy
jsut go to the admin.htm I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

No need for any apology (it was really my fault)...
Thanks for all the help...and hope you like star I gave... I have not failed; I merely found 100,000 different ways of not succeding...

 

[onpnt]

Thanks, I like stars, yes I do.

Also, thanks for that post regarding a star in the text size thread. I appreciate that a lot. I'm trying, really I am!
admin@onpntwebdesigns.com

 

[GUJUm0deL]

I have already changed the color/font and all that...

Go take a look, and tell me if you like the color and all that... I have not failed; I merely found 100,000 different ways of not succeding...

 

[Dud3]

where can I get this poll, or was it programmed

​

 

[GUJUm0deL]

Hey man, I know how it feels when you help someone and they just take it and &quot;leave town&quot;...lol
I hope you get that star from that person... I have not failed; I merely found 100,000 different ways of not succeding...

 

[glenmac]

He did!!