Skip to main content

How to connect PDA with SQL Server 2000

How to connect PDA with SQL Server 2000

When we trying to connect PDA with SQL Server 2000 It generate SQL Exception every time. We searched every where to overcome this matter. Our target was connecting PDA to Server Computer via Wifi and does the transaction to SQL Server 2000. We designed program with MS Visual Studio 2005 and Deployed to PDA. We included the Connection String as following.

"Data Source=ServerName;Initial Catalog=master;Integrated Security=true;User ID=sa"

Server Computer should include following connectivity software.


  • MS .NET Framework 2.0

  • MS SQL Server 2000 Service Pack 3

  • MS SQL Server 2005 Compact Edition [ENU]

  • MS SQL Server 2005 Mobile Edition Device SDK

  • MS SQL Server 2000 SP3a Replication Components

  • MS SQL Server 2000 SP4 Replication Components

You can download above from the Microsoft site.

After you install above software and when you trying to connect PDA with Server maybe you will still get that SQL Exception Error. What you have to do is go to your Windows firewall and switch off the firewall and go to Advance Tab and click ICMP Settings and enable "Allow incoming echo Request". Apply the settings and try to Connect.

If you have still troubles with this Matter mail me your situation to lasanthaindrajith@ymail.com.

Author
http://www.programming.isgreat.com/
Labels:

Comments

  1. darshana4itJuly 21, 2009 at 5:44 AM

    MaXxA macha this is a great article....
    If you can add some images related with this activity.

    ReplyDelete

Post a Comment

Popular posts from this blog

Expire Session When the Browser Close [Codeigniter]

I wanted user to log again to the site whenever they close the browser. i searched everywhere and i found the easiest way. application/config/config.php sess_expire_on_close = TRUE Easy Session Preferences You'll find the following Session related preferences in your file: Preference Default Options Description sess_cookie_name ci_session None The name you want the session cookie saved as. sess_expiration 7200 None The number of seconds you would like the session to last. The default value is 2 hours (7200 seconds). If you would like a non-expiring session set the value to zero: 0 sess_expire_on_close FALSE TRUE/FALSE (boolean) Whether to cause the session to expire automatically when the browser window is closed. sess_encrypt_cookie FALSE TRUE/FALSE (boolean) Whether to encrypt the session data. sess_use_database FALSE TRUE/FALSE (boolean) Whether to save the session data to a database. You must...
3 comments
Read more

Dual Screen Script for Ubuntu

I have experienced problems when installing two monitors in Ubuntu. Following script will help you to solve this problem. I had problems when saving below values so I created a script and put it to the startup. #!/bin/sh xrandr --output VGA-0 --mode 1920x1080 --pos 1280x0 --rotate normal --output DVI-I-1 --off --output DVI-I-0 --mode 1280x1024 --pos 0x0 --rotate normal --output HDMI-0 --off
Post a Comment
Read more