I've made the following changes in config.asp (after finding an editor for it!)
strDBType = "access"
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("WhoKnowsWhat\snitz_forums_2000.mdb") '## MS Access 2000 using virtual path
strConnString = "Provider=SQLOLEDB;Data Source=localhost;database=WhoKnowsWhat\snitz_forums_2000.mdb;uid=WhoKnowsWhat;pwd=;???????" '## MS SQL Server 6.x/7.x/2000 (OLEDB connection)
where ????? is my password for whoknowswhat, but I did not want to post it to a forum.
Whereami.asp says strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\1a\whoknowswhat\snitz_forums_2000.mdb" '## MS Access 2000
(I've used the default database, with the default name in the same area as the other files as there will be no data here I mind being viewed)
I've tried various combinations of c:\1a\whoknowswhat\snitz_forums_2000.mdb and a.1asphost.com/whoknowswhat and I've tried the virtual string and the direct string.
and yes, I have read countless FQA's etc ~ Can someone save my monitor from having my keyboard thrown through it by telling me what I am doing wrong?
you only use one of the strConnString values. If you are using an Access database, use the first one you showed. The second one is only for a MS SQL database.
Topic Locked
Posted - 11 July 2003 : 07:47:24
