We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

ADO.NET Connection

Thread ID:




45957 Jul 1,2006 06:55 AM Windows Forms 0
Tags: FAQ
Asked On July 1, 2006 06:55 AM

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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.