I have Snitz running on a IIS 5.0 .Net server connected to a SQL 2000 SP2 database. I imported the access database tables into a sql server database but had to recreated the database relationships. The error shown below is the same error I received even prior to recreating the database tables relationships.
The error is as follows after clicking the Members hyperlink:
Technical Information (for support personnel)
Error Type: ADODB.Recordset (0x800A0BB9) Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /forum/members.asp, line 232
Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; Q312461; .NET CLR 1.0.3705)
The problem lies in the way you created the tbales in SQL Server. The only way you have to avoid a multitude of problems is this:
1. Drop the existing database or tables. If your drop the database create a new one.
2. Run setup.asp?RC=5 to create the tables with the proper structure in the SQL Server DB.
2. Use DTS to import the data from the Access database to the SQL Server database. When you do this, make sure you configure the DTS transformation columns so that you delete the existing table data and that you enable identity insert.
3. If you no longer have the Access database, then do not delete the existing tables and database. Just create a new database and use DTS to move the data from the current database to the new one. After making sure the new database is OK, you can delete the current one.
Topic Locked
Posted - 09 July 2002 : 15:56:03
.