Remote Connection From Mobile Device...?

Jun 5, 2006

Hello,



I try to connect the SQL Server from the mobile device.

my connection string is:

string conn_str = "Server= 10.0.0.11;Database=theDB005;uid=bahadir;pwd=abcd;Trusted_Connection=false;";

when i try to open the connection I get SqlException,altough the 10.0.0.11 machine is reachable.. is not allowed to access a remote sql server with ip?



Thanks in advance.

View 1 Replies


ADVERTISEMENT

Visual Studio 2005 The Remote Connection To The Device Has Been Lost. Please Verify The Device Connection And Restart Debugging.

Jun 19, 2006

Basically I've been using Visual Studio 2005 for a few weeks now moving a Pocket PC project from 2003 to 2005. When I hit the Start Debugging Button every time until today the project would rebuild and deploy to my pocket PC allowing me to debug etc but now I get

The remote connection to the device has been lost.

Please verify the device conection and restart debugging.

I used to get this problem in VS2003 sometimes and just like the numerous posts on different sites that I've looked at the problem eventually goes away and I'm none the wiser. One guy said that he found that if he went to bed the problem was resolved when he came back!

My PDA running Windows 2003 2nd Edition is directly connected to my PC via a USB port. I've rebooted my PC and done a soft reset on the PDA but it didn't help. I'm using ActiveSync 4.1.

Does anyone know how to resolve this problem?

View 54 Replies View Related

Connection From Windows Application To Mobile Device(*.sdf)

Jan 21, 2008



Hi,
I'm writing a windows application using VB.NET 2005 that must connect to Pocket PC via ActiveSync to read data from SQL Server CE. This is my code:


Dim cnn As New SqlCeConnection


cnn.ConnectionString = "Data Source =Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf"


cnn.Open()

But I get the following error:

The path is not valid. Check the directory for the database. [ Path = Mobile DeviceStorage CardProgram FilesMyAppMobileDB1.sdf ]

Any help would be greatly appreciated!
Leila

View 5 Replies View Related

How To Transfer Database To Mobile Device?

Dec 23, 2006

Hi all, I'm new to mobile devices.

I have a desktop application that uses SQL Server Compact Edition. I will soon have a mobile application that will use the same database. How can I (at runtime of the desktop app, say when the user clicks a button) transfer the sdf file to the mobile device? I'm not necessarily interested in synchronizing the databases, simply overwriting the database on the mobile device with the one on the desktop would suffice.

Is something like this possible?

Thanks!

View 3 Replies View Related

SQL Mobile Installation Problem On Device

Jan 26, 2006

I have been unable to properly install SQL Mobile 2005 on my armv4i windows CE 5 device. Below is a summary of what I have found and done. Any help in resolving my issue will be appreaciated. Thanks in advance for your help.

Symptoms:


No errors occur during installation of SQL Mobile on the device via cab files (either deployed through VS2005 or manually copied and installed on the device)

SQL Mobile 2005 appears to be installed, can see it in the device remove programs list. All 7 SQL Mobile dll files are present in the windows folder. (sqlceca30.dll, sqlcecompact30.dll, sqlceer30en.dll, sqlceme30.dll, sqlceoledb30.dll, sqlceqp30.dll, sqlcese30.dll - version for all files is 3.0.5206).

The following error occurs when attempting to create a new or open an existing database using SQL Mobile query analyzer on the device - "Failed to initialize the provider. Please make sure that SQL Server Mobile Edition is properly installed".

Problem is not isolated to SQL Mobile query analyzer, a similar problem occurs when attempting to instantiate SQL objects from within a C#.Net smart device test program - "Can't find PInvoke DLL 'sqlceme30.dll'.

Problem is not solved by copying SQL Mobile dll files to program folders.

No registry entries exist for any of the 7 SQL Mobile dll files under the HKEY_CLASSES_ROOT.

None of the dll files for SQL Mobile can be registered manually via the regsrvce.exe program. The error code c1 is returned - invalid win32 application (Note SQL CE 2.0 dll files can be successfully registered via this program).



Background:

