| Author |
 Topic  |
|
|
koskats
Starting Member
3 Posts |
 Posted - 20 June 2001 : 15:08:34
|
I have downloaded the snitz forum pack and have followed the instructions to install in on my server. After the uploading was finished I gave the url on my browser and I got a message "Your database needs to be upgraded. Code: 3704". I followed the link "Click here to upgrade..." and I got a "You need to logon as a forum administrator first" message. I entered as username=Admin and password=admin (as explained in readme.txt). What I got is this:
ADODB.Connection.1 error '80020009'
Empty connection string.
/forum/setup_login.asp, line 58
What do I do now?
PLEASE HELP ME!
|
|
|
Synasenn
Starting Member
6 Posts |
Posted - 20 June 2001 : 15:16:46
|
I have the same problem..
I can't figure out what it is either. My server accepts ASP and I tried several things already
|
 |
|
|
Ribkick
Junior Member
USA
296 Posts |
Posted - 20 June 2001 : 15:31:53
|
Just curious, did you run setup.asp from your forum directory? Might be the problem...hope so.
|
|
|
|
Synasenn
Starting Member
6 Posts |
Posted - 20 June 2001 : 15:41:55
|
I ran the setup from the forum directory as it is on my website yes.
is that wrong?
|
|
|
|
big9erfan
Average Member
540 Posts |
Posted - 20 June 2001 : 16:08:11
|
You guys need to open up your config.asp files ( NOT on the server, but on your local PC so you can edit them )
and look for this
'#################################################################################
'## SELECT YOUR DATABASE TYPE AND CONNECTION TYPE (access, sqlserver or mysql)
'#################################################################################
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 97
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/fpdb/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\scripts\31_sr3_b2.mdb;" '## MS Access 2000
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=SQL_USER;pwd=PASSWORD;database=DATABASE_NAME" '## MS SQL Server 7
'strConnString = "driver=MySQL;server=SERVER_NAME;uid=MYSQL_USER;pwd=PARRWORD;database=DATABASE_NAME" '## MySQL
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\html\users\ugflnet\database\snitz_forums_2000.mdb;"
You need your OWN paths in strConnString, those are just examples.
http://www.ugfl.net/forums |
|
|
|
Synasenn
Starting Member
6 Posts |
Posted - 20 June 2001 : 16:41:50
|
mmh did that, made the source where it should be my online database: /web/forum/db/snitz_forums_2000.mdbAfter logging in as admin I now get this error:
quote:
ADODB.Connection.1 error '80004005'
SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified
/forum/setup_login.asp, line 58
I think I am getting further already
Edited by - Synasenn on 20 June 2001 16:48:31 |
|
|
|
Synasenn
Starting Member
6 Posts |
Posted - 20 June 2001 : 17:43:04
|
Still can't figure out what mistake I am making...
|
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 20 June 2001 : 23:55:42
|
What is your web server operating system? I hear that you can't use an .mdb file on a Chilisoft system unless your host sets up some kind of DSN for you.
======
Doug G
====== |
|
|
|
koskats
Starting Member
3 Posts |
Posted - 21 June 2001 : 01:48:40
|
I've done everything...I also changed the path in the config.asp file, but still no results... I cannot figure out what I'm doing wrong.
P.S. The server is set as well...
|
|
|
|
RichardKinser
Snitz Forums Admin
USA
16655 Posts |
Posted - 21 June 2001 : 01:51:52
|
kosats & Synasenn,
take a look at the above post by big9erfan.
Can y'all post the same lines from your config.asp files so we can see what they look like?
And like Doug mentioned above, if you are on a Unix/Linux server running Chili!Soft ASP then your Access DB cannot reside on the Unix/Linux server, the Access DB can only reside on a windows server. What the web host usually does is setup a DSN that points to a Windows Server, where they place the Access DB.
|
|
|
|
koskats
Starting Member
3 Posts |
Posted - 21 June 2001 : 07:29:44
|
As you can see my knowledge is not that deep. Is there something I can do to fix this problem, or it simply does not work?
Cheers!
|
|
|
| |
Topic |
|
Topic Locked
