How to connect to sql server 2008 through windows mobile 6 - Mobile Discussion Boards

lol

Vuyiswa Maseko,

Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

why?

hi
how to Mark and Pick all row number 1 on DataGrid when the form load ?

on Windows-mobile

thanks in advance

I want to upload a zip file in j2me to server for Lava mobile. The code works well for Nokia mobile but fails to upload file when used for Lava mobile reporting an error "CONTENT DISPOSITION or PREMATURE ENDING". Please help in sorting out this problem.
Thanks !

Hi,

I have been struggling to send sms using pdu mode in vb.net, My code is working fine for Text Mode, even I am sending sms from Hyperterminal with PDU command. When I try the same PDU in VB.Net code. The same is not working. I trying waiting for the port to respond. Used Thread.Sleep upto 10000ms but not succeed. Below is my code in VS 2005 (2.0 Framework)

Dim firstarg As Integer = Convert.ToInt32(pdudata.Substring(0, 2))
firstarg = firstarg * 2
tmp = pdudata.Substring(2)
tmp = tmp.Substring(firstarg)
firstarg = tmp.Length \ 2
port.WriteLine("atz" & vbCrLf)
port.WriteLine("ate0" & vbCrLf)
port.WriteLine("AT+CMGF=0" & vbCrLf)
read = New Byte(port.BytesToRead - 1) {}
port.Read(read, 0, read.Length)
'txtsms.Text += Encoding.ASCII.GetString(inbuf);
tmp = port.ReadExisting()
port.WriteLine("AT+CMGS=15" & vbCrLf)
Thread.Sleep(1000)
port.WriteLine("0021000C91190910153570000002E834" & Chr(26))
Thread.Sleep(5000)
port.DiscardOutBuffer()
'read = New Byte(port.BytesToRead - 1) {}
'port.Read(read, 0, read.Length)
I tried using msgbox and found that everything is going perfect except the last command i.e. 0021.... chr(26)

The given pdu is working in hyperterminal.

Can u figure out the problem for me.

Your solution will be highly appreciable as I am tired trying various combinations.

Thanking you in the meantime.

Jaidev Khatri

This function worked for me. It sends a PDU message.

Private Sub PDUSMS()
        If Comport = "" Then MsgBox("Please Choose A connection") : Return
        smsPort.PortName = Comport
        smsPort.BaudRate = "115200"
        smsPort.Parity = Parity.None
        smsPort.DataBits = 8
        smsPort.StopBits = StopBits.One
        smsPort.Handshake = Handshake.RequestToSend
        smsPort.DtrEnable = True
        smsPort.RtsEnable = True
        smsPort.NewLine = vbCrLf

        If Not (smsPort.IsOpen = True) Then
            smsPort.Open()
        End If
        At_length = "17"
        PDU_code = "079144772800800011000C914477529628010000AA03E8721E"
        'smsPort.WriteLine("AT" & vbCrLf)
        'System.Threading.Thread.Sleep(2000) 'Pause to allow last command to get to phone
        smsPort.WriteLine("AT+CMGF=0" & vbCrLf) 'open space for new message
        System.Threading.Thread.Sleep(2000) 'Pause to allow last command to get to phone
        smsPort.WriteLine("AT+CSMS=0" & vbCrLf) 'open space for new message
        System.Threading.Thread.Sleep(2000) 'Pause to allow last command to get to phone
        smsPort.WriteLine("AT+CMGS=" + At_length + vbCrLf) '+ Chr(34) + At_length + Chr(34) +
        System.Threading.Thread.Sleep(2000) 'Pause to allow last command to get to phone
        smsPort.WriteLine(PDU_code + Chr(26)) 'number to send message to  + vbCrLf +
        System.Threading.Thread.Sleep(2000)

        If smsPort.IsOpen = True Then
            smsPort.Close()
        End If
    End Sub

I am doing project in c# for sending sms via AT commands using gsm modem having serial port RS232 to my cell phone. But this modem with serial port rs232 is very rarely used by people now a days. Can any one suggest me the better alternative for this but which can support the same AT commands that are supported by this modem. Any kind of help will be appreciated.

Thanks in advance.

Regards,

Aeman

hello guys...

Im trying to build a windows mobile application using visual studio 2008,windows mobile 6 using C# and sql server 2008.
all programs are on the same laptop.

I almost had everything right except i couldnt connect to the database through the pocket pc.

Here is what i've done so far:

