| Author |
 Topic  |
|
|
Journeyman
Starting Member
9 Posts |
 Posted - 20 July 2001 : 17:06:08
|
Bear with me I am still rather new to this. Basically I was following the instructions and I got stuck.
I think I need to create a database but I am not sure exactly how. or where to put it.
I am hosted on a WIN 2000 machine with SQL 7 support
This is the error I received when attempting to access the setup.asp file.
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 : -2147467259
Also I have 2 different directories on my server (private)(htdocs) obviously the htdocs is where the actual site is stored. Should I store the database in the private directory??
Any help is greatly appreciated
Edited by - Journeyman on 20 July 2001 17:22:44 |
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 20 July 2001 : 17:50:08
|
quote:
Bear with me I am still rather new to this. Basically I was following the instructions and I got stuck.
I think I need to create a database but I am not sure exactly how. or where to put it.
I am hosted on a WIN 2000 machine with SQL 7 support
This is the error I received when attempting to access the setup.asp file.
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 : -2147467259
Any help is greatly appreciated
Once you have downloaded the forum, unzip it.
Open up the folder, you should see a file called tools.asp. Unzip the file.
In that folder (tools) you should see a file called "snitz_forums_2000.mdb"
Now in your case, your server supports SQL 7 and not access 2000(the database we just stated)
If you have SQL 7 (on your computer), you can import access 2000 into it. Otherwise you will have to find a nice person at this forum who can send an SQL Snitz Forum Database to you.
Once you have your database sorted out, open up config.asp, You need to edit some stuff here.
----------------------------------------
Find this bit of code on line 48,49,50
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
You need to change that to
strDBType = "sqlserver"
'strDBType = "access"
'strDBType = "mysql"
------------------------
Now below all that you should see the following
--------------------------------------------------
'## Make sure to uncomment one of the strConnString lines!
strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Intetpub\wwwroot\snitz\tools\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\dbroot\forum.snitz.com\snitz_forum.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
------------------
You need to change all that to
(Just copy the below code and replace)
--------------------------------
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Intetpub\wwwroot\snitz\tools\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\dbroot\forum.snitz.com\snitz_forum.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
---------------------
Now the lines above in bold is very important. This specifys the path to the Database, username and password. You need to ring your host and find out what is the path to your site. eg they might say its "c:\inetpub\site"
Here is link to tell you how to fill in the code in bold above
http://www.planet-source-code.com/vb/scripts/ShowCode.asp?lngWId=4&txtCodeId=6442
Once you have that stuff filled in, upload the files to the cgi-bin, and if your paths are right, your forum will work at full pace.
Hope this helps, if you have any more questions, just post :)
Regards,
Spoon, (ya all love me right?) |
 |
|
|
Journeyman
Starting Member
9 Posts |
Posted - 20 July 2001 : 17:54:04
|
Thank you very much for the indepth answer. I will start working on this now and will post my results.
Thanks again.
Also I just checked the site for my server and it seems I can use either access or SQL
quote:
ODBC Database support
Your website can use any ODBC compliant database such as Microsoft Access or Microsoft Excel. ODBC data sources can be installed instantly on your control panel.
New Microsoft SQL Server 7.0 Databases*
You can create MSSQL Server databases on your account and have full control of them via the Microsoft Enterprise Manager or ODBC.
Edited by - Journeyman on 20 July 2001 17:58:09 |
|
|
|
Spoon
Average Member
Ireland
507 Posts |
Posted - 20 July 2001 : 18:06:29
|
Well if you can use access, use access, :)
In that case do this, find lines 48,49,50 again and make sure they look like this
'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
Then below again, make sure they look like this
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\Intetpub\wwwroot\snitz\tools\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\dbroot\forum.snitz.com\snitz_forum.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
-------------------------------
Fill in the variables and off you go posting messages, ask if you need more help
Regards,
Spoon, (ya all love me right?) |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 20 July 2001 : 22:27:08
|
quote:
If you have SQL 7 (on your computer), you can import access 2000 into it. Otherwise you will have to find a nice person at this forum who can send an SQL Snitz Forum Database to you.
Don't do that. After you create a blank SQL dtabase, run the setup.asp file and it will install the necessary database fields for you.
If you have an option between Access and SQL databases, you should with SQL. Or you can start out with Access database, and as your database gets bigger and your forum has a lot of members and posts, you can switch to SQL. But you can save doing all that by justing going with SQL. As SQL is much better performance wise.
- David |
|
|
|
Journeyman
Starting Member
9 Posts |
Posted - 23 July 2001 : 11:13:32
|
Thanks for all the help guys. I got the forum up and working. It is using access right now. However, I am also going to play with SQL and see if I can get it set up that way. Thanks again.
|
|
|
| |
Topic |
|
Topic Locked
