SQL 2008 Developer Edition Management Studio Does Not Work For Compact Edition 3.5 Databases
Sep 27, 2007
I am attempting to use the SQL Server 2008 Developer Edition (Management Studio) to create/manage a Compact Edition 3.5 database. My problem is that I cannot even create/open the compact database in Management Studio. Any help would be GREATLY appreciated. TIA
Problem Creating the Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <New Database...> as the Database file.
Browse to folder where file will be created (C:MyDatabase#1.sdf was used in my example)
Leave all other field as default selections OR make changes, either way it does not work.
Click OK.
At this point the OK button just becomes disabled and nothing happens.
Problem Opening An Existing Compact Database:
Open 2008 Management Studio
From menu choose File | Connect Object Explorer...
Choose SQL Server Compact Edition as the Server type.
Choose <Browse for more...> as the Database file and locate a ".sdf" file that I created using VS2008.
Enter password, if any.
Click OK.
The following exception is displayed:
TITLE: Connect to Server
------------------------------
Cannot connect to C:Documents and SettingsdarrinbMy DocumentsVisual Studio 2008ProjectsTestSQLCompactEdition35TestSQLCompactEdition35AFS.sdf.
------------------------------
ADDITIONAL INFORMATION: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476
------------------------------
Could not load file or assembly 'Microsoft.SqlServerCe.Enumerator, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) (mscorlib)
------------------------------
BUTTONS: OK
------------------------------
View 1 Replies
ADVERTISEMENT
Oct 1, 2007
Is it possible to use SQL Server Compact Edition v3.5 with SQL Server Management Studio?
When I attempt to connect to a 3.5 database I get the following error:
"You are trying to access an older version of a SQL Server Compact Edition Database..."
I am using v3.5 beta 2.
If not, is there anything out there that provides a Query Analyzer like interface for viewing data that works with v3.5?
Thanks.
View 3 Replies
View Related
Jul 13, 2007
I got VS Pro which came with SQL Server Management Studio Developer Edition. Very exciting! However, when I go to update from SQL Server Management Studio Express to Dev Edition it says that there are tools / components already installed. I completely uninstalled everything having to do with SQL Server from my machine and tried again. It still says that the tools / components are installed. I see that there are still several instances of SQL Server still on my machine. So I tried reinstalling Express again. However, now the Configuration Manager has a snap-in that won't start. Any help would be much appreciated.
Thanks
View 3 Replies
View Related
Jan 16, 2007
Hello ,
Is possible to specify reationships between tables on SQL Server Compact Edition database in Management Studio Express ?
I can connect to database file , add tables, add data , but I dont't found the right methot to specify reationships as with SQL Server Express.
Any ideas?
View 5 Replies
View Related
Aug 21, 2007
I have installed Visual Studio 2005 Prof Edition on a Vista machine and SQL Server 2005 Developer Edition on a Windows 2000 server. They will be used as a development environment for us. As we need to management the SQL Server 2005, we would like to install the 2005 Developer SSMS on the Vista machine such that we can manage the SQL Server 2005 developer instance installed on that Win2k machine. However, the system does not allow us to do it. We have the express edition autoamtically installed while we installed the Vistual Studio. Is there any workaround that i can still install the 2005 developer SSMS without uninstall the sql server 2005 Xpress version? Or, I have to uninstall the Xpress version before i can install the 2005 developer's SSMS? Please help!
View 11 Replies
View Related
Jun 2, 2015
I have just migrated a complete SQL Server 2008 R2 SP2 development server from Windows 2003 to Windows 2008 Server. Â I just realized that I should not have used the Data center edition Product Key as this is Development server. Â I am being asked to downgrade to Developer edition. Â I have already migrated all the logins, databases(40 databases), cubes etc. Â I really can't uninstall and reinstall Developer edition. Â How else can I upgrade/downgrade to switch from Datacenter edition to Developer edition. Â
View 2 Replies
View Related
May 5, 2008
in visual studio web developer express edition 2008 i added a new item this was a sql server database which i called test2. I added a table called comments, and the fields name, email, comments, IPAddress, and Date and in my comments.aspx page i added a name textbox, a texbox for email, a textbox for comments and the submit button i double clicked on the submit button and added the following code
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim mydS As New SqlDataSource mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString1").ToString mydS.InsertCommandType = SqlDataSourceCommandType.Text mydS.InsertCommand = "INSERT INTO comments(Name,Email,Comments,IPAddress,Date) VALUES (@Name,@Email,@Comments,@IPAddress,@Date)" mydS.InsertParameters.Add("Name", TextBox1.Text) mydS.InsertParameters.Add("Email", TextBox2.Text) mydS.InsertParameters.Add("Comments", TextBox3.Text) mydS.InsertParameters.Add("Date", Date.Now) mydS.InsertParameters.Add("IPAddress", Request.Params("REMOTE_ADDR")) Dim rowsaffected As Int16 = 0 Try rowsaffected = mydS.Insert Catch ex As Exception Server.Transfer("errors.aspx") Finally mydS = Nothing End Try If rowsaffected <> 1 Then Server.Transfer("errors.aspx") Else Server.Transfer("confirm.aspx") End If End Sub Protected Sub TextBox1_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles TextBox1.TextChanged End Sub but when i run it it gives me a problem with this line mydS.ConnectionString = ConfigurationManager.ConnectionStrings("testConnectionString2).ToString and says something abt unidentified object and I want to know how do i set the connection string or alternatively where?????? and my table does not update with the corresponding values i enter on the webpage. i also changed the authentication mode to forms instead of windows as i was advised but i'm still having a problem
View 12 Replies
View Related
Jul 26, 2007
Hello,
I just installed SQL Server Compact Edition, since I am considering using it instead of SQL Server Express for a local database in my application. The documentation mentioned that I could use SQL Server Management Studio Express to connect to the Compact Edition and create and manipulate databases.
To try to connect, I run Management Studio and bring up the "Connect to Server" dialog. Unfortunately, the pull-down list of "Server name"s does not include the SQL Server Compact Edition server. I do not know how to type in the server name manually, so I cannot connect.
To install Compact Edition, I downloaded it and ran "SQLServerCE31-EN.msi". This installed, and I assume registered, a number of DLLs in "C:Program FilesMicrosoft SQL Server Compact Editionv3.1".
Is there perhaps an additional step that I left out to complete the installation?
Might I need an upgrade to some other components? My Management Studio Version is:
- Microsoft SQL Server Management Studio Express 9.00.2047.00
I would appreciate any help you can provide.
Thank you,
WTW
View 7 Replies
View Related
Aug 26, 2007
I have a question about a problem that I cannot seem to tackle. I have installed the following programs on Windows Vista:
- SQL Server 2005
- Visual Studio 2008
- SQL Server Compact Edition 3.5
- SQL Server Compact Edition 3.5 Server Tools
I want to do the following:
1. I want to create a SQL Server Compact Edition 3.5 database in the SQL Server Management Studio
2. I want my SQL Express server in SQL Server 2005 to be a distributor and publisher
About 1. In SQL Server Management Studio I cannot choose SQL Server Compact Edition 3.5 .
ABout 2. I tried to setup my server to be a distrubutor by running a stored procedure with the following name: sp_adddistributor. I get the following error: This edition of SQL Server cannot act as a Publisher or Distributor for replication.
Does anyone have a solution to both problems.
View 1 Replies
View Related
Mar 14, 2007
I have a Symbol MK1200 device (Intel XScale processor) running CE.NET 4.2 and when I try
to reference any SQL objects I get the error:
Can't find PInvoke DLL 'sqlceme30.dll'
The documentation says that Compact Edition is supported on CE.NET 4.2,
(ms-help://MS.SSCE.v31.EN/ssmmain3/html/ee220634-55c9-4123-85c4-4e6ceb07f942.htm)
but I came across a hotfix (http://support.microsoft.com/kb/924811/) which
contradicts this and says CE.NET 4.2 is not supported by default.
Can someone clarify this for me? I know that VS.NET 2005 doesn't support debugging of CF 2.0
apps to CE.NET 4.2 devices but I thought I could manully deploy a CF 2.0 SP1 application with SQL
Compact Edition (although I'm still not sure whether I need the hotfix) ?
Either way I've been playing around and here is what I found ...
1. I installed CF 2.0 SP1 and verified a simple 'Hello World' application could deploy. All worked ok.
2. I downloaded & installed the SQL Compact Edition CABs on the device manually from
'SmartDevicesSDKSQL ServerMobilev3.0wce400armv4'.
I opened Query Analyzer on the device and it worked i.e. I could open a database, run query, etc.
3. I modified my application with the following sample code:
try
{
SqlCeCommand sqlCmd = new SqlCeCommand();
}
catch (Exception exception)
{
MessageBox.Show(exception.ToString());
}
Once again, just deploying (not debugging) the app. and got the error above 'Can't find PInvoke DLL 'sqlceme30.dll'
4. I installled the HotFix from http://support.microsoft.com/kb/924811/, now Query Anaylzer did not work even though it did work pre-hotfix install, and I'm still getting the same error when I test my code.
Can anyone shed any light on this? It's driving me up the wall ;o)
View 6 Replies
View Related
Jul 23, 2005
Microsoft site says yesIf yes, then if I publish my site on a win2k server, will it stillwork?These questions assume that a yes answer does not involve jumpingthrough too many hoops or having to spend an entire day or longerporing through MSDN.God I sound jaundiced don’t I!Any help with these questions will be greatly appreciated.Thanks,Adso--Posted using the http://www.dbforumz.com interface, at author's requestArticles individually checked for conformance to usenet standardsTopic URL: http://www.dbforumz.com/General-Dis...pict221847.htmlVisit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbforumz.com/eform.php?p=763479Posted Via Usenet.com Premium Usenet Newsgroup Services----------------------------------------------------------** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **----------------------------------------------------------http://www.usenet.com
View 2 Replies
View Related
Jun 4, 2008
I'm trying to start an application in C# with visual Studio 2008 and I want to connect it to a SQL CE 3.5 Database (local .sdf file).
I only found samples or How-to guides that use the wizard to add the datasource and the way dragging the dataset to the form. All things binded to the database where you don't have to do coding.
I don't want to have the binding navigator bar, I just want to use text box, date picker and buttons and Save that to the database myself. That way I think it will be more easy for me to validate or manipulate data before the insertion in the DB.
Some time ago a make an ASP.net that was doing same kind of thing with an Access DB...
Hope this can help to show what i really want...
(sorry for my bad english....)
Nick
Code Snippet
Private Sub btnAskSql_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAskSql.Click
lblMsg.Text = ""
Dim MyDS As New DataSet
'txtRequest.Text is a SQL command like Select * from.....
MyDS = SQLRequest(txtRequest.Text)
Try
DG01.DataSource = MyDS.Tables(0).DefaultView
DG01.DataKeyField = "ID"
DG01.DataBind()
Catch ex As Exception
lblMsg.Text = Err.Description
Finally
End Try
End Sub
Function SQLRequest(ByVal TheRequest As String) As DataSet
Dim _Con As OleDbConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=" & Server.MapPath("Gifts.mdb") & ";")
Dim selectCMD As OleDbCommand = New OleDbCommand(TheRequest, _Con)
selectCMD.CommandTimeout = 30
Dim custDA As OleDbDataAdapter = New OleDbDataAdapter
custDA.SelectCommand = selectCMD
Dim TheDS1 As New DataSet
Try
custDA.Fill(TheDS1, "Request")
Catch ex As Exception
'oups
lblMsg.Text = Err.Description
Finally
_Con.Close()
End Try
Return TheDS1
End Function
View 1 Replies
View Related
Feb 22, 2008
(1) I have already installed of SQL Server 2005 Developer Edition first.
(1) Can I install visual studio 2008 without the 2005 express edition of SQL server? Will be any problems because I don't have express edition of SQL server? Do I need to install the express edition of SQL server as well?
(3) How to use SQL Server 2005 Developer Edition instance on visual studio 2008?
View 3 Replies
View Related
Jun 1, 2007
Hi, all -
I'm trying to register a developer's 2000 pc from my 2005 pc.
i'm not sure this is even something possible from Dev Edition to Dev Edition- I can register a 2000 server just fine.
I can ping him. Both our systems have remote access 'on'. His server is (local), i've tried connecting to it by just entering his machine name and by using just the ip address. The error I get is "timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding."
Am I just not registering this properly? I entered just the ip address in the 'server' box. I am connecting as sa with the pw he gave me. When i connect to my server, I use the ip addressinstance. However, I am not sure what to use for the instance when all I see when I look at his machine is (local).
I haven't needed to do this before.
Suggestions?
View 2 Replies
View Related
Sep 24, 2007
In my IPAQ, I have been using SQL CE for databases with various sizes without any problem. I am creating the databases on my desktop using VS 2005. After I moved to VISTA, I have upgraded my VS 2005 to SP1 and SQL CE to 3.1. My databases which were created before worked without any problem. After I have created my databases via 3.1 on the desktop and moved them to Mobile, I had problems.
1. I specify Max database size parameter as the size of the database
2. If the size of the database is smaller than 16 then I specify 128
3. If the database is old version then program runs without any problems whatever the database size is
4. If the database is created with 3.1 and size is small (20MB, 60MB, etc) no problems arise
5. Ä°f the databse is created with 3.1 and size is large (133MB, 174MB) then dbconnection.Open() command runs indefinitely and program hangs up .
My IPAQ runs "Microsoft Pocket PC Version 4.20.1081" and desktop runs VISTA Home Premium. I have installed VS 2005 SP1.
Thanks for any help
View 8 Replies
View Related
May 5, 2008
Hello,
we've got a SQL Server 2005 which replicates with an SQL Server Compact 3.5. Every 10 to 20 synchronisations we're getting the error mentioned above. A Soft reset of the device helps to make the synchronization working again.
Why is this error happening and how can we resolve this?
BTW, we've also running system that replicates with an SQL Server Compact 3.0 without having this problems.
Thanks,
Markus
View 1 Replies
View Related
Jan 20, 2008
Hello,
I have a SQL Server CE 3.1 database, which I want to connect to.
Browsing through the documentation, It's not clear to me which tools to use for this.
I have installed VS 2005 express edition (with sp1), but it can't connect to .sdf and
version VS 2008 only connects to SS CE 3.5.
The tools installation file ssce31vstools-ENU.exe file doesn't install on express edition
it seems, as I get an error message, that the patch is not valide.
I also installed the SS Management studio, but it doesn't seem to be able to handle .sdf.
Am I missing something obvious here? I am simply trying to access and modify a SS CE 3.1
databse...
Thanks for the help
Christophe Bouhier
View 1 Replies
View Related
Jan 24, 2008
Hi there,
i've tried using the SELECT SQL sentence on PPC with UNION and INNER JOIN in combination with DATEDIFF function which works fine on ordinary SQL but obviously does not work on compact edition. Is there some workaround?
SQL sentence that works:
Code Snippet
SELECT * FROM
(
SELECT 'O' Type, O.Name , OC.Name Contact, Birthday FROM OutletContact OC
INNER JOIN Outlet O ON OC.OutletID=O.OutletID
UNION
SELECT 'W' Type, W.Name,WC.Name Contact, Birthday FROM WholesalerContact WC
INNER JOIN Wholesaler W ON W.WholesalerID=WC.WholesalerID
) S
WHERE Birthday IS NOT NULL AND (DATEDIFF(day,GETDATE(),Birthday) BETWEEN 0 AND 14)
Thanks for any hint or solution to my problem,
Gorazd
View 1 Replies
View Related
Jan 17, 2007
OK I think I am missing something here. I have installed the newly released SQL Compact Edition, Server Tools, and Tools for VS SP1. According to the documentation you can do the following to create a SQL Compact Edition DB:
Creating a SQL Server Compact Edition database on the server
In SQL Server Management Studio, open Object Explorer.
In Object Explorer, click Connect, and then choose SQL Server Compact Edition.
In the Connect to Server dialog box, select <New Database€¦> from the Database file drop-down list.
In the Create New SQL Server Compact Edition Database dialog box, type a file path and file name for the new database file. You can optionally select the default sort order and choose whether you want to encrypt or password-protect the database. If you choose to encrypt or password-protect the database, type a password, and then click OK.
Click Connect to connect to the new SQL Server Compact Edition database. The database is now displayed in Object Explorer.
I see no reference to or any option to create or connect to a SQL Server Compact Edition database in SQL Mgmt Studio. I had SQL 2005 Mobile installed previously and this still shows as an option. What I am missing here? Is SQL Mobile now SQL Compact Editon?
Thanks in advance,
Jack
View 5 Replies
View Related
Mar 17, 2007
Hi i have two version of SQL server express (with Visual Studio 2005) and developer edition i am trying to access an sql database file -created by the express edition integrated with Visual studio- using a developer edition instance can i just attach it and access it. and can i use BI and reporting services on that file
View 1 Replies
View Related
Jan 28, 2008
Hi,
I have recently upgraded a SQL x64 server from Developer Edition to Standard Edition, This succeeded without issue. Following a reboot SQL Server yielded the following message
Your SQL Server installation is either corrupt or has been tampered with unable to load SQLBoot.DLL. Please uninstall then re-run setup to correct this issue.
Please can anyone help ?
Many Thanks
Marcus Stuart
View 1 Replies
View Related
Dec 21, 2007
Hi
I am interested in taking MCTS exam 70-431 for sql server 2005 implementation and maintainance.
I have been reading the hardware requirements for the instalation of sql server versions and realise that enterprise and developer editions have same minimum requirements for the operation system.
I understand that the Developer Edition includes all the functionality of SQL Server 2005 Enterprise Edition, but it is licensed for use as a development and test system, not as a production server.
Also I undestand that the developer edition supports the Windows XP Home Edition with SP2 or later but the enterprise edition does not support this operating system. The evaluation/trial version is for the enterprise edition. Can I use the developer version of sql server 2005 for my practice exercises instead of using the trial version?
I have all hardware requirements for the trial enterprise version except that I am using Microsoft windows Xp home edition version 2002 with SP2. I am trying to see if I can use the developer version of sql server 2005 as it is cheaper for me to buy this software than buying the new operating system for my computer.
According to the microsoft book for the MCTS exam 70-431 there is a section which states that before you begin you should have Microsoft Windows Server 2003 running on your computer on an NTFS file system
(NTFS) partition. Will I still be ok to use the book and be able to do all the tests in the book if i am using the developer version of sql server 2005 with my Microsoft windows Xp home edition than using the trial version which comes with the book?
Thanks
gifty
View 3 Replies
View Related
Nov 14, 2007
Hello everybody,
Wrote before but did not go any answer , try again.
I have two question about SQL compact edition (SQLCE) (.sdf) and SQL Express edition (SQLED) (.mdf).
I have been testing SQLED and have many tables and data in it.
I want know to test SQLCD and hopefully be able to communicate with the SQLED.
For this reason I was wondering the following:
1. IIs it possible to move all the tables and it constratints into the SQLCE from the SQED ?
2. Another possibility I was thinking about was to use some tables in the SQLED in the SQLCE and move data between these two databases through RDA .
However, does this two versions aloud this kind of communciation...between them....?
Thanks in forehand,
Matilde
View 7 Replies
View Related
May 10, 2006
As an ISV, I want to certify my product on Standard Edition. I am using Developer Edition everywhere. Is there a way I can do the certification using the Developer Edition, or do I need to obtain/purchase a copy of the Standard Edition?
View 3 Replies
View Related
May 13, 2007
Can I install SQL Server 2005 Developer Edition on XP Media Center Edition?
Thanks.
View 3 Replies
View Related
May 20, 2008
We have an existing installation of SQL Server 2005 Developer Edition (64bit) that we are ready to go live with and would like to change the edition to Enterprise Edition (64bit). We have purchased all the appropriate licenses. We would like to avoid UN-installing the Developer Edition and RE-installing the Enterprise Edition. There must be some way to change a registry key, provide your serial number via a command line utility or re-run the setup with the license key provided and direct it to just change the edition from Developer to Enterprise and not change any of the other settings like service account, sa account, collation, etc. Any help is most appreciated.
Thank you,
Matt
View 1 Replies
View Related
Mar 11, 2008
Hi there,
everything is ok for first run. but i leave the program relogin
than that error occured ppc2003 second edition devices. Windows mobile 5.0 device works fine.
can anybody help me?
VS2005 ver 8.0.50727
SSCE31VSTools-ENU.exe loaded
SSCE31SDK-ENU.msi loaded
machine 1
SQL 2005 loaded
machine 2
http://192.168.20.22/ssce/sqlcesa30.dll
"Microsoft SQL Server Compact Edition Server Agent" looks fine
pocket pc side
C:Program FilesMicrosoft SQL Server Compact Editionv3.1SDKinwce400armv4
.net cf 2.0 sp2
sqlce30.dev.ENU.ppc.wce4.armv4.CAB
sqlce30.ppc.wce4.armv4.CAB
sqlce30.repl.ppc.wce4.armv4.CAB installed too.
my code
---------------------------------------------
Dim RdaStr As String = "Provider=SQLOLEDB; Data Source=" + Server + ";Initial Catalog=" + DataBase + ";Integrated Security=SSPI"
Dim rda As SqlCeRemoteDataAccess
Try
rda = New SqlCeRemoteDataAccess "THIS LINE GIVES ME THAT ERROR
Catch ex As Exception
MsgBox(ex.ToString)
Application.Exit()
End Try
Try
rda.InternetLogin = [String].Empty
rda.InternetPassword = [String].Empty
rda.InternetUrl = "http://" + IP_no + "/ssce/sqlcesa30.dll"
rda.LocalConnectionString = ConnectString
Catch ex As Exception
MsgBox("Bağlantı hatası..")
Application.Exit()
End Try
------------------------------------------------------------------------------
i added the following code to very beginning of my code too.
that code lock my device
Declare Function LoadLibrary Lib "coredll" Alias "LoadLibrary" (ByVal lpLibFileName As String) As IntPtr
Dim pt As IntPtr
pt = LoadLibrary("\windowssqlceca30.dll")
pt = LoadLibrary("\windowssqlceoledb30.dll")
pt = LoadLibrary(\windowssqlcecompact30.dll)
-----------------------------------------------------------------------------
View 4 Replies
View Related
Sep 25, 2007
We have a performance problem with a SQL statement (never completes) on one of our customer€™s sites. They are running SQL Server 2005 Standard Edition with SP2. The server is dual core with 3GB or RAM.
We requested a backup of the database and restored it to a SQL Server 2005 Developer Edition Server with SP2. The server has a single CPU with 2GB or RAM. However the exact same SQL (cut and paste) executes in approx 35 seconds.
We restored the backup of the customers database SQL Server 2005 Standard Edition with SP2. The server is dual core with 2GB or RAM. However as on eth customer site the SQL never completes.
So our question is why is this happening and is there a solution?
Our understanding is that the SQL Server 2005 engine is the same but Developer Edition (aka Enterprise Edition) has additional options.
View 4 Replies
View Related
Mar 20, 2008
I tried to download PerformancePoint Server Trial Version to ther server today and I got to the configuration point of the Analysis Services Setting, and when I clicked next to proceed with the configuration I got a popup error message:
"Microsoft Analysis Server must be Evaluation, Developer or Enterprise Edition".
Now I have SQL Server 2005 Developer Edition Disc (Bought it with Visual Studio 2005) but on the server I have SQL Server 2005 Standard Edition, if I try to run the sql server developer Edition disc, I use the wizard download and it seems that the download is going through the SQL Server entire download, it's like I'm re-downloading SQL Server all over again.
Does that seem right?
what is the best approach to work around this probelm?
I appreciate any help
Thanks
View 6 Replies
View Related
Nov 1, 2005
I tried to install this on the same box and I'm not sure how to reply to setup questions since I want to keep my SQL Server 2000 intact.
View 5 Replies
View Related
Aug 19, 2007
Hello
I recently downloaded the sql mobile edition, and then I found out about the compact edition.
I understand that these are relational lite version of sql server that can run on mobile devices.
However, what is the difference between the CF and mobile edition? Why should I choice one over the other?
I have just heard about sql everywhere, seems there are all these edtions and how would you choice the right tool for the right job?
Many thanks if someone could explain further,
Steve
View 1 Replies
View Related
Aug 4, 2006
Trying to replicate,
from: Win 2K Server, SQL Std Edition 8.00.818 SP3
to: Win XP Pro, SQL Developer Edition 8.00.2039 SP4
XP has Firewall 'Off', and I added sqlservr.exe and port 1433 to the exceptions list.
Subscription on Win 2K Server gets error that it cannot connect to the subscriber system: SQL Server does not exist or access denied.
Ping from the Win2K to the WinXP box works fine.
The WinXP SQL login works when I connect from my desktop to the XP box using both SQL Ent Mgr and Query Analyzer.
Any ideas?
View 1 Replies
View Related
May 28, 2008
Hi All,
Do I need to remove Microsoft SQL Server 2005 (Standard) from the Add or Remove program to replace it with Developer Edition?
I also wondering if I would need to backup my data and log files first, would they be deleted during the process?
Thanks.
View 1 Replies
View Related