I must be stupid, GoDaddy and WebWiz
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=16296
Printed Date: 13 April 2026 at 9:53pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: I must be stupid, GoDaddy and WebWiz
Posted By: pogowolf
Subject: I must be stupid, GoDaddy and WebWiz
Date Posted: 22 August 2005 at 6:58pm
|
I'm trying to run the 'msSQL_server_setup.asp' file to set up the database, and keep getting the 'Unable to connect to the server' error. I assume that I've got something incorrect in the settings from the 'SQL_Server_Connection' page. Can anyone advise, how to find out the 'servername' with a GoDaddy account?
or do I just need to switch out the connection string to a DSN connection and not a DSN-less connection?
TIA!
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 23 August 2005 at 7:20am
|
Has godday given you an SQL Server Database? If they have they will be able to give you the details on how to connect to your MS SQL Server database. The forum is written to use a DSN-less connection with SQL Server, the DSN method will not work. ------------- 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: pogowolf
Date Posted: 23 August 2005 at 10:22am
| Thanks, I was able to figure it out. The server name didn't work the first time, so I thought I was doing something wrong.. but figured it out. =) Thanks!! |
Posted By: IRC_Sandman
Date Posted: 30 August 2005 at 2:50pm
|
I'm on godaddy aswell pogowolf, and use the MS SQL webwiz forums. If ya need help with setting it up or anything lemme know, coz i need help aswell on something lol. First off , i'm new to databases and asp etc, and i managed to setup the forums on godaddys MS SQL but I'm totally lost as to how to backup the entire forum in case something goes wrong and i lose data, and if needed, how do i restore it ? I mean if i used the Access webwiz forums, i'd just copy the db from the folder and paste it into a folder on my pc, but how do i backup with sql ?
thanks in advance :)
------------- |
Posted By: pogowolf
Date Posted: 30 August 2005 at 6:15pm
Try this...
1) Log into GoDaddy
2) Go to 'My Hosting Plan'
3) Click on 'Databases'
4) CLick on "Manager'
5) CLick on 'Generate Insert Scripts'
6) Select the table to Export.
This will create an SQL script that can be used to insert the data
back into another Database (like stored locally for back up)
and that looks to be the only way..
I HATE GoDaddy and there BS Database control. =) |
IRC_Sandman wrote:Posted By: IRC_Sandman
Date Posted: 30 August 2005 at 10:00pm
|
Thanks for that, i hadn't used the insert scripts thing b4. One problem tho, i'm dumb when it comes to databases as i'm only new to it lol... so once i've generated an insert script for a table, what do i do ? i've copied one and saved it into a .txt file for now. Any idea on how to import data back into the SQL so that it restores to a previous state? what i mean is to test things, i've deleted a couple of words from the world filter inside my forum admin ,then after that i've generated the insert script for that table within the sql manager. I've also exported the same table as CSV. But i get errors or no lines replaced when i try to import that CSV file back in.
Yeah i've had no problem with godaddy until now,and that's only coz their database help and manager is crap.
I dunno what i'm gonna do should i lose data from the forums.
i'm lost.
thanks in advance anyone ------------- |
Posted By: clownfire
Date Posted: 24 December 2005 at 9:44am
|
Hey sports fans,
Does anyone know to migrate my access forum into sql on godaddy, they don't use the enterprise mangler and i'm kinda new to this.
|
Posted By: WebWiz-Bruce
Date Posted: 24 December 2005 at 2:11pm
|
With the DTS import tools in SQL Enterprise Manager, there probally isn't away to do this. Most host should allow remote connections to the SQL Server inorder to use SQL's Enterprises Manager. ------------- 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: clownfire
Date Posted: 24 December 2005 at 4:10pm
|
Any idea how one makes a remote connection? |
Posted By: WebWiz-Bruce
Date Posted: 27 December 2005 at 1:42pm
|
To make a remote connection you need to web name or IP address of the SQL Server.
------------- 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 |