| Author |
 Topic  |
|
pcgamer72
Starting Member
12 Posts |
 Posted - 08 September 2007 : 13:42:43
|
Hello everyone. I'm new to Snitz... and to running a website in general. Before I started with this, I had ZERO knowledge of what I was doing, so I've been working on this for a while now on my own, because I wanted to learn. However, I have hit a roadbump that I just cannot figure out. I'm going to try to explain my problem as well as I can but please keep any responses as simple as you can, because I'm not going to know any lingo :P.
I have a Deluxe Hosting package from GoDaddy.com. I have the website itself up and running, but I cannot figure out how to get the database for Snitz to work.
First, I created an SQL database on godaddy. Let's say I named it "X". Well, there's a bullet on their site saying that the username and domain name will be the same for all domains on their site. Well, the domain is created, but I don't know and can't figure out if I need to do anything inside of it before the forums work??
I opened up the config.asp file in Araneae, and I believe that I have changed everything that I need to inside of it. For instance.. I took the "'" out from in front of strDBTtype = "sqlserver".
Then, I took the "'" away from this line:
strConnString = "Provider=SQLOLEDB;Data Source=Y;database=X;uid=X;pwd=password;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
Where, Y= my Server IP address
X= username/domain name as I explained earlier
password= the password I chose
I created a folder on the ftp, and I transferred all of the snitz files (besides the Access one) into a folder named "forum".
I know that the username/password is correct, because I can log into the database itself using them.
When I go to: http://<yourservername>/<forumdirectoryname>/setup.asp
I get this error message:
"The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80004005
Error Description :
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied."
I really have no idea what I'm doing at this point, so if anybody has had any experience with setting up a Snitz forum on godaddy or just knows what I am doing wrong at all, I would GREATLY appreciate it! I'm trying to learn, but it is taking me a little while. :( |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 08 September 2007 : 14:52:26
|
Here is the part from the the database creation screen that I was talking about:
"NOTE: The database name and username will be identical for all newly created databases."
They are talking about the two fields that I had to enter into the config file right? Database name and user name?
Is there anything that you usually have to do in a database before it can be used? Enable anything? Do I have to connect it with the folder for Snitz on the ftp in any way? |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 08 September 2007 : 15:19:55
|
That's weird, you can't have two different Dbs with the same name, unless they are in different servers.
Did you specify a username and password during database creation, of after database creation?
Once the database is created, and a user to access that database is created too, you don't need to do anything else to start using the database. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 08 September 2007 : 15:26:29
|
| Whenever I created the database, it prompted me to enter a Domain name and a password. However, then it told me that the username is the same as the domain name. So, whenever I try to open database "x", a window pops up that asks me to enter a username and password. The username is also "x" though. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 08 September 2007 : 20:51:13
|
| Well, I never removed those apostrophes, so I thought they would be there, but I checked anyways and they are. I'm going to try to contact godaddy I guess now. |
|
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 08 September 2007 : 21:26:43
|
| I don't really know what I'm asking here but... is Snitz an ASP.NET.2.0 application? |
|
|
|
phy1729
Average Member
USA
589 Posts |
Posted - 08 September 2007 : 21:50:16
|
| No just normal ASP. A .NET version is in Beta at snitz.reddiweb.com |
|
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 08 September 2007 : 21:55:07
|
I got it to work! I changed the server address from the ip that my host is on, to the address for the database. Thanks a lot for the advice guys. I searched 10+ forums before I decided to use Snitz. I can't wait to get it running.
One final question though, what are the settings that I need to keep in order to not break copyright and what not? Is it just the "Forum's COpyright"? section? |
Edited by - pcgamer72 on 08 September 2007 22:03:14 |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 09 September 2007 : 11:17:44
|
There is a link in the bottom-right hand corner that needs to stay there (you can change between using an image or just text, whichever works best for your design) and you'll see the relevant parts of the code with comments around them along the lines of "DO NOT EDIT" 
Edit: the forum's copyright box is for you to indicate to whom the forum's content is copyrighted to. |
Edited by - AnonJr on 09 September 2007 11:18:33 |
|
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 10 September 2007 : 14:52:55
|
Once again, thanks to everyone that has helped me so far. I'm already learning a great deal.
I have another question now though.. heh. I'm trying to set up the e-mail function so taht when a new user tries to register, an e-mail is sent to them that forces them to verify the e-mail address before their membership is approved. I'm having trouble getting it to work however.
Would the "E-mail Server Address" be the address that godaddy specifies as the address to sue for SMTP relays? I'm trying to find what I need to put in the box, because when I ran a test, I never received an e-mail from the forum after I tried to register.
Oh, and how do I tell what type of e-mail account it is? I've searched all over the account info page, and I don't see anything referring to CDONTS, Chili!Mail, or CDOSYS.
Thanks! |
Edited by - pcgamer72 on 10 September 2007 15:01:23 |
|
|
|
JJenson
Advanced Member
USA
2121 Posts |
Posted - 10 September 2007 : 15:01:11
|
| Yes you will need to put in the smtp relay for godaddy. usually its something like mail.yourdomain.com. At least that is what it is for me. As well you need to make sure your Allow Emails is turned on in the admin options as well. |
|
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 10 September 2007 : 15:02:43
|
| Dang, you responded right before I edited my post. Could you help me with the last part of my question too? Thanks, I'll try that. |
|
|
|
pcgamer72
Starting Member
12 Posts |
|
|
pcgamer72
Starting Member
12 Posts |
Posted - 11 September 2007 : 13:20:06
|
| I'm a little bit confused. adminATlaminigamingDOTcom is an e-mail address I created on their e-mail servers, but it is not my primary e-mail account there. Does it have to be that one? |
|
|
|
Topic |
|
Topic Locked
