Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Pocket PC And SQL Server CE.


Hi,

How to replicate data from SQL Server CE (Pocket PC) to MSDE using C#
(data size = from 2 to 10 MB)?
--
*Best regards,*
Klaudiusz Bryja


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Pocket PC Remote Sql Server App
Hello-

I am interested in developing a remote Pocket PC database application with wireless connection to the database via the internet. Does anyone have experience in this? What is involved and what technologies are the best approach and why?

I think that SQL Server 2000 has some kind of stub program available for the Pocket PC for this purpose. This is my dream platform for remote sales applications with live data access to the company database at a remote location wirelessly.

I would appreciate any and all helpful input.

Thanks.

Vincent DeLuca
VDeluca7@aol.com

View Replies !   View Related
SQL Server 2005 Express Works With Pocket PCs?
Hello!
I am trying to find out if SQL Server 2005 Express Edition databases will work on a Pocket PC with Pocket PC 2003 SE OS. Does anybody know the answer or can direct me where I can find the answer?
Thanks!

View Replies !   View Related
Synching SQL Server Data On A Pocket PC And Windows?
I asked this question on another forum, and it was suggested that using SQL Server might be the way to go.

What I would like to do is create a database that can store detailed employee payroll information for workshop production. Included in this db would be employee info, job details, hours worked, pay rate, and so on and so forth. That will probably be the relatively easy part.

I would like to allow supervisors (job coaches) to enter this data on a Pocket PC (windows mobile) device, and then be able to synchronize the pocket pc to a workstation, allowing their data to be uploaded to the main database at the end of the day.

Can that be done using SQL Server as both the main networked database as well as having it (or a lite version of some sort) installed on a Pocket PC for synchronization purposes as described above?

Thanks for any input.

View Replies !   View Related
Sql Server 2005 && Pocket Pc2003Se Connection
 how do i connect to sql server with pocket pc2003 se emulator.it gives me the sql exception all the time.i tried to install virtual machine network adapter but result is same.Am i missing something?

 

Thanks in advance

View Replies !   View Related
Beginner Q: Pocket PC Access To SQL Server 2005
Hi,

  I am a total beginner to Pocket PC, and a 2-month beginner to SQL Server 2005 and Visual Studio 2005.  I made a database Pillbox.mdf, and wrote a Windows Forms program to access it.  It's really easy.  I just added a Data Source, chose tables and Stored Procedures, and dragged them onto my forms.  It automatically created adapter classes and a DataGrid for me.

  Next, I wanted to do the same thing for Pocket PC.  I did the same drag and drop thing, and was happy to see the empty DataGrid in the emulator (design-time) form.  From here on, trouble.  When I ran it, it said it could not connect.

  So some questions:

1) Does my connection string have to change?  It has 3 parts: machine name, database name, and security spec.  It specifies my machine name.  Is that ok?  Is it known by the Pocket PC, or do I have to specify http something?  Does my machine have to change any settings to become a "server"?  It's just a standalone PC with no network.  I understand the emulator chooses to pretend that it's not "on" my computer.  Is the database name known by the Pocket PC?  (Same type of question.)  And is Windows authentication ok on a Pocket PC?  Or must I create a name/password pair on SQL server?

2) When I went to modify my connection string, I noticed a setting to specify the Data source.  For SQL Server 2005, it asks me for a dbo, but for SQL Server Mobile, it asks me for a *.sdf file.  What type of file is this?  Is there a way to generate this from my other database?  Is it not possible to have the the Pocket PC app point to the same database as the Windows app?  Oh... does the sdf represent the Pocket PC's local database?  If so, then my question is just how to populate it.  But I will also have to update the main database at some point.  I guess I'm confused about how Pocket PC's are supposed to work.

3) Do I have to deploy SQL CE or something?  I think I read that Visual Studio does it automatically.  It's a bit hard reading blogs because many comments talk about things that are now contained in VS.  One blog was talking about 7 dlls that need to be downloaded to the Pocket PC.

4) My application just has to get a table, store it on the Pocket PC, and allow the user to modify and update records.  The bandwidth should be low, as the table is small and updates should not be frequent.  Is this a reasonable design?  What I am asking is if it's ok to have direct database access, or if I should package up the data in some custom format, and use a Web service to pass the data back and forth.  I have read and understood articles why you should not pass a Dataset in a web service, but the point was just that web services can be interoperable, so why spoil that with MS-only Datasets.  In my case, I just want to get this simple app up and running quickly.

Thanks in advance.

 

View Replies !   View Related
Connecting To Sql Server 2005 From Pocket Pc 2003 Emulator
Hi. I have a problem. I'm working at the moment on application witch should write and read data from sql server. The application should work on windows mobile devices. I'm linking this code to event on a button:





