Beginner Q: Pocket PC access to SQL Server 2005


hi,

  total beginner pocket pc, , 2-month beginner sql server 2005 , visual studio 2005.  made database pillbox.mdf, , wrote windows forms program access it.  it's easy.  added data source, chose tables , stored procedures, , dragged them onto forms.  automatically created adapter classes , datagrid me.

  next, wanted same thing pocket pc.  did same drag , drop thing, , happy see empty datagrid in emulator (design-time) form.  here on, trouble.  when ran it, said not connect.

  so some questions:

1) connection string have change?  has 3 parts: machine name, database name, , security spec.  specifies machine name.  ok?  known pocket pc, or have specify http something?  machine have change settings become "server"?  it's standalone pc no network.  understand emulator chooses pretend it's not "on" computer.  database name known pocket pc?  (same type of question.)  , windows authentication ok on pocket pc?  or must create name/password pair on sql server?

2) when went modify connection string, noticed setting specify data source.  sql server 2005, asks me dbo, sql server mobile, asks me *.sdf file.  type of file this?  there way generate other database?  not possible have the pocket pc app point same database windows app?  oh... sdf represent pocket pc's local database?  if so, question how populate it.  have update main database @ point.  guess i'm confused how pocket pc's supposed work.

3) have deploy sql ce or something?  think read visual studio automatically.  it's bit hard reading blogs because many comments talk things contained in vs.  1 blog talking 7 dlls need downloaded pocket pc.

4) application has table, store on pocket pc, , allow user modify , update records.  bandwidth should low, table small , updates should not frequent.  reasonable design?  asking if it's ok have direct database access, or if should package data in custom format, , use web service pass data , forth.  have read , understood articles why should not pass dataset in web service, point web services can interoperable, why spoil ms-only datasets.  in case, want simple app , running quickly.

thanks in advance.

 

[excuse me late response]

make sure of following:

1) have remote connetions enabled sql server 2005.  please use surface area configuration , enable tcp/ip , named pipes.

2) not need sql ce/mobile.  if having app directly work sql server 2005. however, here assumption use app when have connection sql server 2005.

however, have questions you:

1) said app needs table sql server 2005 , store on device.  in form want store.  sql mobile helps you.  sql mobile tiny sql database management on devices.  please go through http://forums.microsoft.com/msdn/showpost.aspx?postid=295034&siteid=1 and have lots of information know sql mobile.

thanks,

laxmi narsimha rao oruganti, msft, sql mobile, microsoft corporation

 



SQL Server  >  SQL Server Compact



Comments

Post a Comment

Popular posts from this blog

Azure DocumentDB Owner resource does not exist

having same error microsoft.azure.documents.documentclientexception: message: {"errors":["owner resource not exist"]} , scenario. when deployed webapp azure , try document docdb throws error. docdb exists in azure , contains document looking for. weird local machine(running vs) works fine. i'm using same settings in azure , local. have , idea this. thanks Microsoft Azure  >  Azure Cosmos DB
Read more

job syspolicy_purge_history job fail in sqlserver 2008

Image
hello guys, when installed sqlserver,it automatically created 1 job name job syspolicy_purge_history. but failed @ step 1. the reason is: date                11/6/2010 2:00:00 am log                job history (syspolicy_purge_history) step id                1 server                mxosv-otsdb01 job name                syspolicy_purge_history step name                verify automation enabled. duration                00:00:00 sql severity                16 sql message id                34022 operator emailed                operator net sent                operator paged                retries attempted                0 message executed user: nt authority\system. policy automation turned off. [sqlstate 42000] (error 34022).  the step failed. have run statement: select msdb.dbo.fn_syspolicy_is_automation_enabled the returned valus 0. what can resolve it? or can delete job manually.   thanks in advance. if haven't things want,be
Read more

Trying to register with public marketplace error with 'Get-AzureStackStampInformation'

when trying register against public azure adfs azure stack error below. logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  and  \\azs-ercs01\c$\maslogs error occurred checking stamp information: system.management.automation.remoteexception: term 'get-azurestackstampinformation' not recognized name of cmdlet, function, script file, or operable program. check spelling of name, or if path included, verify path correct , try again. @ c:\azurestack-tools-master\registration\registerwithazure.psm1:1106 char:5 +     throw "logs can found at: $global:azureregistrationlog  and  \ ... +     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~     + categoryinfo          : operationstopped: (logs can fou... , try again.:string) [], runtimeexception     + fullyqualifiederrorid : logs can found at: c:\maslogs\azurestack.azureregistration.2017-10-12.01-31-23.log  a    nd  \\azs-ercs01\c$\maslogs error occurred chec
Read more