Delphi MSSQL Problem

[wpsd.forum]

Hi all I'm new here

Is there a difference in Delphi programming to connect MSSQL 2000 and MSSQL 2005
My software using a register settings ( connection string element such as user pass and sql server "dsn" ), and I have two mssql server in two server
one is already working the other one is for upgrade.

I 100% backup the one in 2000 and restore it to 2005 checking all the table and function and trigger is all working in the new 2005

But when i change the register settings to point to the new mssql 2005 it can't connect. why ?
I check using the "udl" method it can connect flawlessly without problem, then i create a small program to connect ( not in delphi though ) to both of the database no problem at all.

Is there a difference ?

[Kambiz]

MS SQL 2000 is not forward compatible with MS SQL 2005. I think you need the proper SQL Native Client for each version of MS SQL Server.