Hi, I think I almost got it working now, but if you go to my login page:
http://www.jonescomputersolutions.com/forum/login_user.asp
You get this error (or at least I do)
Microsoft OLE DB Provider for SQL Server error '80040e09'
EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'spikeas_sqldb', owner 'dbo'.
/forum/common.asp, line 264
Line 263: 'Query the database
Line 264: rsCommon.Open strSQL, adoCon
Why does it say owner 'dbo' and why in the common.asp file is this line uncommented:
strCon = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & strDbPathAndName 'This one is for Access 2000/2002
I don't understand because I downloaded the SQL version.
Can someone tell me why I'm getting that error? Thanks!