|
Customers?
|
|
|
|
|
... that use the applications you write - who are probably using Windows 7. The chances of them still being with XP is slim, and in a year or two virtually nill. So we have no choice but to code for use in the latest OS.
|
|
|
|
|
Plus, how else can I do:
<DBT>
<DatabaseManager Load="%APPDATA%\DatabaseManager.xml" />
</DBT>
|
|
|
|
|
That is better, at least it does not have the "Application Data" literal string.
BTW: you might want to follow the convention of having a company and a product subfolder.
|
|
|
|
|
I hesitate to make a directory (or two) for one measly XML file.
|
|
|
|
|
and that is exactly why the top directory of your C: partition is such a mess
|
|
|
|
|
How'd you guess?
|
|
|
|
|
I wrote this tip[^] to address this point exactly.
|
|
|
|
|
Pls i want to know where is the start point in a class lib project.
what i mean is how do acchieve class initilalize here like is in vb6
thanks and best regards.
|
|
|
|
|
There is no "start point" in a class lib project - it cannot run on it's own. A class lib is a set of classes that can be used by a variety of other applications, they are not executable directly.
Instead, the various class constructors do the init when they are first executed.
If you need a start point, then create it as a Winforms project or similar instead.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
I am not able to connect to a remote MySQL server on C#.Net. The server is not accepting the request of opening the database. I think the connection string is going somewhere wrong:
<add key="ConnectionString" value="SERVER =IP add; HOST=localhost; PORT=portNo; DATABASE=dbname; UID=userId; PASSWORD=pass;Connection Lifetime=0;"/>
I dont know where im going wrong. Please correct me if someone knows the correct string to connect to a MySQL db thru C#.Net2.0
Thanks
|
|
|
|
|
Message Closed
modified 23-Nov-14 5:58am.
|
|
|
|
|
Dear Friend i have tried it earlier, it didn't work out for me ..
|
|
|
|
|
Message Closed
modified 23-Nov-14 5:58am.
|
|
|
|
|
Connection Terminated unexpectedly. I would like to add here that now I have installed a local MySQL Server and restored one of the table to fetch data form it. But still I am not able to connect to the database locally also from C#.Net2.0
When the code reaches to mySQLCon.open(), then it fires the above exception.
Connection String:"Server=localhost; PORT=80; Data Source=ecampust_opensis; User Id=root; Password=;"
Thanks
|
|
|
|
|
Show us the code fragment you are using to access the connection string, and the code fragment you use to open the connection to the DB. (Not the whole program, please, just the relevant bits)
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Web.Config: Containing the connection string
<appSettings><br />
<add key="ConnectionString" value="Server=localhost; PORT=80; Data Source=ecampust_opensis; User Id=root; Password=;"/><br />
</appSettings>
Fetching the Connection string into a string connStr and opening the connection:
connStr = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
mySQLCon = new MySqlConnection(connStr);
mySQLCon.Open();
|
|
|
|
|
My guess is that you have the wrong port number. Port 80 is normally reserved for HTTP traffic (web browsers/servers).
|
|
|
|
|
Hey Dave, I am checking the connection locally, so i think the port must be 80 (for all local servers).
|
|
|
|
|
The port number has nothing to do with the server being local or not.
Varun Sareen wrote: so i think the port must be 80
"Thinking" is not allowed in this business. You either know what the port is, or you have to find out.
|
|
|
|
|
|
Now the exception is coming as:
{MySql.Data.MySqlClient.MySqlException: Unable to connect to any of the specified MySQL hosts ---> System.Net.Sockets.SocketException: The requested name is valid and was found in the database, but it does not have the correct associated data being resolved for
|
|
|
|
|
Check your database server: Do you have the Named Pipes protocol enabled in the Network setup? (apparently .NET Sockets likes both Named Pipes and TCP/IP)
Also check your firewall at the server - it may be rejecting port 80.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
|
|
|
|
|
Hey dear Griff, I would like to ask you here that "As MySQL is open source and there are many articles for connecting the .Net application with MySQL db, and no where I have found that someone have specified this Named Pipes protocol thing in order to connect to MySQL dB although I have checked firewall. As our client is the owner of the MySQL Database, I think some dB level permission is to be granted in order to access the dB remotely. What do you say dear Griff on this?
Thanks
|
|
|
|
|
Hey dear Griff, the error is coming as "Connection unexpectedly terminated". I am just going sick over this issue Kindly help someone.
|
|
|
|