Web Wiz Support and Community Forums : I need help setting up SQL on GoDaddy

Web Wiz Support and Community Forums : I need help setting up SQL on GoDaddy https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sun, 12 Apr 2026 14:25:54 +0000 Fri, 07 Apr 2006 12:08:43 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17770 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[I need help setting up SQL on GoDaddy : You are posting in the version...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post103564.html#103564 Author: WebWiz-Bruce
Subject: 17770
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.
]]> Fri, 07 Apr 2006 12:08:43 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post103564.html#103564 <![CDATA[I need help setting up SQL on GoDaddy : so i have same problem, what can...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post103515.html#103515 Author: onslaught26
Subject: 17770
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 :)
]]> Thu, 06 Apr 2006 18:08:36 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post103515.html#103515 <![CDATA[I need help setting up SQL on GoDaddy : I see it, it says: Estimated...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96495.html#96495 Author: justme
Subject: 17770
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,

]]> Fri, 06 Jan 2006 19:42:53 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96495.html#96495 <![CDATA[I need help setting up SQL on GoDaddy : When would that be released? ...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96494.html#96494 Author: justme
Subject: 17770
Posted: 06 January 2006 at 7:28pm

When would that be released?

]]> Fri, 06 Jan 2006 19:28:56 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96494.html#96494 <![CDATA[I need help setting up SQL on GoDaddy : I see the problem now, looking...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96491.html#96491 Author: WebWiz-Bruce
Subject: 17770
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 afree database system and SQL Server being a Micrsoft database systemcosting 1000's of dollars.

Web Wiz Forums 7.x only supports Access and SQL Server, if you wantmySQL support you will need to wait for version 8 release on Web WizForums.
]]> Fri, 06 Jan 2006 18:27:57 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96491.html#96491 <![CDATA[I need help setting up SQL on GoDaddy : These are not the actual names,...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96489.html#96489 Author: justme
Subject: 17770
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,

]]> Fri, 06 Jan 2006 18:12:27 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96489.html#96489 <![CDATA[I need help setting up SQL on GoDaddy : Tgis may sound like a stupid question,...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96487.html#96487 Author: WebWiz-Bruce
Subject: 17770
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 youare actualy entering the your SQL server username, password, anddatabase 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.
]]> Fri, 06 Jan 2006 18:05:11 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96487.html#96487 <![CDATA[I need help setting up SQL on GoDaddy : I've got the SQL version...]]> https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96486.html#96486 Author: justme
Subject: 17770
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.

]]> Fri, 06 Jan 2006 17:57:49 +0000 https://forums.webwiz.net/i-need-help-setting-up-sql-on-godaddy_topic17770_post96486.html#96486