| Author |
 Topic  |
|
|
Sigi
Starting Member
Austria
5 Posts |
 Posted - 03 April 2001 : 20:38:06
|
I've read most postings and still can't get past config.asp
1) I have the sf2k_32a06 version.
2) The mdb was converted to access 2000.
3) tried all sorts of variations: like...
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitz_forums_2000.mdb")
4) I know ASP runs - because I use another DSN
5) DSN has been set to 'snitz'
6) My hoster, 'readyhosting.com' requires that the mdb is in a directory called 'database' which must be on the same level as the 'html' directory (security).
7) I would just love  to get this running. Its just  !
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
|
|
Sigi
Starting Member
Austria
5 Posts |
Posted - 03 April 2001 : 21:53:26
|
in fear of being called a p.i.t.a. I have this response
Path Translated: d:\html\users\psychoanalyseorg\html\sf2k_32a06\whereami.asp
but the database is on the level of html... which out of security reasons you cant get to.
|
 |
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 03 April 2001 : 22:04:06
|
you can deduct the physical path by comparing the directory structure.
Since you said that the database directory is on the same level as html then you should try this:
d:\html\users\psychoanalyseorg\database\snitz_forums_2000.mdb |
|
|
|
Sigi
Starting Member
Austria
5 Posts |
Posted - 03 April 2001 : 22:09:34
|
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\html\users\psychoanalyseorg\database\snitz_forums_2000.mdb;" '## MS Access 2000
is what i am using. without success.
Edited by - Sigi on 03 April 2001 22:18:41 |
|
|
|
beano
Starting Member
1 Posts |
Posted - 18 April 2001 : 17:29:53
|
I am having the exact same problem with the exact same hosting company if any one can help it would be much appericated
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 April 2001 : 18:51:15
|
How does the non-success manifest itself? (what is the error :)
======
Doug G
====== |
|
|
|
ronny
Starting Member
1 Posts |
Posted - 18 April 2001 : 21:41:11
|
quote:
I've read most postings and still can't get past config.asp
1) I have the sf2k_32a06 version.
2) The mdb was converted to access 2000.
3) tried all sorts of variations: like...
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/database/snitz_forums_2000.mdb")
4) I know ASP runs - because I use another DSN
5) DSN has been set to 'snitz'
6) My hoster, 'readyhosting.com' requires that the mdb is in a directory called 'database' which must be on the same level as the 'html' directory (security).
7) I would just love to get this running. Its just !
I also have an account with ReadyHosting and they have been extraordinarily helpful... Try using this solution (this is using a DSNless database in Access 2000):
'***************************************
' include the following in config.asp
strDBType = "access"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:/html/users/domaincom/database/snitz_forums_2000.mdb"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\domaincom\database\snitz_forums_2000.mdb;Persist Security Info=False"
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
'*************************************
For your directory structure use the following:
1.on the same level as the html directory, make a directory called database and copy the snitz_forums_2000.mdb (and whereami.asp)
2. make a subdirectory in the html directory called forum and copy all the files in the zip archive to that directory.
3. edit the config.asp as above...
My forum DOES work!
Hope that helps...
One last question for Richard,
The readyhosting people actually helped me edit the file, but for some reason, I think that there may be some extraneous "nonfunctional" lines in the above section.
|
|
|
|
butcher
Starting Member
1 Posts |
Posted - 20 April 2001 : 18:31:54
|
quote:
I also have an account with ReadyHosting and they have been extraordinarily helpful... Try using this solution (this is using a DSNless database in Access 2000):
'***************************************
' include the following in config.asp
strDBType = "access"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:/html/users/domaincom/database/snitz_forums_2000.mdb"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\html\users\domaincom\database\snitz_forums_2000.mdb;Persist Security Info=False"
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
'*************************************
For your directory structure use the following:
1.on the same level as the html directory, make a directory called database and copy the snitz_forums_2000.mdb (and whereami.asp)
2. make a subdirectory in the html directory called forum and copy all the files in the zip archive to that directory.
3. edit the config.asp as above...
My forum DOES work!
Hope that helps...
One last question for Richard,
The readyhosting people actually helped me edit the file, but for some reason, I think that there may be some extraneous "nonfunctional" lines in the above section.
LOL! I'm on readyhosting too! I can't seem to get it to work either. I set my config.asp exactly as you have yours, except modifying specifically to my domain. Mine still doesn't work. I did go ahead and setup a DSN (is that a bad thing?) and called their tech support and they gave me a DSN connection string :
quote:
Set connectionToDatabase=Server.CreateObject("ADODB.Connection")
connectionToDatabase.ConnectionTimeout=60
connectionToDatabase.Open"DSN=mydsn"
[make sure to insert the following line where you want to close the connection]
connectionToDatabase.Close
Set connectionToDatabase=Nothing
But that didn't work either. I'm stuck.
A lot of web hosts provide a forum for their customers to use. Maybe since snitz is free and so many of us are using it already, readyhosting should add it in so they could tailor it specifically to their system.
|
|
|
|
Bear Skarky
Starting Member
USA
29 Posts |
Posted - 25 April 2001 : 16:59:26
|
Good idea for Readyhosting to use a Snitz forum, but if they can get it to work, they won't need it. 
Here's the error I'm getting right now on my site on Readyhosting (www.poasters.com):
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
/forum/inc_top.asp, line 42
This has been happening intermittenly for several weeks now. I've tried the suggestions above and no luck. I have an email query in with Readyhosting's owner and their tech. I'll pass along whatever response I get.
|
|
|
|
Bear Skarky
Starting Member
USA
29 Posts |
Posted - 25 April 2001 : 20:00:57
|
Received a reply from Jeffrey at Readyhosting, and he changed the connection string to the following:
quote:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=d:\html\users\poasterscom\database\snitz_forums_2000.mdb;Persist
Security Info=False"
Since this is the solution Ronny posted above and I had already tried it without success, I'm not convinced this is a permanent solution. But the forum is back up, so fingers crossed.
Butcher, if you're still having problems, try emailing Jeffrey at jeff@readyhosting.com.
|
|
|
|
badark
Starting Member
Pakistan
1 Posts |
Posted - 30 April 2001 : 10:10:26
|
I URGENTLY need help!!! The worst thing, "whereami.asp" doesnt work on my server, have hosting with imtis.pair.com.
Secondly, I dont know about ASP, can anyone be nice and help how to really setup this thing ... I urgently need to setup it up and running ... !!!
I have tried to put everything in different directories and all but all in vain :(
Thanks in advance,
Badar.
Badar Khushnood
badar.k@usa.net
http://badar.tripod.com |
|
|
|
Coder
Starting Member
3 Posts |
Posted - 30 April 2001 : 10:30:59
|
I set up two Snitz-boards yesterday, also on ReadyHosting.com. First it worked, then it didn't (see post below "Database Gave Up on me").. But then I converted the database to Access 2000 (in Access), and now it works just fine!
I renamed the database to forum_1.mdb and then it in
d:\html\users\mydomaincom\database\forum_1.mdb
In the config.asp I use the following connectionstring:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\html\users\mydomaincom\database\forum_1.mdb;"
Works just great!
|
|
|
|
xylemnia
Starting Member
United Kingdom
18 Posts |
Posted - 03 May 2001 : 16:25:43
|
i cannot even begin to edit the config.asp, im using the original folders, e.g. forum/tools/snitz....mdb and do not know what to edit with what in the config file, im using ms access 2000, please tell me what to replace with what??
www.xylemnia.b0x.com |
|
|
| |
Topic |
|
Topic Locked
