2 days later and still no workie - SQL
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=16554
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: 2 days later and still no workie - SQL
Posted By: tasforsale
Subject: 2 days later and still no workie - SQL
Date Posted: 14 September 2005 at 8:07pm
|
I've got the SQL version and am really struggling getting this thing set up on godaddy.com
I've created my MS SQL database with them and gotten my username and password for the database and put it in the SQL_server_connection.asp
And I can never seem to get it to log me in to get this dang forum up and running :(...do i have to go back into the common.asp files and rename the database to the same on that godaddy assigned to me when i set up the databases? Or am i doing something else wrong...
~Confused in Charlotte ------------- Loster than the people on Lost |
Replies:
Posted By: WebWiz-Bruce
Date Posted: 15 September 2005 at 4:20am
|
To use the MS SQL Server version make sure you have downloaded the MS
SQL Server version and then follow the install instructions that come
with it. So that the forum connects to the SQL Server database the only file you need to edit is the SQL_server_connection.asp file found in the admin area entering your sql server database details. Also check that your SQL Server database is setup properly and you can log into it (Godady should be able to hlp you further with this part). Also if you are still having problems if you could let us know the exact error message it should help further track down your exact problem. ------------- 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: tasforsale
Date Posted: 15 September 2005 at 12:34pm
|
thanks borg
I'll try it all over again...and just wipe the slate clean and start all over...question...
is it easier to install it with mySQL or MS SQL because i have the option of using either... ------------- Loster than the people on Lost |
Posted By: tasforsale
Date Posted: 15 September 2005 at 1:39pm
|
Here is what my server is telling me, if any of this info is sensitive
and can be used by hackers...please edit it out for me...but i withheld
the username/password...i can log in through "open manager" option in
my databases using this username/password to see the "tree" for my
databases - so that works...but here is the information the server is
giving me and i'm pluggin it into sql_server_connection.asp:
Database Name: DB_17542
Type: MS SQL
Status: Active
Host Name: <edit>
Size: 0mb
strSQLServerName = "whsql-v03" 'Holds the name of the SQL Server
strSQLDBUserName = "username(same as godaddy to enter database tree)" 'Holds the user name (for SQL Server Authentication) strSQLDBPassword = "password(same as godaddy to enter database tree)" 'Holds the password (for SQL Server Authentication) strSQLDBName = "DB_17542" 'Holds name of a database on the server 'Please note the forum has been optimised for the SQL OLE DB Driver using another driver 'or system DSN to connect to the SQL Server database will course errors in the forum and 'drastically reduce the performance of the forum! 'The SQLOLEDB driver offers the highest performance at this time for connecting to SQL Server databases from within ASP. 'MS SQL Server OLE Driver (If you change this string make sure you also change it in the msSQL_server_setup.asp file when creating the database) strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";" ------------- Loster than the people on Lost |
Posted By: dj air
Date Posted: 15 September 2005 at 1:54pm
|
you can not run this on a MySQL the above is almost there the strSQLServerName, should be (i think) what was in the part that i edited that is the server server name/server |
Posted By: tasforsale
Date Posted: 15 September 2005 at 2:31pm
I'll give it a shot and let you know dj...thanks...keep your fingers crossed! ------------- Loster than the people on Lost |
Posted By: tasforsale
Date Posted: 15 September 2005 at 2:47pm
|
it works!!!!!!!
I deleted the SQL_server_connection.asp file from the site now for protection as described...so it should be pretty secure now correct? Anything else i should look out for?
Thanks so much! I almost gave up but now...
 ------------- Loster than the people on Lost |
Posted By: dj air
Date Posted: 15 September 2005 at 6:15pm
|
you should be ok as long as you : dont have an easy password to guess and you keep up to date, with the updates |
Posted By: arhunter
Date Posted: 16 September 2005 at 12:11am
|
I have a similar problem...after my database was set up and I try to go to my forum I get the following message.
Microsoft OLE DB Provider for SQL Server error '80040e4d' Login failed for user 'admin'. /forum/common.asp, line 260 I can login to the database and all the tables are there. |
Posted By: dj air
Date Posted: 16 September 2005 at 9:16am
|
the username and password specified within the SQL connection file
found in the admin folder, is the ones used to access the SQL server
not the Forum. please make sure these are correct as it sounds this is the issue |
Posted By: arhunter
Date Posted: 16 September 2005 at 10:44am
|
I am sure that the user name and password are the ones for the data base....they are the same ones I use to access the data base through Enterprise Manager. |
Posted By: clownfire
Date Posted: 24 December 2005 at 9:45am
|
Anyone have any ideas on importing my access db to sql on godaddy? They don't use enterprise mangler. |
Posted By: safetynut
Date Posted: 28 December 2005 at 9:34pm
Cn you provide me with the details that corrected this issue. I'm having a similar issue with the same ISP and I believe your fix may be what I am needing. I'm assuming it was a correction to the string for accessing the actual server.
|
dj air wrote:Posted By: dj air
Date Posted: 29 December 2005 at 4:04pm
|
the host name should be a IP Address or a host name/ domain style.
what i edited is on page one, and was the strServername.
|