| Author |
 Topic  |
|
|
darkmercenary44
Starting Member
USA
11 Posts |
 Posted - 12 May 2001 : 22:36:34
|
ok, here is what my config.asp looks like:'strDBType = "sqlserver"
strDBType = "access"
'strDBType = "mysql"
strConnString = "DRIVER=Microsoft Access Driver(*.mdb);DBQ=" & Server.MapPath("/vbdeveloper/database/snitz_forums_2000.mdb")
'## Make sure to uncomment one of the strConnString lines!
'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/vbdeveloper/database/snitz_forums_2000.mdb")
'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
:The page at domaindlx says I need a DNS-less connection to db, this is what they wrote:
How do I setup a DSN-less connection to my database?
Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "DRIVER=Microsoft Access Driver
(*.mdb);DBQ=" &
Server.MapPath("/USERNAME/database/yourdatabase.mdb")
------------------------------------------------------------
Here is what my directory looks like
/
-- [dir]database
- snitz_forums_2000.mdb
-- [dir]forum
-- [dir]scripts
-- [dir]tools
- all files in tools.zip except mdb
-- all files in original zip, except for tools.zip
I did have all the base files in the forums dir and the tools dir in the forums dir, but I couldn't get it to work this way, I then put them here and got the setup error that my database location was wrong, but its right. I'm new to ASP I have no clue what is going on. Also I've got Visual Studio 6.0 and when I double click on config.asp it opens Microsoft InterDev, thats how I edit the file, does that make a difference???
I generate4d the error again here it is:
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
Somebody help please.
Edited by - darkmercenary44 on 12 May 2001 23:58:50 |
|
|
darkmercenary44
Starting Member
USA
11 Posts |
Posted - 13 May 2001 : 00:19:50
|
Nevermind I got it to work, and I'm glad I did cause this is awesome, congrats to the DevTeam..
|
 |
|
|
Martha2Mary
Junior Member
New Zealand
250 Posts |
Posted - 13 May 2001 : 00:26:21
|
Well, I'm not sure if this will help you or not, but as someone who did get their Forum working on domaindlx, I thought I might be of some help.
Firstly, domaindlx state that your asp files need to be in your 'scripts' directory, so you should put your forum files into that directory. I actually renamed the 'scripts' directory to 'forum', so that the directory could have a more appropriate name, but with the correct permissions. Your Snitz Database obviously needs to be in the 'database' directory, which you already seem to have. I did not use the same string to point to the database in config.asp as you did. What I did was to upload the file whereami.asp that you can download from here at Snitz (http://forum.snitz.com/archive/redirect.asp?linkid=17) , upload that file to your 'database' directory, then point your browser to it. You should then be advised what the actual path to that directory is. After doing that, this is how my config.asp for domaindlx is configured now (uncommented lines in red):
'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("/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\home\wtowforums\database\snitz_forums_2000.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=PASSWORD;database=DATABASE_NAME" '## MySQL
I hope that this is of some help to you!
*If Knowledge is Power, and Power Corrupts, what hope is there for Mankind  * |
|
|
|
darkmercenary44
Starting Member
USA
11 Posts |
Posted - 13 May 2001 : 01:25:16
|
Thanks for the info, appreciate it, any idea on how to get the star rankings to show even if you have the ranking settings to STARS ONLY???
|
|
|
| |
Topic |
|
|
|
Topic Locked
