ADO.NET Connection

[Myra]

HI everybody,

I have a problem with the ADO.NET Connection which i use in my coding in VB.net 2005, to connect to the SQL Server 2000.

This connection works properly on a local machine , when i set the servername as localhost. but when i set the servename as the name of the server on which the SQLServer is installed, it doesn''t work. whereas the ADO Connection does.(Provider=SQLOLEDB.1ersist Security Info=False;User ID=sa;Initial Catalog=Test;Data Source=" & ServerName)

The ConnectionString I''m using is "Data Source=" & ServerName & ";Initial Catalog=DatabaseName;Integrated Security=true"

Thanks, in advance
Regards,

Myra