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

  New Posts New Posts RSS Feed - error when connecting to SQLServer
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

error when connecting to SQLServer
 Post Reply Post Reply Page  123>
Author
  Topic Search Topic Search  Topic Options Topic Options
Constantine287 View Drop Down
Newbie
Newbie


Joined: 02 August 2006
Location: United States
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Constantine287 Quote  Post ReplyReply Direct Link To This Post Topic: error when connecting to SQLServer
    Posted: 02 August 2006 at 4:14pm
it's the first time I run WWF!

Okie, when i run WWF v8.03 MSAccess2000 in localhost like this:
http://localhost/forum/
the forum work okie,

but when I run WWF v8.03 SQLServer in localhost the same like Access version, got 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

Plz tell me how to fix this error, thank!
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: 02 August 2006 at 5:35pm
MS SQL Server isn't a flat file like Access, so you are not connecting to an a file like you do with Access.

Do you have an SQL Server instance setup with a database created on it?
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Constantine287 View Drop Down
Newbie
Newbie


Joined: 02 August 2006
Location: United States
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Constantine287 Quote  Post ReplyReply Direct Link To This Post Posted: 03 August 2006 at 5:26pm
Yes, I have SQL Server 2000 version Personal and setup it before running the forum.

In database_connection.asp, I found code:

strSQLServerName = "" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "" 'Holds the name of the database 'Initilise the DB

Connection String strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

but how could i get database for the forum?

Anyone can up example database of WWF 8.03?
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: 04 August 2006 at 8:51am
There is no such version as the personal version of SQL 2000 so I don't know if you are referring to MSDE or SQL 2000, both of which are different (the personal version is more likely to mean MSDE)

However, I would recommend that you use SQL 2005 Express instead and install the database is mixed mode.

The following instructions are for SQL 2005 Express only.

Then use SQL Studio Express to connect to and create a database on the SQL Server (you may need to run the SQL Server Surface Area Config Tool to allow remote connections), followed by creating a user for this database with DBO (Datbase Owner) permissions on the database.

Then for the database_connection.asp enter:-

strSQLServerName = "localhost\SQLEXPRESS"

Only enter localhost\SQLEXPRESS if this is the 2005 Express version and localhost if it is running on the local computer, if running on a remote computer enter the IP address followed by \SQLEXPRESS.

You then enter the database name you created and username and password for the other connection details.


Edited by -boRg- - 04 August 2006 at 8:51am
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Constantine287 View Drop Down
Newbie
Newbie


Joined: 02 August 2006
Location: United States
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Constantine287 Quote  Post ReplyReply Direct Link To This Post Posted: 04 August 2006 at 7:00pm
Originally posted by -boRg- -boRg- wrote:

There is no such version as the personal version of SQL 2000


sorry, it's SQL Server 2000 Personal Edition

http://www.microsoft.com/sql/prodinfo/previousversions/system-requirements.mspx

sorry, my confusion.
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: 04 August 2006 at 7:10pm
Never come across the personal edition before, but it looks like from the link it is much the same as the MSDE version.

You should upgrade to the free SQL 2005 Express version as it doesn't have the limitations of the Personal Edition, you can also follow the advice I have given in my last post on installing web wiz forums.

Once you have created a blank database on the SQL Server follwo the install instructions that come with the software to run the SQL Setup file which will create the database for you on the blank SQL Server database.


Edited by -boRg- - 04 August 2006 at 7:14pm
Web Wiz Forums Hosting
ASP.NET Web Hosting
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: 04 August 2006 at 7:15pm
This is the online version of the install instructions for creating the database:-

Installing Web Wiz Forums SQL Server version on your webspace
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
carywinton View Drop Down
Newbie
Newbie
Avatar

Joined: 17 July 2006
Location: United States
Status: Offline
Points: 5 		Post Options Post Options   Thanks (0) Thanks(0)   Quote carywinton Quote  Post ReplyReply Direct Link To This Post Posted: 08 August 2006 at 1:04am
I would have to agree with Constantine287,
It seems we are asking the questions, but no one is providing the complete answer, and "PLEASE!" don't say go look at this document here:
Because it is very incomplete. I submit this is what I, and I believe, Contantine287 need.
First: a total working example of these lines:
strSQLServerName = "" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "" 'Holds the name of the database 'Initilise the DB

Connection String strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
Not just parts of it, all of it. Like so
strSQLServerName = "YourServerName\SQLEXPREESS" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)

strSQLDBUserName = "IUSR_SERVERNAME" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "If your using IUSR_YOURSERVERNAME (then there is no password, leave it blank? put in "null" or what?" 'Holds the password (for SQL Server Authentication)

strSQLDBName = "YOURSERVERNAME\SQLEXPRESS\DATABASES\FORUM" 'Holds the name of the database 'Initilise the DB

Connection String strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
Ok? So does that look correct?
Now what about permissions in the SSMSE (SQL Server Management Studio Express) under our new forum database for IUSR_YOURSERVERNAME, should it be db_datareader and db_datawriter? Anything else needed here?
Now the actual folder on our harddrive for the forum "webwiz\forum" Permissions need to be set on this for "not" to allow inheritable permissions to propagate to this object from parent, so we "uncheck" this box. But wait? no other permissions need to be here? like "system" or "administrators"?
So if this is all correct all that should be left to do is run this file 'msSQL_server_setup.asp'
Then proceed to "upload" the files to your web hosting provider, but in my case I am hosting it on my own network and my own server, which all ready have working and dns resolving web sites, so I know my server is working properly.
Now I should be able to "log in" to the forums administration page, if I did not recieve any errors from the 'msSQL_server_setup.asp' script. But what if I did get an error here? what if it is one of those darned "cannot connect to database" errors, then what? Where do I look for the problem? A log file perhaps? Where would it be? What would it be called?
I am sorry if I have seemed to "rant" on a bit here, but I believe this is the proper form and required information needed to respond on a forum.
Thank you for your time and I hope there will be someone who will assist us further. If you desire to call it "having to hold my hand and spoon feed me, so be it" I just want to get this darn thing done and working.
 
 
Back to Top
 Post Reply Post Reply Page  123>

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.