Re: Connect to DB on Unix machine; and File Transfer

Ginny Caughey.

Thanks for replying.

Still I will be having issues with the same. I have to create Webservice
which is pointing to Unix. If it was Windows, and is to be developed in .NET,
that was not a problem. But creating Webservice pointing to Unix is what I
havent done earlier.

And reagarding RAPI, that also, should be developed for Unix machine. If at
all, it was Windows application, how can I invoke a particular desktop
application from a mobile application? Since, the application I am developing
has to send files from the PPC to Desktop PC on click of a button in the PPC.



"Ginny Caughey [MVP]" wrote:

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