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/

Comments

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

How To Disable Export Button In Crystal Report When you are taking crystal report printouts through a program, such as program written using vb6. you might have a problem how to disable Export button in print preview. All you have to change following property to false or Uncheck the Export option in Property Pages. You CR.WindowShowExportBtn = False Crystal Report Object in Visual Basic 6. (CR is refer to Crystal Report Object ) You can go to Property Pages by right click and choose Properties on Crystal Report Object After you done those things you crystal Report print preview will showing like follows. I was face to above problem. We implemented a software program which is written using vb6. Cashier can take daily sale print out. before printing it is showing a preview to the user. So when the time pass user click export button and saved that report as a excel file. Then he modified the values and took printout to the management. That gives Security problem to the program a

Magento Generate Google Sitemap using Cron

I had a problem with generating the Google sitemap using cron job. To do that you can simply change following database value. SELECT * FROM core_config_data WHERE path = 'crontab/jobs/sitemap_generate/schedule/cron_expr' Change the value as you set time in cron jobs. EX: Generate the Sitemap for every 5 minutes value = */5 * * * * That's it. Now you have to worry about cron is working or not. Just type following in your browser and hit enter. http://youresite.com/cron.php
Git script which shows little bit advanced status. Save with Preferred file name in /usr/local/bin/XX branch="" branches="git branch --list" ESC_SEQ="\x1b[" COL_RESET=$ESC_SEQ"39;49;00m" COL_RED=$ESC_SEQ"31;01m" while read -r branch; do clean_branch_name=${branch//\*\ /} description=`git config branch.$clean_branch_name.description` if [ "${branch::1}" == "*" ]; then printf "$COL_RED$branch$COL_RESET $description \n" else printf " $branch $description\n" fi done <<< "$branches" git status Use the following command to add a description to your local branches. git branch --edit-description