Code Block        private void menuItem1_Click(object sender, EventArgs e)
        {

            SqlConnection sqlCon;
            sqlCon = new SqlConnection(String.Format(@"Data Source={0};Initial Catalog={1};User ID={2};Password={3}",
                @"192.168.54.149sqlexpress", "MojDom", "kuba", "abuk"));
            sqlCon.Open();

            string insertString = @"insert into {0} values ('{1}', {2})";
            SqlCommand cmd;

            cmd = new SqlCommand(string.Format(insertString, "MojDom", "Kuba", 15), sqlCon);
            cmd.ExecuteNonQuery();


            if (sqlCon.State == ConnectionState.Open)
                sqlCon.Close();

        }



and on line sqlCon.Open() i get exception:




Code Block

System.Data.SqlClient.SqlException was unhandled
  Message="SqlException"
  Class=20
  LineNumber=0
  Number=6
  Procedure="ConnectionOpen (Connect())."
  Server="192.168.54.149\SQLEXPRESS"
  Source=".Net SqlClient Data Provider"
  State=0
  StackTrace:
    at System.Data.SqlClient.SqlConnection.OnError()
    at System.Data.SqlClient.SqlInternalConnection.OnError()
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
    at System.Data.SqlClient.TdsParser.Connect()
    at System.Data.SqlClient.SqlInternalConnection.OpenAndLogin()
    at System.Data.SqlClient.SqlInternalConnection..ctor()
    at System.Data.SqlClient.SqlConnection.Open()
    at AIHouse.FormMain.menuItemSettings_Click()
    at System.Windows.Forms.MenuItem.OnClick()
    at System.Windows.Forms.Menu.ProcessMnuProc()
    at System.Windows.Forms.Form.WnProc()
    at System.Windows.Forms.Control._InternalWnProc()
    at Microsoft.AGL.Forms.EVL.EnterMainLoop()
    at System.Windows.Forms.Application.Run()
    at AIHouse.Program.Main()
And when im using exactly the same code in windows console application everytihng works fine when i run it on pc with sql server and emulator, or other pc connect to network. I'm working on emulator of Pocket PC 2003, I've "put" it in cardle and the emulated device has connection to my pc and internet, the firewall is off.

I really dont have any idea why it's not working.

sorry for my english, but its not my foreign language.

thx for sugestions and reply.

regards Kuba

View Replies !   View Related
How To Migrate Data From Sql Server 2005 To Local Pocket PC?
Hi,

I have a database on a sql server 2005, and I would like to migrate data from sql server 2005 to local Pocket PC. How can I create a database on local Pocket PC and how to migrate the data from sql server 2005 to local Pocket PC? The operating system on Pocket PC is Microsoft® Windows Mobile„¢ 2003 Second Edition. Thanks in advance.

View Replies !   View Related
Microsoft SQL Server 2005 Compact Edition 3.5 And Pocket PC 2002
 

Is there any way to install SQL Server 2005 Compact Edition 3.5 on a Pocket PC 2002 mobile device.
 
Thanks,
 
Peter

View Replies !   View Related
Pocket Pc 2002 Sqlce Data Synchronization With Sql Server 2000 (SP4)
i am using C#..net

I  am synchronizing the sql server data with sqlce.but i get an
error when i call synchronize function. i am using sqlcereplication
class.

the error is

"a call to sql server reconciler failed"

native error 29006

and sometimes

native error

29045.

View Replies !   View Related
Sdf File Edited In SQL Server Managment Studio Crashes My Pocket Pc Application.
I have a sql server ce db file that I use in my pocket pc application. It seems to be working until I try to edit my .sdf file in SQL Server (2005) Managment Studio. After this I cannot open modified file in my application.
 
I receive native exception error when I call Open method for Connection object:
ExceptionCode: 0xc0000005
ExceptionAddress: 0x03f8aaac
Reading: 0x00000010
 
When I edit .sdf file in another pc it's all working.
 
My config is:
windows vista business
.net compact framework 2.0 sp2
sql server 2005
sql server 2005 compact edition
sql server 2005 compact edition server tools
sql server 2005 compact edition tools for visual studio 2005
 
Best regards
 
 
 
 

View Replies !   View Related
SQL Server Mobile 2005 Merge Replication Failing Over SSL, But Can Browse Through Pocket IE.
Hi All, this system is scheduled to go live in near to a day... but i have hit an issue when switching on SSL.  Any help would be greatly appreciated.
 
Device Env:
Windows Mobile 5.0 + Messaging and Security Feature Pack
SQL Server Mobile 2005.
 
Merge replication works fine without SSL.  After running the Configure Web Sync wizzard to setup SSL merge replication no longer works.  Note i checked using pocket IE by browsing to https://mycompany.com/pub/sqlcesa30.dll?diag and all worked fine.  There was no prompt saying the cert was bad etc.
 
The certificate is a:
Equifax secure global ebusiness CA-1 cert.
Signature algorithm md5RSA
public key RSA(1024 bits)
thumbprint algorithm sha1
 
