Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Current Version (Old)
 Help please...		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

calhoun
Starting Member

16 Posts
Posted - 14 June 2001 :  13:45:33  Show Profile  Visit calhoun's Homepage
/web
/myusrname
/cgi-bin
*I have the access database here
/fourms
*the stuff that was extracted and then uploaded
myusrname is not the attuall text, its really my user name that goes int there but I cant be bothered typing the gibberishly designed usr name out. But, If you want an idea of it,
kwalnegwipegaj
and the password is similar
I am trying to get the fourms to work on my webpage (www.jsa3d.co.uk) I also have mySQL but that failed to work.
so,
'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("/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
What do I put in this?

Ribkick
Junior Member

USA
296 Posts
Posted - 14 June 2001 :  13:51:15  Show Profile
create a folder called database, have your host set it up read/write. move your access database there and remove the ' mark in front of the database type and either one of the jet access 2000 drivers. edit that driver with the correct path to your database folder, then run setup.asp from your forum. that should be it.

Should look like this:

strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=drive letter:/web/yoursitename/database/snitz_forums_2000.mdb;" '## MS Access 2000

If you're installing on your existing web page, make sure your host supports ASP code



Edited by - ribkick on 14 June 2001 13:57:44

Edited by - ribkick on 14 June 2001 14:00:37
Go to Top of Page

big9erfan
Average Member

540 Posts
Posted - 14 June 2001 :  13:53:53  Show Profile
Try using this


'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("/cgi-bin/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



If you want to use MySQL you have to create and empty database first and give the connection string above the database name, and proper name and password for login. Then make sure and remove the ' infront of 'strDBType = "mysql"

That's ONLY if you're using mySQL though. If you're just using the access db that came with the download, try using the code above.



http://www.ugfl.net/forums
Go to Top of Page

calhoun
Starting Member

16 Posts
Posted - 14 June 2001 :  18:04:04  Show Profile  Visit calhoun's Homepage
That did not work. I get this:
ADODB.Connection.1 error '80004005'

SQLState: IM002
Native Error Code: 0
[INTERSOLV][ODBC lib] Data source name not found and no default driver specified


/fourms/setup_login.asp, line 58


Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts
Posted - 15 June 2001 :  16:35:09  Show Profile
See if this topic will help you:
link.asp?TOPIC_ID=10227
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.3 seconds. Powered By: Snitz Forums 2000 Version 3.4.07