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
