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

  New Posts New Posts RSS Feed - Initial setup
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Initial setup
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
anthonym View Drop Down
Newbie
Newbie


Joined: 29 April 2007
Location: England
Status: Offline
Points: 1 		Post Options Post Options   Thanks (0) Thanks(0)   Quote anthonym Quote  Post ReplyReply Direct Link To This Post Topic: Initial setup
    Posted: 29 April 2007 at 11:43pm
I have managed to create an SQL database as required. I then run default.asp and get the following error 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

Can enyone help.
 
The forunm runs on a windows 2003 server with SQL 2005 server.
 
Thanks.
 
 
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 2:47am
Check that you entered the correct database connection info and you followed the setup instructions.
Back to Top
ecem View Drop Down
Newbie
Newbie


Joined: 30 April 2007
Location: United Kingdom
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ecem Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 4:36pm
Hi.
 
I received same error message. When I checked database_connection.asp, SQL Server parameters is true.
 
I connected the SQL Server in EnterPrice Manager. Really no problem.
 
I couldn't why I received this message.
 
Thanks.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 4:48pm
Like Maddog said, make sure you entered the right connection information. If you are unsure paste it here (hide the password) and we can help. It IS wrong info you entered into the SQL connection file.
Blog | MPG Tracker
Back to Top
ecem View Drop Down
Newbie
Newbie


Joined: 30 April 2007
Location: United Kingdom
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ecem Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 4:57pm
Hi.
 
I am sure. I can entered Sql Server 2000 on Enterprice Manager with same info.
Back to Top
ecem View Drop Down
Newbie
Newbie


Joined: 30 April 2007
Location: United Kingdom
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ecem Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 5:03pm
Database_connection.asp
 


strSQLServerName = "XX.XX.XX.XX" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
 strSQLDBUserName = "username info" 'Holds the user name (for SQL Server Authentication)
 strSQLDBPassword = "password info" 'Holds the password (for SQL Server Authentication)
 strSQLDBName = "database name info"  'Holds the name of the database


 
 
 'Initilise the DB Connection String
 strCon = "Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"
End If
 
But The Forum worked an hour. Then I received this error message.
 
What do you think about this message?
 
Thanks...
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 30 April 2007 at 10:27pm
the forum will have never worked with the information above. you need to fill in those variables.
Blog | MPG Tracker
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.