| Author |
 Topic  |
|
|
stevieh
Starting Member
1 Posts |
 Posted - 18 July 2002 : 09:41:39
|
hi
i'm trying to set the forum with sql 2000 server.
when trying to connect to the database i recieve error 80040E4D
what should my connection string look like in config.asp?
please help
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 18 July 2002 : 14:23:22
|
Your current problem surely results from the fact that you're not executing setup.asp as it is required. You should run it like this: setup.asp?RC=5
There was no info about this on readme, you're right. This is just a bug (3.4 is near, so it won't last for long...).
I recommend that you use this connection string:
strConnString = "Provider=SQLOLEDB;Data Source=YOURSERVER;Initial Catalog=DATABASE;User ID=UID;Password=PASSWORD;"
-------------------------------------------------
Installation Guide | Do's and Dont's | MODs |
 |
|
|
braun
Starting Member
2 Posts |
Posted - 24 July 2002 : 06:58:49
|
I have the same problem using version 3.3.05.
After the "The Installation has been completed !" there are no tables created. The user configured in the connection string is the db-owner.
What's wrong??
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 24 July 2002 : 15:49:46
|
You might check that your sql server is running in mixed authentication mode.
======
Doug G
====== |
|
|
|
Yaz
Starting Member
Netherlands
7 Posts |
Posted - 05 August 2002 : 08:55:49
|
I had this same problem (and the 8004005 error) in SQL 2000.
The solution was giving the account you use to install the forum with explicit table creation rights (and many more creation rights).
You can do this by the following method.
Select the database in SQL 2000,rightclick and select "properties".
In the tab "security" (2nd tab) select your install user and mark all boxen that allow creation and modification of the dabase.
Press Ok.
This solved my problemens, I hope it solved yours.
If anyone want a more detailed installation, let me know, i will create one w/ pictures and such.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 05 August 2002 : 10:05:55
|
db_owner rights will be enough don't need to tick all of them :)
www.daoc-halo.com |
|
|
|
lionheart
Starting Member
2 Posts |
Posted - 06 August 2002 : 02:58:57
|
i have already setup the forum with SQL Server 2000, the tables were created but the setup didn't create the tables relationship.
can you give me the solution?? i'm really need a help on this.
|
|
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 06 August 2002 : 04:23:10
|
There are no predefined relationships on a standard install, all of the business logic is based in the code itself.
If you've successfully run setup.asp then you should be good to go.
What errors are you getting Lionheart ?
It would also be better if you created a new thread with the specific problem your having as well so that this one can continue to be used to help the original poster resolve his/her issues.
www.daoc-halo.com
Edited by - Gremlin on 06 August 2002 04:31:08 |
|
|
|
lionheart
Starting Member
2 Posts |
Posted - 07 August 2002 : 03:47:42
|
i'm not getting any errors yet.
i'm just curious, because there are table's relationship in access, so i was thought the setup wasn't work properly.
thx
|
|
|
|
HuwR
Forum Admin
United Kingdom
20595 Posts |
Posted - 07 August 2002 : 04:20:04
|
the relationships in Access are a through back from a much older version, and should really be removed as they have been known to cause a few people problems
|
|
|
|
continuity
Starting Member
1 Posts |
Posted - 09 August 2002 : 01:48:17
|
I'm using SQL 2000 as my datastore and I can see the Installation of forum page and I've tried the suggestion above and below but I'm still getting the 8004005 error.
Thanks in advance for any suggestions.
quote:
Originally posted by Gremlin
db_owner rights will be enough don't need to tick all of them :)
www.daoc-halo.com
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 09 August 2002 : 02:39:48
|
quote:
but I'm still getting the 8004005 error
Which one? There are hundreds of different 80004005 errors that can be generated. |
|
|
|
Eric915
Starting Member
31 Posts |
Posted - 09 August 2002 : 12:43:24
|
I had the same problem and just changing the connect string was not enough. You must also uncomment the strDBType var. the section should look like this after you make the change.
strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
You have to do the above in addtion to setting up your connection string.
|
|
|
| |
Topic |
|
Topic Locked
