| Author |
 Topic Search  Topic Options
|
GolfResv 
Newbie
Joined: 07 December 2003
Location: United States
Status: Offline
Points: 4
|
 Post Options
 Thanks(0)
 Quote  Reply
 Topic: Problems with locktypes
Posted: 07 December 2003 at 4:02pm |
First of all, Hi, I'm impressed ;)
I needed something like this as quick solution for our site [GRH] and this suites me pretty well.
I created the sql database and imported the data from the mdb. I ran into some little problems which I've fixed (mainly NULLs written to a RS) I've now encounterd a new one.
ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/forum/post_message.asp, line 603
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.1.4322)
|
I tried all different kinds of locktypes, none worked. Maybe the problem is something else; is it normal that I have so many problems installing it on an IIS6/MSSQL2k? (Web Wiz Forums version 7.6)
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 9:19am |
|
Sounds like a problem with ADO on the server
|
|
|
|
GolfResv
Newbie
Joined: 07 December 2003
Location: United States
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 2:12pm |
thx for the reply, didn't help much tho.
I deleted the tables and procedures, created new ones using the sql script. Imported the data from the mdb and then I logged into the admin panel.
After login, I decided to add a new category (forum cat), this error occured:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'Cat_order', table 'GolfResv.dbo.tblCategory'; column does not allow nulls. INSERT fails.
/forum/admin/category_details.asp, line 88 |
Am I doing something wrong when importing or what is happening? Why can't I get it to work?
-boRg-, can you give me a link to the previous version so I can try that? Or simply tell me if I'm doing something wrong :(
|
|
GolfResv
Newbie
Joined: 07 December 2003
Location: United States
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 2:17pm |
set the default value of cat_order to 0 and allowing nulls now, fixed that one.
when adding a forum, I get this:
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'No_of_posts', table 'GolfResv.dbo.tblForum'; column does not allow nulls. INSERT fails.
/forum/admin/forum_details.asp, line 194 |
Am I suppose to fix the forum code 1-by-1 or what's the deal here? Please someone advise me and tell me what's going on, I'm on a deadline here and would really like to implement your forum but I'll have to move on if I can't get this resolved.
PS: I'm on an NT5/MSSQL environment now.
Edited by GolfResv
|
|
Phat
Senior Member
Joined: 23 February 2003
Status: Offline
Points: 386
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 5:54pm |
|
It's your update to the sql server not the forum code.
Can you make a new sql database and not import from access?
Or at least try making a new sql database to make sure it is working correclty on your server.
|
|
GolfResv
Newbie
Joined: 07 December 2003
Location: United States
Status: Offline
Points: 4
|
Post Options
Thanks(0)
Quote Reply
Posted: 08 December 2003 at 6:10pm |
Phat wrote:
It's your update to the sql server not the forum code.
Can you make a new sql database and not import from access?
Or at least try making a new sql database to make sure it is working correclty on your server. |
I figured it's not the forum code, that's why I stopped debugging it.
I'm going to recreate the database using the provided script and I will NOT import the Access database this time. Just one question: How do I go about the default admin account? That was the reason why I imported the data of the access database to the sql structure created by the .sql script.
|
|
Paul Lush
Mod Builder Group
Joined: 24 September 2003
Status: Offline
Points: 59
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2003 at 3:40am |
|
Dont import from Access, export from it. In the tools menu, find "Upsizing Wizard" and make sure "table relationships" is NOT ticked. Try that, it fixes 90% of problems in SQL when youve imported from Access (mainly .addnew or .update when SELECT-ed with JOIN-s)
|
|
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 09 December 2003 at 3:55am |
|
The SQL setup file also creates default values and admin accounts etc on the SQL server.
|
|
|
|
