Author |
Topic  |
|
jackstraw
Starting Member
USA
19 Posts |
Posted - 29 February 2004 : 19:46:34
|
ok, I know little about programming if anything. Having said that I am in the middle of something I need to finish...You will soon see what..
I will be changing the look of the page but I have been kinda busy..
Here is my dilemma...I needed to mod my barebones forum to do a bunch of stuff...since I lost the programmer I figured I would start over with the modded forum....Here is what I did...
I cut and paste the connection string from the one that was working into the one that I got in the new zip file. I then uploaded that into the www.root/forums folder on my site. That seems fine...
I seem to be having a problem with iis so I dont really know how to "run" the dbs. I dont remember exactly what I did when I started it in the first place because I started it and then passed it to the programmer.
so..along with changing the connection stuff and pointing it correctly ect..I simply uploaded the new dbs's to the same place where the other one was, renaming the snitz forum db, the name of mine so it could find it......
that is where I am currently,,,,,,It is sorta working, I am like a little kid sitting here trying to figure this out, it cant be that hard its just language??
if someone could give me some insight into the error I am receieving and likely how to run dbs from the site? I cant get into anything just yet....
forum can be found here www.thegraphicdesignresource.com
thanks much Nigel lew |
Edited by - ruirib on 29 February 2004 19:57:38 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
jackstraw
Starting Member
USA
19 Posts |
Posted - 29 February 2004 : 22:40:57
|
can someone please steer me to the language install instuctions I dont see them anywhere?
thanks Nigel |
 |
|
jackstraw
Starting Member
USA
19 Posts |
Posted - 01 March 2004 : 02:20:53
|
ok well I guess I am having a data base issue or I put something in the wrong place??? I dont know I made a little headway but I might be backing up
www.thegraphicdesignresource.com |
 |
|
OneWayMule
Dev. Team Member & Support Moderator
    
Austria
4969 Posts |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
|
jackstraw
Starting Member
USA
19 Posts |
Posted - 01 March 2004 : 07:49:54
|
man I have been up all night I need to sleep....I started over with a fresh install...worked great on iis. so I uploaded but I seem to have two of some stuff and yeah my connection string isnt right?
'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("database/forums/tgdr04.mdb") '## MS Access 2000 using virtual path 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("tgdrforum") '## 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=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL w/ MyODBC v2.50 'strConnString = "driver={MySQL ODBC 3.51 Driver};option=4;server=SERVER_IP;user=UID;password=PWD;DATABASE=DB_NAME;" '##MySQL w/ MyODBC v3.51 'strConnString = "DSN_NAME=" & ("tgdrforum") '## DSN
strTablePrefix = "FORUM_"
I think all I need to do is get that right but my www folder on the server is sort of a mess, web folder looks like this database, logs, ecomm, www.....in the www folder is forums folder, the three new dbs are both in forums folder and database folder.... |
 |
|
jackstraw
Starting Member
USA
19 Posts |
Posted - 01 March 2004 : 15:57:41
|
ok well it didnt kill me....lol
I have the forum working perfectly on iis...., I have removed everything except my actual webpage from the server so I just need to move the **** thing...How should I build my directory on the server so the thing will work. Here is my current connection string.
'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("/forum/db/snitz_forums_2000.mdb") '## MS Access 2000 on Brinkster 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\websites\setup\db\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=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL |
 |
|
ruirib
Snitz Forums Admin
    
Portugal
26364 Posts |
Posted - 01 March 2004 : 17:39:46
|
Create a folder at the same level of your www folder. Name it DB, for example. Then place the mdb file there. The connection string should then be:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("../db/snitz_forums_2000.mdb")
You need to use Windows Explorer to give read/write permissions on this DB folder and on the database itself to the IUSR_.... user. If you're not running the server talk to your host for him to do it. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
 |
|
|
Topic  |
|