| Author |
 Topic  |
|
|
bbdesign
Starting Member
USA
3 Posts |
 Posted - 18 April 2006 : 15:58:43
|
I needed to move my databases from one server to another. Initially, I did a data export/import, but that did not retain all field parameters, caused errors in my forum, etc. So, I did a backup/restore, and that appeared (as it should) to retain everything. However, still getting ASP errors:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/forums/forum.asp, line 329
Nothing changed in the code, so I assume something in the DB is causing the error. Not sure what could have happened.
I have everything setup in the forums the way I like... can I resetup the database without having to re-do all my preference settings? Will the setup.asp app somehow allow me to start from scratch with a fresh DB creation? Not sure the best way to handle this, any help would be greatly appreciated. Thanks! |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 April 2006 : 16:22:00
|
Assuming you haven't added any MODs, your best bet would probably be to let setup.asp create the tables for you and then import the data. That's roughly the same course of action for moving between different database types, and offhand I don't see where it would be all that bad of an idea in this case.
Not being an expert on MSSQL Server, you might want to wait for some verification on that...  |
 |
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 18 April 2006 : 16:26:16
|
How did you export the data? I'd use DTS in the "transfer objects and data" mode which will move all constraints, defaults, etc to the target db.
I've moved forum DB's from one server to another, and the only change to make in the code was to edit the connection string to the new server. This was between the same version of SQL Server, I'm not sure what you might need to do if the two server versions are different.
|
======
Doug G
======
Computer history and help at www.dougscode.com |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
bbdesign
Starting Member
USA
3 Posts |
Posted - 18 April 2006 : 17:07:11
|
| It appears I was able to solve the problem by doing an Upgrade Database, even though it didn't need it, and technically I told it I was upgrading from 3.0.04 when I already had the newest version installed. Looks like everything is intact, maybe that was a dangerous thing to do, but it seemed to work in this case. |
|
|
|
Podge
Support Moderator
Ireland
3776 Posts |
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
| |
Topic |
|
Topic Locked
