| Author |
 Topic  |
|
|
BrianTT
New Member
57 Posts |
 Posted - 09 June 2001 : 22:07:49
|
Hello,
I've never installed a forum before and I just decided to get in to all this...I hared from a friend that Snitz would be the best way to go but it's not an easy task getting things the way you want when your new...
Well, I uploaded all the files to a host site(7host.com) so I can fiddle around and see how things work out for me...I created a 'cgi-bin' directory to put the DB file in thinking thats what I was supposed to do(not sure if thats what I'm supposed to do, but hey, I'm new,what can I say)...
Now I havent got the slightest clue on where to start with the'strConnString' lines...I don't know what to put down or which line to put it on,I'm pretty much in the dark and the readme file dosent help people like me very much, it all looks greek...
The code things below are what I'm talking about incase you don't know what I'm babbling about...
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
Can anyone help me out here, I want to learn this stuff but I cant do it alone...
Thanks!
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 10 June 2001 : 01:31:58
|
I am not sure if this is the right string for 7host.com and someone will have to correct me if I am wrong.
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/cgi-bin/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
You want to type in the path of where the database is. I put in there what I think it should be, wherever you located the cgi-bin folder.
The cgi-bin folder must have read/write permissions or else the forum won't work, you will get an error.
First off in your config.asp file you must get rid of the little ' in front of the access option. This is before the string lines. Just delete the ' out of there. Also do the same on the string line as I noted in red above. Set the path to that, I hope it is right. After this is all done, re-upload the config.asp file into your forum folder and run the setup.asp file in your browser..example -> www.yoursite.com/forum/setup.asp After this is completed the forum should work and you are all set to go. Post here if you need more help. 
__________________________________
 www.snowmobilefanatics.com/images/sr_erick_logo.gif" border=0>
www.snowmobilefanatics.com" target="_blank">Snowmobile Fanatics
Edited by - sr_erick on 10 June 2001 01:33:44 |
 |
|
|
BrianTT
New Member
57 Posts |
Posted - 10 June 2001 : 17:17:13
|
None of that is working for me, I keep getting an error when I try and run the 'setup.asp' file...
This is what I put in:
'(this is deleted BTW)strConnString= "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/root/cgi-bin/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
Maybe it because I dont know how to set the DB to read/write, any tips on how I do that?
|
|
|
|
sr_erick
Senior Member
USA
1318 Posts |
Posted - 10 June 2001 : 23:53:49
|
That doesn't seem like the right path to me for some reason. What is the error that you are getting? Search for the "whereamI.asp" file here at this forum and it will tell you the location of the database.
__________________________________
Snowmobile Fanatics
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 11 June 2001 : 00:31:56
|
This is what I used for 7host. I created a folder called "db" and placed my database in there. This is the connection string I used:strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\user\USERNAME\db\snitz_forum_2000.mdb;" '## MS Access 2000 Replace username with the name you signed up with on 7host. My user name is "davio".
|
|
|
|
BrianTT
New Member
57 Posts |
Posted - 11 June 2001 : 17:53:27
|
This is the error I get when I run the setup file:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : -2147467259
I've tried the thing that have been mentioned here but none have worked...
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 11 June 2001 : 18:12:47
|
Post your connection string again from your config.asp file.
You might also want to doublecheck that you have the correct name of the database in your connection string too.
|
|
|
| |
Topic |
|
Topic Locked
