Sorry for being a newbee, I tried a lot but my forum is still not working.
I use a access 97 database on a NT server with a DNS connection named "forums". Just like many others i get the error: [Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.
'## Make sure to uncomment one of the strConnString lines! 'strConnString = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=F:\213.132.192.53\cgi-shl\snitz_forums_2000.mdb" '## MS Access 97 'strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("\cgi-shl\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 strConnString = "dsn=forums"
The database is under the "\cgi-shl\" directory. I looked him up via WHERAMI The address of the website is: http://www.inter-face.be
I didn't make a forum directory yet so everything is under the root. http://www.inter-face.be/default.asp should go to the right page. When i log in i see some things, but i can't reply on messages. admin and Admin are still the user name and password.
the problem is with a setting in IIS. i had that problem once, it is when there are more than 1 record sets on a page, but i cant remember how i fixed it.
I don't exactly know what is was, but it had to do with permission. When i emptied the whole directory and created a new web in frontpage (fpdb directory included) and copied my database into fpdb it worked!!
Topic Locked
Posted - 01 March 2001 : 11:13:41
