[rockybanu]

I am trying to connect to database which is in other system.....how can i do this??? i am doing like this....

	  private static string Constr = "server=v3-desktop3;" + "username=root;" + "password=sa;" + "database=proinstitute;";

But it is failed to connect How to do this???

[Momerath]

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

[rockybanu]

i tried it but it is giving error please give me an example.... Here i am having two systems on one system i am having database and on one i'm having application to connect to database ....but it is giving error please solve my problem

[rockybanu]

Hi, went thru the search engine and juz find only one thread abt this related problem, so decided to post again .. sori.

Currently i am working on a proj and it requires a laptop to connect to a desktop mysql server through router. In my desktop i am able to use the mysql server and code but the prob is that when i try to set the DSN in the Data Source Administration under control panel, i cant connect. I change the hostname to my IP address instead of "localhost" and it cant work. In my laptop i install the mysql odbc connector and set the DSN and set to my desktop ip and when i click on the test data source it say not allowed to connect to the server.

Sorry for the lengthy description

[TyVeryMuch]

Have you forwarded the port correctly?

[rockybanu]

i mentioned port also. If u dont mind plz mention an example of connection string

to retreive data from a remote database which is in LAN server from a client pc plz... mention a connection string in c#.net

[JackOfAllTrades]

http://connectionstrings.com/