How to connect to remote mysqlserver

How to connect to remote server?

Page 1 of 1

6 Replies - 1808 Views - Last Post: 04 November 2009 - 06:36 AM Rate Topic: -----

#1 rockybanu  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-October 09

How to connect to remote mysqlserver

Posted 03 November 2009 - 10:53 PM

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???
Is This A Good Question/Topic? 0
  • +

Replies To: How to connect to remote mysqlserver

#2 Momerath  Icon User is offline

  • D.I.C Lover
  • member icon

Reputation: 1010
  • View blog
  • Posts: 2,444
  • Joined: 04-October 09

Re: How to connect to remote mysqlserver

Posted 03 November 2009 - 11:08 PM

Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;
Was This Post Helpful? 0
  • +
  • -

#3 rockybanu  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-October 09

Re: How to connect to remote mysqlserver

Posted 03 November 2009 - 11:23 PM

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
Was This Post Helpful? 0
  • +
  • -

#4 rockybanu  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-October 09

Re: How to connect to remote mysqlserver

Posted 04 November 2009 - 03:54 AM

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
Was This Post Helpful? 0
  • +
  • -

#5 TyVeryMuch  Icon User is offline

  • New D.I.C Head
  • member icon

Reputation: 7
  • View blog
  • Posts: 33
  • Joined: 24-March 07

Re: How to connect to remote mysqlserver

Posted 04 November 2009 - 03:59 AM

Have you forwarded the port correctly?
Was This Post Helpful? 0
  • +
  • -

#6 rockybanu  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 11
  • Joined: 23-October 09

Re: How to connect to remote mysqlserver

Posted 04 November 2009 - 04:04 AM

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
Was This Post Helpful? 0
  • +
  • -

#7 JackOfAllTrades  Icon User is offline

  • Saucy!
  • member icon

Reputation: 6036
  • View blog
  • Posts: 23,432
  • Joined: 23-August 08

Re: How to connect to remote mysqlserver

Posted 04 November 2009 - 06:36 AM

http://connectionstrings.com/
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1