| Author |
 Topic  |
|
divizion
Starting Member
12 Posts |
 Posted - 06 June 2001 : 08:27:36
|
Alright, I've been trying to get this forum working for a couple weeks now, and I've had no luck so can someone please help me?
Here's where I've got so far.
http://www.divizion.com/forum/default.asp
yeah I know I need help.
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 06 June 2001 : 09:02:29
|
You modified the connection string in config.asp? and if so, you have the correct path to the database?
save your config.asp file as a .txt and post it.
<-- Eric -->
InsideWaco.com |
 |
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 09:15:22
|
I've tried that, maybe you can help me out here then.
'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
which one of these do I use, and what excatly should it say?
My (snitz_forums_2000.mdb) file is in the fpdb folder right outside of my server (www.divizion.com) if this helps at all?
Thanks for your help
|
|
|
|
e3stone
Average Member
USA
885 Posts |
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 09:37:02
|
So then is this what I should put?
I can't believe I still don't quite get it, sorry?!?
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="Request.ServerVariables("snitz_forum_2000.mdb") '## MS Access 2000 using virtual path
Here's what that where am I file told me
<p>Path Translated: <b><%= Request.ServerVariables("PATH_TRANSLATED") %></b></p>
Edited by - divizion on 06 June 2001 09:38:52 |
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 06 June 2001 : 09:52:48
|
quote:
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
Use this one...
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 10:01:51
|
alright I got one thing down for sure now, I'm using this line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
Now I need to figure out what to change in that so it will work??
I got this from the "whereami.asp" file that e3stone told me to use earlier:
Path Translated: /home/sites/site7/web/fpdb/whereami.asp
So how do I put the two together for this thing to work???????
Edited by - divizion on 06 June 2001 11:58:47
Edited by - divizion on 06 June 2001 12:00:38 |
|
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 12:04:57
|
Do I have to change this at all?
strDBType = "access"
just remove the "'" before it right? I'm trying to figure it out guys, sorry.
|
|
|
|
tilttek
Junior Member
Canada
333 Posts |
Posted - 06 June 2001 : 12:07:09
|
quote:
alright I got one thing down for sure now, I'm using this line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\forum.snitz.com\snitz_forum.mdb;" '## MS Access 2000
Now I need to figure out what to change in that so it will work??
I got this from the "whereami.asp" file that e3stone told me to use earlier:
Path Translated: /home/sites/site7/web/fpdb/whereami.asp
So your connect string will look like this:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/home/sites/site7/web/fpdb/snitz_forums_2000.mdb") '
Philippe Gamache
http://www.tilttek.com
http://www.lapageamelkor.com |
|
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 12:14:46
|
Thanks, alright well Its still not working though. :(
http://www.divizion.com/forum/
What else could I be doing wrong now.
Aaaaaahhhhhhhhhhhhhhhhhh!!!!!!!!!!
|
|
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 06 June 2001 : 12:22:22
|
According to your config.txt file, this is your connection string:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/home/sites/site7/web/fpdb/snitz_forums_2000.mdb");" '## MS Access 2000
erase the red quote
Edit: also erase the semicolon at the end
<-- Eric -->
InsideWaco.com
Edited by - e3stone on 06 June 2001 12:30:43 |
|
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 12:32:47
|
Well I did that now, And guess what? Still isn't working.
I think I'm giving up now.
Anyone want to do it for me? :) e3stone? :)
if its possible to get someone started.
Edited by - divizion on 06 June 2001 12:35:20 |
|
|
|
e3stone
Average Member
USA
885 Posts |
|
|
divizion
Starting Member
12 Posts |
Posted - 06 June 2001 : 12:41:26
|
e3stone I just emailed you. Thanks
|
|
|
|
tilttek
Junior Member
Canada
333 Posts |
|
|
e3stone
Average Member
USA
885 Posts |
Posted - 06 June 2001 : 15:44:45
|
I couldn't tell. I found out that he's using FrontPage, so when he edited the config.asp file it might have messed it up. I wasn't able to do anything because he doesn't have ftp access..just publishes the pages through FP.
I just sent him a config file that I edited, we'll see if this works.
I'm not at all familiar with FP. So, I don't know what to do.
<-- Eric -->
InsideWaco.com |
|
|
|
Topic |
|
Topic Locked
