Author |
Topic  |
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 18:59:22
|
Really I have no idea what I'm doing.. but maybe someone can help me...
I get this error when I try to setup my forum.
There has been an error !!
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
How Do I create a database?? Or whatever it means. Someone please help me!
|
|
RaiderUK
Average Member
  
United Kingdom
577 Posts |
Posted - 06 July 2001 : 19:51:48
|
a access database is included with the download of the forum, try having another read of the readme and FAQ section for setting up connection to the database.
|
 |
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 21:00:27
|
I've read it 10 million times. And I can't figure it out.
What would I put for my connection thing is my forum was at http://www.cgate.net/evans/forum my .mdb is at http://www.cgate.net/evans/cgi-bin
If when I try to open the .mdb thing and it downloads.. does that mean the server doesn't support it?
|
 |
|
asp_storm
Average Member
  
USA
787 Posts |
Posted - 06 July 2001 : 21:39:35
|
What Host Do You Have?
quote:
I've read it 10 million times. And I can't figure it out.
What would I put for my connection thing is my forum was at http://www.cgate.net/evans/forum my .mdb is at http://www.cgate.net/evans/cgi-bin
If when I try to open the .mdb thing and it downloads.. does that mean the server doesn't support it?
Also, Did You Put the .mdb file in your database directory?, for instance, if your domain was like mine, it would be: D(or your what drive your host sayz):WWWRoot/sitenamecom/database/snitz_forums_2000.mdb. Hope this helpz ____----____----____ Webmaster Of: Newschoolskiing.com

Edited by - asp_newbie on 06 July 2001 21:45:38 |
 |
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 21:43:41
|
I use my ISP.
|
 |
|
HuwR
Forum Admin
    
United Kingdom
20595 Posts |
Posted - 06 July 2001 : 21:49:46
|
try using this
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/cgi-bin/snitz2000.mdb") '## MS Access 2000 using virtual path
|
 |
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 21:59:07
|
Ok.. Now I've tried to move the forum to Brinkster.. and still get the same error.
Someone with Brinkster.. Can you paste your config.asp connection thing in here. So I can get mine working.
Thanks!!
|
 |
|
tomw
Starting Member
USA
20 Posts |
Posted - 06 July 2001 : 22:02:19
|
marsh, if you have removed the "'" in front of the connection string that looks like Huwr's message,(line#54 approx) and updated that string to match Huwr's message in the "config.asp" file,you should be able to input "http://wwwcgate.net/evans/default.asp" and your forum will run.
But I will be brutely honest, if you did not follow what the last three people sent you on setting up this forum including the readme.txt, then you probably should skip Snitz as a project, or get someone else to do it for you. Good Luck
Tom |
 |
|
marsh
Starting Member
7 Posts |
|
asp_storm
Average Member
  
USA
787 Posts |
Posted - 06 July 2001 : 22:29:15
|
quote:
I have read everything and tried everything. Nothing will work. If someone wants to setup the config.asp file and send it to me that would kick. The database is at http://www22.brinkster.com/marshforum/db/snitz2000.mdb .
Ok, Here Is Mine,
quote: '################################################################################# '## 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=D:\wwwroot\mysitecom\database\snitz_forums_2001.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
If you want me to. i could do it for ya if this dosent help -------------------------------- Webmaster Of: ==============

Edited by - asp_newbie on 06 July 2001 22:37:27 |
 |
|
marsh
Starting Member
7 Posts |
Posted - 06 July 2001 : 22:40:46
|
Do you got AOL Instant Messenger? If so, could you PLEASE IM me? My screen name is "ball point pens". THANKS!
|
 |
|
asp_storm
Average Member
  
USA
787 Posts |
Posted - 06 July 2001 : 22:44:51
|
k
/\/\/\/\/\/\/\/\/\/\/\/ Webmaster Of: ==============

Edited by - asp_newbie on 06 July 2001 22:51:41 |
 |
|
|
Topic  |
|