Stacktrace given is:
-  ex {"A request to send data to the computer running IIS has failed. For more information, see HRESULT."} System.Data.SqlServerCe.SqlCeException
-  Errors {System.Data.SqlServerCe.SqlCeErrorCollection} System.Data.SqlServerCe.SqlCeErrorCollection
  Count 1 Integer
  Item In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user. System.Data.SqlServerCe.SqlCeError
  HResult -2147012858 Integer
  InnerException Nothing System.Exception
  Message "A request to send data to the computer running IIS has failed. For more information, see HRESULT." String
  NativeError 28037 Integer
  Source "Microsoft SQL Server 2005 Mobile Edition" String
  StackTrace "at System.Data.SqlServerCe.NativeMethods.CheckHRESULT()
at System.Data.SqlServerCe.SqlCeReplication.Synchronize()
at MyApp.Helper.Replication.SynchronizeInit()
at MyApp.CallSynchronize()
at System.Windows.Forms.Control.OnGotFocus()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.ContainerControl.WnProc()
at System.Windows.Forms.Form.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at MyApp.Program.Main()

View Replies !   View Related
Need Help On A Visual Basic.net Pocket Pc App. With SQL Server CE 2005 And SQL Server 2005 Synchronization Problem
 

Hi,
I am developing an application for pocket pc 2003 smart device which utilizes synchronization between SQL CE 2005 and SQL server 2005 by means of REMOTE DATA ACCESS method call PULL( ) and PUSH( ) but currently these are the details of the error Im encountering when PULL( ) method is called:

 
Error code: -2147467259
Descripion: An error occured on the computer running IIS.Restart the IIS server.

Minor error: 28022
Source: SQL server CE
Currently Im developing this application as a final project and due to some limitations I have setup my pc to act as the SQL server and the IIS server both on the same machine.
 
Any help will be appreciated, thanks.

View Replies !   View Related
Printing From Pocket PC
Hi,

I am developing an applicaiton through which, i want to print from pocket pc emulator 2003. I am using PrinterCE.NETCF SDK to do this task. I am able to print from my applicaiton like we do in ASP (Printing one line at a time). In PrinterCE, there is an option of printing the output to a file. But, I am not able to find how we do it.

So, I want to know how we can print the output through PrinterCe into a file. Can anybody help me??

thanx and regards
ramesh chandra

View Replies !   View Related
MSSQServer 2000 For Pocket Pc
Hi to all.
I have a windows ce mssqlserver 2000 version.
I have writted a java application and i needed a database connection.
I wish a driver for execute the connection to mssql server 2000 into pocket pc.

The connection string that i use is

connessione = DriverManager.getConnection("jdbc:microsoft:sqlserver://localhost:1433;databasename=A&MMobile", "sa", "sa");

Ok?

Which are the driver that i needed?

Thanx,

Simona

View Replies !   View Related
Can't Open .sdf DB On Emulator (Pocket PC)
Hi,

I'm a developer of VB.NET mobile applications at work.  We have used Access in the past, and manually pushed flat files to and from the scanner.  We are now exploring SQL CE.

Trouble is, I am having a difficult time figuring out how to open SQL CE databases on the Pocket PC emulator.  I've worked more on the middleware programs in the past - and have just dealt with ADO.NET connection strings - not the actual development on the scanner itself. 

I am try to figure out how to actually connect to SQL Server CE on the Pocket PC 2003 SE emulator. 

When I deploy the application on the emulator, it installs SQL Server CE onto the emulator.  However, I'm not sure how to install the sample database (starting off with Northwind.sdf for testing purposes) onto the emulator.  I'm also not positive the connection string is correct - as it seems to be different than typical ADO.NET. 

Here's my code (for connecting to the database) so far.





Code Snippet

Public Class SampleInventorySystem

    Private _conn As SqlCeConnection
    Public Sub New()

        ' This call is required by the Windows Form Designer.
        InitializeComponent()


   _conn = New SqlCeConnection("Data Source = .Northwind.sdf") 'This is one of 'many connection strings I've tried


       
    End Sub
    Private Sub SampleInventorySystem_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
       

Dim cmd As New SqlCeCommand()


            cmd.Connection = _conn
            cmd.CommandText = "SELECT [Employee ID], [Last Name], [First Name], Photo FROM Employees"




        Try


            _conn.Open()
        Catch ex As Exception
            MessageBox.Show("Error opening database", "Error")
        End Try

    End Sub

End Class
When I deploy the application, the Try Catch block catches the error "Error Opening Database".  I've also tried putting the full path for the connection string.  Is there a folder which I should directly put the .sdf file into the emulator - similar to the folder directory of the scanner? (i.e. Storage Card/...)

Thanks for your help!

