I likewise am having some difficulty writing to a database. However, I am using a Microsoft tutorial that came from their website. Here is the link.
http://msdn.microsoft.com/library/de...sptutorial.asp
I have followed its steps, and when I try to view it and test it on my localhost (which is running PWS and IIS 5.0), I get this error on my page "Microsoft VBScript compilation error '800a0409'
Unterminated string constant
/tutorial/guestbook.asp, line 21
strProvider = "Driver={Microsoft Access Driver (*.mdb)};
My root folder is c:/Inetpub/Wwroot/tutorial as they have suggested. However I noticed that my DSN was located in my
C:\Program Files\Common Files\ODBC\Data Sources
could that be the problem?
thanks,