I am installing this on a 2003 server using SQLServer I have set type strDBType="sqlserver" I have set strTablePrefix="CC_" I have set strMembertablePrefix= "CC_" I have set strFilterTablePrefix="CC_"
and my connection string strConnString = "SNITZ" when I run setup I enter my administrative password for the login Full access to everything and put newinformation in for the username and password at the bottom of the setup screen.
I continue to get Cannot create table error messages.
Could someone offer some suggestions on what to try next
It's not the Snitz code that supports DSNs it's ASP itself, we just use it. Probably the issue lies with the way the DSN was setup, though I can't really be sure about that.
Anyway, DSN is something to avoid, IMO, whenever the option to use an OLEDB provider is available.