SASP Consultants : Solutions - How to connect to a SQL Anywhere DB on the PDA from the Desktop PC?

How to connect to a SQL Anywhere DB on the PDA from the Desktop PC?

The following example connects desktop ASA9 to PPC ASA9 by utilizing an ODBC profile through MS Active Sync

Assumptions
01. Desktop OS : WIN XP
02. PPC OS : WM 5 or WM 6
03. MS ActiveSync 4.0 or greater
04. C:\ASA9\ is the path to all ASA driver files
05. Mobile device app using PocketBuilder (or any other)
06. Desktop app using PowerBuilder (or any other)


		Allow port 2638 to be used by ActiveSync. Create a .reg file and install
		Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows CE Services\ProxyPorts] "ASA"=dword:00000a4e Copy the above 3 lines of text into note pad and save it as .reg file. Then simply double click the file to register. There will be a Registry Editor Popup response window prompting you to confirm.

		ODBC (PC) to connect to the Mobile Device
		Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 9.0] "Driver"="C:\\ASA9\\dbodbc9.dll" "Setup"="C:\\ASA9\\dbodbc9.dll" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources] "mDB"="Adaptive Server Anywhere 9.0" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers] "Adaptive Server Anywhere 9.0"="Installed" [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\mDB] "Driver"="C:\\ASA9\\dbodbc9.dll" "UID"="mDB" "PWD"="mDB" "DatabaseName"="mDB" "EngineName"="mDB" "AutoStop"="YES" "Integrated"="NO" "Debug"="NO" "DisableMultiRowFetch"="NO" "CommLinks"="SharedMemory,TCPIP{host=127.0.0.1}" "Compress"="NO" "Description"="mDB" Copy the above text into note pad and save it as .reg file. Then simply double click the file to register. There will be a Registry Editor Popup response window prompting you to confirm. Note: mDB is the SQL Anywhere DB name on the PDA -: OR : - Using Administrative Tools - Data Sources (ODBC)
		.DSN file on the Mobile Device
		[ODBC] uid=mDB pwd=mDB databasename=mDB databasefile=\Program Files\Sybase\ASA\mDB.db start=\Program Files\Sybase\ASA\dbsrv9.exe -q -x tcpip -n mDB

		WM Device : Dock it on the cradle or activate Bluetooth connection

		Desktop : Make sure the connection between the PC and the Device is established


		WM Device : Start the SQL Anywhere mDB
		Desktop : You are all set.

		Some resources
		http://www.sybase.com/developer/codexchange http://www.pfcguide.com/_newsgroups/subject_list.asp?group=sybase.public.pocketpowerbuilder http://www.pfcguide.com/_newsgroups/subject_list.asp?group=sybase.public.sqlanywhere.mobilink

	Analytical Analysis of Endoscopic Sclerotherapy
	Barcode (Symbol) Based Data Capturing
	Business Process Outsourcing
	Control of Monitoring and Measuring Devices – ISO 2001:2000 & QS9000 (CSSsoft)
	Cargo
	Data Warehousing
	Document Management System
	Donation Management System
	Electronic Mail Management
	Finance (FINsoft)
	Hotel (HMsoft)
	Leasing / Hire Purchase (FINLEASE)
	Library (LIBsoft)
	Lottery
	ERP Solutions for Manufacturing Units (BIZsoft)
	Marketing
	Payroll (PAYsoft)
	Property Management System
	Public Deposit (PDsoft)
	Quickbooks Integration
	Sale Monitoring (SMsoft)
	Service Call Manager
	Telephony - Predictive Dialer
	Tender Costing (TCsoft)
	Time Office (TOsoft)
	Student Course Monitoring (SCMsoft)
	Integrated Mobile solution for MAXIMO 4.x, 5.x, 6.x and 7.x
	IBM MAXIMO Upgrade 4.x onwards to 7.x
	Various Customized Software
	Third Party Software Upgradation & Maintenance