Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - database permissions
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

database permissions
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
505090 View Drop Down
Newbie
Newbie


Joined: 06 September 2009
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 505090 Quote  Post ReplyReply Direct Link To This Post Topic: database permissions
    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 Error An Error Occurred Writing the Database Settings File

Please 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
505090 View Drop Down
Newbie
Newbie


Joined: 06 September 2009
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 505090 Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.

Quote
ADODB ActiveX Data Objects are a language-neutral object model that expose data raised by an underlying OLE DB Provider. The most commonly used OLE DB Provider is the OLE DB Provider for ODBC Drivers, which exposes ODBC Data sources to ADO.


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/

All our web hosting packages include Web Wiz Forums installed for you running off a SQL Server database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
123Simples View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 July 2007
Location: United Kingdom
Status: Offline
Points: 1192 		Post Options Post Options   Thanks (0) Thanks(0)   Quote 123Simples Quote  Post ReplyReply Direct Link To This Post 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
Visit 123 Simples Web Design
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.