| Author |
 Topic  |
|
|
houseofstrauss
Starting Member
15 Posts |
 Posted - 16 August 2002 : 07:33:44
|
Windows XP home, 66k modem, current version snitz, Dougs download mods, Brinkster free account.
I followed the beginners guide using 'find.asp' which returned <<<your path is:
\\genfs2\www20\houseofstrauss\snitz_forums_2000.mdb>>>. All files are now uploaded. Run.asp returned the following error<<<Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/houseofstrauss/forum/config.asp, line 55
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\genfs2\www20\houseofstrauss\snitz_forums_2000.mdb
-------------------------------------------------------------------------------------------------------------------
I also received a runtime error. I have uploaded the ms database file in the default directory but created a new directory called 'forum' for all other files. I believe this is all per instructions. Your help is much appreciated as I am not skilled in asp code
Thanks Richard
|
wether you think you can, or wether you think you cant... you are right! |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 16 August 2002 : 07:38:56
|
You are a missing a quote at the end of that line:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\genfs2\www20\houseofstrauss\snitz_forums_2000.mdb"
Also rename your database for a hard to guess name, or even snitz_forums_2000.asp and change the name accordingly in that strConnstring line, so that no one can download your database.
Make sure you're using the Brinkster files. You can find them at Snitz Exchange (link below). |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 16 August 2002 : 07:40:40
|
There are already some connection strings for use with brinkster in the config.asp file, you only have to replace the test "USERNAME" with your brinkster user name  I dont have an example at the moment.
Also go to the snitz exchange and download the special brinkster files, they are needed for the forum to work on brinkster servers, the snitz exchange is the "mods" link in my signature. |
|
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 16 August 2002 : 08:46:06
|
Thanks for replies Ruirib & Hamlin. I added the quote ammended file and tried again, This time with a new fault as below <<<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 : 80004005
This is how my code looks at present could you please advise how to proceed
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/houseofstrauss/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\genfs2\www20\houseofstrauss\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
Thanks Richard |
wether you think you can, or wether you think you cant... you are right! |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 16 August 2002 : 09:30:33
|
Originally posted by houseofstrauss
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/houseofstrauss/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\genfs2\www20\houseofstrauss\snitz_forums_2000.mdb" '## MS Access 2000
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 97 on Brinkster
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
'strConnString = "DSN_NAME" '## DSN
strTablePrefix = "FORUM_"
If your on brinkster then add the red ' and remove the ' from the line i have made green...that should do it, assuming the database is in the db folder provided by Brinkster |
Edited by - Hamlin on 16 August 2002 09:31:11 |
|
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 16 August 2002 : 14:48:02
|
Thanks Hamlin for the help above. I got the congratulations screen this time, but when I clicked to go to my forum I had an internal 500 error page.(several attempts) I trust this is a server update problem or something. If it spells another problem ahead perhaps you can advise
Thanks again, Richard |
wether you think you can, or wether you think you cant... you are right! |
|
|
|
Hamlin
Advanced Member
United Kingdom
2386 Posts |
Posted - 16 August 2002 : 14:53:28
|
Can we have a link to your forum?
If you have IE try this: Tools > Internet Options > Advanced > un-tick "Show friendly HTTP error messages"
You should get a better error description  |
|
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 16 August 2002 : 18:11:45
|
Here is the link to my forum.
http://www20.brinkster.com/houseofstrauss/forum/default.asp
I accessed the error from ie as follows <<<<Microsoft JET Database Engine error '80040e37'
The Microsoft Jet database engine cannot find the input table or query 'MEMBERS'. Make sure it exists and that its name is spelled correctly.
/houseofstrauss/forum/inc_functions.asp, line 905
>>>> Does this mean some files are missing, corrupted or what? Do you recognise the problem?
Thank-you Richard |
wether you think you can, or wether you think you cant... you are right! |
|
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 16 August 2002 : 18:23:42
|
| addition to last post... inc_functions.asp is present in the files list- I checked. |
wether you think you can, or wether you think you cant... you are right! |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 16 August 2002 : 18:32:26
|
In config.asp, what do you have for strTablePrefix and strMemberTablePrefix? It should be:
strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"
|
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 16 August 2002 : 19:06:48
|
Thanks, Nikkol, You were right on with spotting an error. strTablePrefix = "FORUM" was missing. I ammended the file and sent it to the server. Alas, a new error message <<<504 Gateway Timeout
This Web page could not be opened. There may be too many people accessing this page or the page may be unavailable. Please try again later. >>> From the outset I have not edited any files except the connection strings. I have also replaced original snitz files with the moded ones. Still hoping to see my page soon ...
Thanks Richard |
wether you think you can, or wether you think you cant... you are right! |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
houseofstrauss
Starting Member
15 Posts |
Posted - 17 August 2002 : 04:46:11
|
Nikkol, I opened default page myself this morning, nothing else worked. Ok... I'm going to recheck and upload all files again except database and config.asp. I suspect using file manager on Brinkster may have missed out some files. Leave it with me for a day or 2. I will try and sort it out. Thanks for your support guys.
Richard |
wether you think you can, or wether you think you cant... you are right! |
|
|
| |
Topic |
|
Topic Locked
