| Author |
 Topic  |
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
123456
New Member
75 Posts |
 Posted - 07 July 2003 : 18:38:46
|
| Allright, will give it a shot...... |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 18:53:05
|
quote:
Originally posted by Nikkol
try downloading the latest zip from http://forum.snitz.com/download.asp, delete everything in your board folder (except the database), and then copy all the files from the zip file (except the database), change the config.asp file to reflect your strDBtype and strConnString and then run setup.asp.
When I put the name of the database in, do I put it in as just the name of the database?
For instance, lets say the database name was FRED.mdb, and it was located in a file named FRED....
Would I just put in FRED.mdb as the database name, or do I have to put something like Fred/Fred.mdb?
|
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 19:04:35
|
Here my brain is fried.....Been up for days it seems like.
Which of these do I use?
Here's my host: http://www.snaphost.com/default.asp
I was reading the Mysql was better so how do I set it up....Seems easy but my brain has about given up.
'strDBType = "sqlserver"
'strDBType = "access"
strDBType = "mysql"
'## Make sure to uncomment one of the strConnString lines and edit it so that it points to where your database is!
'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=" & 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={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("/USERNAME/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=SQLOLEDB;Data Source=SERVER_NAME;database=DB_NAME;uid=UID;pwd=PWD;" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
'strConnString = "driver={SQL Server};server=SERVER_NAME;uid=UID;pwd=PWD;database=DB_NAME" '## MS SQL Server 6.x/7.x/2000 (ODBC connection)
'strConnString = "driver=MySQL;server=IP ADDY;uid=UID;pwd=PWD;database=DB_Name" '## MySQL
'strConnString = "DSN_NAME" '## DSN |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 07 July 2003 : 19:07:25
|
| You said your database from the old site was Access, so use that. As Dave said earlier, you can always upgrade to MySQL later. But if you don't know how to administer a MySql database, I'd stick with Access if I were you. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 19:11:00
|
Okay so use Access out of the top 3 right?
Which should look like this:
strDBType = "access"
Then when do I do for the bottom? |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 07 July 2003 : 19:27:08
|
I prefer the physical path myself. the one with the c:\ in it, but you'll need to know what the physical path is. does your host give you a special folder to put databases?
|
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 19:33:32
|
quote:
Originally posted by Nikkol
I prefer the physical path myself. the one with the c:\ in it, but you'll need to know what the physical path is. does your host give you a special folder to put databases?
No they don't.
I've tried creating a folder for it, transferring it to there.....
Should the DB be in the same folder as the Board?
If so which strConnString do I use? And how do I point it in the right direction. Let's say the database is located in A Folder called FRED, and the file is called FRED.mdb
Then what?
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 07 July 2003 : 19:48:24
|
I can't help right now ... gotta run ... start by reading the readme file. It explains a little about where to put the database and how to determing the path.
I'm sure someone will come around that can help further if you need it; otherwise I'll check back later. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 20:29:01
|
| Still no luck....lol |
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 07 July 2003 : 21:01:06
|
| want me to try to set it up for you? if you do, email me with your ftp login info and the admin username/password for the forum. if not, let me know and i'll see how well i can do stepping you through it. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 21:07:40
|
Email sent.
Thanks
|
|
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
123456
New Member
75 Posts |
Posted - 07 July 2003 : 21:46:23
|
Sent an email back from your email...
haha |
|
|
|
Topic |
|
Topic Locked
