SQL + ASP coding

Hi , can anoyone help me solve this problem....

i developed a website that used both ASP and SQL commands.

I managed to upload it to the server....but pages containing these commands wont display.

When i run a localhost on my pc ....everything was fine.

SQL version used for localhost was MSSQL2000 personal edition on WinXP....but server uses MSSQL 4 on Unix.

Is there a version conflict or could it b some other problems..

If it is some other problems...pls highlight the changes i need to do.

Thanks in Advance.

>> SQL version used for localhost was MSSQL2000 personal edition on WinXP....but server uses MSSQL 4 on Unix

Boss, MSSQL does NOT run on UNIX. Also, there was never a version 4 of MSSQL (earliest release was 6.5, which they purchased from Sybase and renamed as MSSQL). I think you're confusing MySQL (which does have a version 4 and runs on *NIX systems) and MSSQL.

>> Is there a version conflict or could it b some other problems..
If the server is running mysql, then you have some interesting issues.

>> If it is some other problems...pls highlight the changes i need to do.
At the very least, you probably need to alter the connection statement. That might just be the beginning of your problems though. MySQL and MSSQL use different syntax for the SQL statements. For example:

* MySQL does not support subselects
* MySQL does not support stored procedures, triggers, views etc.
* MySQL has better string function support (IMHO)

Even a simple SELECT statement might have differences. For example, to select the first 10 rows:
MySQL:
SELECT * FROM TABLE LIMIT 10
MSSQL:
SELECT TOP 10 * FROM TABLE

Depending on your program, you may need to make a few or many changes.