View Replies !   View Related
Syncronize Pocket Pc, VB.net And Ms Access
I have developed an application using visual studio 2005 and I am trying to figure out how to store the data on the pda and sync it with a dadabase on the pc. we have a database server but it is only have sql server 2000. i have only been able to find instruction for sqlserver 2005. can anyone help.
 
thank you
Tony

View Replies !   View Related
Creating Mobile Database On Pocket Pc
Does anyone know a site that shows me how to develop a mobile databasesystem on the pocket pc? im a newbie to mobile databases. Thank you.regards,eugene

View Replies !   View Related
Urgent: Drop Database On Pocket PC
Hi,

Any body please give me any reference to the C# code, how to drop a database on SQL SERVER CE.

thanx and regards
ramesh chandra

View Replies !   View Related
Pocket PC Application Cannot Push Data
 I have a Pocket PC application (VS2005, SQLCE 2005, Windows Moblile 5.0, SQL Server 2000)  that can pull data with no problem but produces an error when an RDA push is attempted.  The error message is: Error Code: 80072EE4 Minor Err: 28037.  The information in TechNet has description of : A request to send data to the computer running IIS has failed. For more information, see HRESULT.  It does produce a log in the folder for SQLCE 3.0 and has the following message: Hr=80070585 ERR:REQUEST NOT QUEUED for ulRSCBId =  -1.  Not sure if this means anything because I can't find much information on it.  Anyone have any ideas on what this could be?  Do I display the HRESULT the message mentions in Visual Studio debug?  We have this working on our development server so I am not sure what is different here.

View Replies !   View Related
Problem Regarding Windows Mobile And Pocket Pc
 

we are using windows ce5.0 smartphone ,it is working fine but here the problems is the values which we are entering in front end are not inserting into database.i will  clearly explain what we have done.

                                                  we have taken a dataadapter from dataset.xsd.we configured select and insert statements through wizard,now we are creating instance for that particular adapter and calling inser method by passing values.  
 mobiledbDataSetTableAdapters.labinformation1TableAdapter ins = new testing.mobiledbDataSetTableAdapters.labinformation1TableAdapter();
ins.InsertQuery("B", Convert.ToInt32(txt_nb.Text), Convert.ToInt32(txt_pb.Text));
alternatively we have taken the dirrect metheod i.e
SqlCeConnection con1 = new SqlCeConnection("Data Source=" + (System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase) + "\mobiledb.sdf;Persist Security Info=False"));
con1.Open();     string stra;
stra = "INSERT INTO labinformation VALUES(getdate(),'A'," + Convert.ToInt32(txt_na.Text) + "," + Convert.ToInt32(txt_pa.Text) + ")";
SqlCeCommand cmd = new SqlCeCommand(stra, con1);SqlCeTransaction Trans = null;
Trans = con1.BeginTransaction();
cmd.ExecuteNonQuery();
Trans.Commit(CommitMode.Immediate);
now we are taking a data grid with data source from dataset.xsd,another dataadapter(select stament).the problem is


the values are not inserting into database but showing in datagrid

if we close and open the application datagrid is not displaying what we it has displayed previously
 
 
Thanks&Regards
Praveen..

View Replies !   View Related
Unable To Call SQL View From Pocket Pc
 

When I try to do a pull using a view I'm getting the following error message:

 

€œThe query cannot be tracked. There might not be a primary key, or the query might involve multiple tables. [ Query string = SELECT * FROM DATABASE_NAME.viewname ]€?

 

but when I do a select col1 from view I get my data. The view has some inner joins included in it, could that be the issue?

 

NOTE: this is from my handheld device, its not SQL Server related. I posted this earlier in this forum but it was moved to SQL Server.

I get the error on my handheld device and handheld device only

View Replies !   View Related
[Ask]Getting Files From Pocket Pc Emulator To Desktop Pc
hi...!
I'm creating a small device application using visual studio.NET 2003. Is it possible to get a sql server ce database file (.sdf) that i created at the pocket pc emulator to my desktop pc ?
If that's possible, then can you tell me how to do that ??

thanx b4

View Replies !   View Related
¿Data Transfer Pocket PC &&<--&&> Desktop PC?
Hi,everyone!

I'm new to this forum and also new to Visual Studio 2005 .NET.

I'm going to develop a pocket pc(windows mobile 2005) application which needs to save some data introduced by the user.Later that data should be syncronized with MS SQL Server database.

The application is going to be developed using Visual Studio 2005 with c#.

So I'm doubting wich is the best way of syncronising the data between Pocket Pc and a Desktop PC.Should i use MS SQL Server Mobile(RDA,Merge Replication) or XML(Xml Web Services) would help me better?Or is there any other better way of data syncronization/storage?

Could anyone help me,or post some links + code samples,please?

Thanks!

View Replies !   View Related
Problem On Running Replication On Pocket Pc
hi i tried to view a replication on a pocket pc app that i created. and i used the following code

