Re: Embeded MySQL with C#

In fact, MySql can be embedded in an application; at least in a C/C++
application. So, in theory can be embedded also in a managed application.

Dumitru

"Mark Rae" <mark@xxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ei3y7st8FHA.3380@xxxxxxxxxxxxxxxxxxxxxxx
> "Ümit Kavala" <umit@xxxxxxxxxxxx> wrote in message
> news:uX0PQfa8FHA.1420@xxxxxxxxxxxxxxxxxxxxxxx
>
>>I wrote an application using c# and mySQL database. But when I deploy it
>> doesn't work on an other PC. How can I embed mysql in C#.
>
> I think you have a fundamental misunderstanding of what mySql is or
> rather, much more importantly, what it is not.
>
> Like SQL Server and Oracle, etc, it is a server-based RDBMS. It is not the
> same as, say, an Access database in this respect. You can't "embed" it in
> C# as such.
>
> You need to install mySql on a server which is "visible" to your
> client(s) - this could be on a server local to their network, or on the
> Internet. If this is a WinForms app, the client machine(s) will need at
> least the .Net Framework installed and a reasonably recent version of
> MDAC. If this is a WebForms app, your webserver will similarly need a
> resonably recent version of MDAC - your sebserver will already have the
> .NET Framework installed as part of the IIS installation.
>
> Luckily, once this is in place, interfacing with mySql in the .NET world
> is relatively simple - all you require is a .NET data provider. There are
> several native .NET data providers available, as well as OleDb providers
> and even ODBC drivers.
>
> You will also need some mechanism of telling the client(s) how to connect
> to the mySql database - this is achieved by means of a connection string.
>
> So...
>
> 1) Where is the mySql server?
>
> 2) Is this a WinForms or WebForms app?
>
> 3) What .NET data provider are you using?
>


.

Relevant Pages

  • Re: Moving a MySQL database
    ... providing you're using the same or a newer mysql server on your new system, you just need to copy the whole data directory of your mysql installation. ... > I have a MySQL database residing on a RH9 server. ...
    (Debian-User)
  • Re: RH 8.0 Where is libmysqlclient.so.10 library
    ... > We are using a seperate machine as mysql database server. ... > My question is do i need to install mysql to get this library ??. ...
    (linux.redhat.install)
  • ANN: MySQLDirect .NET Data Provider 2.30 Released
    ... Core Lab company has recently released new 2.30 version of MySQLDirect .NET ... Data Provider, 100% managed full-featured .NET data provider for direct ... Data provider can access MySQL server either using native MySQL network ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: [PHP] copy tables
    ... The content is in a mysql database. ... how about using a status column in the "dev" server that keeps track ... SELECT query accordingly. ...
    (php.general)
  • Re: PHP Personality in D2007 Architect?
    ... I was following all the hype about ASP.NET but after a try I figured that it creates a lot dependency around windows and MSSQL for sporadic and small web development, after trying PHP 4 months ago I have to say it's good enough. ... Thanks to open source projects like the PostgreSQL .net data provider you at least don't have to run a M$ database which would suck ... There are nice .net providers for MySQL and Firebird as well. ... Home of Lightning Admin for PostgreSQL and MySQL ...
    (borland.public.delphi.non-technical)
Quantcast