The desktop used for development is running Windows 2000 sp4. The develpment enviroment is Visual Studio 2005 Professional Edition (version 8.0.50727.42 (RTM.050727-4200). The version of the Microsoft .NET Framework installed is 2.0.50727. The programming language is C#.NET. The device is a 64 MEG Armv4i device running a custom image of windows CE5. The CE5 image was created by Platform Builder with all QFE's through 2005 applied. .NET Compact Framework version 1.0.4292 and SQL CE version 2.0 are included as part of the image (both are in ROM). .NET Compact Framework version 2.0.5238 and SQL CE Mobile are installed via CAB files in the order defined below:



netcfv2.wce5.armv4i.cab

sqlce30.wce5.armv4i.cab

sqlce30.rep.wce5.armv4i.cab

sqlce30.dev.ENU.wce5.armv4i.cab

system_SR_ENU.cab

View 23 Replies View Related

Blank Page On Mobile Device

Sep 13, 2007

Hello,

I am using the SQL Reporting services with SQL Server 2005. I am able to view my reports in the report manager however, when the report generates on my device it shows blank of 0 pages. I created a simple test report with just a header, company's logo and contact info and still no luck. I am using anoynomous user access and have given IUSR datareader access in SQL Server. Not sure where I am going wrong. I feel like I am so close...If someone out there had any success viewing reports on mobile device (WM5.0) and would be so kind to share their experience or knowledge, I would greatly appreciate it!

Thanks.

View 1 Replies View Related

Connecting To Sql Server From Mobile Device

Nov 15, 2005

How can I connect to sql server from a mobile device?

View 14 Replies View Related

Synchronize Between Mobile Device And Desktop

Oct 5, 2007

I want to create an application for home users which runs on their mobile device (smartphone) and their desktop PC and keeps the data synchronized between them. On their desktop I want to run either SSCE or SSExpress. There are so many options in the SSCE literature, which options should I use? How do I synchronize the data?
The literature has so many options I don't know where to start.

View 1 Replies View Related

Updating A Sql Database From A Mobile Device

Aug 19, 2007

Hello,

VS 2005 & SQL server 2005

I developed a mobile application PDA using the Compact Framework 2.0. And using typed datasets

I have also developed a web service. When the PDA is connected to the Internet it can access the web service and get all the data that is in the sql database. The user can add new records, update existing records, and delete them. So the web service acts like a middle man.

In the PDA the data is filled using typed datasets.

However, the customer now wants to be able to interact with there data on the PDA, currently they have to be connected to the Internet. But if there is no internet connection, then they will still like to add, update, and delete the records. Then once they have a connection, all these would be updates with the sql database.

What is the most efficient method to do this.

Many thanks for any suggestions,

Steve

View 4 Replies View Related

SQL Mobile Performance/size Problems With WM5 Device

Apr 19, 2006

I just upgraded our application from SSCE 2.0 to SQL Mobile. Our app is written in C++, and we use OLE DB for most of our queries, including the routine the downloads and inserts our lookup table data. This application is running on a Dell Axim X51.

Using SSCE 2.0, this routine takes 236 seconds, with most time spent inserting data into various tables (using OLE DB). The resultant database size is 15.1 MB.

Using SQL Mobile, this routine now takes 675 seconds, with a resultant database size of 27.9 MB!! There is a noticable increase in time when the downloaded data is being inserted into the database.

What would be the reason(s) for the slower performance and the increased size of the database? This appears to be a monumental step backwards in performance. Any suggestions regarding improving the perfomance and size?

View 6 Replies View Related

SQL Mobile Query Hangs PPC 2003 Device

Mar 11, 2006

I've written a query to pull data from a SQL Mobile database which seems to completely hang the device when I run it (I waited several minutes before warm-starting). Yes, it's a bit complex, but it works fine on the desktop version--completes pretty much instantly.

Are there any limits to SQL Mobile that might prevent me from writing such a query? There are not very many records in any of the tables (all are <20, except one which is ~2500).

Here is the query:

------------------------------------code---------------------------

SELECT oi.ProductID, g.GenusName, Species.SpeciesName, f.FormName, f.Abbr, sz.Sizes, su.SizeUnits, su.Abbr, pa.PackageName, pa.Abbr, oi.NumRequested, oi.NumProvided

FROM OrderItems oi

JOIN Products p ON p.ProductID=oi.ProductID

JOIN Varieties v ON p.VarietyID = v.VarietyID

JOIN Genus g ON v.GenusID=g.GenusID

JOIN Species ON v.SpeciesID=Species.SpeciesID

JOIN Grades gr ON gr.GradeID=p.GradeID

JOIN Form f ON gr.FormID=f.FormID

JOIN SizeUnits su ON gr.SizeUnitsID=su.SizeUnitsID

JOIN Sizes sz ON gr.SizeID = sz.SizeID

JOIN Packages pa ON p.PackageID=pa.PackageID

WHERE oi.OrderID=3

------------------------------------------code---------------------------------------

Any ideas? Thanks in advance.

-Kevin

View 6 Replies View Related

Merge Replication Using SSL On A Windows Mobile 5.0 Device

Feb 5, 2007



Dear ppl,

I have a windows mobile 5.0 application that syncronises with SQL Sever 2005 (Merge Replication). The replication works fine without SSL. But when using SSL it doesn't work .On the device i get an error





28037, A request to send data to the computer running IIS has failed.

I have created a a Wild Card Certificate (*.domain-name.net) using Microsoft Certificate Services (Stand Alone) and setup the replication website with replication virtual directory under it , in IIS, to use this certificate. The host header for the replication site is set to "sql.domain-name.net". I have binded the host headers to the port as well.

I can access the https://sql.domain-name.net/replication/sqlcesa30.dll from remote computer and device and it says Microsoft SQL Server Compact Edition Server Agent, that means it is setup correctly.

I have installed the certificate authority and its wild card certificate on the device Root Certificates. Now when I call repl.syncrhonise() from device .. it throws exception with error 28037, A request to send data to the computer running IIS has failed.

which i think means, it can't find the service url.

I am not sure what is the problem..something to do with Trust - SSL certificates... Is there any thing i am missing ?

Awaiting,



View 9 Replies View Related

Designing A Compact Database For Mobile Device

Apr 4, 2008

Hey guys,

So I started an SQL CE database for use inside a mobile application. I used SSMS to create a .sdf file (because if I let Visual Studio do it, SSMS can't open it because it will be version 3.5).

The reason I wanted to use SSMS is because I wanted to be able to design the database in design view, and populate it with initial information for the application to use. That means adding tables and rows.

The problem is, SSMS doesn't seem to have a design view available when working with CE databases. It also doesn't seem to have a feature for adding rows into tables. It's essentially as useless as VS2008 for designing my mobile database. It only lets me add tables, and I can't even do that visually in design view. I have to use those cumbersome forms.

Is there any way to design a CE database in design view? And add rows of data into tables? It feels like I'm overlooking something.

Note: I dont need to subscribe or publish the database. The mobile application just needs to use the database as a repository.

View 7 Replies View Related

Mobile Device Database Develpment Problems

Dec 9, 2006

Hi, Guys

I read a lot of your post about the mobile device connecting SQL Server. I try to solve my problem, but i still in trouble of Mobile database application.

The following is my development enviroment

Visual Studio .net 2005
Sql Server 2005
Windows CE.Net 4.2
Microsoft ActiveSync 4.2

First i can run some simple application on the Mobile Device( Symbol MC9060G Mobile Device), all the connection between develop PC and Mobile Device is fine. All the develop SDK for the Mobile device without problem.

Secont, i can develop a simple normal windows database application, work fine, can get data from SQL Server 2005. the connection to database server is fine.

I used VS2005 develop a simple database with DataGrid on the form( all the code generated by the VS 2005), when run the program, got error at " int returnValue = this.Adapter.Fill(dataTable)"
error "PlatformNotSupportedException". I don't know what's going on.

I think the connection to the database no problem. Maybe the Mobile device has problem. I insatlled sql.ppc.wce4.armv4.cab file to mobile device.

Can someone help me out?

Thanks.

View 4 Replies View Related

Problems Installing SQL Server 2005 Mobile On Device

Dec 24, 2005

I have a Fujitsu-Siemens LOOX 520 running WM 5 version 5.1.70 on which I am trying to create a Server 2005 Mobile database.

I have installed the following files on the Pocket PC after a hard reset to make sure the unit was in its vanilla state:

NETCFv2.wm.armv4i.cab

sqlce30.dev.ENU.ppc.wce5.armv4i.CAB

sqlce30.ppc.wce5.armv4i.CAB

sqlce30.repl.ppc.wce5.armv4i.CAB

All the files appeared to succesfully install. Connecting to the device in VS2005 works with no problems. Creating a small test app in VB.NET and running it on the device works no problems, so the device is satisfactorily connected to VS2005.

My problem is this:

When I try to create an SQL Server 2005 Mobile database on the device using Add Connection under the Data Sources window in Visual Studio 2005 Professional (RTM version), I get the following error:

"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding."

Trying the same thing in Microsoft SQL Server Management Studio gives the same error, but a little bit of extra information:

"Microsoft SQL Server 2005 Mobile Edition and/or .NET Compact Framework v2.0 is not properly installed on your mobile device or the device is not responding. (SQL Server Mobile Edition ADO.NET Data Provider)"

As far as I can see, everything IS installed OK, so why is VS2005 not working?

Thanks for any help.

JB

View 6 Replies View Related

Can I Write A Dll(or Share The Same Code) That Works On Both Mobile Device And Pc?

May 4, 2007

hi,

Can I write a dll(or share the same code) that works on both Mobile device and pc? Since we are using compact edition, we are hoping we can write some common module with the same code that could works on both mobile device and pc platform. I noticed the reference is the same, System.Data.SqlServerCe.dll 3.0.

Another question is, we already have a module for SQLCE2.0, with .net CF1.0. Now, we will start to use compact edition, should we just update on the 1.0 one, or we have to write a different one based on .net CF2.0? Can I use compact edition in CF1.0 dll?



Thanks.

View 1 Replies View Related

How To Pass A Parameter Or Value To A Publication From A Mobile Device During Sync.

Aug 5, 2007

Hiya,

I have a project that requires that I filter certain data going to the mobile device via the publication based on user selected value on the mobile device. (Filter by location based on the selection of the location on the mobile prior to syncronization).

Now, our current authentication model is Windows Authentication, and changing that to Username based authentication is not feasable, and using the users account to pass that value to the database is the only way I can think of to do this... (Then filter based on username)

But then I thought that there has to be another way - such as passing a variable or parameter to the sync request during or before syncronization... Is this possible? If I could query the data being sent back up to the server, for instance, I could do so to retrieve the value I need.... Any ideas?

Any help appreciated!!

Dave Borneman
anyWare Mobile Solutions

View 1 Replies View Related

Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)

Apr 4, 2006

Hi,

I am developing an application for a Pocket PC (PPC). I am using Visual studio 2005, and the Operating system on this PPC is Window Mobile 2003 SE. The followings are my codes to connect PPC with the database on my PC with sql server 2005. But when I cick the button1, the error with "SQL Server does not exist or access denied." Any ideas? Thanks a lot.



Imports System.IO

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports System.Drawing

Imports System



Public Class Form1

Dim strConnection As String = "Server=localhost;Integrated Security=SSPI;database=AdventureWorks"

Dim strQuery As String

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

Label1.Text = "Hello, Clicking after."



ReadOrderData()

End Sub



Private Sub ReadOrderData()

Dim queryString As String = "select * from Person.Address where AddressID < '10'"

Using connection As New SqlConnection(strConnection)

Dim command As New SqlCommand(queryString, connection)

connection.Open()

Dim reader As SqlDataReader = command.ExecuteReader()

While reader.Read()

MsgBox(String.Format("{0}, {1}", _

reader(0), reader(1)))

End While

reader.Close()

End Using

End Sub

End Class

View 15 Replies View Related

Can We Generate Reports Out Of SSRS That Can Be Viewed On A Mobile Device?

Feb 14, 2008


Hi All,

Can we render a report directly on to a mobile device/ interface from SSRS?

View 6 Replies View Related

Merge Replication 32-bit IIS - 64-bit SQL Server 2005 -Windows Mobile 5 Device

Nov 15, 2006

We have setup a 32-bit IIS server on a 32-bit machine. Installed necessary SQL Server components (32-bit replication components). We have installed SQL Server 2005 64-bit SP1 with latest hotfixes on a 64-bit machine.

On the Mobile device we installed SQL Server 2005 Mobile.

When we start mergereplication the problem we have is error 28009 (An instance of the SQL Server Reconciler cannot be created) on the mobile device. I read allot about it, but still have a questetion.

Should this work?

I found the doc: SQL Server 2005 Upgrade Technical Resource Guide:
Note: If your upgrade involves SQL Server CE subscribers, you must perform additional actions on the IIS server. You will need to install SQL Server 2005 client connectivity components along with SQL Server Mobile Edition components on the IIS server. You will also have to replace sqlcesa30.dlll, sqlcerp30.dll, and all the replication components on the IIS server.

From this I conclude it should work or is the doc in error?

If it does not, what can we do?

32-bit SQL Server 2005 on the 64-bit machine should work. (Can a 64-bit SQL Server 2005 run alongside 32-bit SQL Server 2005?).

Beste regards,
Hans Mank

View 1 Replies View Related

0x80040e21 Error Running SQLCE 2.0 On Windows Mobile 5.0 Device

May 19, 2006

I have an SDF using SQLCE 2.0. When I run the app on a Pocket PC device running Windows Mobile 5.0 I get 0x80004005 and 0x80040e21 errors. The same app executes fine on PPC 2003.

The app is written in VC++ using and uses the SQLCE OLEDB Provider to access the SDF. It is complied with eVC 4.0


Any idea as to the problem?

View 5 Replies View Related

Problem With Sync O2 Mini With Windows Mobile Device Center

Sep 9, 2007



I use my Pocket PC XDA O2 mini for 2 years already and I don't have any problems when I sync it with my previous laptop which has Window XP operation system.

A few months ago, I bought a new laptop with Window Vista operation system, I could not sync my O2 mini with my PC. Then, I download Windows Mobile Device Center but my computer still could not recognize my O2 mini. My O2 mini has window mobile 2003 Second Edition Version 4.21.1088 operation system. Please let me know if you have any advices.

Thanks.

View 1 Replies View Related

Ensuring Database Is Updated In Mobile Device When Performing Merging

Jul 24, 2007

Hi,

I am using web service to synchronize data between SQL Server 2005 on a desktop and a SQL Server Mobile Edition on a mobile device.

Initially, when i added the data source to my mobile application, my .sdf only has 3 records. I am then supposed to retrieve 97 more records from the desktop server when my mobile application runs. After performing merging, I clicked (on my device emulator) on the .sdf deployed under my mobile application and the query analyzer showed all 100 records.

Does this mean my mobile database has been successfully updated with all 100 records? If not, how do I check that? The reason why I am asking this is that the file size of this .sdf with 100 records is still the same as the initial .sdf with only 3 records. How is this possible?

Am I missing anything or getting some concepts wrong? Please enlighten. Thanks.

View 4 Replies View Related

Query Performance Issue Of Sql Server 2005 Mobile Edition On Device

Jun 28, 2006

Executing a select query with left outer joins etc takes .53 seconds to execute on sqlce 2.0.

Same query on sql 2005 mobile ed. takes 11 minutes .

on database having same data.

Sample query

SELECT routes.location,routes.equipment_type, routes.contract_type,

routes.maintenance_interval,routes.bank_description,routes.Unit_Des,

routes.Unit_no,max(task_last_completed.date_completed)as date1,min(case when

task_last_completed.due_date is NULL then getdate()-1 else due_date end) as

due_date FROM routes left outer join tasks on tasks.model = routes.model and

tasks.eqtyp = routes.equipment_type inner join task_by_contract_type on

tasks.task_id = task_by_contract_type.task_id and

task_by_contract_type.contract_type = routes.contract_type and

task_by_contract_type.model = routes.model left outer join

task_last_completed on routes.unit_no = task_last_completed.equipment_Id and

tasks.task_Id = task_last_completed.task_Id WHERE routes.location LIKE

'S153825-01%' group by

routes.location,routes.equipment_type,routes.contract_type,routes.maintenanc

e_interval,routes.bank_description,routes.unit_des,routes.unit_no ORDER BY

routes.location, routes.bank_description, routes.Unit_Des

WHY????????????????

View 4 Replies View Related

IID_IDBDataSourceAdmin Error Trying To Create A Database Using Query Analyzer On A Mobile Device

Sep 25, 2007



Hi,

Please provide some help regarding the "Interface Defining Error: IID_IDBDataSourceAdmin" error while trying to create a SDF database using Query Analyzer on a Windows CE 5.0 mobile device (Symbol MC3000).

Error: 0x80004005 E_FAIL
Native Error: 28558
Description: SQL Mobile encountered problems when creating database [,,,,]

Param. 0: 0
Param. 1: 0

Param. 2: 0
Param. 3:
Param. 4:
Param. 5:

A list of (related) installed packages:

NETCFv2.wce5.armv4i.cab
sqlce30.dev.ENU.wce5.armv4i.CAB
sqlce30.repl.wce5.armv4i.CAB
sqlce30.wce5.armv4i.CAB


PS.
Basically I have developed a mobile application that programmatically creates the database, the code worked on a similar device (Win CE 50), trying to run the application on a new device resulted in database creation errors. I tried creating a test database manually .. and this is what I got.

Browsing MSDN or searching on the Forum did not help.

~Zarko Gajic

View 3 Replies View Related

Error Connecting To Localhost Site To View SQL Server Mobile Agent On Device

Feb 9, 2007

I have set up a locahost site in IIS using the "Configure Web Synchronization Wizard". One of the first test I was asked to do was to open a broweser and browse to http://localhost/MobileTest/sqlcesa30.dll

If all is well I should get a web page with the following line:

SQL Server Mobile Server Agent 3.0

But unfortunately I get an error stating :
"The server has encountered an error while loading an application during the processing of your request. Please refer to the event log for more detail information. Please contact the server administrator for assistance."

I checekd the Event log and found this error related the IIS launch process on my machine.

DCOM got error "Logon failure: unknown user name or bad password. " and was unable to logon .IWAM_Rataq in order to run the server:

where Rataq is the name of my machine. Could my IWAM_Rataq account be corrupted, my other sites on the machine work.

Infact if i put in a Test.htm page in the virtual directory MobileTest I am able to browse to the page.

Can the Account be re-set? is there another problem that I am not aware of. I have Norton Internet 2006 running could that be the reason? Could Norton be blocking the dll from loading? But the event log states it is a Account error.

Any ideas why this might occur? any help is always appreciated

View 1 Replies View Related

Backing Up To A Remote Network Device

Sep 14, 1999

I need to backup a remote Database to a local device. Does anyone know how I do this . How do I define a remote Network device/ what priviliges are needed
How I do set up the Backup job....

View 3 Replies View Related

Remote Tape Backup Device On SQL Server

Aug 7, 1998

Does anyone know if it is possible to have a tape device another server as a tape dump device on SQL. Instead on removing the tape drive and installing it locally ?!?

Regards

Jasper

View 2 Replies View Related

Xp_cmdshell & Remote Backup Device Issue

May 30, 2002

I want to set up remote backup device on "serverCentral" for 50 MSDE SQL2k servers so that they could use one backup to create(restore) any new customer databases. This way, I could keep one resource with many coming updating on procs and triggers...

I could create remote backup device with serverCentralackupackupdeviceName...

The problem is the remote device is "access denied" when I issued a "restore headeronly from backupDeviceName" sql query.

Neither I could issue xp_cmdshell 'dir serverCentralackup' --"Access Denied" from server49
Though I could dir serverCentralackup*.* from server49 command prompt.
It looks security permission is OK otherwise I could not dir from command line.
thanks for the help
David

View 1 Replies View Related

Question: Can I Synchronize The Mobile Device Which Has A SQL Server CE Database With The Access Database On The Desktop?

Sep 26, 2006

Dear All,
i have a question abt winCE 4.2 and SQL server CE.
i am using VB.net of Visual Studio 2005
My platform is using a PDA with winCE 4.2 and SQL server CE. The Host program is using dbf files on desktop side.


I got a problem of how to sync / read the sql CE data from a windows application.

so, i wanna ask,

1. any method to access the data from winCE data by windows application? or can i convert the sdf file to windows readable files? or any others?

2. Can i use a MDB to sync with SQL server CE?
can i synchronize the mobile device which has a SQL Server CE database with the Access database on the desktop?

last question,
3. is that windows CE .net 4.2 not support pocket access (cdb) anymore?

please help me out

View 1 Replies View Related

How To Open SDF File Stored On Windows Mobile Device From A Windows Desktop App?

Apr 14, 2008

Long story short -

Have two C# applications - one WinForms desktop app, the other a WinForms smart device app. Both use SQL Server Compact CE 3.5 to store data locally. Both work just fine.

Now the desktop app needs to open and update the .SDF file that is stored on the Windows Mobile device. (Device will be docked via USB.)

What format would the path to the .SDF look like that the WinForms application would need to specify in order to open it?

Thanks for reading.

View 3 Replies View Related

Can't Connect To Remote Sql 2005 From Mobile 5 Emiulator

Jun 6, 2007





m_strRDA_DBConnectionString = @"Data Source=servername;Initial Catalog=dbname;User ID=username;Password=goodpassword;Integrated Security =true; ";



Failure to open SQL Server with given connect string. [ connect string = ;Data Source=servername;Initial Catalog=dbname;User ID=username;Password=goodpassword;Integrated Security =true; ]



i used several format for servername (sql server name; machine name, IP adress and IPaddress with port number) but no able to connect..



can you tell me where /whatis the problem?



thanks

IFR



Note:

I can connect to sql 2005 database through other win C# program with no problem.

The same code with mobile 5 with sql 2000

I have no problem. Once I moved to sql 2005 (without and with SP2 istalled) .

I can access the http://ipaddress/MobileDeviceApp/sqlcesa30.dll via the mobile browser no problem.





stack list:

at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()

at System.Data.SqlServerCe.SqlCeRemoteDataAccess.Pull()

at MobileDeviceApp.RDAForm.btnRDAGetData_Click()

at System.Windows.Forms.Control.OnClick()

at System.Windows.Forms.Button.OnClick()

at System.Windows.Forms.ButtonBase.WnProc()

at System.Windows.Forms.Control._InternalWnProc()

at Microsoft.AGL.Forms.EVL.EnterMainLoop()

at System.Windows.Forms.Application.Run()

at MobileDeviceApp.Program.Main()





the code for MobileDeviceApp.RDAForm.btnRDAGetData_Click()



if (File.Exists(m_strLocalDBFileName))

File.Delete(m_strLocalDBFileName);



SqlCeRemoteDataAccess pSqlCeRemoteDataAccess = null;

SqlCeEngine pSqlCeEngine = null;



try

{

pSqlCeEngine = new SqlCeEngine();

pSqlCeEngine.LocalConnectionString = m_strLocatConnectionString;

pSqlCeEngine.CreateDatabase();



pSqlCeRemoteDataAccess = new SqlCeRemoteDataAccess(m_strRDA_URL, m_strLocatConnectionString);

pSqlCeRemoteDataAccess.InternetUrl = m_strRDA_URL;

pSqlCeRemoteDataAccess.LocalConnectionString = m_strLocatConnectionString;



pSqlCeRemoteDataAccess.Pull("tb1", "SELECT id1, name FROM tb1", m_strRDA_DBConnectionString);

lblMessage.Text = @"Done";



}

catch (Exception oException)

{

lblMessage.Text = "Error: " + oException.Message;



}

pSqlCeEngine.Dispose();

pSqlCeRemoteDataAccess.Dispose();



lblMessage.Refresh();

View 3 Replies View Related

Connection Path OK On Device, Not On Desktop

Oct 3, 2007

This code...

string Path = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
// Create the connection fConnection = new SqlCeConnection("Data Source ="" + Path + "\TreeNotes.sdf" ;Password ="abcd1234";");
fConnection.Open();

...works on my device, but on my computer it gives SqlCeException with message:
The database file cannot be found. Check the path to the database. [ File name = Program FilesTreeNotesTreeNotes.sdf ]

I've tried all sorts of things, but the computer just can't find the database. I've even tried putting a copy of the database into...
C:Program FilesTreeNotesTreeNotes.sdf...hoping that the computer will find it there.

What am I missing?

View 12 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved