How to connecting shared database?

Question

My database is in shared folder. now i want to connect to shared database. how to write sqlconnection string. here i am using that shared database ip address but no use..

Sam Hobbs · Answer

Please read my article Database Table Update in a DataGridView without Writing Code . That article might not explain how to do what you need to do for your program, but the important part of that article is the part about creating a data source. If you can create a data source that way, then that will help you to create a connection string. There are otehr ways to create a connection string, but doing it the way I describe n my article is a good place to start.

Pravin Ghadge · Answer

Change ur conn string as follows: string sqlString = "Data Source=192.168.1.2;initial catalog= Uganda_SEMIS;Integrated Security=true;User Instance=True; " ; SqlConnection con = new SqlConnection (sqlString); con.Open(); con.Close(); & 2)make TCP/IP enabled 3)Windows firewall off

saisagar nalla · Answer

this is not my ans. any other solution

Hemant Kumar · Answer

I think this might be some network problem.Please contact your network Admin

saisagar nalla · Answer

me doing on and off both but no use

Pravin Ghadge · Answer

Hi Sai Plz check firewall setting of shared PC. If windows firewall is on then turn it off

saisagar nalla · Answer

A network related error occured..........Shared database is not connected

Pravin Ghadge · Answer

Hi sai, r u getting some error? if yes plz share that error.

saisagar nalla · Answer

string sqlString = "Data Source=192.168.1.2;AttachDbFilename=" Uganda_SEMIS";Integrated Security=true;User Instance=True; " ; SqlConnection con = new SqlConnection (sqlString); con.Open(); con.Close();

Hemant Kumar · Answer

Hi sai, Please share your code .

saisagar nalla · Answer

it's pingging successfully..

Hemant Kumar · Answer

Hi I think you need to give the Machine Name or IP Address.Please check the connection using the Command Prompt Ping.

How to connecting shared database?

Answers (12)