Forum ASP Questions... [Archive]

View Full Version : Forum ASP Questions...

Syedur

16.05.2001, 16:38

Hey Thomas or anyone knows ASP...
1. You know this snitz fourm database is in Access 97 format...
When I try to convert it to Access 2000 format, the forum doesn't run.
Anyone one know how can I convert it and still make it run?
2. Thomas has somekind of password protection in his database folder... I do too... but the thing is... the folder is protected but not the files if anyone guesses the name, they can download the file... I told my host provider to look everything on that folder... when they did, the forum didn't run... you know what causes that too?
Or... do you know a better way to look the web folder?

<center>[url="http://e-syed.net/"]e-syed.net[/url:udfapv0msg]
||| Part of syedsoft.com |||
webmaster@e-syed.net
...Coming Soon...
In a browser near you.</center>

Dan

16.05.2001, 16:47

Can't really answer your question but the best way I've found with databases is to have them in the root directory, so for example on manski.co.uk I have:
<pre id=code>/manski
/web
/db</pre id=code>

======================
Dan
www.pupius.net
======================


Edited by - Dan on 05/16/2001 15:48:02

dayve

16.05.2001, 19:27

I am using MSAccess 2000 and it works like a champ. Do not use the Access 97 connection string. Comment that line out and use one of these instead:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path

OR

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_for um.mdb;" '## MS Access 2000

The first connection type is my favortie one to use.

dayve

NIN Discussion: http://www.burningsouls.com/forum

Dan

16.05.2001, 19:33

Hi Davye, just a quick question... would the 'inetpub' be your root directory then, where the domain points too?

======================
Dan
www.pupius.net
======================

Syedur

16.05.2001, 21:26

<BLOCKQUOTE id=quote>quote:<hr height=1 noshade id=quote>
Hi Davye, just a quick question... would the 'inetpub' be your root directory then, where the domain points too?
<hr height=1 noshade id=quote></BLOCKQUOTE id=quote>Hey Dan,
Thats the file directory... the domain can point to anything they want to...
My host sets up D:\websites\e-syednet\[THIS IS MY MAIN DIR]
so... when I have a default or index file there...
the domain e-syed.net points to that page...


Hey Davye,
I know what you are trying to see, I guess you misunderstood my question...
I have the database set up...
I want to change the .mdb file format to Access2000 file format (its written in Access97).
Everytime I try to convert the file format, the forum doesn't display, and I don't whats causing it.
Thanks.

<center>[url="http://e-syed.net/"]e-syed.net[/url:evbgvu0e6x]
||| Part of syedsoft.com |||
webmaster@e-syed.net
...Coming Soon...
In a browser near you.</center>

dayve

17.05.2001, 01:23

nope, I understood completely what you were asking. I converted the 97 database to 2000 and used the different connection string and it works like a champ. I have set up 5 Snitz forums for people now plus mine and converted the database to 2000, it works. show me your config.asp

Dan:

The following string assumes you have a virtual directory named fpdb which would be your root

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

This connection string:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_for um.mdb;"

uses absolute pathing, NOT RECOMMENDED IN MY BOOKS...

dayve

<center>
Nine Inch Nails Forum
http://www.nineinchnailz.com/forum
</center>

Edited by - dayve on 05/17/2001 00:24:39