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

Sarun,

I didn't understand that your desktop machine is running Unix. Ok, how about
using sockets? There are sample socket samples on MSDN that you could
probably adapt. Or you might find some Unix socket samples that you could
adapt.

Ginny

"Sarun" <Sarun@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EEC54731-C99B-45B2-B1C8-86E51D10C654@xxxxxxxxxxxxxxxx
> 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
>> >
>> >
>> >
>>
>>
>>


.