| Author |
 Topic  |
|
|
jalbani
Starting Member
14 Posts |
 Posted - 13 May 2001 : 08:49:12
|
I am new to this and need help with configuring my 1st forum. What would be most helpful is a sample of coding for both access 97 and access2000 databases --- specifically the "strConnSring variable would be great.
Edited by - jalbani on 01 June 2001 18:45:47< |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 May 2001 : 11:21:43
|
if you look in config.asp, there are example of each of the stsConnstring, you just need to change the path to the db and uncomment the one you want
< |
 |
|
|
jalbani
Starting Member
14 Posts |
Posted - 13 May 2001 : 13:12:04
|
do I need to have my host establish a DSN?
< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 May 2001 : 13:15:00
|
NO, you can use a physical path or a relative path, or if using SQL ust upply the servernamme or IP.
What host are you with, someone may have the info you require
< |
|
|
|
jalbani
Starting Member
14 Posts |
Posted - 13 May 2001 : 13:28:10
|
I have tried both and absolute and relative paths and neither have worked. --- my db is access
< |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 13 May 2001 : 14:43:06
|
Ok, here is an examp;e.
Your website is at www.mywebsite.com and you have copied the forum asp files to a subdirectory called forums and the database to a directory called forums/data
you would use a pth like this
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/forums/data/snitz_2000.mdb")
< |
|
|
|
sarmadys
Starting Member
8 Posts |
Posted - 01 June 2001 : 04:32:13
|
Hello
I have tested all options even mappath way.
But it does not work for my host (readyhosting) which needs DSN only.
Is there a way to implement DSN connections for this?
My server issues the following error in most pages :
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/forum/inc_functions.asp, line 644
Also in different files.
I insist, if there is a way to do it with DSN would someone please send a snippet code?
Regards, Mac
< |
|
|
|
davemaxwell
Access 2000 Support Moderator
USA
3020 Posts |
Posted - 01 June 2001 : 07:32:50
|
quote:
Operation must use an updateable query.
This is a permission problem. The database and the directory it resides in MUST have read/write access on it...
Dave Maxwell
--------------
Proud to be a "World Class" Knucklehead < |
|
|
|
sarmadys
Starting Member
8 Posts |
Posted - 01 June 2001 : 17:19:24
|
Ok
I fixed the problem using below connection string
"DSN=dsnname"
And well it took only 6 hours before it is hacked by one of visitors of above message !!!!
Thanks a lot ! only 6 hours is a good record.
Some parts of database including users, categories and boards, messages etc. are changed.
I think this is because I have not used any password for database is it?
By the way they are replaced by a "Brasilian or portugal" message board's contents and users.
So it seems I must put "snitz" away what I was proud of finding it or you have a better suggestion ? ( I really want to have a stable message board )
Regards,
< |
|
|
|
Deleted
deleted
4116 Posts |
Posted - 14 August 2001 : 06:51:17
|
I wanted to bump this.
I don't think thats a problem with Snitz (if you have the latest Service Releases). There is no currently known security problem related to Snitz as far as I know.
Can this be a problem with DSN or Server hack?
Think Pink< |
|
|
|
kaibo
Starting Member
USA
4 Posts |
Posted - 20 August 2001 : 17:54:04
|
It's your hosting service's security problem.
I believe the hack was done by downloading your .mdb file from your subpath.
The secure way is to put your .mdb file some place other than the virtual path like http://www.yourdomain.com/dbpath/xxx.mdb.
Lots of hosting services have a better file structure like this
/webs/youraccount/db (write/read permit and accessable by you via ftp only)
/webs/youraccount/www (this your virtual root directory for the domain, accessable via the browser and via your ftp)
Then you can put your .mdb file in the /db directory.
Note: .mdb password (Access 97) can easily cracked with some tools.
Hope this helps
< |
|
|
| |
Topic |
|
Forum Locked
