CODEWITHSUNDEEP
asp.netmysqlconnection-string
Heena Dave
Heena Dave

Reputation: 321

problem in connectionstring in asp.net

private string conString = "Data Source=173.56.33.6;Database=musicapp;User ID=guest;Password=guest"; I was working on local database at that time my application was successfully interacting with mysql database.when put the database on server, my application still taking the old connection string and data is stored in local database and not on server. what is wrong?

Upvotes: 1

Views: 612

Answers (4)

Robert Peter Bronstein
Robert Peter Bronstein

Reputation: 166

if Data Source=173.56.33.6; is the location of your server database try this instead Data Source=\173.56.33.6;

Upvotes: 0

Hasan Fahim
Hasan Fahim

Reputation: 3885

Make sure whether you updated your connection string when you transfered your DB to server. In any case it is best to store connection string in web.config, so that you can modify it when ever your db is changed or transferred to another location. This change in connection string in your web.config wouldn't require you to rebuild your application. Although if your connection string is hard-coded in code, then you would require to rebuild your application when ever you change the connection string.

Upvotes: 0

Haukman
Haukman

Reputation: 3776

I think your problem is that you have the connection string hard-coded in your code (as a private string that you show above). A much better way is to store it in the config file, use Settings in VS and select ConnectionString as type.

Upvotes: 0

Matthew Abbott
Matthew Abbott

Reputation: 61589

I'd remove hard coded connection strings all together. There is a dedicated section of your config file for this very purpose:

<connectionStrings>
    <add name="MusicApp" connectionString="Data Source=173.56.33.6;Database=musicapp;User ID=guest;Password=guest;" />
</connectionStrings>

Which you can then read out:

string connection = ConfigurationManager.ConnectionStrings["MusicApp"].ConnectionString;

Upvotes: 3

Related Questions