private void Sync()
        {
            public string AppPath =     System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
            SqlCeReplication repl = new SqlCeReplication();

            repl.InternetUrl = @"http://naomi/sqlmobile/sqlcesa30.dll";
            repl.Publisher = @"Naomi";
            repl.PublisherDatabase = @"SQLMobile";
            repl.PublisherSecurityMode = SecurityType.DBAuthentication;
            repl.PublisherLogin = @"sa";
            repl.PublisherPassword = @"<...>";
            repl.Publication = @"SQLMobile";
            repl.Subscriber = @"SQLMobile";
            repl.SubscriberConnectionString = @"Data Source=""" + AppPath + @"SqlMobile.sdf"";Max Database Size=128;Default Lock Escalation =100;";
            try
            {
               repl.AddSubscription(AddOption.ExistingDatabase);
               repl.Synchronize();
            }
            catch (SqlCeException e)
            {
               MessageBox.Show(e.ToString());
            }

when i run it i keep on getting the error:
The SQL Mobile Subscription already exists. Publisher, PublisherDatabase, and Publication for this subscription should be different from any existing subscription.

However, i can still view the contents of the datagrid that refers to the database subscription.

1. What should i do in order to stop getting the error above?
2. If i edit the contents of the datagrid in the pocket pc app how will i update the replication in the sql server? thanks

View Replies !   View Related
Pocket Pc Mssql Remote Database Admin
Hi,I am working on an Open Source pocket pc remote databaseadministration utility using C# (i.e. the native .Net CompactFramework, not the opennetc).Anyway, i wanted to ask that does this application has some potentialor i am putting my free time to waste ;)BTW the application has started to take shape and you can have a lookat http://www.pocketsqlman.com for a brief outline of what the wholeidea is.Regards,Dheeraj Juneja

View Replies !   View Related
Porting Database Functions From WM 5 Pocket PC To WIN32
Hi all,

I'm working on porting a solution running under WM 5 Pocket PC to Win32 but I got some problems with type definitions like CEOID, CEGUID... I saw that these types are defined  in windbase.h (EDB definition added to preprocessors) ) which includes types and definitions usefull for database managment. Anyway this header file is not present in C:Program FilesMicrosoft Platform SDK for Windows Server 2003 R2Include, so I was wondering which is the header file I can use instead of it. Thanks

View Replies !   View Related
Performing Insert / Update Queries Using Pocket PC / SQL CE
I'm writing an application for Windows Mobile 5 / Pocket PC using VB.NET 2005.  The database is connected using an instance of SqlCeConnection and updated by an SqlCeCommand.

The application can perform select queries on data originally entered into the database through Visual Studio, or perform update / insert queries at run time.  Anything inserted or updated can be returned by a select query whilst the application is running, however, anything I have inserted or updated doesn't appear to be written to the SDF file and hence is not in the database after restarting the application.

Am I missing something that's different between performing queries on an SQL CE database on Pocket PC and an ODBC source in a normal Windows application?

View Replies !   View Related
How To Develop Today Screen Plug In For WM5 Pocket PC
Hi, anybody help me how to develop Today Screen plug in for WM5 pocket pc.

View Replies !   View Related
How To Start Develop Database Applicaton On Pocket Pc ?
i have install vs2005 and wm5 sdk on my pc. i want to develop database application on my pocket pc (database = sqlserver 2005 express)

- i need to install another software on my pc or pocket pc ?
- how to start develop database application on my pocket pc?

thank you

View Replies !   View Related
Can Not Connect To Desktop Sql Database From Mobile Device (Pocket PC)
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 Replies !   View Related
How To Connect With SqlServer 2000 In Pocket PC 2003 Application.
How to Connect sqlServer 2000 in Pocket PC 2003 Application.
In Packet PC 2003 Application I have to connect to sql server 2000 on
my machine. The application gives error if connected using sqlConnection. Is SQL server CE necessary to connect to sql server 2000 in .Net Compact Framework?

View Replies !   View Related
Cannot P/Invoke SQLCEME30.DLL When Debugging Pocket PC 2003 SE Emulator
I'm trying to debug an assembly with System.Data.SqlServerCe - and when I deploy to a IPAQ 2210 - I get no errors! Alas, when I try to debug using the Pocket PC 2003 SE Emulator - I get the "cannot P/Invoke SQLCEME30.DLL" exception.

Can anyone offer directions?

best regards,
Walther

View Replies !   View Related
Accessing SQL Mobile Databases In VB2005 - Pocket PCApp
I am using VS 2005 to develop a Pocket PC 2003 application and for some reason I dont have the ability to assign my datasource to a SQL Mobile Database? 

When opening Server Explorer, right clicking Data Connection, Add New Data Source, Change Data Source, the only options I get are

Microsoft Access Database File
Microsoft ODBC Data Source
Microsoft SQL Server
Microsoft SQL Server Database File
Oracle Database
<other>

I was trying to follow the tutorial



Step by Step: Developing a SQL Mobile Application with Visual Studio 2005
and SQL Server 2005 (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppcgen/html/med302_msdn_sql_mobile.asp)
and in that tutorial when they do the exact same thing it shows a screen shot that also lists 'Microsoft SQL Server Mobile Edition'

Any ideas why I dont have that option?  FYI, I have SQL Server 2005 and have installed SQL Server 2005 Mobile Edition.

Thanks

Mike

View Replies !   View Related
Does The DAAB SqlCeDatabase Class Work On Windows Mobile 5 (Pocket PC)?
Hi All,Does any one know whether I can use the newly released DAAB update for SQL Server Compact Edition assembly to access .sdf files on a Windows Mobile 5 device?I just starting playing with "Enterprise Library 3.1 - May 2007" because of the Sql Server Compact Edition support, but ran into issues when trying to run my app on my Dell Axim X50 (Windows Mobile 5). It seems the SqlCeDatabase project references desktop .NET assemblies (System.dll, System.XML.dll, System.Data.dll) located and not the CE based ones. When I run my app on the pocket pc, I get the following error:An unhandled exception of type 'System.TypeLoadException' occurred in MobileDesignRepository.exeAdditional information: Could not load type 'Microsoft.Practices.EnterpriseLibrary.Data.SqlCe.SqlCeDatabase' from assembly 'Microsoft.Practices.EnterpriseLibrary.Data.SqlCe, Version=3.1.0.0, Culture=neutral, PublicKeyToken=DFE7C825CCFDFC7D'.Also, DAAB SqlCe uses the desktop 'DataSet' class and not the CE one. Is it really only meant to access .sdf files from the desktop?Can anyone give me a definitive answer on this?Thanks a bunch,ealimam

View Replies !   View Related
HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)
 

