Can't seem to get set up
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=20820
Printed Date: 08 April 2026 at 10:03am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Can't seem to get set up
Posted By: Martimus
Subject: Can't seem to get set up
Date Posted: 26 July 2006 at 4:38am
|
Hello- I looked for an answer to what I am facing but am still a bit confused...I am a realtive hack, but am trying to set up the forum on a new website I am building, sremal.com. I uploaded the files easily, and added the info to the database_connection.asp page, but every time I try to go thru the set-up page, I get blocked with an error stating there is a problem with the form, specifically "Username - Enter a Username with tbale creation rights on the database." I have created only 2 users so far for this database, and both with rights to edit, but neither seems to work. I did add both (one at a time) to the database_connection.asp page. Any ideas? ------------- Clutter is the illusion of activity. |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 9:26am
|
You haven't mentioned what database version you are trying to use? Also, is this on your own server, or that of your web host? ------------- 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: Martimus
Date Posted: 26 July 2006 at 12:37pm
|
I have V8.3, and I am hosting on my webspace (external host) at: http://m6.net ------------- Clutter is the illusion of activity. |
Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 12:46pm
|
You still have not said which database version you are using, Access, SQL Server, or mySQL? ------------- 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: Martimus
Date Posted: 26 July 2006 at 12:50pm
|
Sorry--SQL Server. ------------- Clutter is the illusion of activity. |
Posted By: WebWiz-Bruce
Date Posted: 26 July 2006 at 12:55pm
|
Contact the SQL Server admin to get the correct settings from them, they may also need to set a user with DBO rights for you to be able to create the database on the SQL Server
------------- 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: Martimus
Date Posted: 26 July 2006 at 11:31pm
|
I will do that--I actually contacted them before you, but you actually take your support requests as initiatives...I still have not heard back from them. Thanks for the prompt attention, I hope I can get it rectified, but feel good knowing I can come back if bad things continue. I appreciate you. ------------- Clutter is the illusion of activity. |
Posted By: dj air
Date Posted: 27 July 2006 at 1:00am
|
all they have to do is give you IP/Domain alias to the server : Server address Username password some hosts give seperate logins for editing and connecting/reading from the database. sort of a edit database user and a Website username with editing disabled, i can see a good side ie, more secure but then, if someoine wants to get in they will. |
Posted By: Martimus
Date Posted: 27 July 2006 at 2:20am
------------- Clutter is the illusion of activity. |
Posted By: WebWiz-Bruce
Date Posted: 27 July 2006 at 9:13am
|
This all depends on how your web host has their SQL server login setup for you. The only people who can tell you this info is your web host. I often find phoning web hosts gets you a faster response than trying to email them. ------------- 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: Martimus
Date Posted: 28 July 2006 at 10:38pm
|
It was a problem on their end, which once fixed, was no longer an issue--it set up immediately. However, when I tried to get in then, I got this error:
Server Error in Forum Application
An error has occured while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid connection string attribute Thoughts? ------------- Clutter is the illusion of activity. |
Posted By: dj air
Date Posted: 28 July 2006 at 11:16pm
|
means your connectiopn settings arent correct. checlk the settings, or some hosts will also checlk the file that holds the connection and alter for you. |
Posted By: Martimus
Date Posted: 29 July 2006 at 4:51am
|
Got it--and the forum was great in seconds. Will have great fun looking at this--appreciate your fast reponses (I received multiple posts here within hours to my web hosts single email that took days), and your advice to get me moving. It must be very well put together if I can't break it, because I do have the touch. :) ------------- Clutter is the illusion of activity. |
Posted By: Music God
Date Posted: 03 January 2007 at 6:18am
How do I check the connection settings? Which file do I need to modify? |
dj air wrote:Posted By: Music God
Date Posted: 03 January 2007 at 8:13am
Ok in the database_conection.asp folder I've typed in my info: strSQLServerName = "x.x.x.x.x" strSQLDBUserName = "Name_Name" strSQLDBPassword = "xxxxx" strSQLDBName = "Name_Name" I was told set up was complete so I went to the url/forum and I get this message Server Error in Forum Application An error has occured while connecting to the database. Please contact the forum administrator. Support Error Code:- err_SQLServer_db_connection File Name:- common.asp Error details:- Microsoft OLE DB Provider for SQL Server Invalid connection string attribute all of my information is correct and my server is running MySQL 4.1 I see no reason why this shouldn't be working does anyone know? |