| Author |
 Topic  |
|
chiefcook
Starting Member
USA
30 Posts |
 Posted - 04 August 2006 : 06:39:16
|
I am new to Snitz and this Forum and am completely stumped at this point. I have tried looking through all of the help forums that looked like they might have an answer (that I could find searching Snitz)for the last three days.
I am running ver. 3.4.05 on Windows 2003 server. I cannot get the setup page to open the database. I get the following error -
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 : 424
The database type is set correctly and so is the path (I used whereami to double check). I have edited config trying all of the Access options. Iusr access is set to read write. I even went so far as to try giving Iusr full access to the entire root of the web drilling down to make sure of inheritance, no go. I managed to get past the ASP enabling option to at least get to the setup page to get this error.
This is on an Intranet so I cannot link.
|
Everything is easier when it is someone else's responsibility |
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 04 August 2006 : 06:43:01
|
| have you got the correct permissions set on the database and it;s directory |
 |
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 04 August 2006 : 06:57:52
|
| Yeah, I even went so far as to give "everyone" full to the entire directory. |
Everything is easier when it is someone else's responsibility |
|
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 07 August 2006 : 06:20:49
|
| Anyone know what Code: 424 is? |
Everything is easier when it is someone else's responsibility |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 07 August 2006 : 07:59:34
|
It also says this:
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.
|
Everything is easier when it is someone else's responsibility |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 07 August 2006 : 09:31:28
|
Seems like that is an object not available error. I really don't know what could cause that...
Do you have desktop access to that Windows server? If you do, try the advice here. Even if it was originally given for SQL Server, you can use it for Access. Just choose the Jet OLEDB provider and pick the path to where the database is localed. Then click the test connection button and let me know if you have success. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 07 August 2006 : 10:34:05
|
So that I am sure I followed instructions properly...
I chose jet 4.0 as my provider (after creating udl file), selected my database name, and tested connection. The test works, but when I enter the string from the udl I get the following error:
Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/forum/config.asp, line 53
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RootDrive\WEB\Forum\NHVH_Forum.mdb;Persist Security Info=False
I don't think I missed any of the instructions/ applying them to access instead of SQL |
Everything is easier when it is someone else's responsibility |
|
|
|
Roger Fredriksson
Average Member
Sweden
556 Posts |
Posted - 07 August 2006 : 11:58:36
|
| A missing " after False could explain a lot ;) |
rf/www.avgifter.com |
|
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 07 August 2006 : 12:08:29
|
Thanks, but I missed copying the end of the string. Sorry, the (") is there. here is the full string:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RootDrive\WEB\Forum\NHVH_Forum.mdb;Persist Security Info=False" '## MS Access 2000 |
Everything is easier when it is someone else's responsibility |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 07 August 2006 : 14:55:53
|
I am new to this forum, so if there is a way I can upload a text file and link it I am unaware of it. I am operating within an Intranet and cannot make files available outside of it by linking to my network (I am a tree in someone else's Forest...). I am willing to upload, FTP, or email a copy of the text file though.
Here is the content of line 53: strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\RootDrive\WEB\Forum\NHVH_Forum.mdb;Persist Security Info=False" '## MS Access 2000
If it helps... I have only modified this line and the Database type. |
Everything is easier when it is someone else's responsibility |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 07 August 2006 : 20:25:51
|
Make sure there is a space between the " and ' after False
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
chiefcook
Starting Member
USA
30 Posts |
Posted - 08 August 2006 : 05:51:18
|
| The space is there, I hope it turns out to be syntax though. I am rechecking my edits again just to be sure... |
Everything is easier when it is someone else's responsibility |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Topic |
|
Topic Locked