Hi all,

 

I am trying to access my SQL Server database through SqlCeConnection:

 

cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");
cecon.Open();

 


I am getting the following error:

 

System.Data.SqlServerCe.SqlCeException was unhandled
  Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
  HResult=-2147467259
  NativeError=25009
  Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
  StackTrace:
    at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at nddbpda.frmCeMain.frmCeMain_Load()
    at System.Windows.Forms.Form.OnLoad()
    at System.Windows.Forms.Form._SetVisibleNotify()
    at System.Windows.Forms.Control.set_Visible()
    at System.Windows.Forms.Application.Run()
    at nddbpda.Program.Main()

 

 


When I tried to get the path from which the database file is being accepted, I got a different path:

 

string path;
path = System.IO.Path.GetDirectoryName(
System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);
MessageBox.Show(path);
 

 

 

This code gives me this path:

 

Program Filesddbpda

 

 


Then I changed the path in my connection string to this:

 

cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");
cecon.Open();

 

 


 When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

 

 

What should I do now to correct this?

 

Thanks in advance.

 

Saswata.

View Replies !   View Related
HELP: SqlCeConnection Path Error In .NET Compact Framework (Pocket PC Emulator)
 

Hi all,

 

I am trying to access my SQL Server database through SqlCeConnection:

 

cecon = new SqlCeConnection("Data Source=D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf");

cecon.Open();

 

I am getting the following error:

 

System.Data.SqlServerCe.SqlCeException was unhandled
  Message="The path is not valid. Check the directory for the database. [ Path = D:\D_Drive\csharppract\nddbpda\nddbpda\nddbpdadatabase.sdf ]"
  HResult=-2147467259
  NativeError=25009
  Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider"
  StackTrace:
    at System.Data.SqlServerCe.SqlCeConnection.ProcessResults()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at System.Data.SqlServerCe.SqlCeConnection.Open()
    at nddbpda.frmCeMain.frmCeMain_Load()
    at System.Windows.Forms.Form.OnLoad()
    at System.Windows.Forms.Form._SetVisibleNotify()
    at System.Windows.Forms.Control.set_Visible()
    at System.Windows.Forms.Application.Run()
    at nddbpda.Program.Main()

 

 

When I tried to get the path from which the database file is being accepted, I got a different path:

 

string path;

path = System.IO.Path.GetDirectoryName(

System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase);

MessageBox.Show(path);

 

This code gives me this path:

 

Program Filesddbpda

 

 

Then I changed the path in my connection string to this:

 

cecon = new SqlCeConnection("Data Source=\Program Files\nddbpda\nddbpdadatabase.sdf");

cecon.Open();

 

When I ran my application it worked (virtually), but the database is not getting updated (for obvious reasons).

 

 

What should I do now to correct this?

 

Thanks in advance.

Saswata.

 

 

View Replies !   View Related
Creating And Deploying Sql Mobile Database In Pocket Pc Without Using Merge Replication And RDA
Hi,

