Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Site Related Forums
 Site Related Discussions
 Error subscribing to topic

Author  Topic 

SamC
White Water Yakist

3467 Posts

Posted - 2003-06-17 : 07:26:09
Microsoft OLE DB Provider for SQL Server error '80040e2f'

Cannot insert the value NULL into column 'SUBSCRIPTION_ID', table 'sqlteam.dbo.FORUM_SUBSCRIPTIONS'; column does not allow nulls. INSERT fails.

/Forums/pop_subscription.asp, line 153


Sam

X002548
Not Just a Number

15586 Posts

Posted - 2003-06-17 : 09:16:58
OK, and what is this then?

quote:

Microsoft OLE DB Provider for SQL Server error '80004005'

[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

/forums/inc_subscription.asp, line 67



Received this when trying to reply to a post....



Brett

8-)
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2003-06-17 : 09:18:23
And at it's height...Rome began to crumble....

What's going on guys?



Brett

8-)
Go to Top of Page

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2003-06-17 : 11:26:50
I don't think these two are related. Although I'm not sure why that isn't working. That's about the simplest INSERT statement on the site. And the SQL looks ok to me.

Performance seems to be up and down today. Earlier it was bad, but it seems ok now. Unfortunately when I'm at work I'm kind of limited in my ability to troubleshoot. I'll look at the subscription problem tonight.

===============================================
Creating tomorrow's legacy systems today.
One crisis at a time.
Go to Top of Page
   

- Advertisement -