SQL 2000 (version 7) installation

Hi

I' ve just purchased you ASP Forum software and am busy installing it.

I' ve come across an error when running the first script 1.42.13_Full.sql, I cut and pasted the whole script and pressed f5, the following errors came up :-

Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 3
Line 3: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 4
Line 4: Incorrect syntax near ' COLLATE' .
Server: Msg 170, Level 15, State 1, Line 5
Line 5: Incorrect syntax near ' COLLATE' .

I have a SQL server 2000, what have I dome wrong?

Please return answer ASAP please.

Thanks

Jason Podwojski.

I sent you an e-mail already. Please check out your inbox.

So, what was that whole string about?

those was about incompatibility with older version of sql server. Nothing serious, and it just means our software don' t run on sql 7.

This forum is a strict SQL 2000 driven application

We also are just installing the forums and have a similar problem on SQL 2000. When running the query, here' s the list of errors:

SQlNumResultsCols Failed
SQLExecDirect Failed
Error Messages:
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 3: Incorrect syntax near ' GO' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 7: Incorrect syntax near ' GO' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 11: Incorrect syntax near ' GO' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 15: Incorrect syntax near ' GO' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 19: Incorrect syntax near ' GO' .
[Microsoft][ODBC SQL Server Driver][SQL Server]Line 23: Incorrect syntax near ' GO' .

this just means you are not using QA. Your SQL control panel does not recognize the " GO" keyword.