I am developing a application where the database needs to be deployed from the central database server which is sql server 2005, and we have only few fields and few new tables which need to be deployed into pocket pc using sql mobile from sql server 2005. We would like to design the database in sql server 2005 for mobile, which will be only structure and will be deployed into PDA using web service.

Could anyone help on the above problem?

View Replies !   View Related
RDA - Vb 2005 App - Desktop &&amp; Pocket Pc Emulator - Error: 80072F76 Native Error: 28035
RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76   native error: 28035

PDA info:
                .NET CF 1.0 env-string...
                MS SQL client
                MS SQLCE 2.0 dev
                MS SQLCE 2.0

DESKTOP info:
    Microsoft SQL Server Management Studio Express        9.00.2047.00
    Microsoft Data Access Components (MDAC)            2000.085.1117.00    
                                                                                      (xpsp_sp2_rtm.040803-2158)
    Microsoft MSXML                                                        2.6 3.0 6.0
    Microsoft Internet Explorer                                            6.0.2900.2180
    Microsoft .NET Framework                                           2.0.50727.42
    Operating System                                                            5.1.2600

copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip
modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
  <DatabaseServer>192.168.1.89</DatabaseServer>
    <DatabaseName>D1Temp</DatabaseName>
    <DatabaseLogin>sa</DatabaseLogin>
    <DatabasePassword></DatabasePassword>
  <SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
  <LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect>
   
  <LocalDBLocation>My Documents</LocalDBLocation>
    <LocalDBName>MyFav.sdf</LocalDBName>
  <IISLogin>192.168.1.89/Jason</IISLogin>
  <IISPassword>batman2005</IISPassword>
</Configuration>

error is "Header information is either corrupted or missing. [,,, header name,,]"

have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?

View Replies !   View Related
Error Inserting Image Into SQL Server2000 Table From Pocket PC Application Only When Using Stored Procedure In Table Adapter Wiz
My Pocket PC application exports signature as an image. Everything is fine when choose Use SQL statements in TableAdapter Configuration Wizard.
 

main.ds.MailsSignature.Clear();

main.ds.MailsSignature.AcceptChanges();
 

string[] signFiles = Directory.GetFiles(Settings.signDirectory);

 
foreach (string signFile in signFiles)

{


mailsSignatureRow = main.ds.MailsSignature.NewMailsSignatureRow();

mailsSignatureRow.Singnature = GetImageBytes(signFile); //return byte[] array of the image.

main.ds.MailsSignature.Rows.Add(mailsSignatureRow);

}
 

mailsSignatureTableAdapter.Update(main.ds.MailsSignature);
 
But now I am getting error "General Network Error. Check your network documentation" after specifying Use existing stored procedure in TableAdpater Configuration Wizard.
 

ALTER PROCEDURE dbo.Insert_MailSignature( @Singnature image )

AS

SET NOCOUNT OFF;

INSERT INTO MailsSignature (Singnature) VALUES (@Singnature);



SELECT Id, Singnature FROM MailsSignature WHERE (Id = SCOPE_IDENTITY())
 
For testing I created a desktop application and found that the same Code, same(Use existing stored procedure in TableAdpater Configuration Wizard) and same stored procedure is working fine in inserting image into the table.
 
Is there any limitation in CF?
 
Regards,
Professor Corrie.

View Replies !   View Related
Memory Configurations For SQL Server 2005 EE X64 With SQL Server 2000 EE X32 On Windows Server EE X64 Server
My server is a dual AMD x64 2.19 GHz with 8 GB RAM running under Windows Server 2003 Enterprise Edition with service pack 1 installed.  We have SQL 2000 32-bit Enterprise installed in the default instance.  AWE is enabled using Dynamically configured SQL Server memory with 6215 MB minimum memory and 6656 maximum memory settings.

I have now installed, side-by-side, SQL Server 2005 Enterprise Edition in a separate named instance.  Everything is running fine but I believe SQL Server2005 could run faster and need to ensure I am giving it plenty of resources.  I realize AWE is not needed with SQL Server 2005 and I have seen suggestions to grant the SQL Server account the 'lock pages in memory' rights. This box only runs the SQL 2000 and SQL 2005 server databases and I would like to ensure, if possible, that each is splitting the available memory equally, at least until we can retire SQL Server 2000 next year.  Any suggestions?

 

View Replies !   View Related
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql
 
Hi,
 
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
 
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
 
Thanks.
 

View Replies !   View Related
How To Move Sql Server 2000 Database From One Server Box To Server 2005 On Another Server Box Sql?
Hi,
 
We have an old machine which holds SQL server 2000 database. We need to migrate a whole database to a new machine which has SQL server 2005.
 
When we tried to move whole database using Import and Export Wizard, only tables can be selected to import/export. However we want to import/export the whole database, including tables, stored procedure, view, etc. Which tool should we use?
 
