| Author | 
                
                  Topic   | 
                  | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  08:46:58
                        
                        
                      
  | 
                     
                    
                       Version: Latest Web Host: Brinster Server: ??? OS: they use Windows 2000  Database: Access
  It tells you change part of the line can someone tell me what to change?
  Thanks Ronan
 
  | 
                     
                   
                 | 
              
              
                | 
                 crash 
                Advanced Member 
                      
                 
                
                Netherlands 
                2064 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  08:52:48
                        
                        
                      
  | 
                     
                    
                       change a line...
  and i take it you think that we can smell what you mean? we cannot.
  it would help if you post where you read that and in which file that line should be changed (although i think you mean config.asp)
 
 
   Crash's Site | Crash is from  
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 ruirib 
                Snitz Forums Admin 
                      
                 
                
                Portugal 
                26364 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  10:22:18
                        
                      
  | 
                     
                    
                       Read the Installation Guide by clicking the link in my signature below. That should help a bit.
  Also make sure you use the Brinkster files. You can get them here: http://www.ls3k.com/snitz/temp.asp
  ------------------------------------------------- Installation Guide | Do's and Dont's | MODs
  Edited by - ruirib on 11 May 2002  10:24:02 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:01:31
                        
                        
                      
  | 
                     
                    
                       Session.LCID = 1033 '## Do Not Edit Response.Buffer = true
  dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit
  '################################################################################# '## 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("/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=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=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
  strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_" 
  ---------------------------------------- This is what i get when I load in my text editor, can some please tell me what I have to delete?
 
  | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Nathan 
                Help Moderator 
                      
                 
                
                USA 
                7664 Posts  | 
                
                  
                 | 
              
              
                | 
                 Roland 
                Advanced Member 
                      
                 
                
                Netherlands 
                9335 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:08:00
                        
                      
  | 
                     
                    
                       quote:
  Session.LCID = 1033 '## Do Not Edit Response.Buffer = true
  dim strDBType, strConnString, strTablePrefix, strMemberTablePrefix '## Do Not Edit
  '################################################################################# '## 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("/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=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=SERVER_IP;uid=UID;pwd=PWD;database=DB_NAME" '## MySQL
  strTablePrefix = "FORUM_" strMemberTablePrefix = "FORUM_" 
  ----------------------------------------
 
  
  Download the Access 2000 database from http://www.snitz.info and then remove the quotes I showed in red. Then upload your database to the db folder on your brinkster account and change the line in green to fit your information.
 
 
  
  http://www.frutzle.com
  Snitz Exchange | Do's and Dont's | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:08:56
                        
                        
                      
  | 
                     
                    
                       www30.brinkster.com/ufpst is the web address
  PLEASE HELP ME, I DON'T KNOW HOW TO DO IT???  
  "They have two settings stun and kill, it would be best not to confuse them." | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:12:26
                        
                        
                      
  | 
                     
                    
                       Thanks, i'll be back, one more thing, do you know any good ASP hosts that let you use your own FTP???
  What does that file download do??? The one with in the previous messgae byou told me about?
  "They have two settings stun and kill, it would be best not to confuse them."
  Edited by - StarFleet on 11 May 2002  15:15:16 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Roland 
                Advanced Member 
                      
                 
                
                Netherlands 
                9335 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:14:32
                        
                      
  | 
                     
                    
                       quote:
  Thanks, i'll be back, one more thing, do you know any good ASP hosts that let you use your own FTP???
 
  
  Please go to http://www.webbhost.net if you want to get more information about hosts that other people use for Snitz. That site was set up specifically to provide that information to people using Snitz that need a host.
 
  
  http://www.frutzle.com
  Snitz Exchange | Do's and Dont's | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:19:17
                        
                        
                      
  | 
                     
                    
                       Where your asked to change the USERNAME etc, do i put in "ufpst" or do i put i the whole "http://....." etc?
  Is 10mb enough to run this forum?
  "They have two settings stun and kill, it would be best not to confuse them."
  Edited by - StarFleet on 11 May 2002  15:26:02 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 Roland 
                Advanced Member 
                      
                 
                
                Netherlands 
                9335 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:40:20
                        
                      
  | 
                     
                    
                       Well you're supposed to replace USERNAME with your Brinkster username, so you do the math.
  10MB will be enough for starters. Once you get more posts and more members your database will grow and it might get over it's limit. So keep an eye on the database and start looking for a decent host early enough.
 
  
  http://www.frutzle.com
  Snitz Exchange | Do's and Dont's | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 11 May 2002 :  15:44:43
                        
                        
                      
  | 
                     
                    
                       I will hopefully be signing up with a new account soon!
  "They have two settings stun and kill, it would be best not to confuse them." | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 12 May 2002 :  05:23:42
                        
                        
                      
  | 
                     
                    
                       OK, i am now using WEBSAMBA, http://www.websamba.com/ufpst
  What do I have to change now in the CONFIG.asp file? (as above)
  Thanks
  On further inspection, this http://freehost21.websamba.com/ works
  "They have two settings stun and kill, it would be best not to confuse them."
  Edited by - StarFleet on 12 May 2002  05:27:46 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 StarFleet 
                Starting Member 
                 
                 
                
                United Kingdom 
                25 Posts  | 
                
                  
                    
                      
                       Posted - 12 May 2002 :  14:39:00
                        
                        
                      
  | 
                     
                    
                       Can someone please respond to my message??
  "They have two settings stun and kill, it would be best not to confuse them." | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                | 
                 ruirib 
                Snitz Forums Admin 
                      
                 
                
                Portugal 
                26364 Posts  | 
                
                  
                    
                      
                       Posted - 12 May 2002 :  15:34:32
                        
                      
  | 
                     
                    
                       Frutzle already told you what you needed to change in config.asp (and the Installation Guide also tells you what needs to be changed).
  You may want to use whereami.asp to obtain the path to use in the connections string. It can be obtained here:
  http://www.heptite.com/snitzinfo/whereami.zip .Just extract the asp file inside, upload it to your site and execute it to get the path to use in the connection string.
 
  ------------------------------------------------- Installation Guide | Do's and Dont's | MODs
  Edited by - ruirib on 12 May 2002  15:35:08 | 
                     
                    
                        | 
                     
                   
                 | 
              
              
                |   | 
                
                  Topic   | 
                  |