I am redevoping an application originally written in Visual Studio 6, Accessdb ; and Embedded ce.
I am now using Visual Studio 2005 (with the Windows Mobile extensions); SQL Compact. This is on a Vista machine. I am new to this environment.
I have the Visual Studio and the SQL Compact installed and have written some very basic programs. It is progressing, but I am stuck on a few issues:
-- What tool should I be using to manage the SQL Compact DB; I have seen conflicting notes on the net. At this point in time I can use the SQL Query and wizard within Studio 2005, but would like to know if there is front end for SQL Compact.
-- I am struggling with the interface to SQL Compact from within VS 2005. Specifically, if I try to run a "CREAT TABLE ...." command from code it appears to complete, but the table is not created. If I run same "CREATE TABLE " from the query pane available within VS 2005, a warning message comes up along the lines of "CREATE TABLE ... not suported" / "Cannot display this query graphically <or somthing along these line -- don't have the dev environment in front of me write now>" with the warning window having a heading of "...SQL Diffs...". Once I click through this warning, the table is created.
-- Once I get past this initial learning curve, I will be getting data from an SQL server into SQL Compact and then onto a windows mobile PDA. Ideally I would like to dump Schema and data from SQL Server in a form that SQL Compact db (via VB program) be able to import. Any pointers?
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
I have recnetly purchased a new notebook and I am trying to work on my projects in VS2005. I have istalled the Vista Patch for VS2005, and i can view the data files on both my Win Mobile database and the ODBC database if I chose preview data. However if I try to start debugging, I get this error right on the first line of code :this.clientsTableAdapter.DeleteQuery(); This all runs fine on Win XP
VS tries to run : Can I get this to run on Vista??
System.Data.SqlServerCe.SqlCeException was unhandled Message="An internal error occurred. [ ID = 3640 ]" Source="SQL Server 2005 Mobile Edition ADO.NET Data Provider" HResult=-2146697111 NativeError=28574 StackTrace: at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommandText(IntPtr& pCursor, Boolean& isBaseTableCursor) at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options) at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery() at FBWinMobileSync.FB7MobileDBDataSetTableAdapters.ClientsTableAdapter.DeleteQuery() in C:UsersPublicProjectsFBWinMobileSyncFBWinMobileSyncFB7MobileDBDataSet.Designer.cs:line 5729 at FBWinMobileSync.Form1.SyncButton_Click(Object sender, EventArgs e) in C:UsersPublicProjectsFBWinMobileSyncFBWinMobileSyncForm1.cs:line 77 at System.Windows.Forms.Control.OnClick(EventArgs e) at System.Windows.Forms.Button.OnClick(EventArgs e) at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent) at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ButtonBase.WndProc(Message& m) at System.Windows.Forms.Button.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.DebuggableCallback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.Run(Form mainForm) at FBWinMobileSync.Program.Main() in C:UsersPublicProjectsFBWinMobileSyncFBWinMobileSyncProgram.cs:line 17 at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart()
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?
I am thinking about installing dvd microsoft office ultimate 2007 visio before I install sql server 2005 sp2. I already have visual studio 2008 rtm pro professional vl on my vista computer. Will I have any issues doing this? Thank you
I have a couple of questions which is better for commercial development the standard edition sql or sql express edition? Does the express edition 2005 in visual studio professional come with advanced services or do you have install sp2? Has anyone installed sql 2005 reporting services on vista ultimate is there anything I should know besides the article How to install sql reporting services on a windows vista computer? Thanks I have sql express on my visual studio 2008, however I have not installed it. Will this be a problem if I install standard ediion?
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.
Hello, How are you? I have a problem when I try to create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE. When I€™m going to choose the data source, the SQL Server 2005 Compact Edition provider doesn€™t appear in the list. I installed the SQL Server 2005 Compact Edition from this page http://www.microsoft.com/downloads/details.aspx?FamilyId=%2085E0C3CE-3FA1-453A-8CE9-AF6CA20946C3&displaylang=en. In the additional information says by installing SQLServerCE31-EN.msi installs the provider (System.Data.SqlServerCe.dll) in the GAC (global assembly cache) and registers the OLEDB provider (sqlceoledb30.dll). So, I don€™t understand why couldn€™t I create a new connection with Microsoft SQL Server 2005 Compact Edition from Visual Studio 2005 IDE?
Hi, I am running SQL Server 2005 x64 DE on Vista x64. I installed MS VS 2005 Pro. Edition. During the setup of VS, I did a custom install, un-checking the SQL Express addition box. After installation, I received errors that indicated the SQL Express did not install. Even though I do not have SQL Express installed on my machine, MS Update says that I need SQL Express SP2. My SQL DE is up to date with SP2 and MS Update indicates as "optional" that I need SQL SP2.
Is SQL Express a necessity for VS Pro? If not, why is MS Update indicating that I need SQL Express SP2? In addition, why is MS Update telling me I need SQL SP2 when it is already installed?
Note: I installed SQL SP2 manually, not through MS Update. This makes me believe that MS Update is not detecting it.
I have a database in my "App_Data" folder of my visual studio project. I can view it fine in Visual Studio's built-in tools for managing a database attached to a solution. However i recently started playing around with the SQL Server Management Studio Express program. When i attach my database to Management Studio, and try to run my program it crashes. I think it might be a permissions error?!? When i detatch it and reattach it in visual studio it runs fine again. Any suggestions? ThanksJason
I recently installed the Evaluation Edition of SQL Server 2005 x64 and it appears that MS Visual Studio 2005 is installed in stead of SQL Server Business Intelligence Development Studio. When I choose new project the only template available is "Blank Solution". How do I get all the templates (i.e. Analysis Server Project, Integration Services Project, Report Model Project, Report Server Wizard project, etc.)?
Or would it be better to uninstall MS Visual Studio 2005 and attempt to reinstall BIDS?
I am new to visual studio and I am still not sure of all its components and features.
I installed visual studio 2005 standard edition but cannot find SQL Server Management Studio?
I guess this must be because it is not included with Visual studio 2005 standard. Is it included with VS 2005 professional?
I want to add pictures of products to my shopping site using an SQL database and I’ve been told that SQL Server Management studio is required as it is a graphical tool.
How would I go about obtaining the SQL server management studio. There seems to be different versions of SQL server that it is confusing to know which one to purchase.
Will the SQL server 2005 version that comes with Visual studio standard be sufficient for me now right? I want to create a shopping site with hundreds, perhaps even thousands of products. I want to use an SQL server 2005 database. The database will include ‘dynamically generated’ product images if that is the correct terminology.
My goodness, it seems I still have so much to learn.
I have created a database under management studio and i want it to be connected in visual studio but it failed the error msgs said that the database can't be connected coz the database with same name exits but that is not true
How do i get the database that i am using in visual studio into my SQL server management studio? i need to create some scripts to create stored procedures on a live server.
I have SSRS in Visual Studio. I created a query that works fine in SQL Server Management Studio, but when pasted into Visual Studio I get the error "An expression of non-boolean type specified in a context where a condition is expected, near '('.
Here is the query. Can anyone help on why this isn't working? Thanks.
SELECT CASE WHEN MONTH(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = MONTH(GETDATE()) AND YEAR(dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate) = YEAR(GETDATE()) THEN dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount ELSE 0 END AS CurrentMonth, CASE WHEN SubString(dbo.MAS_CCS_GL_Account.Account,1,3) = '400' THEN 'ALEDO' ELSE ' ' END AS Location, dbo.MAS_CCS_ARN_InvHistoryHeader.SOTransDate, dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber, dbo.MAS_CCS_AR1_CustomerMaster.CustomerName, dbo.MAS_CCS_ARO_InvHistoryDetail.DetailSeqNumber, dbo.MAS_CCS_ARO_InvHistoryDetail.LineType, dbo.MAS_CCS_GL_Account.Account, dbo.MAS_CCS_ARO_InvHistoryDetail.SOExtChargeAmount FROM dbo.MAS_CCS_AR1_CustomerMaster, dbo.MAS_CCS_ARN_InvHistoryHeader, dbo.MAS_CCS_ARO_InvHistoryDetail, dbo.MAS_CCS_GL_Account WHERE dbo.MAS_CCS_AR1_CustomerMaster.CustomerNumber = dbo.MAS_CCS_ARN_InvHistoryHeader.CustomerNumber AND dbo.MAS_CCS_ARN_InvHistoryHeader.InvoiceNumber = dbo.MAS_CCS_ARO_InvHistoryDetail.InvoiceNumber AND dbo.MAS_CCS_ARO_InvHistoryDetail.SOGLSalesAcct = dbo.MAS_CCS_GL_Account.AccountKey
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?
I'm very confused. I installed Visual Studio 2005 and thought I understood that SQL Server 2005 came with it, but it appears that it's SQL Server 2005 - Express. Can anyone tell me what I need to do in order to get Data Transformation Services loaded or the equivalent of DTS in SQL Express?
Hi there, after some hours of installing and experiments i can now open and sql server compact database (sdf) iam also able to create a new database and add tables and columns. (everything with the ms sql server management studio express)
i can also open the northwind database. but iam not able to view the data .
if i rightclick on a normal database table i can choose ->open table and see its content.
but on a compact table i have at rightclick only
edit table properties delete
refresh
how can i see the data in the table or add new content ?
i don't know if it was mentioned before, but i solved the issue that Microsoft SQL Server Management Studio Express won't show the option to create/modify a sql compact database by installing not this Version:
Microsoft SQL Server Management Studio Express Date: 19.04.2006 http://www.microsoft.com/downloads/details.aspx?FamilyID=c243a5ae-4bd1-4e3d-94b8-5a0f62bf7796&DisplayLang=en
but this one:
SQL Server Management Studio Express Service Pack 2 €“ CTP-Version Date: 19.12.2006 http://www.microsoft.com/downloads/details.aspx?FamilyID=ccbda432-8ecf-4c82-bdef-b575eaf07f55&DisplayLang=en
hope this helps.
Nihat
P.S. i'm curious if anybody else had the same issue, caused of using the wrong Version of SSMSe?
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.
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 ...
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)?
I watched and followed the Intro to VB 2008 Express, but in the final part of the video, when you add a database, i did everything as the video says, still i get:
An error occurred creating the form. See Exception.InnerException for details. The error is: Unable to load DLL 'sqlceme35.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E)
Ive tried the fix stated in another forum, the one about changing the "Target CPU" but the option doesn appear, what does appear its the "Platfrom" dropdown list, but its fixed to "Any CPU" and dont have any more options.
Ive also downloaded Microsoft SQL Server Compact 3.5 ENU and "re-installed" and selected repair, followed the steps, rebooted and still nothing.
I'm trying to install "SQL Server Management Studio Express" on a PC running Vista and I get the following message.
"Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation."
I just recently purchased a sony with Vista business preloaded. It seems like it came with MS 2005 Sql Server but I'm not sure what edition. I went to the start menu to locate the Management Studio however the only option was the Configuration file. I went to MS site and downloaded the 2005 Sql Server Express Edition with Advance Service SP2 and it installed correctly. I believe this edition comes with Management Studio. However when I went to my Start Menu, the Management Studio file is still not there. How do I fix this problem? I am new to the MS Sql so a detail explanation will be appreciated. Thanks in advance.
When I try to create a database that will have fields for a date and a time the only data type option in visual studio is datetime. This stores data as dd/mm/yyyy-00.00.
how can I set it to store either a date dd/mm/yyy or a time 00.00 but not both.
Hi all, Have tried running a dts package but Im unable to add the reference Microsoft.Sql.managedDts. Is there any other way that i can do tat from Visual studio code behind page? I need to let the user to trigger the package from the web application. Thks in advance.
visual studio 2005 how will i know what edition of visual studio i have? i have seen in connection strings the .sqlexpress. does it mean that it is express edition? but the owner of my cd told me that it is not.
can u help me build my connection string?
when i uninstall visual studio, will my files be lost? or i can still access them when i reinstall it? because i'm planning to uninstall and reinstall it but i don't want my files to be lost. tnx
