Row number
Thu, 29 May 2008 06:58:11 -0700 (PDT)
Hi!
I'm using SQL Server Compact Edition 3.5 and I need to get row number
in my query. How can I do this?
Thanks for help! ...
|
How would you check what version of sql ce is installed?
Thu, 29 May 2008 12:26:25 +0200
Registry:
v. 3.1 (SQL Server 2005 Compact Edition)
[HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server Compact
Edition\v3.1]
v. 3.5
[HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server Compact
Edition\v3.5]
What about:
[HKEY_LOCAL_MACHINE\Software\Microsoft\.NETCompactFramework\Installer ...
|
Code generator supporting sql compact
Wed, 28 May 2008 19:50:06 -0700 (PDT)
Hello all:
We have several WinForms applications based on MySQL or Access or
SQLite that we are consolidating to sql compact. Our existing data
layer is... challenging.
I have been watching this group and searched without success for a
code generator that supports sql compact. Easy Objects and My
Generat ...
|
help with similar problem
Wed, 28 May 2008 19:05:13 -0700
hello there :)
i have a similar problem. i have changed the custom tool to MsResultSetGenerator. the database table displays on the emulator without problems. i tried all sorts of things to make the resultset updatable and scrollable. but it doesn't happen.
i copied your code for the partial class and pasted i ...
|
Database Restore failing
Wed, 28 May 2008 09:47:01 -0700
restore failed for server
system.data.sqlclient.sqlerror the tail of the log for the database has not
been backed up. use backup log with no recovery to backup the log if it
contains work you do not want to lose. use the with replace or with stopat
clause of the restore statement to just overwrite the content ...
|
Can not restore Sqlserver 2005 Database-I need help
Wed, 28 May 2008 02:54:02 -0700
When trying to restore to a database following error comes
"Restore failed for the server 'srver name'"
Additional Information:
System.Data.SqlClient.SqlError:The backup set holds a backup of a database
other than phase1 dayabase(Microsoft.SqlServer.Smo)
Can anyone help me in this topic?
...
|
Divide by Zero error when deleting rows. Bug#50002288
Tue, 27 May 2008 04:34:00 -0700
Does anyone know when/if a SP is going to be released for this issue? I
can't release a hotfix to a customer.
Thanks,
--
Rob ...
|
|
|
"The Table is not a tracked table"
Mon, 26 May 2008 21:26:01 -0700
Hi all,
When i am doing a rda push to sql server, i get this error message "The
Table is not a tracked table".
My question is where or how do i specify whether the table is a tracked
table or not? ...
|
Connection to a remote database
Sat, 24 May 2008 16:23:28 +0200
Can I connect to a remote SQL Compact database on an device when I know the
directory where the database is on the device and its IP address?
For example from management studio or a desktop application that I write my
self.
If yes how should the connection string be?
Thore Berntsen
...
|
truncate long string on insert into an nvarchar() column?
Fri, 23 May 2008 17:11:28 +0200
Env.: CF3.5, SQL CE 3.5
Hi All,
I have a table with an nvarchar(200) column. Occasionally, my app will try
to insert a new row with a text longer than 200 chars in this column. The
SQL command then returns an error. Is there any option to let it accept the
text and truncate it to the max length supported ...
|
