how to connect mysql server remotly.

Question

0.00/5 (No votes)

See more:

XML

<configuration>
  <appsettings>
    <add key="ohpc_connectionstring" value="SERVER=192.168.15.130;User Id=root;pwd=password;database=ohpc_new1;Persist Security Info=True" />
  </appsettings>
</configuration>

I have declare this code in app.config file but It does not work properly and show error message. So how can I modify the code to access mysql database from our remote server. For mysql database userid =root but we have not set any password for database.

[edit]Code block and HTML encode added to make code fragment visible! - OriginalGriff[/edit]

Posted 28-Aug-12 22:29pm

bigyan sahoo

Updated 28-Aug-12 22:34pm

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 29-Aug-12 4:36am

When you post a question (or answer) please check the preview - if you don't encode HTML tag characters then the client browser will "swallow" them, hiding all your code fragment! I have fixed it for you here - have a look with the "Improve question" widget and you will see what I mean.

Sarrrva 29-Aug-12 4:42am

http://www.codeproject.com/Questions/433687/sql-server-connectity-over-the-internet

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

D-Kishore · Answer 1 · 2012-08-28T23:50:00

Hi Dear,

try this code in app.config file

XML

<?xml version="1.0"?>
<configuration>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" />
  </startup>
  <connectionStrings>
    <add name="SqlServerConnectionstring" connectionString="Password=password;Connection Timeout=0;Persist Security Info=False;User ID=userid;Initial Catalog=Database Name;Data Source=servername;" />
   </connectionStrings>
</configuration>

in C# form page use the following code to acces the SqlServerConnectionstring

SQL

ConfigurationManager.ConnectionStrings["SqlServerConnectionstring"].ToString();

StackQ · Answer 2 · 2012-08-28T22:46:00

Solution 1

XML

<configuration>
    <appSettings>
        <add key ="Connstr" value="SERVER=192.168.15.130\SQLExpress;
database=databaseName;uid=UserId;pwd=Password"></add>
    </appSettings>
</configuration>

Posted 28-Aug-12 22:46pm

StackQ