database permissions
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=27795
Printed Date: 02 April 2026 at 10:04am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: database permissions
Posted By: 505090
Subject: database permissions
Date Posted: 06 September 2009 at 12:54am
trying to install forum on my site. i clicked on "test database connection" and the installer says it was successful, so I clicked yes and got the following error Error
An Error Occurred Writing the Database Settings FilePlease check that you have Read, Write, and Modify Permissions on the Web Wiz Forums 'Database' Directory. I can access the database using "myLittleAdmin (for SQL Server and MSDE) v.2.7 r.123" but have not been able to locate any setting for permissions I can set permission on all of the files and directories i have uploaded through "web files" there is a folder in there labeled "db" which i changed permissions for. But that did not resolve the issue so I changed it back. Do i need to create a directory or does the installer do it, never used a database before and am getting rather frustrated after several hours. Thanks for your time. |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 07 September 2009 at 1:38pm
|
You need to have Read, Write, and Modify Permissions on the Web Wiz Forums 'Database' Directory. The 'database' folder is one of the folders that is part of Web Wiz Forums inside the 'forum' folder located at forum/database. The database folder contains a couple of files, the database_settings.asp needs to be written to by the instal;ler, which is why you need to have read, write, and modify permissions on the forums database folder. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: 505090
Date Posted: 07 September 2009 at 7:19pm
|
After several calls to my host totaling about 3 hours they quit trying
to convince me that "I couldn't have write permissions", seriously
people what good is a database i can't write to. They then send me a
letter stating that their sql server supports ADODB and not ODBC. I have got a forum running (toast) by using an excel.db in my hosting account, but am worried if the forum grows to a significant size there will be performance and possible corruption issues vs. using a database server to hold the data. I am thinking of changing my hosting solution but seeing as I am new to this I wanted some other thoughts. Now the questions, and please feel free to elaborate. Isn't ADODB a linux language not to be confused with microsoft ie MS SQL? Does anyone know a good forum script in either asp or php that supports a ADODB database? (i can change web servers but not database) What are the practical differences between ODBC and ADODB? Who uses ADODB because I haven't found a single script written for it? Will a excel db cause issues down the road compared to a sql db? Anything else you feel like contributing to this cluster F. |
Posted By: WebWiz-Bruce
Date Posted: 08 September 2009 at 10:32am
I think you are a little confused about technologies and have to say your web host sound useless, either they are completely clueless or giving you completely wrong information.
As you can read ADODB is not a database. When your host says they support ADODB not ODBC they mean that the database driver should be OLEDB and not an ODBC driver. An OLEDB driver is what you normally use with SQL server and this is what web wiz forums used when talking to the SQL Server database. Have a look at our own web hosting packages as you would probably get along much better than using a web host that doesn't seem to know the difference between apples and pears:- http://www.webwiz.net/webhosting/" rel="nofollow - http://www.webwiz.net/webhosting/ All our web hosting packages include Web Wiz Forums installed for you running off a SQL Server database. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: 123Simples
Date Posted: 08 September 2009 at 6:28pm
|
505090 - your host is rubbish bud Read, write permissions are standard terms that any host worth a pinch of salt should know. I suggest you find a better host who understands at least that ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |