Web Wiz Forums - Initial setup

Print Page | Close Window

Initial setup

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=23215
Printed Date: 07 April 2026 at 6:11pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Initial setup

Posted By: anthonym
Subject: Initial setup
Date 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.

Replies:

Posted By: MadDog
Date Posted: 30 April 2007 at 2:47am

Check that you entered the correct database connection info and you followed the setup instructions.

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: ecem
Date 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.

Posted By: michael
Date 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.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker

Posted By: ecem
Date Posted: 30 April 2007 at 4:57pm

Hi.

I am sure. I can entered Sql Server 2000 on Enterprice Manager with same info.

Posted By: ecem
Date 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...

Posted By: michael
Date Posted: 30 April 2007 at 10:27pm

the forum will have never worked with the information above. you need to fill in those variables.

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker