C# Discussion Boards - CodeProject

Adrian Hall2-Jan-03 10:43

2-Jan-03 10:43

Disclaimer: Although I use MySQL, I have not used MySQL with C#

That being said, MySQL does have an ODBC driver at www.mysql.com and there is a supported version (via MySQL AB) although you will have to ask for a quote, since in a corporate edition, this can get quite pricy.

... and my experience with C# and ODBC is quite good.

Regards,

Adrian

Re: mySQL, what do you think?

Jassim Rahma3-Jan-03 0:36

Jassim Rahma

3-Jan-03 0:36

then, do you recommend mySQL for corporate application, or let me ask it the other way: which database you recommend for corporate if not MS Access and MS SQL server?

Jassim

Re: mySQL, what do you think?

Adrian Hall3-Jan-03 5:15

Adrian Hall

3-Jan-03 5:15

Thats a good question. Since I am a consultant by day and programmer by night, I'll put my consultant hat on for you.

For small deployments, it really doesn't matter what you choose. I would recommend SQL Server simply because of the ease of deployment.

For larger deployments, where performance becomes an issue (and this point is dependent on the application and the environment), I tend to recommend Oracle.

For web deployments where the data is not as critical, or other programming languages (such as PHP or Perl) need to get involved, I tend to recommend MySQL.

I say "tend to" since I sometimes come across sites which already have a database in place, and that would have a bearing on the overall cost of the solution.

-Adrian

hotmail.com database?

Jassim Rahma1-Jan-03 3:56

Jassim Rahma

1-Jan-03 3:56

Any one knows what database hotmail.com service is using?

Many Thanks,
Jassim Rahma

Jassim Rahma

Re: hotmail.com database?

Mike Epprecht1-Jan-03 8:02

Mike Epprecht

1-Jan-03 8:02

jrahma wrote:
Any one knows what database hotmail.com service is using?

If it's not SQL 2000, M$ would be busy with the conversion.

Cheers

Mike
Johannesburg, South Africa

Re: hotmail.com database?

SimonS2-Jan-03 22:41

SimonS

2-Jan-03 22:41

I'd like to think so too, but there still seems to be a bunch of UNIX in the Hotmail backend.

I think Passport is the only pure MS part of Hotmail at the moment.

Cheers,
Simon

"The day I swan around in expensive suits is the day I hope someone puts a bullet in my head.", Chris Carter.

my svg article

Re: hotmail.com database?

Adrian Hall3-Jan-03 5:26

Adrian Hall

3-Jan-03 5:26

(Disclaimer: I work for a company producing email products, but I have no insider knowledge of
hotmail.com beyond what I have read and heard over the years).

I'm not sure hotmail.com uses a database in the traditional sense of "database" beyond the Passport authentication. The messages are likely to be held in flat files. Email systems just don't work
the same way as databases in general. Even the now defunct Internet Mail Service from Microsoft held
each message in a single RFC-822 formatted file, with an index file for the meta-data.

However, a quick look at the SMTP servers indicate that they are now running Microsoft stuff on at
least some of their servers (It looks like Exchange 2K), and their web servers are running IIS, so
I guess that they are running Microsoft stuff now.

It should be noted that on an Exchange 2K server (at least my Exchange 2K server), I can change directory
to M:\sitename\MBX\ahall\INBOX and see a series of file <number>.EML. If I connect to the IMAP port,
then I see <number> appear as an IMAP UID. .EML format is the same RFC-822 format that their defunct
Internet Mail Service saved data as. So even in Exchange 2K, the database functionality is seriously
limited.

-Adrian

VS Installers

Jassim Rahma1-Jan-03 3:53

Jassim Rahma

1-Jan-03 3:53

what are all the free installers available for .NET on the web?

Many Thanks,
Jassim Rahma

Jassim Rahma

How can I trace a windows installer project?

mkomasi31-Dec-02 22:48

mkomasi

31-Dec-02 22:48

I've made a setup project by Visual Studio.Net and the output is msi(windows installer). In Custom Action part, I've added some dll or exe projects. Now I want to trace the dll or exe projects, but I don't know how.
Can you help me please?

Re: How can I trace a windows installer project?

Stephane Rodriguez.31-Dec-02 23:11

Stephane Rodriguez.

31-Dec-02 23:11

FileMon + Regmon (tools from the Windows Resource kit[^]).

Re: How can I trace a windows installer project?

mkomasi1-Jan-03 1:48

mkomasi

1-Jan-03 1:48

Thanks.
But I couldn't find that. Can you tell more about it?
Mehdi.

Re: How can I trace a windows installer project?

Stephane Rodriguez.1-Jan-03 2:08

Stephane Rodriguez.

1-Jan-03 2:08

Oops, sorry, tools are from www.sysinternals.com[^], (or here[^]).

Re: How can I trace a windows installer project?

Anonymous2-Jan-03 1:59

Anonymous

2-Jan-03 1:59

Look at www.sysinternals.com for FileMon and RegMon

ComboBox FixedHeight

theahmed31-Dec-02 21:07

theahmed

31-Dec-02 21:07

Hi!

i was designing my own comboBox (inherited class), but had some troube with it.

would you happen to now how one can change the height of the comboBox itself.

say my items are 10px eatch in height, how can i make that the height of the combobox as well

i tried to set FixkedHeight to false but thatdoesn't seem to work.

its interesting, becasue i can draw a combobox of anysize, but it seems that a clipRegion is predefiend so i can only see the default combobox of 18px heigh!

Thanks!

Ahmed k Confused | :confused:

Re: ComboBox FixedHeight

Stephane Rodriguez.31-Dec-02 21:46

Stephane Rodriguez.

31-Dec-02 21:46

If all elements are of fixed height, you must also set the DrawMode property to OwnerDrawFixed (instead of Normal, which is the default).

[edit]I have just been looking at the .NET combobox source code and it results from it that once an appropriate DrawMode is set, you just need to set the ItemHeight value you need to see it automatically reflected.[/edit]

If it gets to be full owner drawn, the technique then, inherited from good ol' WIN32 comboboxes, is besides doing .DrawMode=OwnerDrawVariable, to provide your implementation for OnMeasureItem(), and OnDrawItem(). Nish already made something available publicly[^] about it.

Remoting & IServiceProvider

Alex Korchemniy31-Dec-02 13:11

Alex Korchemniy

31-Dec-02 13:11

What I need is to get two applications to be able to communicate. I am very happy with IServiceProvider and System.ComponentModel.Design.ServiceContainer. They allow me to easily give access to my shared classes/components, to other classes. What I want now is to pass the IServiceProvider to the other application through remoting. All the objects that are added to the IServiceProvider are in their own Dll library. (I also referenced this dll library from the second application).

I created a remotable class (inheriting from Marshalobjbyref), that contains the IServiceProvider. (This remotable class is in a dll that is referenced by both applications) I published this remotable class with remoting. The second application is able to see the published class and call methods in it.

Here is the problem:
When I try to use the IServiceProvider - I get an error. It woun't let me use it. Is it possible to remote IServiceProvider?

IServiceProvider sure makes life easier for me, but I can't figure out how to use it remotely.

THANKS A LOT, if you can help me out.

Re: Remoting & IServiceProvider

Alex Korchemniy3-Jan-03 7:40

Alex Korchemniy

3-Jan-03 7:40

I figured it out now.

Here's some help if anyone has the same problem:

- you can remote only classes that inherit Marshalobjbyref
- all objects that are passed/access in the class have to be serializable
- interfaces cannot be access in the class

Encryption question.

jtmtv1831-Dec-02 11:30

jtmtv18

31-Dec-02 11:30

i was just wondering. is it possible to find what type of encryption was used to encrypt a file. ? i have a program im working on that encrypt's decrypt's i want too add a "Auto detect" feature so they dont have to pick the algorithm it will detect it for them. do i have to use filestream with and write a small flag into the file to let me know what encryption was used (then erase the flag from the file and proceed with decryption) or does DES and RC2 have a unique identity that i can find inside each encryption too dectect that encryption.
im pretty sure the file stream would work...but im looking for a cleaner approach, i dont want to do it and find out theres a easyer/nicer way to do it.

thank you for reading this question.

Jesse M.

Re: Encryption question.

David Stone1-Jan-03 6:17

David Stone

1-Jan-03 6:17

I don't think it's possible to detect the type of encryption that you used on a file without putting a little data somewhere in the file itself indicating which one you used. I think it would be very insecure to broadcast to everybody what encryption protocol you used.

I don't know whether it's just the light but I swear the database server gives me dirty looks everytime I wander past.
-Chris Maunder

Microsoft has reinvented the wheel, this time they made it round.
-Peterchen on VS.NET

Re: Encryption question.

jtmtv181-Jan-03 16:15

jtmtv18

1-Jan-03 16:15

thanks david. i wont do it.. i saw a guys source (it was a tourial) he had a way to detect if the file was encrypted or not.. i orignally though there was a way to detect which encryption was being used. but reviewing the code i do see that he added a flag into each file. it was a boolean number (011011 or something) while that does over some security... if i could crack that number and know that means "des" encryption to the program then someone else could too. anyways.. thanks agian.

Re: Encryption question.

Pete Bassett2-Jan-03 1:15

Pete Bassett

2-Jan-03 1:15

Hi.

Like you said, I would just go with the flag describing the file if I were you. It doesn't reduce the security of the file at all if you are using industry standard encryption methods like 3des or Rijndael. Infact, you should write your security routines with the full knowledge that a hacker WILL be able to deduce exactly what techniques you are using in your system. The secret it to use techniques that are hard to break even if you do know the algorithm.

Just use the flag.

Pete

Insert Sig. Here!

ip?

imran_rafique31-Dec-02 9:24

imran_rafique

31-Dec-02 9:24

how to get ip address of different computers on the network?

r00d0034@yahoo.com

Re: ip?

Alex Korchemniy31-Dec-02 17:58

Alex Korchemniy

31-Dec-02 17:58

You can only get the IP if you have the DNS of the computer, or the MAC address. You have to use System.Net classes for this.

Stripping Punctuation

MStanbrook31-Dec-02 5:23

MStanbrook

31-Dec-02 5:23

Anyone have an "efficient" routine for stripping punctuation for a string?

Mike Stanbrook
mstanbrook@yahoo.com

Re: Stripping Punctuation

Nnamdi Onyeyiri31-Dec-02 5:41

Nnamdi Onyeyiri

31-Dec-02 5:41

public string StripPunctuation(string source)
{
   // any chars you want to keep, put between the [] brakets.
   // i think the ^ has to remain where it is though.
   string pattern = "[^a-zA-Z ]";
 
   // use regular expressions.
   System.Text.RegularExpressions.Regex regex;
   regex = new System.Text.RegularExpressions.Regex(pattern);
   return regex.Replace(source, "");
}

That should do it. I think .NET's regular expression classes are effiecient enough.

1001111111011101111100111100101011110011110100101110010011010010
Sonork | 100.21142 | TheEclypse

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.