Showing posts with label mobile. Show all posts
Showing posts with label mobile. Show all posts

Tuesday, March 27, 2012

Data Source Problem in SQL server mobile edition

Hi,

I am using SQLCE and VS 2005 to create a database named "student.sdf" (inside my projects folder, of course). When click on the button, it will test for connection of database.
Everytimes I run the program, it will pop up an error message "The database file cannot be found. Check the path to the database. [File name = .\student.sdf]". How do I fix it?


Code Snippet

Imports System.Data.SqlServerCe

Public Class loginForm

Private _conn As SqlCeConnection


Private Sub ButtonLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonLogin.Click

_conn = New SqlCeConnection("Data Source =.\student.sdf")


Try
_conn.Open()

MessageBox.Show("Correct")

Catch ex As SqlCeException

MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand, MessageBoxDefaultButton.Button1)
Finally

_conn.Close()

End Try

End Sub

End Class







Did you try changing the current directory in debug settings?

Tuesday, March 20, 2012

Data Reinitialized When Filtered Column Changes

Hello,
We have SQL2005 Server, SQL Mobile 2005 CF2.0 application. It seems that
when we mark Orders as complete on the server, it redownloads all
OrderDetails from the server down to the PDA, even though there are no
changes to this table on the server, and there are changes on the PDA that
should get uploaded.
We have 2 tables Orders and OrderDetails. We want only non-complete Orders
and their OrderDetails to filter down to the pda.
So we have a base filter setup on our Orders table like this:
SELECT <published_columns> FROM
[dbo].[Orders] WHERE [Orders].[Completed] = 0 AND
[Orders].[OwnerContactID]=HOST_NAME()
Then we add a join filter to get OrderDetails for those Orders:
SELECT <published_columns> FROM [dbo].[Orders] INNER JOIN
[dbo].[OrderDetails] ON [Orders].[OrderID] = [OrderDetails].[OrderID]
Everthing works great most of the time, the problem is, when someone on the
server marks an Order as Complete, but there are still changes to
OrderDetails on the PDA, it generates conflict on OrderDetails. It does try
to upload from the PDA for OrderDetails, but they are filtered into a
conflict table, and the server wins. The OrderDetails table has not been
touched on the server, so I don't understand this. It's like the server
"sets" all the columns in OrderDetails when Orders.Completed is changed to
TRUE, and then the changes from the PDA are regarded as a conflict.
I don't think I understand how this works, and there probably is a reason is
for this. Any help or suggestions of a better way to do this, filter
Non-Complete items down without reinitializing the child data when that
filtered data changes, please let me know!
Thanks!
Are you using column level tracking? It seems that with column level
tracking this should work.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"nkleinjan" <nkleinjan@.discussions.microsoft.com> wrote in message
news:07D5DD6F-F0DF-4B4F-B1FB-C7CC3DE4F7D3@.microsoft.com...
> Hello,
> We have SQL2005 Server, SQL Mobile 2005 CF2.0 application. It seems that
> when we mark Orders as complete on the server, it redownloads all
> OrderDetails from the server down to the PDA, even though there are no
> changes to this table on the server, and there are changes on the PDA that
> should get uploaded.
> We have 2 tables Orders and OrderDetails. We want only non-complete Orders
> and their OrderDetails to filter down to the pda.
> So we have a base filter setup on our Orders table like this:
> SELECT <published_columns> FROM
> [dbo].[Orders] WHERE [Orders].[Completed] = 0 AND
> [Orders].[OwnerContactID]=HOST_NAME()
> Then we add a join filter to get OrderDetails for those Orders:
> SELECT <published_columns> FROM [dbo].[Orders] INNER JOIN
> [dbo].[OrderDetails] ON [Orders].[OrderID] = [OrderDetails].[OrderID]
> Everthing works great most of the time, the problem is, when someone on
> the
> server marks an Order as Complete, but there are still changes to
> OrderDetails on the PDA, it generates conflict on OrderDetails. It does
> try
> to upload from the PDA for OrderDetails, but they are filtered into a
> conflict table, and the server wins. The OrderDetails table has not been
> touched on the server, so I don't understand this. It's like the server
> "sets" all the columns in OrderDetails when Orders.Completed is changed to
> TRUE, and then the changes from the PDA are regarded as a conflict.
> I don't think I understand how this works, and there probably is a reason
> is
> for this. Any help or suggestions of a better way to do this, filter
> Non-Complete items down without reinitializing the child data when that
> filtered data changes, please let me know!
> Thanks!
>
>

Thursday, March 8, 2012

Data Mining with Mobile 5

Hello everyone!

I'm doing my final school project and i need to know if its possible to use SQL 2005 Data Mining with Mobile5 Applications. if yes, how or please give me references..

My idea its to build a king of Weka on mobile but using 2005 Microsoft Tools.

Thank You..

I'm not familiar with Mobile5 applications, but you should be able to use SQL DM from any platform using XML for Analysis.