SQL SERVER:
-I enabled tcp/ip connection -> cleared all dynamic ip adress and set the port to 1433. i also enabled the name pipes.
-I enable the sql port through windows firewall.(Control Panel->Security->allow aprogram through windows fire wall->add port

Visual Studio:
-New Project-> smart Device project-> device application
added in the form_load the following code:

string conStr = "Data source = Computer name\1433; intial catalog = "database name"; integrated security = true";
sqlConnection sqlCon = new sqlConnection(conStr);
sqlCon.Open();//this is where i get "SqlException"

I also tried the followin connection strings

i- conStr = "Data source = Computer name; intial catalog = "database name"; integrated security = true";
ii-conStr = "Data source = C:\\"path of the .sdf file on my computer";
iii- conStr = Data source = ip address\1433; intial catalog = "database name"; integrated security = true";

Device manager:
i installed virtual pc and windows mobile center;
openned device manager from visual studio, right click on pocket pc 5.0->Connect;
when connected i configured it to enable NE2000 PCMCIA adapter and use attached network card
i then cradel it and it connected well with the DMA.and in windows mobile center it showed connected.

now when i run the application(F5); i get an sqlException when openning the connection

this is a headache but i need a soluttion.

i have a some additional questions:

1- can i connect directly to sql server database engine and access the database(which isent compact).mdf file.
or cant i because pocket pc only connects to sql server compact edition database(.sdf)

2- Am i suppose to install sql compact on the pocket pc, when i run my application, i find it inside the pocket pc with the database and my application solution

3- is it impossible to connect to sql server 2008 directly through a windows mobile 6 . do i need a websrever, web service, replication, IIS....

im really stock at this point. i have no idea what to do or try next.

i'm findig it impossible connectin to sql server 2008.

PLease Helpppp!!!

thank you anyway..

Firstly you state that you get an SQLException (in two places) but you omit to give the exact text of the exception(s) so it is impossible to guess what went wrong. Secondly you seem to be trying to run a mobile app that connects to an SQL server on a remote PC. I wonder how you expect this to work when your phone is out of range of the server? Without knowing what your app is supposed to do it is not clear why you are doing it this way, but I would expect that most mobile apps would use SQL CE installed on the device itself.

I must get a clever new signature for 2011.

window mobile always use sql ce not sql and the database should be in .sdf format.

if u want to use .mdf file to connect to your mobile.then you have to use webservice.

In window mobile connection string should be..

string conn ="Program Files//database.sdf";

deploy your application to your mobile..connecting with active sync.

Hi guys,

I have tried many times to download the SDK from blackberry, but it seems after a while it times out and i have only downloaded aboiut 80%.i have tried google but only can find it at the same blackberry site.
my buddy also tried with same result.

any suggestions? Confused | :confused:

thanks

Did you notify the administrators of the Blackberry site of your problem?

I must get a clever new signature for 2011.

Hi Yes, i did!
sent them a screen-shot of the error.

thanks

hi
i have Windows-mobile program that connect to my WebService.

how to check if there is connection from my Windows-mobile to my WebService ?

Except of using `try` and `catch`......

thanks in advance

7-zip's lza.exe would be perfect except there isn't a CE 6.0 version.

(Yes, we are currently rolling our own from zlib, but I've found that the latest z-lib has all sorts of problems and it would probably be cheaper just to buy something.)

Hi All,

I'm busy messing around with some live wallpaper code and i was wondering if it is possible
to scale text to fit a certain rect. Reason is that not all Android screens are the same, so
what looks nice on certain size screens looks horrible on others.

I have noticed that you can use the getTextBounds method to get a boundary rect of a given string
and its TextSize. So you could possibly cycle through a Textsize range (100 downto 10 or whatever)
and compare its textbound rect to the rectangle you want to fit the text in, to see if they are the same or
slightly smaller. That said, this method looks extremely long winded and messy.

Is there a better way, i do not want to use a textview.

Ideally i just want to be able to know for example in rect (0, 0, 100, 50) i can fit the string "Hello World"
perfectly with textsize 15 (i made that number up :P)

Many thanks,

Tim

Hi Experts

How can i send multiple(different number) SMS through code? Code is here..

public class sms extends Activity {
   private static final String View = null;
   /** Called when the activity is first created. */
   boolean b;
   
   
   public void onCreate(Bundle savedInstanceState) {
      super.onCreate(savedInstanceState);

try {
         
         sendSMS(Numbert, Message);
         Toast.makeText(sms.this, "SMS Sent", Toast.LENGTH_LONG).show();
         

      } catch (Exception e) {
         
         //Toast.makeText(sms.this, e.getMessage(),Toast.LENGTH_LONG).show();
      }
      
      
   }

public void sendSMS(String number, String msg) throws Exception {
{
for(int i=0;i<10;i++)
{
SmsManager sms = SmsManager.getDefault();
             TelephonyManager telemngr = (TelephonyManager) getSystemService(TELEPHONY_SERVICE);
            
                sms.sendTextMessage("01234555", null, "Test Message", null, null);
}
}

What exactly you want.. you code already seen good, are you getting any error? Unsure | :~

Pavan Pareta

Thanks for reply

No i am not getting any error.
But when i send message on more than one number,then some time code fail.I mean message not send successfully.
So my question is that if my code is good then
1) Why not send successfully 100%
2) Or Any other option to send multiple sms

Are you sure you want to create SmsManager and TelephonyManager objects inside loop?

Also, is it for android? If so, you can try to use sentIntent to check if sending was successfull or reason of failure for your messages.

--
"My software never has bugs. It just develops random features."

thanks for reply

It doesn't matter for where i create SmsManager and TelephonyManager.I wont only one thing send sms 100% successfully from my side.

If you have any idea then please give me tips or example

Thanks in advance

MsmVc wrote:
one thing send sms 100% successfully from my side.

If you mean one single function call that will always work, then you can't do it. Using cellular communications inherently contains the possibility of failure due to glitches in signal strength, visibility of nodes, interference, ... The best you can do is put a reasonable number of retries in your code to handle the failure case.

Judy

Be wary of strong drink. It can make you shoot at tax collectors - and miss.
Lazarus Long, "Time Enough For Love" by Robert A. Heinlein

Thanks for valuable response

Can you give me some example code?

Please help me

please help me somebody...

use my previous suggestion to add some retries ... you had code in your very first post - simply check the return value and retry if it returns an error

Judy

Be wary of strong drink. It can make you shoot at tax collectors - and miss.
Lazarus Long, "Time Enough For Love" by Robert A. Heinlein