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

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: Connect to DB on Unix machine; and File Transfer
    ... I didn't understand that your desktop machine is running Unix. ... That should work with any database and any OS that supports Web ... >>> using for the application is MySql. ... >>> the server, insert it into SQLServer CE, and later upload it back to ...
    (microsoft.public.dotnet.framework.compactframework)