Re: Where to write my program data? - C# Discussion Boards

PIEBALDconsult15-Sep-10 3:39

15-Sep-10 3:39

Customers? Confused | :confused:

DaveyM6915-Sep-10 7:55

DaveyM69

15-Sep-10 7:55

... 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.

Dave

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.
Astonish us. Be exceptional. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

PIEBALDconsult15-Sep-10 4:57

15-Sep-10 4:57

Plus, how else can I do:

<DBT>
  <DatabaseManager Load="%APPDATA%\DatabaseManager.xml" />
</DBT>

Luc Pattyn15-Sep-10 5:07

Luc Pattyn

15-Sep-10 5:07

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.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

PIEBALDconsult15-Sep-10 15:59

15-Sep-10 15:59

I hesitate to make a directory (or two) for one measly XML file.

Luc Pattyn15-Sep-10 16:05

Luc Pattyn

15-Sep-10 16:05

and that is exactly why the top directory of your C: partition is such a mess Laugh | :laugh:

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

PIEBALDconsult15-Sep-10 16:09

15-Sep-10 16:09

How'd you guess? Confused | :confused:

Start point of a classlib Proj

DaveyM6914-Sep-10 9:12

DaveyM69

14-Sep-10 9:12

I wrote this tip[^] to address this point exactly.

Enobong Adahada13-Sep-10 23:16

Enobong Adahada

13-Sep-10 23:16

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.

Re: Start point of a classlib Proj

OriginalGriff13-Sep-10 23:52

OriginalGriff

13-Sep-10 23:52

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.

Connection String for MySQL in C#.Net2.0

Varun Sareen13-Sep-10 22:32

13-Sep-10 22:32

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. Frown | :(

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

13-Sep-10 23:35

stancrm

13-Sep-10 23:35

Message Closed

modified 23-Nov-14 5:58am.

Varun Sareen13-Sep-10 23:38

13-Sep-10 23:38

Dear Friend i have tried it earlier, it didn't work out for me Frown | :(

Message Closed

14-Sep-10 0:00

stancrm

14-Sep-10 0:00

Message Closed

modified 23-Nov-14 5:58am.

Varun Sareen14-Sep-10 0:26

14-Sep-10 0:26

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 Frown | :(

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

OriginalGriff13-Sep-10 23:54

OriginalGriff

13-Sep-10 23:54

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.

Varun Sareen14-Sep-10 0:36

14-Sep-10 0:36

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();

Dave Kreskowiak14-Sep-10 2:10

Dave Kreskowiak

14-Sep-10 2:10

My guess is that you have the wrong port number. Port 80 is normally reserved for HTTP traffic (web browsers/servers).

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Varun Sareen14-Sep-10 19:18

14-Sep-10 19:18

Hey Dave, I am checking the connection locally, so i think the port must be 80 (for all local servers).

Dave Kreskowiak14-Sep-10 20:00

Dave Kreskowiak

14-Sep-10 20:00

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.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Varun Sareen14-Sep-10 23:23

14-Sep-10 23:23

Ok Dave, Thanks

Varun Sareen14-Sep-10 0:43

14-Sep-10 0:43

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

OriginalGriff14-Sep-10 0:51

OriginalGriff

14-Sep-10 0:51

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.

Varun Sareen14-Sep-10 18:50

14-Sep-10 18:50

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

Varun Sareen15-Sep-10 19:17