Sql Server Compact 3.5 Server Tools
Aug 18, 2007
I am having problems installing the Sql server compact 3.5 server tools beta 2 onto a Windows Vista 64 bit system. It keeps saying that either I don't have IIS installed, or I have IIS7 installed but don't have the "backward compatibility" components installed. Id so infact have IIS 7 installed, and I've installed all the IIS6 bits. There are no features named "backward compatibility", so I assumed the IIS6 bits were the right ones. Anyone get this to work? I thought I read somewhere that beta 2 doesn't support 64 bit yet - but now I can't find any mention of it.
View 10 Replies
ADVERTISEMENT
Oct 21, 2007
SQL Server 2005 SP2 Replication
I am having problems installing the SQL Server Compact Server Tools on my
Vista laptop to allow me to connect my Mobile Device running SQL Server
Compact directly to my SQL Server 2005 database through IIS.
I have done this successfully with an XP machine so I'm not sure if it is
Vista problem or not.
I have installed SQL Server 2005 SP2. When I try to install the replication
server tools (Sqlce30setupen.msi), in "System Configuration Check" window I get a failure on "SQL Server requirement" that says: "You must first install the Replication Components for SQL Server 2000 SP 3a
or higher or the SQL Server 2005 Replication Components" and the client components are full instaled in my computer.
I need help for detect and correct the problem.
Sincereously,
Alonso Junior
View 4 Replies
View Related
May 26, 2007
Hi,
I am using SQL Express 2005 server and sql compact edition for my PDA. For synchronization, which SQL Server 2005 Compact Edition Server Tools installation package do I use?
Is it Sqlce30setupen.msi or sql2kensp4.msi or sql2kensp3a.msi? I know for sql server 2005 its Sqlce30setupen.msi. Is it the same for the SQL Express 2005?
Thanks
View 4 Replies
View Related
Apr 1, 2007
Hi,
I have SQL Mobile 2005 server tools installed on my server and also my development PC. I started working with SQL Compact on a mobile application I'm developing so I downloaded the SQL Compact Server Tools and installed on my laptop and it added folders "syncSQL" to my "Program FilesSQL Mobile" folder. I used the configure web sync wizard to create a sync folder for SQL Compact and it added the file sqlcesa30.dll version 3.0.5300.0 to the new folder. The previous sync folders set up using SQL Mobile have version 3.0.5214.0 of the same file.
I then went to install the Compact Server Tools on my server (downloaded the file). When it was installing it asked if I wanted to repair or remove SQL Mobile Server Tools (it didn't do this on the laptop install). I selected "repair" and it apparently successfully installed. I checked the Program FilesSQL Mobile folder and there was no "syncSQL" folder. I created a new web sync folder and the version of sqlcesa30dll added is 3.0.5223.0.
My laptop is running XP Professional and the server is Server 2003. Both are running SQL Server 2005 SP2. It looks like it hasn't installed the server tools correctly on the server, what am I doing wrong? I'm also getting a lot of sync errors and wonder if it has something to do with Compact/Mobile incompatibility.
Some extra information: when I install the SQL Compact Server Tools on my XP Pro computer, the installer window title says "Microsoft SQL Server Compact Edition - English". When I run the same install file on Windows Server 2003 the window title is "Microsoft SQL Server 2005 Mobile SP1 [ENU] Server Tools". It seems to install different versions of the software depending on the operating system. Could someone from Microsoft please confirm that this is the case, and advise how I can get the correct SQL Compact Server Tools for my server.
Regards,
Greg
View 4 Replies
View Related
Jan 15, 2007
Hi,
I've got a big problem reinstalling the just released VS2005 Tools:
I've installed them, but then I've deinstalled them to first deinstall RC1 and install the just released RTM/W(?) of the runtime.
But since then I was not able to reinstall the VS2005 Tools: The installer just says, that a required program for the upgradepatch is missing or another version is installed.
I've also tried to reinstall SP1 of VS 2005, with the same result.
BTW, I just wanna mention, that it is very complex to look through the new released Compact Edition releases. For example for the runtime it is required that the english release is installed before another localized release. But the localized releases are not called "Language Packs" (what they are) and do not verify that the english version is already installed. Also I'm interested what the recommended installation order is for installing on a developer computer eg. in German. First the VS2005 Tools or the SDK or the runtime?
Thanks in advance,
Klaus
View 3 Replies
View Related
Sep 12, 2007
Hi
We are checking VB 9 (Orcas).
we connected to database created under with sql server 7. with this code
Public cn As New ADODB.Connection
Public Sub OpenDB()
cn.Open("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial catalog=Reservation;Data Source=.")
End Sub
this code worked well.
we know sql7 is not compatiable with vista. please tell us how to connect it wiith sql2005 . we downloaded orcas express edition beta. we created a database also. please let u know how to connect with Microsoft SQL Server Compact 3.5 (.NET Framework Data Provider for Microsoft SQL Server Compact 3.5).
Rgds
Pramod
View 7 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
Mar 22, 2007
When I try and download Sqlce30setupen.msi from the msdn site, I keep getting the install for the mobile tools. Can someone explain why this is happening. I am new to SQL compact and I am trying to go through the tutorial http://msdn2.microsoft.com/en-us/library/bb226707.aspx. This tutorial says the download should be for SQL Compact setup.
Thanks
Ryan
View 3 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
Mar 25, 2014
Am customizing SQL server MGMT tools 2012 for Mass deployment.Client had asked to remove Customer Feedback option from help menu.how to disable that.
View 6 Replies
View Related
Sep 20, 2007
Login failed for user 'TOSHIBA-USERASPNET'
I know that the file persmission for the web application have to include aspnet, so i keep resetting the folder permission for aspnet in file manager, but the login failed keeps coming back every day or two
problem is after working with VS05 Pro, SQL Server Management Studio CTP, somehow the aspnet persmission get changed, use alot of sqldatasource wizards and often there is a conflict/hang between the datasource wizard and the need to have the mdf in a dettached state within VS server explorer,
not sure but the procedure to fix this seems to be to reboot, detach and re-attach the mdf in the Sql server Studio tool, re-apply the aspnet file permission on the web app folders (wonder should i be doing this in IIS instead), make sure the mdf within server explorer is detached, the it works
anyway, getting real tired of the resulting delays and design time derailment, clues greatly appreciated, thanks
sometimes i can use View in Browser when in VS05 form view and i wont get the aspnet folder permission error and other times i do.
last thing, is it a bad idea to give aspnet full permission for the entire web applicaiton??
View 2 Replies
View Related
Jun 16, 2008
Dear All,
how can we know that wether we had server tools or client tools on my machine?
Arnav
Even you learn 1%, Learn it with 100% confidence.
View 1 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
Apr 3, 2007
Trying to learn how to use Sql Server CE, Tutorial says to open server explorer, add connection, new connection, select data source as .net sql ce (words to that effect). On my visual studio, it ain't there and I can't figure out how to get it there. I have uninstall all of the Sql Ce stuff and reinstalled it. So I'm missing some key link. What are the magic incantations to get to first base?
Ed Warren
View 4 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
May 7, 2008
Hi all
Which tool can I use for structure editing of SQL Server Compact 3.5 databases? I'm installed SQL Server Compact 3.5. I have SQL Server Management Studio Express which was installed with SQL Server 2005 Express. Unfortunately this SSMS can create and open only 3.1 databases.
View 5 Replies
View Related
Jan 21, 2008
Does Sql Server Compact Edition 3.5 support RDA synchronization with Sql Server 2000 database?
View 4 Replies
View Related
Feb 13, 2007
Hi,
I am very new to SQL Compact. I am trying to create one database which can work on the desktop application and also on a pda application. I want to create the database but I am unable to start without Management Studio. Can you guide me to the right tools so that I can create database, view it and manage it use something like Management Studio Express.
Also one more question is if my database needs to be at both places on the desktop and on pda how can i synchronise them. PDA will take using c# application data from RFID scans and then i need to sync that database on the desktop so that reports and other info can be generated from the desktop c# application. How to do this?
Please can you guide me to any webcasts or labs so i can clarify my doubts about the design.
Regards
Trushar
View 5 Replies
View Related
Mar 11, 2008
Hello,
i tried to connect to a SQL Server Compact Database (version 3.5) with SQL Server Management Studio Express (Version 9.00.3042.00).
But i get the follwing error message (sorry, it's a german message):
.....................................
Es kann keine Verbindung mit 'D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf' hergestellt werden.
------------------------------
ZUSÄTZLICHE INFORMATIONEN:
Sie versuchen, auf eine ältere Version einer Datenbank von SQL Server Compact Edition zuzugreifen. Falls es sich um eine Datenbank von SQL Server CE 1.0 oder SQL Server CE 2.0 handelt, führen Sie 'upgrade.exe' aus. Falls es sich um eine Datenbank von SQL Server Compact Edition 3.0 oder höher handelt, führen Sie die Komprimierung und Reparatur aus. [ Db version = 3505053,Requested version = 3004180,File name = D:DocumentsVisual Studio 2008Projects\_ProduktivSuperkalibrator_PrototypenSuperkalibrator_PrototypenDatenbankDatabaseTest.sdf ] (SQL Server Compact Edition ADO.NET Data Provider)
.....................................
Is there a solution to manage Compact Databases in Version 3.5?
Thanks!
Stefan Wagner
View 4 Replies
View Related
Mar 20, 2007
Hi,
We are currently having a problem with a client running Vista business for a mobile application that uses SQLCE RDA with the Web Synchronization on IIS7.
I have run through the Configure Web Synchronization Wizard and it doesn't create a virtual directory. I manually create the virtual dir and point it to the new folder the Configure Web Synchronization Wizard created.
Browsing to the url "http://localhost/sqlce/sqlcesa30.dll" gives a valid test string.
Here is the ?diag response...
SQL Server Mobile Server Agent Diagnostics
2007/03/20 15:39:49
General Information
Item
Value
Server Name
localhost
URL
/sqlce/sqlcesa30.dll
Authentication Type
Anonymous
Server Port
80
HTTPS
off
Server Software
Microsoft-IIS/7.0
Replication
Allowed
RDA
Allowed
Logging Level
3
Impersonation and Access Tests
Action
Status
ErrorCode
Impersonate User
SUCCESS
0x0
ReadWriteDeleteMessageFile
SUCCESS
0x0
SQL Server Mobile Modules Test
Module
Status
ErrorCode
Version
SQLCERP30.DLL
SUCCESS
0x0
3.0.5300.0
SQLCESA30.DLL
SUCCESS
0x0
3.0.5206.0
Reconciler Test
Reconciler
Status
ErrorCode
9.0 Database Reconciler
SUCCESS
0x0
8.0 Database Reconciler
SUCCESS
0x0
SQL Server Module Versions
Module
Version
sqloledb.dll
6.0.6000.16386
9.0 replrec.dll
2005.90.3042.0
9.0 replprov.dll
2005.90.3042.0
9.0 msgprox.dll
2005.90.3042.0
8.0 replrec.dll
2000.80.2039.0
8.0 replprov.dll
2000.80.2039.0
8.0 msgprox.dll
2000.80.2039.0
When a Windows Mobile or Pocket PC device tries to do a ServerExecute or Push or Pull it gets this error message with SQLOLEDB ...
HResult = -2147467259
Message = " [ 600 ]"
NativeError = 29022
numericErrorParameters = {600,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
Which roughly translates to from the header file ...
#define SSCE_M_INCORRECTPROVIDERVERSION 29022 // The version of the Microsoft OLE DB Provider for SQL Server is not correct. Install MDAC 2.8 or later. [,,,Version,,]
When a Windows Mobile or Pocket PC device tries to do a ServerExecute
or Push or Pull it gets this error message with SQLNCLI ...
HResult = -2147467259
Message = " [ 9 ]"
NativeError = 29022
numericErrorParameters = {9,0,0}
Source = "Microsoft SQL Server 2005 Mobile Edition"
A very similar error.
From this it seems that both SQLCE 2 and 3 seem to want MDAC 2.8+ drivers. The drivers installed with Vista for SQL Native client seem to be versioned 6.0.* and the required versioning would seem to need to be in line with MDAC 2.8.
Are there installable drivers to bump the versioning of SQLNCLI or SQLOLEDB upto MDAC 2.8+ levels?
Or is there an alternative that will make it possible to run SQLCE RDA apps with Vista as the SQLCE server (i.e. sqlcesa30.dll)?
Cheers,
Jonathan
View 5 Replies
View Related
Mar 28, 2008
SQL Server Compact Server Agent is not working in IIS6, when i put de link http://myserver/myweb/sqlcesa35.dll?diag i recive de message
Service UnavailableThe problem is in windows server 2003 IIS6
please a need help....
View 2 Replies
View Related
Apr 21, 2008
Im trying to install the SQL Server Compact Tools in Windows Server 2008, but the installation program won´t let me continue since it says that I must install the IIS Backward Compatibility Tools. The problem is that I can´t find where I do that.
I know that Windows Server 2008 is not listed as a supported os for the server tools, but surely I must at least be able to install them?
View 9 Replies
View Related
Oct 4, 2007
Is there a way to use SSIS to copy data from a SQLServer CE database to a SQL Server 2005 database?
I have a database that has only been used on a mobile device, but now I want to use it among several devices, so I want to copy the structure and data to a SQL Server 2005 database and expand it's scope.
View 3 Replies
View Related
Apr 8, 2008
Hello,
I am a SQL novice and I installed SQL Server Compact 3.5 and wanted SQL Server 2005 Express instead. I uninstalled the Compact version, but when I try to install Express, it still just installs the regular SQL Server 2005 Configuration tools. I have went so far as to uninstall all my Visual Studio Express apps and SDKs and even the .NET 3.5 framework, but it WILL NOT install the SQL Server 2005 Express. I am running 32-bit Windows Vista Home edition.
Please help.
Thanks.
View 1 Replies
View Related
Apr 25, 2008
Hopefully a simple question: Is it possible to use Maintenance Plans created on SQL Server Management Studio (installed as part of an instance of SQL Server 2005 Standard Ed.) to back up databases running on an instance of SQL Server Express Edition with Advanced Services? I don't need directions, just whether or not it is permitted.
I've been able to create the plans including establishing connections to from SSMS to the the SQL Express instance, but they keep erroring out. I just need to know if this is actually permitted since Maintenance Plans are not available on Management Studio Express Edition.
Thank you in advance for your help.
View 7 Replies
View Related
Jul 18, 2007
Hello,
I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.
I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.
The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).
One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.
I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?
Thanks
View 11 Replies
View Related
Jan 24, 2006
After installing MSDE(with SP4) and SQL Server 2000 SP4 Replication Components, the SQL Server 2005 Mobile Server Tools installation fails when running the System Configuration Check with a SQL Server requirement Error.
"You must first install the Replication Components for SQL Server 2000 SP 3a or higher or the SQL Server 2005 Replication Components"
Am I getting this error because I'm using the Desktop Engine version of the SQL Server 2000??
View 7 Replies
View Related
Nov 24, 2006
Hi,
I'm a bit confused about the editions. Will SQL Server Compact v3.1 be a successor of SQL Server Mobile v3.0 (but with desktop and mobile targets) or will the two editions coexist with SQL Server Mobile on Smart Devices and SQL Server Compact on desktop PCs?
I'm drawing this conclusion because the CTP & now also the RC1 of SQL Server Compact are only compiled for desktops (and I've also seen that the .NET library is compiled against .NET Framework 2.0 desktop edition). If I'm wrong, why are no smart device CABs provided?
My second question:
Is the file format of SQL Server Mobile & Compact the same? Can I create a SDF file with the Compact Edition on the desktop, move it to the smart device and use it there with the "older" Mobile Edition? I'm asking, because we are starting a project where we need to create a SDF on the desktop, because of performance reasons.
Thanks in advance,
Klaus
View 5 Replies
View Related
Jul 2, 2007
I've been playing around with Microsoft SQL Server Compact Edition
v3.1 as a posible replacement for the SQL Server CE 2.0 (can't
remember exactly what the called it). Its working pretty well. I
was able to connect to the database using the same recordset object,
ADODB.RecordSet and connection object, ADOCE.Connection.3.1. However
where I've run into trouble is when I try to compact the database.
This code works on 2.0.
srcConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"
destConn = "Provider=Microsoft." & "SQLServer" & ".OLEDB.CE.2.0;Data
Source=myDB.sdf"
Set DBEngine = CreateObject("SSCE.Engine.2.0")
DBEngine.CompactDatabase srcConn, destConn
But now when I try to run it vor v3.1
srcConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=myDB.sdf"
destConn = "provider=microsoft.sqlserver.mobile.oledb.3.0;data
source=mDB1.sdf"
Set DBEngine = CreateObject("SSCE.Engine.3.0")
DBEngine.CompactDatabase srcConn, destConn
I get this error message:
Info: Object required: 'DBEngine'
As I understand it SSCE.Engine.3.0 is still an ActiveX
object. Is it no longer posible to run this directly from
asp?
View 1 Replies
View Related
Feb 2, 2007
Hello,
After installing SQL Server 2005, I get a message stating "You must use SQL Server 2005 management tools to connect to this server", while trying to connect to my localhost using SQL Server 2000 Enterprise Manager.
Regards,
junior
View 4 Replies
View Related
Jun 22, 2000
Hi,
A quick Q for all the Sql Server 2000 beta testers out there. Does anyone know of any problems associated with using SS2000 Enterprise Manager with a SS7 backend running SP2? In particular, I'm keen to try out the Tsql debugger features, if they'll work with SS7.
Many thanks in advance,
Jon Reade,
Sql Server 7 DBA
NEC Technologies (UK) Ltd
Telford, Shropshire.
View 1 Replies
View Related
Jan 20, 2007
I have installed SQL Server 2005 Mobile edition and also the server tools.
I configured a website to sync with my mobile application. When I go t check the SQL server Mobile agent with this url:
http://localhost/MobileTest/sqlcesa30.dll i get a http 500 internal error
I am using remote desktop to access the machine, when I am directly on the machine there is no error I get the correct message in the browser
"SQL Server Mobile Server Agent 3.0"
Is access to the web site via remote desktop a problem?
jawahar
View 1 Replies
View Related
Nov 6, 2007
Hello,
I want to load-balance my PDAs accessing my database to make a merge replication.
As I have one server with the SQL Server Mobile Server Tools installed, can I configure some of these PDAs to use another server with SQL Server Mobile Server Tools to point on the same Database server?
Is it going to work or will it generate problems?
Thanks for your help,
Ben.
View 4 Replies
View Related
