ASP and Access

[Gayowulf]

I am unsure of what version of ms access my host is using. is there any way to find out short of asking the admin?

I also dont know which StrConnString to use:


'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/snitz_forums_2000.mdb") '
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\...
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb") '

as you can see i am installing snitz forums. I would reaal appreciate any help anyone can offer.

-Thanks

[Satelk]

I don't know how to find the version of access, but if I were you I would use:

strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '
That one is the first one in the config file, with full path.
It's for access97, just in case 2000 is not installed, I think it still works with 2000. If it doesn't, just use this instead:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/tools/snitz_forums_2000.mdb") '

[Gayowulf]

I attached the readme. I dont know where to put the *.mdb file. that is the main problem. after that all should be ok

[Satelk]

No need to attach the readme file, I already have the script. I tested the previous version on phidji.com.
As for the *.mdb file:
The best thing to do is put it out of the folder tree so no one can download it. And then edit the full path to the database in the config file.

[Gayowulf]

Currently the *.mdb is in cgi-bin, and the full path doesnt seem to work.

[Satelk]

What does it say when you run the setup.asp file?

[Gayowulf]

Ive got it running now :) i had the path wrong. it said it the database couldnt be located, and to check the StrConnString and StrDBtype. I'm sure ill be having more troubles though.

[Satelk]

Good.
If you ever have another problem, just ask me and I'll do my best to help.

[Gayowulf]

Thanks Ive got this to deal with now :


Server object error 'ASP 0177 : 800401f3'

Server.CreateObject Failed

/forums/inc_mail.asp, line 55

Invalid class string

got that when trying to sign up.

[Satelk]

Maybe you don't have aspemail installed.

[Satelk]

You should go to the admin page and modify what type of mail to use.
The info about the admin is in the readme file.

[Gayowulf]

Probably not. I will have to check with the admin about that. it would make sense for a system that supports asp to have aspmail

[Satelk]

according to the error, it was using aspemail, you probably have aspmail but not aspEmail.

[Gayowulf]

"no compatible component found." Doesn't look too promising.

[Satelk]

You can always use SMTP.
That's why I like the mail() function in PHP, works almost everywhere. :D

[Gayowulf]

I dont have access to SMTP, but i am getting things worked out. despite that error, the account i signed up works.

[Satelk]

You can find information on SMTP on socialreject at http://members.socialreject.net/faqs/mail/

[Gayowulf]

I know :)

So far everything is working perfectly.

[Satelk]

Great. Hope it will stay that way.
Glad I could help... if I did.

[Satelk]

Also hope socialreject will reopen sign ups soon like you said. Didn't sign up when we could cause they didn't have php at that time. Damn!

[Gayowulf]

a kick --- user CP is coming, and there is a nice webmail feature.

Thanks- you did help me. :)