Possible To Connect To SQL Server Mobile Database

Sep 29, 2006

Is it possible to have a Windows applications (based on .NET Framework 2.0) connect to a SQL Server Mobile database?

I manually added the the System.Data.SqlServerCe.dll (retrieved from C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDK\SQL ServerMobilev3.0System.Data.SqlServerCe.dll) to my Windows Form project. When I start the app, it gives me an error message:

{"Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)":"System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"}

TIA

View 11 Replies


ADVERTISEMENT

Receiving Error 'SQL Server Everywhere Encountered Problems When Opening The Database' Trying To Connect To Mobile Sdf.

May 13, 2008

Using the following code we are having a problem connecting a clients WIndows Mobile device to the SDF under IIS. We have success elsewhere. Does anyone have any clues ?

Cheers Al

Dim repl As New SqlCeReplication()
Try
repl.InternetUrl = InternetUrl
repl.Publisher = Repl_Publisher
repl.PublisherDatabase = Repl_PublisherDatabase
repl.PublisherSecurityMode = SecurityType.DBAuthentication
repl.Publication = Repl_Publication
repl.Subscriber = Repl_Subscriber
repl.SubscriberConnectionString = Repl_SubscriberConnectionString
repl.DistributorLogin = Handhelds_User
repl.DistributorPassword = Handhelds_Password

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
MsgBox("Synched!")
Catch err As SqlCeException
MessageBox.Show(err.ToString, "Error")
Finally
Cursor.Current = System.Windows.Forms.Cursors.WaitCursor
End Try

View 3 Replies View Related

VS 2005 - VB.NET - Connect To Mobile SQL Database From Desktop PC

Jun 7, 2006

I want to physically move my .SDF file to my desktop and then access this file from VS 2005 VB.NET. Ideally, I would want to access this .SDF file from MS Access 2003 but I undersand this is not possible.

Here are my VS 2005 VB.NET statements....

Dim ConnPPC As New System.Data.SqlClient.SqlConnection("Data Source = C:Documents and SettingsG014436My DocumentsSQL

MobileActMgr6CE.sdf")

Dim mySqlDataAdapter2 As New SqlDataAdapter("select * from T0002_AE_Activity_Entry", ConnPPC)

mySqlDataAdapter2.Fill(myDataSet2)

On executing the last statement(fill)...I get the following error.

function failed: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

Does anyone have any suggestions?

View 6 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

Connect Sql Server Mobile With VS2005

May 9, 2007

I have a default SQL server 2005 setup on my machine.

There is a large database to whom i can connect.



I made my own data by Sql server Mobile on my local machine and then try to connect it

to the the application in visual studio 2005.



But it each time it gives that the port cannot be open.



I am a native client for SQL server.



Do we have any idea how wil i connect to database local to machine with the

application in Visual studio 2005 with C# language.



thanks



Prashant Gupta



The actual message i am getting



Microsoft SQL Native Client Version 09.00.2047

Running connectivity tests...

Attempting connection
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [53].
[Microsoft][SQL Native Client]Login timeout expired
[Microsoft][SQL Native Client]An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.

TESTS FAILED!



View 4 Replies View Related

Connect Object Explorer - SQL Server Mobile

Nov 23, 2006

Hi,

in Management Studio, for what purposes can i use the server type 'Sql Server mobile' in the menu Connect Object Explorer?

Thanks
SP

View 1 Replies View Related

SQL Server Management Studio Can Not Connect To SQL Server Mobile

Jan 19, 2008



My System: SQL Server 2005 Express, Microsoft SQL Server 2005 Compact Edition, Vista 64

---

Hello@all,

my Problem is i can not connect on Server Management Studio with my SQL Server Compact (local).

here is the message in German:


TITLE: Verbindung mit Server herstellen
------------------------------

Es kann keine Verbindung mit '(local)' hergestellt werden.

------------------------------
ADDITIONAL INFORMATION:

Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: Named Pipes-Provider, error: 40 - Verbindung mit SQL Server konnte nicht geöffnet werden) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=...=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

in the SQL Server Configutation Manage is all Protokoll Aktive, i habe testet with normal user Account and Admin Account... all not work...

