how to connect sql server 2005 to vb.net ?

Question

can any one help me . how can i connect sql server 2005 to vb.net . i want connection string . i want urgent

Answer 1

string constr = "Server=localhost;port=3306;Database=database name;Uid=root;";

MySqlConnection conn = new MySqlConnection(constr);

MySqlCommand comm = conn.CreateCommand();

comm.CommandText = "Select column from table;

try

{

conn.Open();

}

catch (Exception x)

{

}



tis is the connectoin i used in c# which is similar to vb.net any way u try out this ...

and u need to install mysql ddriver fo vb.net

Answer 2

The connection string is going to depend on your local setup. It isn't anything we can help you with. You will need to know the path to the server, the SQL Server account login and password etc.

Answer 3

hi, i think of you could verify for the question timeout in the Server properties, now and back while the state of no interest between a consumer and the database is extra, the consultation gets disconnected and while each and every you desire to open a question window it is going to ask for reconnecting. in the past connecting to the device verify if the facilities are working, bypass to start -> run and form facilities.msc in the facilities verify if the database provider is working or not? if the facilities are down, verify if the login consumer identity is ideal or not and then start up the facilities. you basically have 2 forms of authentication, one is sq. server authentication and yet another domicile windows authentication my advice would be, you have the two. while you're writing sq. queries and use it for coming up purposes use domicile windows authentication, shop yet another sq. authentication like SA consumer or yet another consumer call for sq. DBA purposes like memory placing and admin purposes. for experience works , microsoft has released a set up document which you would be able to get carry of from microsoft internet site and through working the set up document you could set up the experience works on your community device. permit me be conscious of if this facilitates tp settle on your subject concerns. Regards, Varun