Discussions

lAndrewl said:

TadejK said:

*snip*

Hi,

I read the forum topic and is really usefull. I have to make an application which communicates with a smartphone (HTC S740) through the usb port. My problem is I don't know where to begin and I would really apreciate if you could send me the code of the program you have made. I could not download it from the link specified below. Sorry for my bad english 

                             Andrew

Hi.

 

I don't know what happened to the file, but I've uploaded a new one .. the problem is, it's status is still Pending, whatever that means

That's why I also put it on my server - link.

So, your problem is where to begin - well, it really depends on what you want to do. What I'm doing with this code if fairly simple - I'm connecting from the Mobile device to the PC via Activesync using plain TCP connections. Why from the device to the pc and not the other way around? Well, for one reason - if you're on the device, you get a special hostname - ppp_peer - which always corresponds to the connected pc

Hope my sample helps.

 

Regards,

Tadej

PerfectPhase said:

TadejK said:

*snip*

Out of interest what it the Clustering, Mirroring and Replication support like in PostgreSQL how about equivalents for things like SSRS, SSAS, SSIS etc?

You have several options for Clustering, Mirroring and Replication, as can be seen from http://wiki.postgresql.org/wiki/Replication,_Clustering,_and_Connection_Pooling.

I've found an old survey, from which you can see what options are available for PostgreSQL as equivalents (at least to some extent - don't know the product well enough) to SSRS - http://www.postgresql.org/community/survey.43.
SSAS is data mining, if I'm not mistaken - PostModel looks interesting in that field (also provides connection with R Project).
Primary use of SSIS is supposed to be data warehousing. I'm not sure what would come close to that, but you should ask the PostgreSQL mailing list about that .. perhaps the below-mentioned Bizgres.
There is also Bizgres - enhanced PostgreSQL for business - for data warehousing and similar business stuff, but I don't know enough about it to compare it to SSRS, SSAS or SSIS

Regards,
Tadej

jh71283 said:

PerfectPhase said:

*snip*

and just how many of those points are going to be an issue for an app that currently survives using MS access?

You're right .. but, why would you even want to limit yourself?
Nowadays, with multicore processors in every computer, it's not bad if your database can use multiple CPUs.

As I see it, the problem isn't really with these limitations in regards to this specific application, but to the fact that once you start using a database, you're most likely to use it for all of your projects (you already have your code adjusted to that db) - and it's very easy to bump into those limits. For example, let's say you now want to deploy a web app using this db - with several users using it at once, those limits start becoming very low

I'm just trying to say - why limit yourself, if you don't have to? Why buy a car with only 3 seats - what if someday, you'll want to drive a forth person?

Oh, and let's not forget - they're barely surviving using ms access

Regards,
Tadej

In my opinion, go with PostgreSQL.
I've used all of the mentioned databases, but they all have their shortcomings -
Firebird is okay if you need embedded db, otherwise it lacks in everything;
SQL Express is great, but if you need to run it on linux, macosx or another non-windows system, you're out of luck; also, SQL Express is limited (it's like a demo) and when you want to (or need to, because of the limitations) upgrade to a 'real' SQL Server, then that costs *big time*;
MySql .. erm, don't even get me started - you probably love your data too much to lose it someday, right? ;
MS Access - you already know of it's shortcomings;
PostgreSQL - ever since I've stumbled upon it, I've been using it for all of my needs, and it hasn't failed me yet - support is also great (professional and via mailing lists). Oh, and talking about backuping - you have several options available, so you're very likely to find one which suits your needs exactly. And if you're wondering - yes, it can be silently installed along side with your own app.

Regards,
Tadej

If you use this link then simply unzip the files inside the zip, then go to your project in Visual Studio, right click on references, and select Add Reference.
In the window, which opens, select the Browse tab, and then navigate to wherever you unzipped those files.
Double click Indy.Sockets.dll.
If you've already done this, then just skip it.

In the version I'm using (the link I provided), there's no POP3 namespace in Indy.Sockets, which means you can only write "using Indy.Sockets;", and not "using Indy.Sockets.POP3;".

Regarding "Indy controls", as you called them .. AFAIK, there aren't any At least, if you mean controls like "textbox", "button", etc, which you can drag-drop onto your forms.
There are just classes, which you use in your app.

Reply, if you still can't get it working, tell me the version of your Visual Studio, and I'll try and make an empty project, with a working example of Indy.

Regards,
Tadej

staceyw wrote:



I was thinking a couple ways if the work.
1) USB-to-Serial converter on the device.  These devices make a USB port appear as serial ports to the device - I think via HID in usb.  If the device will support, not sure.  But that way your code base stays to serial.

2) Program to HID on the usb ports.  Need a little pinvoke, but does not look to bad.  Scott Hanselman has a sample app using this.

Both ways look very promising

Regards,
Tadej

Rii wrote:

Hi TadeJk..

I m doing web based call accounting system in asp.net(c#)

for dat I hv 2 connect PBX(Private Branch Exchange) With PC.
Collect CDR(Call Detail Records) form PBX.& Brodcast Live!

I m new in networking & even in asp.net.

PBX has 3 interfaces.

1) Com
2) Network Port (Lisnr & Client )
3) File

I want to know for Network Port How can I connect PBX with PC & colllect CDR.
can I use Tcpclient & Tcplistner  classes...??
Plz send some code snipt..

Reply soon...It's Urgent!!
Thanx.

You should take a look at http://www.java2s.com/Code/CSharp/Network/AsyncTcpClient.htm and perhaps http://www.codeproject.com/KB/IP/AsyncSocketServerandClien.aspx

But .. does it really run on TCP? Or perhaps UDP? And you do know the port on which it's running, right?

Regards,
Tadej

Also, here's a neat page about communication via usb to different hardware - http://www.lvr.com/usbcode.htm .. not C#, but it should get you somewhere
There's also a C# class there - for communicating with HID enabled devices - it's under 'HID Page'.

Regards,
Tadej

I'm not quite sure how one would write he's own activesync .. sadly, my knowledge of usb communication is *very* limited
What about an alternative - if you have a WiFi network there, that would make things much easier
But, if you still want to pursuit the 'usb-way', I believe the safest bet would be to interop with the device drivers, and try to communicate that way ..
Also, like I suggested in one of my previous answers to this thread, you might take a look at SyncCE project, which should be able to sync with pocket pc devices .. I believe it's OSS, so why not go the OSS-way and take a peek?

Regards,
Tadej

Indy obviously depends upon Mono.Security .. try to install mono ..
If that won't work, then add a reference to Mono.Security assembly ..

Regards, Tadej