LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Enterprise (http://www.linuxquestions.org/questions/linux-enterprise-47/)
-   -   Accessing and Updating MySql on Redhat Linux v9 FROM .Net application on WIN2K (http://www.linuxquestions.org/questions/linux-enterprise-47/accessing-and-updating-mysql-on-redhat-linux-v9-from-net-application-on-win2k-277219/)

areeh 01-13-2005 03:40 AM

Accessing and Updating MySql on Redhat Linux v9 FROM .Net application on WIN2K
 
Hi to all!

I have this situation in the office, wherein the management would like to include both Windows 2k and Linux Redhat v.9 in the network. A web application to be written in DotNet (C#/ASP.net) will access and update the MySQL database which resides on the Linux box. Is this possible? If yes., what are the things to be done?? If no, any work arounds that can be of help?


I will appreciate your replies on this matter.

THanks :)


Areeh.

ludmil 01-13-2005 06:17 AM

Hi areeh,

1. Download the ODBC .NET Data Provider from:
http://download.microsoft.com/downlo...S/odbc_net.msi

2. Download MySql ODBC driver for Windows from:
http://dev.mysql.com/downloads/connector/odbc/3.51.html

3. Install the above two on the Windows machine

4. Make sure your Linux box running MySql would allow access from your Windows machine's IP on the TCP port MySql listens on.

5. Specify your Linux box IP address or NetBIOS name in the connection string for the OdbcDataProvider

ludmil 01-13-2005 06:57 AM

A better and more detailed description on how to access MySql from .NET can be found here:
http://dev.mysql.com/tech-resources/articles/dotnet/

sample code included

areeh 01-13-2005 08:36 PM

Hi ludmil!! THanks for the help...:) I appreciate it!!!

I will try it right away and work on it...



Regards,

Areeh


All times are GMT -5. The time now is 11:03 AM.