Free users community to help together with jetstat products
You are not logged in.
Can I use FAQ Manager with MS SQL? I upsized the database to SQL and changed the connection string but I am getting error messages. What else - besides the connection string - do I need to alter? Thanks.
Offline
It's not supported but Yes you can.
All problems is in the correct upsize of database structure.
Offline
Wouldn't I need to change the info below?
<%'Configuration Data(cd) for JetStat ASP Script. Copyright(c)Eugene Semerenko,2006.http://jetstat.com
const cdVer="v1.10"'Version
const cDataSource ="/jsfaq/fpdb/jsFaq.mdb"
const cDataSource2 ="/jsfaq/fpdb/jsFaq2.mdb"'Don't Change Filename
const cdDBUserBackPath="/jsfaq/fpdb/jsbackup/jsFaq.mdb"
const cdLogFilePath ="/jsfaq/fpdb/jsFaq.log"
const cdErrLog ="/jsfaq/fpdb/jsErrLog.log"'Error log file
const cdLogMode=1'0=using text file to log,1-Use DB
'MS SQL Server:THIS VALUES GIVEN ONLY FOR UPSIZE COMPATIBILITY
const dbMSSQL=False'DONT CHANGE THIS
const dbSqlServer="127.0.0.1,1433"
const dbInitCat="jsfaq"
const dbUserName="jsfaq"
const dbPassword="jsfaq"
'End of MS SQL Server constants
%>
Last edited by rowant01 (2007-02-13 15:16:08)
Offline
rowant01 wrote:
'MS SQL Server:THIS VALUES GIVEN ONLY FOR UPSIZE COMPATIBILITY
const dbMSSQL=False'DONT CHANGE THIS
const dbSqlServer="127.0.0.1,1433"
const dbInitCat="jsfaq"
const dbUserName="jsfaq"
const dbPassword="jsfaq"
'End of MS SQL Server constants
Part of the coniguration file from above should be set up with correct values.
const dbMSSQL=True
const dbSqlServer="127.0.0.1,1433" '<-actual address should be here
const dbInitCat="jsfaq" ' <-this and below is depends on how you've upsized your db.
const dbUserName="jsfaq"
const dbPassword="jsfaq"
Offline