ok, I' ve started from scratch. but....

I reloaded the database I set permissions to allow the stored procedures to run and I' ve set up the database connection again. Heres the error...

forum/ini.asp
* Line, Column:159, -1

* Description: Query cannot be updated because it contains no searchable columns to use as a key.

Are you using our native OLEDB connection string?

We are using sql server 2000 (sp3), it will not allow updates to rows without a where clause when no primary key is defined. pgd_srvmsg and pgd_dbheaderfooter, ect... do not have primary keys and allow more than one row to be inserted. Is our database in an incorrect mode? if so how do we change it?

If you have a schema for the database could you send it to me so I can verify our db.

I believe everyone is using SP3 now after the Slammer Worm. It worked for your before, right? Then it will definitely work if you follow my instruction precisely this time. Do not use ODBC provider (system DSN). Use the native OLEDB connection string as provided in masterinclude.asp.

well, I guess we' re running sp4 as of earlier this week. This isn' t good.
any comments on the below text?, I guess we changed the OLEDB to a secure string. but it was working fine.. hmmmmm


it will not allow updates to rows without a where clause when no primary key is defined. pgd_srvmsg and pgd_dbheaderfooter, ect... do not have primary keys and allow more than one row to be inserted. Is our database in an incorrect mode? if so how do we change it?

If you have a schema for the database could you send it to me so I can verify our db.

I guess we changed the OLEDB to a secure string

We provided the secure OLEDB string in masterinclude.asp too (which supports Windows Authentication mode for SQL server).

my comment: OLEDB supports update without primary key, while ODBC doesn' t. If you don' t put the original connection string back, it won' t work. SP4 and SP5 are the same in terms of SQL connection.

ok, I' ll get it going thanks
t

Is there anyway to get a fresh copy or a fresh password for the zip file. I need to go back and get a new masterinclude since the DB admin, came over and changed the file to trouble shoot the problem.
let me know if this is possible. I got myself in a jam here.
thanks
t

The software has been mailed to john at rgmlaw.com.

Please keep in mind two things:

1) Keep a copy of the original software package for emergency recovery purposes
2) Do not alter the source code unless you understand the logics of our software first (won' t be too hard at all), as I will not support modified software.

thank you Samuel
toby