| Author |
 Topic  |
|
|
engelman
Starting Member
USA
7 Posts |
 Posted - 04 February 2005 : 17:29:43
|
Hello,
I just installed Snitz Forum 2000 Version 3.4.05.
On invocation of the system's home page, I get the following server error relative to MS SQL:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'FORUM_TOTALS'.
/default.asp, line 89
The abending line is an ADODB recordset open command on the 'FORUM_TOTALS' table. The error above says "Invalid object name", but I verified in MS Enterprise Manager that the table in fact exists.
I am connecting to the database via credentialed ODBC registry entry. As the system made it past the command to open the ADODB connection, it appears I am authorizing to the database without problem.
I am running the system in IIS/ASP on a Windows 2003 server.
I'd be most appreciative if anyone can help.
Thank you.
|
Stewart Engelman |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
engelman
Starting Member
USA
7 Posts |
Posted - 04 February 2005 : 23:49:09
|
Hi,
My forum home page is at http://messageboard.classictoytrader.com/. I can run pure text pages without abend (policy page, FAQ) although CSS isn't applied, but all pages with database output crash with the stated error. |
Stewart Engelman |
 |
|
|
Gremlin
General Help Moderator
New Zealand
7528 Posts |
Posted - 05 February 2005 : 04:04:18
|
| Are the table owners in SQL Server the same logons as you have in your connection string ? |
Kiwihosting.Net - The Forum Hosting Specialists
|
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 05 February 2005 : 09:32:07
|
quote:
Originally posted by Gremlin
Are the table owners in SQL Server the same logons as you have in your connection string ?
I'd say you're right on the money there... If one visits the forum, it's obvious setup.asp needs to be run, and you get the info that the database needs to be installed, which I would say is a clear indicator that there is an issue with table ownership. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
engelman
Starting Member
USA
7 Posts |
Posted - 06 February 2005 : 05:03:25
|
Hello All,
Setup.asp has been run successfully.
Table ownership may in fact be an issue. The NTFS user assigned to my ODBC registry entry is not the same as the admin level user I created for table creation use (although both have read/write access to the tables, the admin account simply has additional priveleges like table create and bulk insert). Is it correct that the admin level NTFS user supplied to setup.asp must also be the user assigned to the ODBC connection?
Thanks! |
Stewart Engelman |
|
|
|
engelman
Starting Member
USA
7 Posts |
Posted - 06 February 2005 : 16:47:38
|
Hello Again,
I switched my ODBC connection to utilize the admin account instead of the user level account, and updated config.asp accordingly. Now everything works! Table ownership was in fact the problem (Snitz must be connecting in a manner requiring priveleges not granted to the lower level NTFS account).
Thanks very much for the good suggestions. |
Stewart Engelman |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 06 February 2005 : 17:31:17
|
I wouldn't advise the use of an ODBC connection. You should use the SQLOLEDB connection since it is faster and more robust. The user specified in the database connection string only needs dbdatawriter role. As long as it has that role for the database to be used, table ownership can be dealt with simply by including the databaseowner in the snitz prefix:
strTablePrefix = "dbo.FORUM_"
strMemberTablePrefix = "dbo.FORUM_"
Above you have an example of a possibility to deal with the issue of table ownership while referring to database tables. In the example, I admit that dbo is the table's owner.
Of course, your forum is working and can keep what you have now. I would recommend changing to an OLEDB connection, though. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 20 April 2005 : 05:22:31
|
Hello,
I had HUGE delays in accessing the pages of my SNITZ forums. I must say that the server environment is very complex with several levels of firewalls.
I dropped OLEDB and switched to ODBC. Now it's great, fast!
So, depending on your configuration, it may be faster to use ODBC |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 20 April 2005 : 07:53:19
|
| I find it very odd, unless your OLEDB drivers are not updated. Using ODBC always means there are more layers of code than using OLEDB. With SQL Server the JETOLEDB provider is optimised for SQL Server and there are no faster drivers than that. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Machina
New Member
Switzerland
74 Posts |
Posted - 20 April 2005 : 10:50:19
|
Yes that's what I thought, but in my case it's better 
I looked all the code, the MODS I implemented and the modifications I made but didn't find a mistake in the implementation I did. It is still little slow with ODBC but quite usable now :-) |
Machina
-------
http://www.jaboulay.fr
--------
Snitz based site:
http://www.itu.int/YLinICTs
MODS Used : TMPJ's Header Cell Image, Site Integration, Front Page News, News Events Calendar, Nikkol's Usergroups, Simple Slash, Avatar, File Sharing, Links |
|
|
| |
Topic |
|
Topic Locked