Installet Software:
Microsoft SQL Server 2005
Microsoft SQL Server 2005 Compact Edition [DEU]
Microsoft SQL Server 2005 Compact Edition [DEU] Server Tools
Microsoft SQL Server 2005 Compact Edition Developer Software
Microsoft SQL Server Management Studio Express
Microsoft SQL Server Native Client
Microsoft SQL Server VSS Writer

Services running to SQL
SQL Server (SQLEXPRESS)
SQL Server VSS Writer
SQL Server-Browser

what is the problem here? please help me....

View 3 Replies View Related

Access SQL2005 MOBILE Database In A VS2003 Mobile App

Mar 6, 2006



It is possible to access a Sql Server 2005 Mobile database in a VS2003 application (compact framework) ?

Thanks

Robson

View 4 Replies View Related

SQL Server 2005 Management Studio Only Can Connect To 2005 Mobile Edition?

Jan 9, 2007

hi,

I have some SQL CE database .sdf file on my handheld, and I was trying to connect to that file via SQL Server 2005 Management Studio, and it does not work. I am wondering if there is any good tool that I can use on desktop to connect to sqlce .sdf database file on my handheld?

Thanks.

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

SQL Server Mobile Merge Replication Walkthrough, Cant Find The .NET Framework Data Provider For SQL Server Mobile Edition.

Sep 9, 2005

Hi,

View 3 Replies View Related

Upgrading Sqlce 2.0 Database To Sql Server For Mobile Database On Desktopn

Oct 23, 2007

can we upgrade a sqlce forgotten password database to sql server for mobile database on our desktop


Thanks & Regards
Mukesh Gupta

View 1 Replies View Related

Connect To SQL 2005 Mobile Edition

Apr 30, 2007



Hi,

I already have SQL Express Edition... i installed SQL 2005 Mobile Edition..
how could i connect to the mobile edition so i can design my DB?

View 5 Replies View Related

SQL Server Mobile Database

Aug 21, 2007


I am have set up a Smart Device €“ Windows Mobile 5.0 Pocket PC €“ Device application.
I need to connect to & populate a listview control but:-
I am having trouble connecting to my Microsoft SQL Server (sqlClient) database.
Do i need to set up & use SQL Server Mobile database.

View 1 Replies View Related

RDA And Sql Server Mobile Database

Jan 6, 2006

hi all

in the wireless application, if i use RDA to pull data from SQL server 2005 database.

do i need to code a exernal class for the PDA to connect to the sql server.

RDA pull data trough what medium, wireless or active sync, if i wanna pull data through wireless what should i do.

By the way, how to i create a database in PDA by using sql server mobile?

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

SQL Server Mobile 2005 Merge Replication Problem On Windows Mobile 5.0

Aug 8, 2006



Dear ppl,

I am writing an application for a device (MDA Pro T-Mobile) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.CreateDatabase);
repl.Synchronize();

I don't understand why I am having this error. It does create the database on AddSubscription() method but it is failing opening the database on Synchronise(). I have also tried uninstalling and then reinstalling all the SQL Mobile components in the following order.

-sqlce30.wce5.armv4i.cab
-sqlce30.repl.wce5.armv4i.cab
-sqlce30.dev.ENU.wce5.armv4i.cab

However, when i run this application on a device(Dell X50 AXIM) with Pocket PC 2003, it runs fine creating the database and sysnchronising it.

The target platform for the project is Windows Mobile 5.0 Pocket PC SDK.

Does any one have any clue what could be the problem ?

Regards
Nabeel

View 6 Replies View Related

SQL Database Synchronization With Server Mobile

May 8, 2007

Hi there,
I need to create a synchoronization with the Server Mobile (displayed in the Pocket PC emulator)  once the website (SQL server Database) is updated. Is there any coding available? How is it possible? PLSSSSS HELP ME....

View 2 Replies View Related

How Do I Drop Sql Server Mobile Database When ...?

Mar 15, 2006

How do I drop sql server mobile database at specifical time in my application in PPC?

And, How do I drop it when user input the worng password third times in my application in PPC?

Thank you very much.

View 4 Replies View Related

