| Author |
 Topic  |
|
|
Digger
Starting Member
USA
22 Posts |
 Posted - 19 August 2002 : 18:51:34
|
When I try to post anything this is what I get....any ideas?
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'REPLY_ID', table 'sportfishingflorida.sportfishingflorida.FORUM_REPLY'; column does not allow nulls. INSERT fails.
/forums3/post_info.asp, line 908
|
Edited by - ruirib on 19 August 2002 18:58:51 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Digger
Starting Member
USA
22 Posts |
Posted - 19 August 2002 : 19:19:03
|
Sorry for originally posting this on the wrong board....
My host converted the db for me, he created a .bak file then did a dump file (greek to me), then went into the code and changed the connection string (from DNs'less to a DNs string) everthing on the boards looks great and posts will pull up, but we cannot add any new posts. |
 |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 19:24:26
|
Yep, I suspected that.
First, what version are we talking about? 3.3.05? 3.4?
To correct this, regardless of the version number, the process is to create the SQL Server tables again either by running setup.asp?RC=5 (for 3.3.05) or by deleting the existing tables and creating them again, using setup.asp (for 3.4).
After having done this, your host can use DTS to import the data from Access. He should be careful, though, to make sure that the transform column for each table is set so that existing table data is deleted and "enable identity insert" is checked.
This is the only way to convert a Snitz Access DB to SQL Server. Any other way will give you problems (as you have found out), because the SQL Server tables will be created with an incorrect structure. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Digger
Starting Member
USA
22 Posts |
Posted - 19 August 2002 : 20:18:22
|
| I am running 3.3.05 now, if I upgraded to 3.4 then run the setup.asp would it reconfigure the SQL db correctly? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 20:25:46
|
No it wouldn't since it won't change the existing tables, for fields that already exist in the database.
You can, however, talk to your host to have 3.4 setup as a new version in a blank DB, and then have him import the data, using DTS, from your 3.3.05 DB. Everything should be ok after doing that. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
Edited by - ruirib on 19 August 2002 20:41:53 |
|
|
|
Digger
Starting Member
USA
22 Posts |
Posted - 19 August 2002 : 20:43:11
|
| If we get the 3.4 db, and have it converted would we need to upgrade our code, or would our current code (Crash's 3.3.15) run with the new 3.4 db like it is? |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 19 August 2002 : 20:50:30
|
You're running Crash's code? Man, you should have posted at his forum for help, though most of what I said still applies.
Your forum won't run on Snitz normal DB. Crash's version requireds a lot more tables and fields than the ones existing at the Snitz database.
Wait for Crash's 3.4 release and upgrade when it comes out. To solve your problem you'll need to do what is recommended at Crash's site:
1. Create the tables for a blank Snitz 3.3.05 database by running setup.asp?RC=5.
2. Run the dbs_3303std-to3315crash.asp file from Mod setup, Admin Options, to convert the database to Crash's db structure.
3. Use DTS, with the settings I explained before, to import the data from the Access DB.
You should have told me from the start that you're using Crash's version. You make me lose time giving you solutions that won't apply to your forum. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Digger
Starting Member
USA
22 Posts |
Posted - 19 August 2002 : 20:55:51
|
Sorry Ruirib...I should have told you this ahead of time.....of course I thought Crash's code ran on .05 so I thought it was the same thing except for added features.
You guys do a great job here and I didn't mean to post something that does not apply..I will admit I am really green when it comes to this stuff....apologies.
|
Edited by - Digger on 19 August 2002 21:14:22 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
