| Author |
 Topic  |
|
maca
Starting Member
1 Posts |
 Posted - 27 May 2001 : 17:40:42
|
Hi all.
I have never set this before, and I can't get it working.
Here is the path to my database:
e:\inetpub\wwwroot\forum\tools\snitz_forum_2000.mdb
What should my path be in my config.asp?
here is what i have:
'strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=e:\inetpub\wwwroot\forum\tools\snitz_forum_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=e:\inetpub\wwwroot\forum\tools\snitz_forum_2000.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
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
should i deleate or modify anything from the above code?
I must be missing something easy!
Thanks,
maca
p.s. i am using access 2000
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 18:22:42
|
You have to uncomment the lines you want to use. In your case it should look like this:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=e:\inetpub\wwwroot\forum\tools\snitz_forum_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=e:\inetpub\wwwroot\forum\tools\snitz_forum_2000.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
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_" |
 |
|
|
miamaca
Starting Member
4 Posts |
|
|
miamaca
Starting Member
4 Posts |
Posted - 27 May 2001 : 18:55:31
|
atually i am using access 2002
can it still work?
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 27 May 2001 : 18:57:54
|
You might need to use the strConnString labeled for Access97 or install the JET drivers on your computer.
http://www.microsoft.com/data
Look for:
Microsoft Jet 4.0 SP3
|
|
|
|
miamaca
Starting Member
4 Posts |
Posted - 27 May 2001 : 19:34:45
|
still does not work!
this is very frustrating
|
|
|
|
miamaca
Starting Member
4 Posts |
Posted - 27 May 2001 : 19:49:39
|
it worked!!!
not i get this:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
/forum/pop_profile.asp, line 904
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 28 May 2001 : 01:00:01
|
Do a search here for "Operation must use an updateable query.". It is a quite a popular error message when installing the forums.
Basically it is a permissions problem.
Also, you can dis-regard my reply to your email since you are already get helped here.
|
|
|
|
Gonzbert
Starting Member
30 Posts |
Posted - 29 May 2001 : 10:52:15
|
Does the database need to be registered in the ODBC-Management?
|
|
|
|
Gonzbert
Starting Member
30 Posts |
Posted - 29 May 2001 : 10:54:40
|
Sorry! I found the mistake myself! It needn't to be registered!
|
|
|
|
Space_Cowboy
Starting Member
34 Posts |
Posted - 09 June 2001 : 17:18:02
|
I'm kind of having the same problem, except my code looks like this:
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=http://spacecowboy.warpstorm.com/fpdb/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=sa;pwd=;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=sa;pwd=;database=DATABASE_NAME" '## MySQL
Every time I try and access the setup.asp thing, I get a 403 forbidden error! I'm doing something wrong, but what?
|
|
|
|
Space_Cowboy
Starting Member
34 Posts |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 09 June 2001 : 18:07:27
|
It sounds like your server doesn't support ASP.
Your webserver is running Apache, which doesn't support ASP. They would have to buy additional software called "Chili!Soft ASP" to support the ASP extention.
Edited by - Davio on 09 June 2001 18:12:44 |
|
|
|
Space_Cowboy
Starting Member
34 Posts |
Posted - 09 June 2001 : 18:15:24
|
Oh brother, can you recommend a FREE site hoster that does support ASP?
|
|
|
|
Space_Cowboy
Starting Member
34 Posts |
Posted - 09 June 2001 : 22:40:05
|
Never mind, I found a sutible host for this. Now I keep getting database errors! The setup thing is located at http://www21.brinkster.com/spacecowboy9999/forum/setup.asp and I have the config file set up like this:
BType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=/fpdb/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=http://www21.brinkster.com/spacecowboy9999/fpdb/snitz_forum_2000.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=sa;pwd=;database=/fpdb/snitz_forums_2000.mdb" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=sa;pwd=;database=DATABASE_NAME" '## MySQL
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 09 June 2001 : 23:56:29
|
Check in the Brinkster help, or search the forum for Brinkster Help, you have to use the Server.MapPath
It will look something like this
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("spacecowboy9999/fpdb/snitz_forums_2000.mdb")
http://www.ugfl.net/forums |
|
|
|
Topic |
|
Topic Locked
