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

  New Posts New Posts RSS Feed - I need help setting up SQL on GoDaddy
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

I need help setting up SQL on GoDaddy
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53 		Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post Topic: I need help setting up SQL on GoDaddy
    Posted: 06 January 2006 at 5:57pm
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.
 
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: DBNAME
 
Host Name: mysql85.secureserver.net
 
User Name Same as DBNAME
 
Password mypassword
 
 
This is what I put in into the sql_server_connection.asp
 
 
'Enter the details of your SQL server below
strSQLServerName = "mysql85.secureserver.net" 'Holds the name of the SQL Server
strSQLDBUserName = "DBNAME" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "mypassword" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "DBNAME"   '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 & ";"
 
 
When I try to run the sql_server_connection.asp file, it first asks for a user name and password, I enter the same user name and password that allow me access to the Database through godaddy and then I get the following error:
 
 
 
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.
 
 

Any help is appreciated. Unhappy

 
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: 06 January 2006 at 6:05pm
Tgis may sound like a stupid question, but the parts where it says 'DBName' and 'myPassword' in the SQL_server_connection.asp' file you are actualy entering the your SQL server username, password, and database name?

Check with your host as to the correct database name as DBName just looks like a generic name, and not a unique database name.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53 		Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2006 at 6:12pm

These are not the actual names, this is what I put down here to keep it confidential, I really think that I am doing this right. Can you please take a closer look?

 

Thanks,

 
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: 06 January 2006 at 6:27pm
I see the problem now, looking at the database name it says 'mysql85'

I guessing then that this is a mySQL database?

mySQL and SQL Server are completly different databases, mySQL being a free database system and SQL Server being a Micrsoft database system costing 1000's of dollars.

Web Wiz Forums 7.x only supports Access and SQL Server, if you want mySQL support you will need to wait for version 8 release on Web Wiz Forums.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53 		Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2006 at 7:28pm
When would that be released?
Back to Top
justme View Drop Down
Groupie
Groupie


Joined: 06 January 2006
Status: Offline
Points: 53 		Post Options Post Options   Thanks (0) Thanks(0)   Quote justme Quote  Post ReplyReply Direct Link To This Post Posted: 06 January 2006 at 7:42pm
I see it, it says:
 
Estimated time till version 8 beta 1 - Next week before Friday 13th January 2006
 
Thanks for your help,
 
 
Back to Top
onslaught26 View Drop Down
Newbie
Newbie


Joined: 06 April 2006
Status: Offline
Points: 2 		Post Options Post Options   Thanks (0) Thanks(0)   Quote onslaught26 Quote  Post ReplyReply Direct Link To This Post Posted: 06 April 2006 at 6:08pm
so i have same problem,
what can i write here mysql85.secureserver.net
i also use mySQL, but i dont know what is 85?
how can i learn it is 24 or 85? whatever else? please some one help me :)
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: 07 April 2006 at 12:08pm
You are posting in the version 7 forum and version 7 of web wiz forums doesn't support mySQL.

Make sure you are using the version 8 RC1.1 mySQL version (not SQL Server which is a different thing)

Also check that GoDaddy are using mySQL 4.1 or above.

The 85 part you mention is just the name given to the server and doesn't effect anything.
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.