BlackBerry & Android apps Tablet programming

Installation Guide:

First off the Required Downloads:

1. VMWare virtual machine player here
2. Adobe AIR 2.5 here
3. BlackBerry Tablet OS SDK here
4. BlackBerry PlayBook Simulator here

The announcement by RIM (Research in Motion) of their latest tablet PlayBook and its accompanying application development platform is really exciting news! Yes – mobile is hot!

 BlackBerry & Android apps

Sharing Few of the documentation for blackberry apps.

*   http://docs.blackberry.com/en/developers/deliverables/11958/Create_a_menu_836422_11.jsp

*   http://docs.blackberry.com/en/developers/deliverables/11958/UI_components_508102_11.jsp

*   http://supportforums.blackberry.com/t5/Java-Development/tkb-p/java_dev%40tkb?labels=blackberry+ui

SQL SERVER 2005 Sps & Qurries /IIS Configs Issues and solutions

SqlServer Complex Qurries:.

Getting 3rd Max Unit Price value form table
---------------------------------
SELECT TOP 1 UnitPrice
FROM (
SELECT DISTINCT TOP 3
 UnitPrice
FROM Products
ORDER BY UnitPrice DESC) A
ORDER BY UnitPrice
----------------------------------

Create Table Named Marks.

CREATE TABLE [dbo].[Marks]([MarksID] [int] IDENTITY(1,1) NOT NULL,[Name] [varchar](50) NULL,[Marks] [numeric](18, 0) NULL,CONSTRAINT [PK_Marks] PRIMARY KEY CLUSTERED ([MarksID] ASC)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]) ON [PRIMARY]GO
Getting 4th and Fifth max Values from a table Marks.

select top 2 (Marks) from (Select top 5(Marks) from Marks Order by Marks Desc)A order by Marks

Multiple Tables Insert using Stored Procedure

Create PROCEDURE dbo.InsertNewImage
 @ImageTitle nvarchar(30),
 @ImageDescription nvarchar(100),
 @ImageFilename nvarchar(50),
 @ImageThumbnail image,
 @AlbumID int
AS
 Begin

  Set Nocount On

  DECLARE @ImageID int

  INSERT INTO Images(ImageTitle, ImageDescription, ImageFilename, ImageThumbnail)
  VALUES (@ImageTitle, @ImageDescription, @ImageFilename, @ImageThumbnail)

  SELECT @ImageID=@@IDENTITY

  INSERT INTO ImageInAlbum(ImageId, AlbumId)
  VALUES (@ImageID, @AlbumID)

 End

OnDelete Cascade Clause

CREATE TABLE test_child
(SUB1 INT,
[NO] int,
FOREIGN KEY ([NO]) REFERENCES Test_parent
ON DELETE CASCADE)


SQL SERVER /2005 Configs Issues and solutions


<b>1-</b> Back Up a Database (SQL Server Management Studio)/Getting Location of any db file.

Error<>

Working in sql with attcahing any db file from any location the above attach file is enable to view in program files because it start overwritting on the attach file .U need make a back of that particular file while transporting it another system.

Solution

Show the Links
http://msdn.microsoft.com/en-us/library/ms187510.aspx
http://msdn.microsoft.com/en-us/library/ms188312.aspx


Creation Of User Login:. 

To Make any user we need to go and login through windows authentecation mode go in security click on logins to create any User Login we need give the users special rights

*SysAdmin
*DBCreator

'sa' is bydefault user of SqlServer if we need to change its password we need go to the login area and give new passwor...

Published Utrack to Samaa Tv/ iReporter Deployment

Need More Work to do on server deployment Utrack has been Publish to samaa tv at 20-jan-2010...... with the following link

http://ireporter.samaa.tv/Utrack/DisplayMap2.aspx (Utrack Web Access)

Above Link is active with perfect traking to both web/Mobile apps.and the product demo has been given on 27th of Jan 2011 to the concerned person..at SAMAA TV.

Ireporter deployment from the scratch has been made to Samaa tv at 17-March-2011 and maintain a new server having all configurations of both IIS and SqlServer 2005.

Keypoints at iReporter Deploymnet:.

* we need to configure IIS properly then made a connetion to the sqlserver
* To Upload any images and videos in any particular dircetory we need to defined few permissons otherwise the desried file image/videos cant be upload we to need rightclick on both photos/Vidoes folder and add users

1-  IUSER
2- NETWORK SERVICE
     Give the writting rights to both the users, Having all these rights the application can run properly and images and vidoes can uploaded from the mobile (Java Enabled)

-----------------------------------------------------------------------------------------------------
Utrack Review (27-sep2011)
 
 The demonstration has bee made on 28-Sep-2011 to CEO.of the company

Need 2B on The Twose In IIS CONFIGURATION(5.1)

Currently working at configuration of iis server a series of issues came but looking forward to fix every problem INSHALLAH......Almost Half Done but i think many 2come.

