Re: Connect to DB on Unix machine; and File Transfer
- From: "Ginny Caughey [MVP]" <ginny.caughey.online@xxxxxxxxxxxxxx>
- Date: Mon, 19 Sep 2005 11:52:05 -0400
Sarun,
I don't have any experience with MySql, so I can't answer your specific
question unfortunately. But have you considered using Web Services as a
solution? That should work with any database and any OS that supports Web
Services.
As for moving files between the desktop and device programmaticly, there is
the Remote API (Rapi) which you can use from a desktop app to do things on
the device. There is a managed code Rapi class on www.opennetcf.org.
Ginny Caughey
..NET Compact Framework MVP
"Sarun" <Sarun@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2F052EC3-F650-4804-A3B1-173F3A1BDACA@xxxxxxxxxxxxxxxx
> Hi All,
>
> I am developing a Smart Device Application in C#.NET. The database I am
> using for the application is MySql. The application should retrieve data
> from
> the server, insert it into SQLServer CE, and later upload it back to the
> Server. The database server resides in a UNIX machine.
>
> I am having two issues in the application. The first one is regarding the
> connection. I am not able to connect to the database server. Details are
> given below.
>
> I downloaded the MySql driver for Pocket PC from the site,
> http://www.crlab.com/ and I was able to connect to the test databases
> residing in our company's LAN, as well as our company's database server.
> These two databases are installed in Windows machine. But, I am not able
> to
> connect to the database that resides in the Unix server, in Germany, where
> as, now I am writing from India.
>
> The connection string I provided in the application is as follows:
>
> public static string strmySqlConn = "User
> Id=Dummy_User;Password=Dummy_Password;Host=xxx.xx.xx.xx;Database=DB_Name;Port=3307";
>
> The default port for MySql server is 3306, where as the client has
> provided
> that the database is installed in port 3307.
> I am able to 'ping' to the IP Address of their database server, which
> means
> it is public IP. But, I am not able to connect to the server through
> application. What can be the reason? If the database is behind the
> firewall,
> will that create any problem?
>
> I downloaded ODBC driver for windows from the site,
> http://dev.mysql.com/downloads/connector/odbc/3.51.html
> I created a windows application and tried to connect using ODBC
> Connection.
> That also didnt give any result. I was not able to connect. Meanwhile, I
> was
> able to connect to the database in our LAN as well as our Company's
> database
> server. So, what can be the reason for the same not connecting to the live
> server? Is it beacause, the server is running on Unix or is it because the
> database is behind the firewall? If it is behind the firewall, what should
> be
> done?
>
> So also, .NET Compact framework doesnot support System.Data.Odbc. So, Odbc
> conneciton is not possible for Pocket PC application. How can I connect to
> the database? Will I be able to connect using the MySql driver provided by
> Corelab? Please help me to find the solution.
>
> The next issue in front of me is regarding the uploading of files.
> Details:
>
> I have to upload files(audio/video) from the Pocket PC to Desktop PC
> through
> the application. My application is having an option of Synchronizing data
> from the Pocket PC to Desktop PC. When the user click the same, I have to
> move files from PPC to Desktop. My database table is not having any BLOB
> type
> field, so i have to physically move the files from PPC to Desktop PC. And
> also the server runs on UNIX. Please help me out in finding the solution
> for
> moving files from PPC to Desktop PC.
>
>
> Thanks
> Sarun
>
>
>
.
- Follow-Ups:
- References:
- Prev by Date: Pocket PC Webcam Programming
- Next by Date: Re: Pocket PC Webcam Programming
- Previous by thread: PPC: Connect to DB on Unix machine; and File Transfer
- Next by thread: Re: Connect to DB on Unix machine; and File Transfer
- Index(es):
Relevant Pages
|
