Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - 2 days later and still no workie - SQL
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

2 days later and still no workie - SQL
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
tasforsale View Drop Down
Newbie
Newbie


Joined: 14 September 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tasforsale Quote  Post ReplyReply Direct Link To This Post Topic: 2 days later and still no workie - SQL
    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
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: 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
tasforsale View Drop Down
Newbie
Newbie


Joined: 14 September 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tasforsale Quote  Post ReplyReply Direct Link To This Post 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...
Back to Top
tasforsale View Drop Down
Newbie
Newbie


Joined: 14 September 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tasforsale Quote  Post ReplyReply Direct Link To This Post 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
Server name : whsql-v03
Server version : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
Language : us_english
Now....i have not created my own database or modified anything other than the SQL_server_connection.asp page and then reloaded it up to my ftp, i simply used the one they assigned to me (DB_17542)...and put in the four things it required in between the green quotation marks...saved it...ran the page sql_server_connection.asp file on ie..and it said done...then tried to run the mssql_server_setup.asp file and got the following...
 
 
Error Connecting to database on SQL Server

Check the following is set up and correct:-

SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server

Check also that you have entered the correct details in the file 'SQL_server_connection.asp' found in the admin directory.
 
Here is specifically what i put in the sql_server_connection.asp page..
 
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 & ";"


Edited by dj air - 15 September 2005 at 1:52pm
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
tasforsale View Drop Down
Newbie
Newbie


Joined: 14 September 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tasforsale Quote  Post ReplyReply Direct Link To This Post Posted: 15 September 2005 at 2:31pm
I'll give it a shot and let you know dj...thanks...keep your fingers crossed!Dead
Back to Top
tasforsale View Drop Down
Newbie
Newbie


Joined: 14 September 2005
Status: Offline
Points: 7 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tasforsale Quote  Post ReplyReply Direct Link To This Post 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...
 
Back to Top
dj air View Drop Down
Senior Member
Senior Member
Avatar

Joined: 05 April 2002
Location: United Kingdom
Status: Offline
Points: 3627 		Post Options Post Options   Thanks (0) Thanks(0)   Quote dj air Quote  Post ReplyReply Direct Link To This Post 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
Back to Top
 Post Reply Post Reply Page  12>

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.