ADO.NET Connection

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

Loader.
Up arrow icon