Issues related to IIS SERVER are mention in timely manner.


Issue related to permissions of iis check the link handle the problem

Issue 1:Server Application Unavailable:.
************************************************************
Got the solution through above link check the permissions
http://blog.crowe.co.nz/blog/archive/2005/08/30/242.aspx
************************************************************

Issue 2:Fail To access IIS MetaBase:.
*************************************************************

//////////////FAIL TO ACCESS IIS Metabase///////////////// (issue:2)

SOLUITON :2

GO in command mode

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

execute this command "aspnet_regiis -i"

it start reinstalling your web 2.0 framework the server will surely run all static asp.net pages..after the above configurations

Other wise if the page not run then go through this one as well...

THE ASP.NET PAGE CAN RUN EASLIY BY GIVING PERMISSIONS TO THE FOLLOWING OTHERWISE THE OTHERS USERS IT ALL ABOUT THE RIGHTS THAT HAVE BEEN TO THE PARTICULAR FOLDER
GIVEN TO THE FOLDER....

1-EVERYONE
2-SYSTEM
3-ADMINISTRATOR


*************************************************************

Most Important Thing to Understand About IIS 5.1

ISSUE:.3

Login Failed because xxxx/asp.net user xxxx=server name

To reslove the probelm go on these steps

Open sqlserver 2005


1 go in Logins
2 check the above user login is present or not
3 if the user login not present then add user login by rightsclick on logins node and add new Login Name or serarch it you can get all the users names while at
4 searching get the name of the user that creats error on web page....
5 After adding add users to login rights click on the user a windows will appear.
6 Check On Server Roles a list of rules will appear then check to "sysadmin" this will allow to access database easily...


Use must select the rights to sysadmin rights ohterwise another error has been like

error 2. like deny select statement occur b/c not assing the role to sysadmin

*********************************************************


Utrack Deployed At Saztel Server

Utrack deployed at saztel server with link 210.2.135.26/Utarck/DisplayMap2.aspx
But the link is enable to access through WAN'.nEED sOMETHING


A core issue evlove during the configrayions og IIS SERVER

check the above link about the issues

http://www.neilstuff.com/iis/common-iis-and-asp.net-issues.htm


IIS   Crystal Report issue

Samaa Tv (Modification to M-reporter and blackberry Versions)

Looking forward to start work on Mreporter Java plus blackberry  versions modifications further updates include the following

these are the updates that has required to smaa tv...


1 - To  achieve better picture quality Samaa TV requires recording of the Video in mp4 or other    format by default  via  iSamaa application.

2- Samaa TV requires Saving of the video in a particular file of memory card.
   
3 -Samaa  TV requires browsing button as a search starter that can find all videos of all formats.

Testing Mreporter at Geo Tv

One the important task we have performed haveing published our server on 27 Novermber 2010 after the completion of our product we need to test our product at Geo Tv....Thanks to ALLAH Again we are on the twose having all the limited resoruces we have successfully give the Demo to Geo Network on 1-12-2010...one of the greatest experience my life to talk to all persons who are the champions of their fields.....

The few things the i have noticed during the meeting....The technical person bent on imphasizing the quality  of the video and the time to upload the vidoes....there is also some issued also whether the product is capable to run on all Symbian Non Symbain OPERATING SYSTEM...well i have got the ans easily the the product of J2ME (Mreporter) can run on  all Java Enabled  mobiles...

Inshallah  i am looking forward to Sent soon the BlackBerry Version to Geo Network for testing Thanks to ALLAH..Who Helped Us....

publishing a dedicated Server

Through Last week I have been working on this issue but still having a problems to connect the mobile apps to the dedicated server for this issue i have to jog my mind and make clear it that it will work very sooner,,,,
We have a series of tasks that we need to perfrom step by step...

1-Dedicated Server Side (Configurations)
2-Web Publish Through IIS

Steps we have Perfromed are listed here....

1- We need to get Public I/P to our DSL provider
2- When we get the i/p we have to perform the port forwarding on the particular i/p assign by the DSL     person ....We perfromed these all setting by the help of our DSL Provider
3- You have to Publish all the Pages  through IIS for this you have to install IIS  6.0 for Xp CD to publish all the pages
4- when we publishing the the pages we give the permissones to all the users to upload rights
5-To assgin Rights to any user are all above important task fo any application.
6-Rights can be given by clicking right click to the folder and go on securityto give rights.
7-After all these happens if the application not uploading files or vides then we have check the Log Error Folder of aspx pages
8- The  Log Error will define wat is actually wrong with the application
9- The Upload Location of any Images/Vidoes are very important for this we have to check our Aspx file.

After  very Hard working of 25 days we made our server on 27-11-2010....Due Lake of Resources the delay has been made although we have published our server  succesfully there are few things we need to be in mind whenever publish the dedicated server the defined