| Author |
 Topic Search  Topic Options
|
pogowolf 
Newbie
Joined: 22 August 2005
Location: United States
Status: Offline
Points: 3
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: I must be stupid, GoDaddy and WebWiz
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!
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
pogowolf
Newbie
Joined: 22 August 2005
Location: United States
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
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!!
|
|
IRC_Sandman
Newbie
Joined: 18 August 2005
Location: Australia
Status: Offline
Points: 2
|
Post Options
Thanks(0)
Quote Reply
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 :)
|
|
pogowolf
Newbie
Joined: 22 August 2005
Location: United States
Status: Offline
Points: 3
|
Post Options
Thanks(0)
Quote Reply
Posted: 30 August 2005 at 6:15pm |
 IRC_Sandman wrote:
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 :)
|
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
Newbie
Joined: 18 August 2005
Location: Australia
Status: Offline
Points: 2
|
Post Options
Thanks(0)
Quote Reply
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
|
|
clownfire
Newbie
Joined: 25 July 2005
Status: Offline
Points: 16
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
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.
|
|
|
|