Problem Using SQL Server Mobile 2005 With Windows Mobile 5 Application

Mar 23, 2006

Hello,

I am developping a non-managed C++ application for PocketPC using a SQL Server mobile database.

The application is compiled for PocketPC 2003 and uses SQL Server Mobile v2. I use Visual Studio 2005. But I need to compile the application for Windows Mobile 5.0 devices. So I installed the WM5 SDK and had the WM5 into my project configuration.

The "ssceoledb.h" which I include incluses the "transact.h" file. But my problem is that this file is only provided with the PocketPC 2003 SDK and not in the WM5 SDK.
So I cannot use the WM5 configuration project with SQL Server. I also tried with the last SQL Server Mobile 2005 (ie v3.0) and the "ssceoledb30.h" also includes "transact.h".

Did I miss something to install ?
Do you know how I can resolve the problem ?

By advance, thank you for any answer.

--
Gregoire

View 9 Replies View Related

Cannot Build SQL Server Mobile Solution For Windows Mobile 5

May 18, 2006

Using MS VS 2005 (incl SQL Server Mobile)
MS Pocket PC 2005 SDK

I am working on a project that builds for Pocket PC on both Mobile 2003 and Mobile 5. The project uses/will use SQL Server Mobile to store local data.

Project created from new with support for both platforms. I include required header files ssceerr30.h and ssceoledb30.h.

Project builds fine in WM2003 configuration, release and debug.

When I build for WM5 the compiler cannot find the header file transact.h. This is included from within ssceoledb30.h. Same as under WM2003.

In WM2003 configuration if I highlight the ssceoledb30.h include in Visual Studio and open the header, it takes me to <Visual Studio dir>SmartDevicesSDKSQL ServerMobilev3.0. I then locate the include for transact.h and do the same, which takes me <Visual Studio dir>SDKPocketPC2003include. The file exists.

If I repeat the above 'browsing' under the WM5 configuration, ssceoledb30.h takes me to a different copy in the WM5 SDK directory. There is no diff between the file here and the other copy used by WM2003. If I attempt to open transact.h - file does not exist.

