SSCE 2005 + Windows 98
Jun 22, 2007Does SSCE 2005 work in Windows 98 ??? If yes, How do I deploy my aplication with SSCE 2005 in Windows 98 ???
Thanks every one,
ADVERTISEMENT
Unable To Connect To SQL SERVER 2005 Database Engine Using Windows Authentication Under Windows Vista...
Mar 26, 2008Hallo there,
I just upgraded from Windows XP Pro to Windows Vista Bussiness and tried to reinstall SQL Server 2005 Developers Edition. After the installation i downloaded (using microsoft windows update) and installed all the service packs for sql and vista available.
My problem is when i open sql server management studio and try to connect to my default instance using windows authentication and database engine, an 18456 error occurs.
I enabled all the protocols and all the ports
I disabled windows firewall and antivirus (eset nod32)
I installed all service packs available
I have also installed Visual Studio 2005 without installing sqlexpress
But nothing happens!
Please i am very desperate, any information will be gratefully accepted.
This is my installation Information
Code Snippet
Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 6.0.6001.18000 (longhorn_rtm.080118-1840)
Microsoft MSXML 3.0 5.0 6.0
Microsoft Internet Explorer 7.0.6001.18000
Microsoft .NET Framework 2.0.50727.1434
Operating System 6.0.6001
Thank you in advance,
Patonios
C++ SSCE Example
Apr 4, 2007Hi
Does anyone have an example code in C++ to create a SSCE db and access data?
Many thanks
Ozzie
Merge Replication - SQL Server 2005, Windows Vista And MSVisual Studio 2005
Jul 11, 2007Hello everybody!
I hope that someone could help me.
I have a problem when i start sincronyzing with the emulator of MSVS2005 to SQL2005 in Windows Vista. I have the same program in the emulator, but sincronyzing with windows XP Pro and no problem...
I configure the connection to use the IUSR.
The source code that i use:
repl.InternetUrl = @"http://laptop/SQLMobileIIS/sqlcesa30.dll";
repl.Publisher = @"laptop";
repl.PublisherDatabase = @"database";
repl.PublisherSecurityMode = SecurityType.NTAuthentication;
repl.Publication = @"Pubdatabase";
repl.Subscriber = @"SQLMobile";
repl.SubscriberConnectionString = @"Data Source='" + nomeFicheiroBD + "';Password='3409'";
The error that returns is:
"Failure to connect to SQLServer 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"
Does anybody knows what i can do?
HELP I NEED SOMEBODY TO HELP!
Thanks!
2 Problem In SSCE
Jul 31, 2007hi,
this is my first post here, i am using Sql Server CE 2005 these days.
in a project i found 2 problem that can't find any solution for them till now , maybe there are some bugs i founded them
here is :
1- when i have a SqlCeCommand Object and the ComandText for it is "Update [Term] SET Year=? WHERE _id=? AND name=? "
the problem is in here , i added parameters for this command, if value of parameter is in Unicode ( i tested it in Farsi[Persian] language value like 'زمستان' on 'name' parameter) , in ExcuteNonQuery() method , it throws FormatException with "Input String was not a correct format".
although if i change the value of 'name' parameter to something non-unicode (for example i tested it with 'ABCDE' ) it works correctly,
i think SqlCeCommand in UPDATE query , have problem with unicode values in paramteres.
2- second one is so strange for me !! , i have a loop that update a column in a table. and then have another loop that update the next column of that table. for example first i update the column 3 in loop, then in another loop i update the column 4.
after all, the value of column 4 and 3 is substituted, it means that values that i updated for column 3 is in column 4 , and values that i updated for column 4 is in column 3 !!!!!!!
both columns is in 'int' type.
and the last point is i tested both of this situations in SQL Server 2000 Developer Edition and both worked correctly without any problem.
also i used SQL Server CE v3.1 with .Net framework 2.0 in Vs2005 and C#.
is there any missing i'v done or is it some kind of bugs.
Transactions In SSCE?
May 16, 2007We are looking into developing our application using SQL Server Compact and have created a test database to become familiar with the API. Having read about ACID transactions in SSCE we would like to know how this is actually employed. What will happen if a power failure occurs during a transaction? Does this have to be recovered in the code?
I have read the following article: http://msdn2.microsoft.com/en-us/library/csz1c3h7.aspx, but is this the best way to deal with transaction failures?
I can't find any examples on how to recover from failures in transactions in SSCE.
Any help would be greatly appreciated.
SSCE Transaction Log
Jun 11, 2007Hi,
Are there any pecularities of Transaction Logs in SSCE comparing to the same log in full scale SQL Server? How are they stored? And when they are considered to be expired in order to safely delete them?
Thanx in advance
Is It A Bug In SSCE OLEDB ?
May 18, 2007i'm use this code ,in SQL2005 std and ACCESS database, it work
but if i use SSCE ,it's throw a OleDbException in ExecuteScalar()
Exception : OleDbException
0x80040E30L
DB_E_BADTYPENAME
Code Snippet
OleDbConnection od = new OleDbConnection("Provider=Microsoft.SQLSERVER.MOBILE.OLEDB.3.0;Data Source=db.sdf;SSCE:Database Password=");
od.Open();
OleDbCommand og = new OleDbCommand("INSERT INTO [bills] ([billno],[checkouttime],[finalprice],[handle],[ischeckout],[memo],[paymode],[trick]) VALUES (@billno,@checkouttime,@finalprice,@handle,@ischeckout,@memo,@paymode,@trick)", od);
og.Parameters.Add("@billno", OleDbType.VarWChar).Value = "2007051800000000";
og.Parameters.Add("@checkouttime",OleDbType.DBTimeStamp).Value="2007-5-18 11:55:40";
og.Parameters.Add("@finalprice", OleDbType.Single).Value = 0.0;
og.Parameters.Add("@handle", OleDbType.VarWChar).Value = "admin";
og.Parameters.Add("@ischeckout", OleDbType.SmallInt).Value = 0;
og.Parameters.Add("@memo", OleDbType.VarWChar).Value = "";
og.Parameters.Add("@paymode", OleDbType.VarWChar).Value = "";
og.Parameters.Add("@trick", OleDbType.VarWChar).Value = "";
og.ExecuteScalar();
od.Close();
why the same code is not work? i'm find all MSDN ,but there is no answer
Who can help me,Thanks
SSCE 3.1 And 3.5 In VS 2008?
Nov 17, 2007Hi-
VS 2008 supports targeting different versions of the .NET Framework. Will this apply to SSCE as well? I have some older apps that I want to keep in .NET 2 and SSCE 3.1. But I would also like to develop new stuff in 3.5. Will the targeting mechanism in VS 2008 support using SSCE 3.1 with .NET 2.0 and SSCE 3.5 with .NET 3.5?
Thanks.
-Gary
Manage Ssce 3.5
Aug 5, 2007I have been having "fun" trying to get all the bits (SSCE 3.5, Orcas Beta 2, SQL Managment Studio) in Vista 64 and Xp 32.
So far I have found at the SQLMetal does work with SSCE 3.5 but not in Vista64
BUT I cannot get any tool (tried SQL and SLQ express) to manage my SSCE db - ie make relationshipos so that SQLMatal can do its stuff
Any advice as to which tool to use to manage SSCE 3.5
Thanks
Mike
Vista SQL 2005 SP2 Client To Windows XP SQL 2005 (non-sp2) Workstation.
Apr 26, 2007I'm trying to use SQL Management Studio to connect from a Vista SQL 2005 client w/ SP2 over to a Windows XP workstation running SQL server developer edition (non-sp2) using windows authentication.
I'm already preauthenticated by network shares to the xp workstation. This worked just fine in windows xp but stop working in vista.
After searching around, i found out that vista handles trusted authentication differently than windows xp due to changes in the SSPI. Logging in as sql authentication works fine. Logging in as windows authentication does not.
UPDATE: I found out that two workstations running vista and sql 2005 sp2 cannot connect to each other using windows trusted authentication!!!
What the heck?
UPDATE: I found out that my IIS 7.0 using ASP.NET and connecting to SQL 2005 (non sp2) on a Windows 2003 server (SP1) WILL connect to the database using trusted authentication... apparently IIS can access the credentials and pass them to the sql 2005 box just fine. My Sql 2K5 SP2 tools cannot. I'm forced to use SQL authentication to the box.
Same thing applies with a Windows XP SP2 box running SQL 2005 (non sp2).
Here is my sql server error log off of the windows xp workstation:
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
How can i Fix this issue?
[1] Client side:
What is the connection string in you app or DSN?
N/A
If client fails to connect, what is the client error messages?
Is the client remote or local to the SQL server machine?
Remote
Can you ping your server?
YES
Can you telnet to your SQL Server?
YES
What is your client database provider?
SQL Management Studio
Is your client computer in the same domain as the Server computer?
WorkGroup
What protocol the client enabled?
Shared Memory & TCPIP
Do you have aliases configured that match the server name portion of your connection string?
NO
Do you select force encryption on server and/or client?
NO
[2] Server side:
What is the MS SQL version?
SQL Server 2005
What is the SKU of MS SQL?
Developer
What is the SQL Server Protocol enabled?
Shared Memory & TCPIP
Does the server start successfully?
YES
If SQL Server is a named instance, is the SQL browser enabled?
N/A
What is the account that the SQL Server is running under?
Network Service
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider?
YES
Do you make firewall exception for SQL Browser UDP port 1434?
N/A
[3] Platform:
What is the OS version?
Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2
Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition
Do you have third party antivirus, anti-spareware software installed?
None
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
N/A
Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
[1] Client side:
What is the connection string in you app or DSN?
N/A
If client fails to connect, what is the client error messages?
Is the client remote or local to the SQL server machine?
Remote
Can you ping your server?
YES
Can you telnet to your SQL Server?
YES
What is your client database provider?
SQL Management Studio
Is your client computer in the same domain as the Server computer?
WorkGroup
What protocol the client enabled?
Shared Memory & TCPIP
Do you have aliases configured that match the server name portion of your connection string?
NO
Do you select force encryption on server and/or client?
NO
[2] Server side:
What is the MS SQL version?
SQL Server 2005
What is the SKU of MS SQL?
Developer
What is the SQL Server Protocol enabled?
Shared Memory & TCPIP
Does the server start successfully?
YES
If SQL Server is a named instance, is the SQL browser enabled?
N/A
What is the account that the SQL Server is running under?
Network Service
Do you make firewall exception for your SQL server TCP port if you want connect remotely through TCP provider?
YES
Do you make firewall exception for SQL Browser UDP port 1434?
N/A
[3] Platform:
What is the OS version?
Client - Windows Vista Final w/ SQL Server 2005 SP2 & Network Client SP2
Server - Windows XP Professional SP2 w/ SQL 2005 Server Developer Edition
Do you have third party antivirus, anti-spareware software installed?
None
[4] Misc:
If you have certificate configuration issue: Please use €œcertutil.exe €“v €“store my€? to dump certificate specific info and post it in your question.
N/A
Tips:
1. Find SQL Server Errorlog: Default to C:Program FilesMicrosoft SQL ServerMSSQL.#MSSQLLOG
2007-04-26 15:41:32.34 Logon Error: 17806, Severity: 20, State: 2.
2007-04-26 15:41:32.34 Logon SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.254.100]
2007-04-26 15:41:32.34 Logon Error: 18452, Severity: 14, State: 1.
2007-04-26 15:41:32.34 Logon Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.254.100]
SSCE 3.5 RTM Build Numbers
Nov 22, 2007
Does anybody have the RTM build numbers for SQL Server Compact Edition 3.5?
Thanks
SSCE License Restrictions?
Sep 20, 2007Could y'all please clarify this statement with some examples:
"A SQL Server Client Access License (CAL) is required for any connection to SQL Server, including a connection from SQL Server Compact Edition."
Is this only referring to RDA, or is it referring to data replication by any means? Is there any restrictions for connections between SSCE devices?
Thanks!
Can't Update .sdf Database With SSCE 3.5
Apr 2, 2008I've just recently downloaded Visual Studio 2008 Express which comes with SQL Server 2005 Express and SQL Server Compact 3.5, both of which were installed when I installed the products.
I've been following the tutorial videos and trying some stuff of my own and I just can't seem to get a Compact 3.5 database to actually update! I'm doing EXACTLY what is shown in the tutorials and th dataset is being updated - changes and added records - and they will show up in a DataGrid control as expected, but when I accept the changes - nothing is changed and/or added to the actual .sdf file. When I open it again, it's the same as it was before. Using exactly the same code but with an SQL Server 2005 Express database (.mdf), updates are fine.
First I created a dataset that connects to the SSCE 3.5 database .SDF file. Then I simply drag the table from the dataset to the form which creates Dataset, Table Binding Source, Table Adapter Manager and BindingNavigator items, in addition to the toolbar and DataGrid controls. The code generated from this is below. I have added the Try/Catch block and messages to see if any errors are ocurring.
Code Snippet
Public Class Form3
Private Sub TblMessageTypeBindingNavigatorSaveItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles TblMessageTypeBindingNavigatorSaveItem.Click
Me.Validate()
Me.TblMessageTypeBindingSource.EndEdit()
Try
Me.TableAdapterManager.UpdateAll(Me.AppMessagesDataSet)
MsgBox("Changes Saved")
Catch ex As Exception
MsgBox(ex.ToString)
End Try
End Sub
Private Sub Form3_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
'TODO: This line of code loads data into the 'AppMessagesDataSet.tblMessageType' table. You can move, or remove it, as needed.
Me.TblMessageTypeTableAdapter.Fill(Me.AppMessagesDataSet.tblMessageType)
End Sub
End Class
When I run the app, the data in the database table is displayed correctly. If I make a change and add a record then click the Save button, I get the expected "Changes Saved" message indicating that there are no errors. When I look a the contents of the table, the changes and additions did not happen and the data is exactly the way it was before.
I had the full SQL Serer 7.0 installed as well so I thought there might be a conflict or something became corrupted. In uninstalled SQL Server 7.0, SQL Server 2005 Express and SQL Server Compact 3.5. I "repaired" VB 2008 Express which reinstalled SQL Server Compact 3.5 and separately reinstalled SQL Server 2005 Express. Same problem.
As I mentioned above, what gets me is that if I use the same setup for a SQL Server 2005 Express database, changes and inserts work just fine. (Used the Northwind.mdf (Express) and the Northwind.sdf (Compact) sample databases and created my own sample .mdf and .sdf databases - same results.)
I've looked at whatever I can to see if I can find the problem but just can't put my finger on it. Very frustrating.
Does anyone have any advice on what I might be doing wrong with Compact or if there is something I've missed or if there's a property somewhere that needs to be set, or perhaps a configuration issue??
Many thanks,
Ben
SSCE 3.5 In VS2008 - Gold?
Nov 20, 2007I just installed VS2008 RTM and noticed that it really wants me to use 3.5 instead of 3.1. As I am doing most of my SSCE work through the SQL Server 2005 Management Studio (its query editor is still far superior to VS'), I found that I can still use 3.1 without much trouble (so long as I manually browse and add the 3.1 reference to my project).
That said, I'd like to use 3.5. My two questions are:
- Is the SSCE 3.5 version included in VS2008 final? I noticed the dlls are all over a month old. Can I redistribute these with my app?
- Will there be support in SQL 2005 or SQL 2008 for connecting to 3.5 databases? I know that a new SQL server 2008 CTP was released, but haven't seen mention of SSCE support. I'd really hate to lose the great query editor of the Management Studio when moving to 3.5.
SSCE OLEDB Bug In GetParameterInfo
Dec 11, 2007Howdy folks,
I may have stumbled upon the most obscure bug imaginable. I was noticing my parameterized queries were failing on our SBC (WinCE5 x86), but not on our WinCE5 x86 emulator, WinXP setup, or WinCE5 ARMIV emulator. After much grief, I discovered the source of the problem had to do with a call to ICommandWithParameters::GetParameterInfo().
On all platforms other than our SBC, the DBPARAMINFO::ulParamSize was (correctly) retrieved as 16B for type DBTYPE_DBTIMESTAMP. On the SBC this value was retrieved as 8B. Now I know that natively all platforms of SSCE store a datetime object in 8B, but a DBTIMESTAMP structure (16B) is what's always used to transfer those fields to and from the database. Needless to say, with the wrong ulParamSize being returned, my data buffer (which used DBTIMESTAMP's) was being overwritten.
The erroneous value can be seen in this image
Just to further the case that this is a bug, the column size of a datetime field is correctly retrieved as 16B on the same platform when GetColumnInfo is run, as shown here.
Do y'all have any insight in this matter?
Conversion MSAccess -&&> SSCe
Dec 6, 2006We have plan to migrate our database from Access to SqlCe.
Here our situation:
We will never use a Pocket PC applications, only Windows desktop application.
We want to migrate the .mdb file to a .sdf file (I've seen the ADS application, but since we don't use mobile devices, it's no use)
The .sdf will be use on local client machine only.
Here's my problems:
I've use a conversion to migrate from access (http://www.primeworks-mobile.com/Downloads/DPW.html) and seem to work fine.
I updated the source code to use the SqlServerCe dll instead of OleDB.
Some of my queries work fine, but others just won't work in VS2005 using C#.
To check if the query is really wrong, I take exactly the same query and put it Query Builder from the Server Explorer in VS2005.
And the query just work fines!!! It's bring back all the records asked for, and I've got an error for the same query from my source code.
I'm using a datatable, here's the code used for filling the DataTable. I've got an error on the line adapter.FillSchema()
string connectionString = @"Data Source=" + fic_parent.CheminFichierComplet;
using (SqlCeConnection connection = new SqlCeConnection(connectionString))
{
SqlCeDataAdapter adapter = new SqlCeDataAdapter();
connection.Open();
SqlCeCommand command = new SqlCeCommand(requete, connection);
command.CommandType = CommandType.TableDirect;
adapter.SelectCommand = command;
tableResultats = new DataTable();
adapter.FillSchema(tableResultats, SchemaType.Source);
adapter.Fill(tableResultats);
// Close connection
connection.Close();
}
Error is:
Message="The specified table does not exist. [ (...) ]"
Source="SQL Server 2005 Everywhere Edition ADO.NET Data Provider"
HResult=-2147217865
NativeError=0
Here my questions:
Is it possible to have an application that will convert my Access databases to an SSCe .sdf file ?
Why I can query in Server Explorer and can't in my source code using the same sql statement ?
At which level my code isn't good, because I just replace all OleDB* --> SqlCe* in my code.
I hope that I explain clearly my problem, do not hesitate to ask me questions about this problem.
SSCE With Flash Memory
Dec 11, 2007
Hi,
I have a question about using SSCE with flash memory. Our CE components equally allocate the write access to the memory location. But write access is guaranteed only 10000 times per memory cell.
So I need to know
1. what changes are made to the file system if I add an entry to a table?
Is this entry the only information added to the file system?
2. What happens if I delete an entry? Will SSCE optimize the data in the filesystem?
Thanks a lot for helping.
Regards Flo
Cannot Get SSCE 3.5 Beta 2 To Work
Aug 3, 2007I'm running VS2008 beta2. I've succefully added a SDF database file to my project and created a couple of tables in it from VS. I added a reference to the System.Data.SqlCeConnection. When I try to create a new instance of the SqlCeConnection class I get a nasty error that states I'm missing the 'sqlceme35.dll' file. I copy all of the files .dll into by bin folder. Now I'm getting a BadImageFormat error when I create an instance. Does anyone know what that means? or why I had to copy those files to begin with? This is very odd. Any help would be appreciated. I am new to SqlCe.
View 14 Replies View RelatedTableAdapterManager Use With SSCE 3.5 Bug Or By Design?
Feb 7, 2008
I don't know if it is by design or a bug. I have tried using the TableAdapterManager with remote SQL 2005, SQL 2005 Express (local and remote) with success.
I have tried using the TableAdapterManager ,( which is included by default with the dataset), with SQL Compact 3.5 as a local (within project) and remote(not in the project) and it does not work.
I would think that if the intention is to start using SCE 3.5 as the local database for applications (which makes sense), then I would think that making use of the TableAdapterManager class would seem to be a no brainer unless I'm missing something. I've been known to do that.
I guess my question is, is this a bug or by design?
Any comments would be appreciated.
Shane
What Is Maximum Database Size In The SSCE?
Apr 24, 2007Hi,
I've found a two different answers for this question:
one - on the http://support.microsoft.com/Default.aspx?kbid=920700 site where on the Performance improvements section there is a 128MB value in the Database size.
other is in the product datasheet there is a information that this version supports databases up to 4 GB.
Could you tell me what is the correct answer?
Regards,
Mariouche
What Tool To View SSCE Database?
Mar 11, 2008
What tool should I use to view SQL Server Compact Edition database?
I have VS2008 Professional, but I didn't find any tool in the installation. So I tried to install the SQL Server Developer Edition, which is included in the VS2008 package, but the installation has quit saying the that there is nothing to upgrade (there is probably newer version of SQL installed by VS2008 itself).
I also tried to download and install SQL Server Managment Studio Express. The installation went well, but then I wasn't able to select any SSCE database (there was only SQL Server Express or something like that selectable).
Is there anything else I should do?
SQL 2005, VS 2005: ASPNET Windows Account Not Being Used For Log In
Oct 25, 2006Ran a trace using profiler and found that the CLR is not using the ASPNET windows account to log into SQL 2005, instead using the admin. Some ado.net code does not work properly as a result. Have had to change the connection string to use SQL logins.Spec: Win XP Pro; IIS 5; 2.0.Is this normal? Where security and permissions are concerned, what changes, if any, are there from SQL 2000?
View 5 Replies View RelatedCan SSCE 3.0/3.5 Cater For Multi-user Instances?
Oct 4, 2007Hi all,
I just want to know if SSCE 3.0/3.5 can cater for Multi-user instances? I have a desktop application that I want to allow multiple Windows-user accounts to access. basically I need a datastore that can be lightweight (which SSCE is) and support "User Instances" (like in SQL Server Express)
thanx!
Migration MySQL To SSCE...big Problems In SQL CE Language...
Jul 10, 2007hello,(sorry for my english language but im french :-) )
I have a lots of problems to convert the SQL language from MySQL to SSCE because the SSCE language is so poor...
If somebody have some URL with a lots of examples of request (select, update).
for example, im not able to convert this update request :
Update reservation,lockers set reservation.ERS_ID='A' where lockers.LCK_CONF!='LW' AND lockers.LCK_PHYS_NO=reservation.LCK_PHYS_NO AND reservation.ERS_ID IN('V','M','E','S','F','D','P');
how to use 2 tables in the same update???
i saw the MSDN but there arent explicit and GOOD examples...
http://msdn2.microsoft.com/fr-fr/library/ms174122.aspx
Thanks you
[Bug?]Exception Thrown In SSCE 3.5 Beta2 But Not In 3.5 Beta1.
Aug 14, 2007
Hi,
I replace the reference assembly System.Data.SqlServerCe with version 3.5 beta2 in Microsoft.Practices.EnterpriseLibrary.Data.SqlCe. When I used the Data.SqlCe block in application, an exception ("Cannot access a disposed object named SqlCeConnection") threw. This didn't occur in SSCE 3.5 beta1 and early versions.
Finally I found the difference between beta1 and beta2.
In the SqlCeConnection class, there is a RemoveWeakReference method. this is code snippet of beta1:
internal void RemoveWeakReference(object value)
{
if (this.weakReferenceCache != null)
{
this.weakReferenceCache.Remove(value);
}
}
and this is for beta2:
internal void RemoveWeakReference(object value)
{
if (this.weakReferenceCache == null)
{
throw new ObjectDisposedException("SqlCeConnection");
}
this.weakReferenceCache.Remove(value);
}
So, if we dispose a connection before a command, such as:
SqlCeConnection cn;SqlCeCommand cmd;... cn.Dispose();cmd.Dispose(); // Error, an exception will be threw. Is it a bug of Beta2?
Table And Query Hints Not Working In SSCE 3.1 ?
Aug 23, 2007I am trying to use hints and they don't seem to be working.
Something like:
select * from TABLE_NAME with (tablock,xlock)
fails.
Documentation clearly states that this is supported (TABLOCK, NOLOCK, XLOCK, etc.), so I must be missing something simple.
Please let me know how do I use Hints in SQL Server 2005 Compact.
Thanks.
PS.
I am using C#. It doesn't work in my code when I use
SqlCeDataReader rs = cmd.ExecuteReader();
And it doesn't work from inside the VS 2005 "query tool" or whatever it is called, when you do "Connect to Database" and so on.
SSCE Open Database On Desktop Application
Jan 31, 2008Hello
I am writing a Desktop application accessing a SSCE database. I am running Windows XP SP2, VS2005 SP1, and have SQLServerCE3.1 installed. Debugging the application shows that ds.m_spInit->QueryInterface() returns E_NOINTERFACE. I have checked that SSCE runtime library is installed, IDBCreateSession uuid exists in the registry and m_spInit.CoCreateInstance(CLSID_SQLSERVERCE_3_0) return S_OK. Can you suggest me what need adding/installing to get the CSession.Open(datasource) working?
Thanks
Ares,
Cannot Construct A SELECT DISTINT COUNT... Statement In SSCE 3.1
Oct 4, 2007Hi everyone,
sorry to b a pest again! Before I made the decision to change the DB used in my app from SQL Server Express to SSCE, I had no problems with constructing a SELECT statement as laid out in the Title.
Basically, I have 2 tables with a one-many relationship between them. In the Parent table, I had a SQL Statement as follows:
SELECT DeptID, DeptName,
(SELECT DISTINCT COUNT(Active) FROM Documents WHERE (Documents.DeptID = Dept.DeptID) AND
(Documents.Active = 'True') AS CountOfActive
FROM Dept
Now in SSCE 3.1, I get an "Unable to parse query" error message when I construct the same SQL statement in my dataset designer.
Any thoughts on how I may solve this?
Much thanx!
Shalan
SSCE Visual Studio Setup / Integration Woes
Dec 19, 2007I have had a heck of a time trying to get SQL Compact Edition 3.5 working in by Visual Studio 2008 environment. I (now) know it comes along with Visual Studio 2008 by default, however, I didn't realize that at first and went and installed one of the SQL Compact Edition MSI's that were available from MS download. Since then I am unable to create a new compact edition database (Add New Item...) in visual studio it says:
The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated.
Also, When I try to create a new connection under server explorer, I notice the SQL Compact Edition is not a data source option.
I am running the relased build from the MSDN download iso: en_visual_studio_team_system_2008_development_x86_x64wow_dvd_X14-26382.iso
I have uninstalled the seperate install of the SQL Compact Edition and run repair on the visual studio 2008 installer and it does not fix the problem. I have seen a reference that says the design time installer should be under Program FilesMicrosoft Visual Studio 9.0Common7IDE, but it isn't in my install. I did find it on the source DVD under the folder WCUSSCESSCEDeviceRuntime-enu.msi.
After running that, I no longer get the original error message. Now I get a little further and then the Data Source Configuration Wizard comes up and says
An error occured while retrieving the information from the database:
SQL Server Compact is either not installed or the installation has been corrupted.
OK, so I look under C:Program FilesMicrosoft SQL Server Compact Editionv3.5 which install from the DVD (WCUSSCESSCEDeviceRuntime-enu.msi.) created and notice a readme file that inside has a link for downloading and installing the Runtime for Desktop computers.
Thinking that perhaps the runtime is a seperate install from the design tools I follow the link and setup starts. At this point I notice that the set says Compact Edition 3.5 BETA - hmm that doesn't seem right so I cancel. Not sure why the final product for the design tools would have a readme that points to a download link for the BETA of the runtime, but going back to the DVD I see the file WCUSSCESSCERuntime-enu.msi and run it. This time it says it will install Compact Edition 3.5 - looks good no BETA.
Finish the instal and viola! it works....
So what worked for me in the end:
1) Uninstall any other installs of Compact Edition 3.5 you might have
2) repair visual studio
3) install the design tools from the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
4) install the runtime fgrom the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
Bad Error Message Connecting To SSCE V3.5 From Orcas Beta 1 In SSMSX SP2 Under Vista
May 12, 2007I'm receiving a bad error message when attempting to connect to SSCE .sdf files installed by Orcas Beta 1 (e.g., Northwind.sdf from the ...v3.5Samples folder) and created by the Orcas Beta 1 Sync Designer with SQL Management Studio Express SP2 (version 9.00.3042.00).
The message is:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Program FilesMicrosoft SQL Server Compact Editionv3.5SamplesNorthwind.sdf.
------------------------------
ADDITIONAL INFORMATION:
You are trying to access an older version of a SQL Server Compact Edition database. If this is a SQL Server CE 1.0 or 2.0 database, run upgrade.exe. If this is a SQL Server Compact Edition 3.0 or later database, run Compact / Repair. [ Db version = 3505053,Requested version = 3004180,File name = C:Program FilesMicrosoft SQL Server Compact Editionv3.5SamplesNorthwind.sdf ] (SQL Server Compact Edition ADO.NET Data Provider)
------------------------------
Obviously 3505053 is a newer than SSCE 3004180, not earlier. I don't understand why SSMSX SP2 would request a specific version and refuse to open the latest version.
I don't recall having this problem with SSMSX SP2 and VS Orcas March CTP under Windows Server 2003 (March CTP wasn't certified for Vista).
VS Orcas Beta 1's Server Explorer can open the .sdf files and display their content but won't execute DDL commands against them.
There also is what I believe to be a related problem with the Sync Designer failing to add LastEdited and CreatedDate fields to the .sdf files (see Sync Designer/SSCE Version Problems with Orcas Beta 1 in the Sync Services forum.
--rj
VS Orcas
VS2008 Solution With Multiple Projects. Best Practices For Connection Strings And SSCE Files?
Jan 15, 2008Hi everyone - I'm getting myself into a right muddle and am looking for advice.
How do people deal with connection string matters when taking a dataset defined in one assembly (and by default using the connection strings defined within that assembly in the settings files) and then using that assembly in an app (which also has a requirement to see the same physical database).
I'm not sure I've explained that terribly well but what I'm trying to avoid is duplicate copies of my database which so far seems to be the only way that I've managed to make stuff work. I'm not very experienced with SSCE data access (I'm a serices/sockets/ip person) and this may just be ignorance. Most of the examples seem to assume that the data is in the same place as the app whereas I'm trying to collate a whole series of functions into a helper assembly that I'd like to re-use for other things.
Ideally the dataset designer would provide an easy way of choosing from centralised connection strings - perhaps this is what the Dataset Project implies - but again the docs are mostly focused on SQL Server? Otherwise the best I've been able to do is make the connection properties public and try to update them that way or use a post-build action to copy the database from my datalayer project directory to that of my application |DataDirectory|
I suppose the question might be if you have a dataset containing multiple tableadapters that assumes one connection string, is there any easy way to keep such strings co-ordinated between projects without hardcoding them? With a server resource, the same non-specific connection string resolves to the same server (if that make sense) and this seems to be were I can't make the logical shift.
Does anyone have any thoughts and can they please point this SSCE noob in the right direction?
Cheers
Cannot Install SQL Server 2005 On A Windows 2003 Cluster In Virtual Server 2005
Jun 5, 2006I
am trying to install SQL 2005 in a 2-node virtual Windows 2003 cluster. I set
the cluster up through Virtual Server 2005 with 2 virtual nodes and one
virtual domain. The nodes can connect to each other as well as the
physical machine. When I try to install a fresh copy of SQL 2005 on my
cluster, I get an error every time. The
error stops the installation while checking system configuration after
installing prerequisites. The log file entry is as follows:
*******************************************
Setup Consistency Check Report for Machine: --SERVERNAME--
*******************************************
Article: WMI Service Requirement, Result: CheckPassed
Article: MSXML Requirement, Result: CheckPassed
Article: Operating System Minimum Level Requirement, Result: CheckPassed
Article: Operating System Service Pack Level Requirement, Result: CheckPassed
Article: SQL Compatibility With Operating System, Result: CheckPassed
Article: Minimum Hardware Requirement, Result: CheckPassed
Article: IIS Feature Requirement, Result: Warning
Description:
IIS is not installed, therefore Report Server feature will be disabled
Action: Install IIS in order for Report Server feature to be enabled
Article: Pending Reboot Requirement, Result: CheckPassed
Article: Performance Monitor Counter Requirement, Result: CheckPassed
Article: Default Installation Path Permission Requirement, Result: CheckPassed
Article: Internet Explorer Requirement, Result: CheckPassed
Article: Check COM+ Catalogue, Result: CheckPassed
Article: ASP.Net Registration Requirement, Result: CheckPassed
Article: Minimum MDAC Version Requirement, Result: CheckPassed
<Func Name='PerformDetections'>
1
Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0
Error: Action "InvokeSqlSetupDllAction" threw an exception during execution. Error information reported during run:
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "ComputerList" {"SqlComputers", "", ""} in cache
Source File Name: datastoreclusterinfocollector.cpp
Compiler Timestamp: Fri Sep 16 13:20:12 2005
Function Name: ClusterInfoCollector::collectClusterVSInfo
Source Line Number: 883
----------------------------------------------------------
Failed to detect VS info due to datastore exception.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56
----------------------------------------------------------
Failed to find a cluster group that owned shared disk: J:
WinException : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastoreclustergroupsproperties.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: ClusterGroupScope.SharedDisks
Source Line Number: 56