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)
 whats worng?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

aviv
Junior Member

474 Posts
Posted - 27 May 2001 :  06:30:51  Show Profile  Visit aviv's Homepage
what is worng with this code?

'## 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_forums_2000.mdb;" '## MS Access 2000
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\snitz_forums_2000.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=PASSWORD;database=DATABASE_NAME" '## MySQL

strTablePrefix = "FORUM_"
strMemberTablePrefix = "FORUM_"




please?

gor
Retired Admin

Netherlands
5511 Posts
Posted - 27 May 2001 :  07:51:22  Show Profile  Visit gor's Homepage
what is the error you get ?

Pierre
Join the Snitz WebRing
Go to Top of Page

MorningZ
Junior Member

USA
169 Posts
Posted - 27 May 2001 :  11:23:20  Show Profile  Visit MorningZ's Homepage  Send MorningZ an AOL message
first off, looks like you are using the Access 2000 string for the included database ( if i am not mistaken, it is an Access 97 DB )

second, you have this database in the absolute root directory of "c:\" ??? that's a baaaad thing to do.... put it somewhere in the Inetpub dir, not necessarily in the wwwroot dir, and you must set NT permissions to be able to "write" to that directory..

third, if this is running on a local machine that you have access to the whole computer, just set a DSN for the DB in "Control Panel", "Admin tools", "ODBC"

and then use:
strConnString = "DSN=mydatabase"

( using this method allows you to skip all the permission stuff )



Edited by - MorningZ on 27 May 2001 11:24:03
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.32 seconds. Powered By: Snitz Forums 2000 Version 3.4.07