Fix (which I'm not too sure about, i.e. is it OK?) - If I copy transact.h to the WM5 SDK directory, the project builds.

Why has transact.h disappeared from WM5 SDK?
I can find no ref's to this problem anywhere. Is my installation of the WM5 SDK corrupt? What else could I be missing?
Is there a sample for SQL Server mobile (like the NorthwindOLEDB sample) that comes configured to build for WM5?

View 1 Replies View Related

SQL Server Mobile Tutorial And Getting Proper Mobile DB Installation

Apr 24, 2006

Hi folks, I'm new to Windows Mobile progamming, and new to this forum. Apologies in advance if I'm asking a boneheaded question, but I've done searches and can't find anything directly applicable to my problem.

I'm currently walking through the published MS tutorial in setting up an SQL Server 2005 Mobile application that subscribes to a publication on SQL Server 2005 to exchange information.

I've gotten almost all the way through... successfully set up the server components, creating the publication, etc. On the mobile side, I've been able run the cab files to install the SQL Mobile components and to create the project, add the reference to the dll, and instantiate an engine object. It compiles.

The step in the tutorial after that, though, where you specify the data source from the "data" menu, I've got a problem. When I try to use the "new connection" dialog from choosing the data connection, "MS SQL Server Mobile Edition" doesn't show up as a choice. I've tried choosing any of the other combinations, and in teh subsequent "Connection properties" section my database, SQLMobile (as in their sample) is available, but I get an error when I choose it and click OK. Clicking on "Test Connection" gives me a connection successful message.

My guess is that something about the Mobile server side components is not installed correctly on my development machine, but honestly I have no idea how to begin to fix it. Has anyone seen this problem before and know how to resolve it?

Your time and any knowledge sharing is greatly appreciated.
Thank you,
-Dana

View 8 Replies View Related

SQL Server 2005 Mobile: Problem With Connection To Database

Aug 3, 2006

Hi, everyone! I have a small problem.

It consists in:

1. I'm trying to connect to database on my Pocket PC within Visual Studio 2005 (C#)

Connection string looks like this:

SqlCeConnection1.ConnectionString = "data source = '\storage card\mobiluser.sdf'";

But when i'm deploying it to Pocket PC the error "An error message cannot be displayed because an optional resource assembly containing it cannot be found" appears.

2. When I'm doing te same on Pocket PC Emulator everything is normal.

Off course, I have the .sdf file on Pocket PC which is placed to Storage Card into root directory.

If anyone knows where I get a mistake, help me please!



Thanks for your help!

View 1 Replies View Related

SQL Server Mobile Encountered Problems When Opening The Database.

Dec 19, 2006

Hi,

I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
I also checked the the connection string and it seems to be fine. Both my device and server can ping each other. Moreever I can also access the Web syncronization folder(on server) from the device.Is anyone having a resolution for this?

View 3 Replies View Related

SQL Server Mobile Encountered Problems When Opening The Database.

Oct 30, 2007

Hello!
I'm trying to connect a sql ce database from a PPC with WM 2003 to a sql server 2005 database.

I discover the class SqlCeRemoteDataAccess, so i've been trying, unsucessfuly, to get things working.

I googled a lot, i read Ms Articles from MSDN, i read some posts here, but can't find solution for my problem. As you can see in my code, i already tryed different aprroaches, differente connections strings, with "provider", without "provider", with "sspi", without "sspi", you name it...

I configure the sql server agent like i read in msdn, and he's working well, i'm able to see the message. ("Microsoft SQL Server Compact Edition Server Agent" when i open the url).

The sql database credentials are correct, i already check that.

I did everything i knew and i read, unfortunately i still can't manage to find a solution for an error message:

"SQL Server Mobile encountered problems when opening the database." The native error is 28559


That's an Exception error message, that appears to me.

Can somebody help me?

Thank you!





Code Block
string connString = "Data Source=\My Documents\inv.sdf;Persist Security Info=False;";

string rdaOleDbConnectString = @"Data Source=server;Initial Catalog=mycatalog;Integrated Security=SSPI;User Id=myLogin;Password=myPasssword;";


public void ImportDatabase()
{

//rda.LocalConnectionString =@"Data Source=\My Documents\inv.sdf";
//rda.InternetUrl = "http://myserver/sync/sqlcesa30.dll";
//rda.InternetLogin = "myLogin";
//rda.InternetPassword = "myPassword";


SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess("http://server/sync/sqlcesa30.dll","myLogin","myPassword",connString);



try
{
// Try the Pull Operation

rda.Pull("localtable", "SELECT Cod, Name FROM People", rdaOleDbConnectString, RdaTrackOption.TrackingOnWithIndexes,"ErrorTable");


}
catch (SqlCeException exc)
{
// Handle errors here
//
MessageBox.Show(exc.Message + "-" + exc.NativeError);
}
finally
{
// Dispose of the RDA object
//
rda.Dispose();
}

View 1 Replies View Related

SQL Server Mobile Encountered Problems When Opening The Database.

Dec 19, 2006

Hi,

I am writing an application for a device (HP IPAQ 6828) having Windows Mobile 5.0 using

-MS .NET Compact Framework 2.0 SP-1
-SQL Mobile 2005.
-VS 2005 .NET

The application uses Merge Replication. The error occurs in the Synchronise() Method of the SqlCeReplication object.

"SQL Server Mobile encountered problems when opening the database."

repl.AddSubscription(AddOption.ExistingDatabase)
repl.Synchronize()
I
also checked the the connection string and it seems to be fine. Both my
device and server can ping each other. Moreever I can also access the
Web syncronization folder(on server) from the device.Is anyone having a resolution for this?

View 1 Replies View Related

SQL Server 2005 Mobile Edition ANd SQL Server CE - SHould I Have Uninstalled Mobile First ?

Sep 16, 2007



Hi:

When I try and connecto to SQL CE I always get an invalid operation exception. I"m afraid that I did not follow the proper install for Orcas Beta 2. I can't remember if I was supposed to uninstall SQL Mobile 2005 first or not.

All I know is when I try and use my SQL CE I can't connecto to a DB / sdf file ?

Any help would be appreciated I"m just starting to use SQL CE.

thanks
mark

View 2 Replies View Related

Creating A Mobile Application With SQL Server Mobile - FIX

Jul 21, 2006

This is a great tutorial and it's a shame one of the more important steps was missed.
In the €œCreate the snapshot user€? section you you find the steps to create the snapshot_agent account. Then in the €œCreate the snapshot folder€? section you find the share and folder permissions. However, at no point do the instructions advise you about adding the snapshot_agent to the SQL Server Logins. The result is that agent cannot perform the initial snapshot but you won't find this out until 50 steps later after Step 10 in the section  €œCreate a new subscription".
 
To get back on track, openthe Object Explorer's Security section and add the snapshot_agent to your logins. Then using the "User Mappings", set an appropriate level for the SQLMobile database role. Once completed you then need to run the agent.
 
Right-click the SQLMobile publication you created and select "View Snapshot Agent status". From that dialog you can select "Start" to run the agent. When it completes, you can return to the tutorial section "Create a new subscription" and continue with the tutorial.
 

 

View 4 Replies View Related

Creating A Mobile Application With SQL Server Mobile

Nov 3, 2007

I am studying the tutorial in SQL Server 2005 Mobile Edition Books Online, and the topic is Creating a Mobile Application with SQL Server Mobile. I have got a problem when creating a new subscription after created a new SQL Server Mobile database. And the problem is shown below:

New Subscription Wizard

- Beginning Synchronization (Success)

- Synchronizing Data (100%) (Error)
Messages
* Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.
HRESULT 0x80004005 (29061)

* 無法完�作業。


- Finalizing Synchronization (Stopped)

- Saving Subscription Properties (Stopped)

Before I have met this problem, I have finished all the task. And I can browse the localhost web site by using anonymous account even I use internet explorer or browse the directly in IIS.

Does anyone can solve it?? Thank you very much~~~

View 3 Replies View Related

How To Import Data Into SQL Server 2005 Mobile Edition Database?

Jan 5, 2007

There are any import/export utilities for SQL Server 2005 Mobile Edition database? Which edition of SQL Server 2005 can do this?

Or we must use publication/subscription to transfer data to the mobile database?

Thank you for your help!

View 6 Replies View Related

Transform sql Server Mobile Edition Database To Sqlce2.0 Format.

Apr 21, 2006

how do I transform sql server mobile edition database to sqlce2.0 format?

I have a database with sql server mobile edtion , and I want to depoly application to ppc with .net cf1.0, so , I must change format from sqlce3.0 to sqlce2.0.

Please.

View 7 Replies View Related

How To Add Data In Sql Mobile Database From Sql Server 2005 Management Studio

Feb 17, 2006



Hi,

After creating mobile database into sql server 2005 management studio, how to insert the records from sql server 2005 management studio into and mobile database from excel file?

Thank you

Prashant

View 1 Replies View Related

SQL CE 3.0 SQL Server 2005 Mobile Edition Database Password Problem

Dec 5, 2006

Hi,

I was wondering if someone could help me as this is a bit of a puzzle.

I have created a database using a password, the create table scripts are executed successfully using the connection string however when I try and use the same connection string to insert some data into the database an error is produced, with the following message 'The specified password does not match the database password'.

I have opened the database using the SQL Server 2005 Management Studio and provide the password and I can access the database without a problem.

When the connection object is first instantiated all the Connection String property, the connStr variable and the modifiedConnStr are all correct (by this I mean that the data source and the password are present). However when the connection object is accessed again the Connection String property and the connStr variable are both set incorrectly (by this I mean that the password= section of the string is missing) however the modifiedConnStr is set correctly (by this I mean that the password= section is present in the string).

The connection object does not get set in between creating and accessing the connection object.

I have resorted to using no password, however I really need to be able to use a password.

Here is a copy of the connection string I am using (Copied directly from the quick watch window):

"Data Source = '\Program Files\Application\DataBase\MyDatabase.sdf'; password="Pa55word";"

I am sorry this a little long winded however I would like to provide as much information as possible. I hope someone can help me with this problem.

Thank you for reading.

Paul Diston

View 4 Replies View Related







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