New Installation problem
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=24287
Printed Date: 06 April 2026 at 5:24pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: New Installation problem
Posted By: charades
Subject: New Installation problem
Date Posted: 29 August 2007 at 3:53pm
|
I have followed everything step by step according to this url http://www.webwiz.net/webwizforums/kb/sql_server_install.asp - http://www.webwiz.net/webwizforums/kb/sql_server_install.asp
Upto 9 steps everything was smooth.
From 10th step which is
 I got this error. I sincerely appreciate your help in this matter.
Server Error in Forum Application
An error has occurred 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 Please direct me on where I could have went wrong.
My Username, password DB name etc are all checked and they are all in sync
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 29 August 2007 at 4:13pm
|
The error suggests something is incorrect in your database_connection.asp file. Make sure that you have entered the details correctly of your SQL Server and there are not any mistaken characters such as quote marks within 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: charades
Date Posted: 29 August 2007 at 4:59pm
|
I appreciate if you can let me know what exactly I need to fill in database_connection.asp if this is the current connection string.
Provider=sqloledb;Data Source=abcd.1234.com,1433;Initial Catalog=abcdefghijk;User Id=ABCDEFGHIJKL;Password=*****;
This is what is currently in database_connection.asp
strSQLServerName = "abcd.1234.com" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "ABCDEFGHIJKL" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "********" 'Holds the password (for SQL Server Authentication) strSQLDBName = "abcdefghijk" |
Posted By: WebWiz-Bruce
Date Posted: 29 August 2007 at 5:26pm
|
You don't need to edit the connect string itself, just enter your database details in the place indicated. strSQLServerName = "abcd.1234.com" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server) strSQLDBUserName = "ABCDEFGHIJKL" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "********" 'Holds the password (for SQL Server Authentication) strSQLDBName = "abcdefghijk" No other part of the file needs to be edited. ------------- 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: charades
Date Posted: 29 August 2007 at 5:30pm
That's exactly what I did .... and I also verified the extra quotes etc which u mentioned
|
-boRg- wrote:Posted By: WebWiz-Bruce
Date Posted: 29 August 2007 at 5:43pm
|
Check with your web host you have the setting correct.
------------- 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: charades
Date Posted: 29 August 2007 at 5:47pm
| Will do Sir thanks for the help |