I use Brinkster, for those who want to know. Let's assume that my URL is http://www14.brinkster.com/mysite I have Snitz in my /db directory. I used the find.asp file (it's in the same directory) and this is what it says:
quote: This file currently resides on this server at: \\genfs1\www14\rlp2183\db\
If you are uploading the database to this directory and have not changed the database name(snitz_forums_2000.mdb) your path is: \\genfs1\www14\rlp2183\db\snitz_forums_2000.mdb
Can anyone tell me what my full connection string should be? And also, how do I know what type of database I'm using? I'm thinking that I am using MS Access but how do I determine it?
"In the palace of the virgin Lies the chalice of the soul And it's likely you might find the answer there"
I changed the string but setup.asp still doesn't work. Here is what my actual config.asp file looks like:
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=" & Server.MapPath("snitz_forums_2000.mdb") '## MS Access 97 using virtual path strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("\rlp2183\db\snitz_forums_2000.mdb") '## MS Access 97 on Brinkster '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("/tools/snitz_forums_2000.mdb") '## MS Access 2000 using virtual path 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("/USERNAME/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\dbroot\snitz_forums_2000.mdb" '## MS Access 2000 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 7 'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 2000 'strConnString = "driver=MySQL;server=localhost;uid=heptite;pwd=justtesting;database=heptite" '## MySQL 'strConnString = "DSN=mysqldsn" '## MySQL
Make sure you rename the database to something that no one can guess (kinda like a password.) You'll not only need to rename the actual database file, but update the strConnString in the config.asp file as well.
Also, you need to change the Admin password to something other than admin. Best way to do this is to logout first(if you have already logged in), then click on the Profile link at the top right hand side of the page. Enter Admin/admin and then on the Edit Profile page, you can update the e-mail address and change the password.
The next important thing to do is to visit this forum:
Topic Locked
Posted - 10 May 2002 : 18:24:27