Thanks.
 

View Replies !   View Related
Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server Does Not Exist Or Access Denied
Hi,

When I am trying to access SQL Server 2000 database from another machine i got this error

Server: MSg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied

but I could access the database on same server and in that server i could access other databases in different server.

 

 

View Replies !   View Related
SQL Server 2000 Databases To SQL Server 2005? Enterprise Manager And Management Stuio At The Same Server?
When I proposed start to use SQL Server 2005 for new VS 2005 web sites, one of my co-workers responded that
we will update the old SQL Server 2000 databases to SQL Server 2005 when we are ready to use 2005 SQL Server.

Questions:
1. Any expected problems to upgrade old 2000 databases to new 2005 SQL Server?
2. I have installed both 2005/Management Studio Express and 2000/Enterprise Manager in my PC.  Any expected
    problems when running both 2000 and 2005 SQL Server at the same database server?
3.  What is the best configuration for running SQL Server 2005 when we have old 2000 databases?  Upgade or not upgrade?  

TIA,
Jeffrey

View Replies !   View Related
Query Analyzer Error Unable To Connect Server Local Msg17, Level 16,state 1/ODBC SQL Server Driver [DBNETLIB]SQL Server Does Not
I am getteing
need help
Query analyzer error Unable to connect server local Msg17, level 16,state 1
ODBC SQL server driver [DBNETLIB]SQL server does not exist

View Replies !   View Related
Can't Connect .Net Application From Windows Server 2003 To Database Server (SQL Server 2000)
Hi,
I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error.
Here is the error:
System.Data.SqlClient.SqlException: 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
 Here is the Environment:
App Server:
Windows Server 2003 Standard Edition
Inside Company's Firewall/ Network
Database Server:
Windows Server 2000 Advanced Edition
SQL Server 2000 SP4
Remote Connections to the Server is checked
Enable Protocols: Named Pipes & TCP/IP
TCP/IP Port: 1402 (I don't know why it isn't the default of 1433)
The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition.
I can ping the db server from the app server using the IP address.
I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server).
I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP?
What do I tell the network admin to change?
Any help would be appreciated.
Thanks,
Oran
 

View Replies !   View Related
Help! SQL Server Error - [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid Object Name ...
Dear all,On Win2000 server with SP3, I am trying to access a SQL Server 7.0database, "TestDB", from VB6 via a SQL Server ODBC system DSN using ADO2.7. In SQL Server Enterprise Manager, there is a login named "Tester".In its property window, NO "Server Roles" was assigned but its"Database Access" was set to "TestDB". This login was also made as theuser of "TestDB" with "public", "db_datareader" and "db_datawriter"selected as its "Database role membership". All the tables I am tryingto access in "TestDB" were created under "Tester".My code is like:Set conn = New ADODB.Connectionconn.Open "DSN=TestDSN;UID=Tester;PWD=test"Set cmd = New ADODB.Commandcmd.ActiveConnection = conncmd.CommandText = SQLset rs = cmd.Execute()If I set the SQL to something like "SELECT * FROM tbl_test", I alwaysget an error of "-2147217865" saying "[Microsoft][ODBC SQL ServerDriver][SQL Server] Invalid object name tbl_test". If I set the SQL to"SELECT * FROM Tester.tbl_test", everything runs properly. Could anyoneplease kindly advise why the first SQL is not working? Or in otherwords, why must I prefix the table name with its owner while the DBconnection is already made under that owner name? Thanks in advance.Tracy

View Replies !   View Related
Problem Occurs When Migrating A SQL Server 2000 Database To A SQL Server 2005 Server
When I try to migrate a database on a SQL Server 2000 server to a SQL Server 2005 server with the Copy Database Wizard of the SQL Server Management Studio, I'm confronted with the following problem;

Performing operation...

- Add log for package (Success)
- Add task for transferring database objects (Success)
- Create package (Success)
- Start SQL Server Agent Job (Success)
- Execute SQL Server Agent Job (Error)
 Messages
 * The job failed.  Check the event log on the destination server for details. (Copy Database Wizard)

When I take a look at 'Event viewer' on the SQL 2005 server, the following error is displayed;

InnerException-->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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I already enabled the MSSQLSERVER network configuration protocols (TCP/IP and Named Pipes ).

How do I solve this problem?

 

 

 

View Replies !   View Related
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.
My site works fine in VWD2008 express, but I get this error when I try to use it on my live website.
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. 
According to this article: http://support.microsoft.com/kb/914277  I am supposed to:




1.
Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
Ok, there is no such program in this folder.  The only thing in there is "SQL Server Error and Usage Reporting"...
 The other thing I am greatly concerned with is this:  All is want is for my webpages to be able to access my database for user authentication.  I DO NOT want to grant the internet rights to remote connect to my database.
 
 
 
 

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved