SQL Compact 3.5 With VS2008
Feb 8, 2008
I have VS2008 (9.0.21022.8 RTM) and I cannot get SQL Compact 3.5 to work with it. Whenever I attempt to open a compact edition database, I get a message that "The operation cannot complete, click OK on the "Package Load Failure" dialog, reinstall SQL Server Compact 3.5 and then from the command line run devenv /resetskippkgs. I've tried that twice and no joy. I can connect and work just fine with SSMS 2005, but I cannot get it to work in VS2008.
Also when in VS2008 and I go to Server Explorer | Data Connections | Add Connection, I do not have Microsoft SQL Server Compact 3.5 in the list.
Any suggestions? Thanks.
-John
View 10 Replies
ADVERTISEMENT
Nov 30, 2007
I'm using VS2008 RTM with a new SQL Compact 3.5 database and I read in VS2008 and SQL Compact 3.5 BOL that Database Diagrams are supported as well as Foreign Key creation from Server Explorer.
However, there doesn't seem to be support for this. Database Diagram commands are not displayed for this new database (but it is for my SQL Express database) as instructed by BOL.
Can anyone tell me if VS2008 fully supports SQL Compact 3.5 with database diagrams and visual tools to create relationships? If so, how can you create a database diagram in VS2008 for SQL Compact 3.5?
View 1 Replies
View Related
Feb 4, 2008
Hello
Know that VS2008 is out, when would be possible to create SSIS and BI projects for SQL2005 with it?
Thanks a lot.
View 1 Replies
View Related
Feb 25, 2008
I have VS2008 installed which has installed SQLEXPRESS. But it seems not all of it.
I want to be able to create tables and generally mess about with SQLEXPRESS without VS2008, is it safe to install Sql Express from this site that will hopefully? install all the management tools? Will this action compromise the VS2008 installation? Will I need to uninstall all the SQL Server stuff that is currently installed?
I am a complete noob when it comes to SQL Express having done all my SQL using Access.
Many thanks
Andy
View 1 Replies
View Related
Nov 20, 2007
I 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.
View 5 Replies
View Related
Feb 21, 2008
I was initially interested in building my small retail app on Framework 3.5, until just now when I saw the download size. I won't make a single sale with that as a prerequisite.
I would, however, like to use VS2008 for this. If I target Framework 2.0, will I still be able to use SQLCE v3.5? The new SET IDENTITY INSERT functionality is an absolute requirement. (Note: I haven't installed VS2008 yet--I'm still investigating options.)
Thanks!
View 1 Replies
View Related
Dec 1, 2007
Hi. I recently upgrading my dev machine to Vista and VS 2008 simultaneously (clean install) and upgraded my VS2005 project, which was previously using SQL CE 3.1. Now when I compile and run it, I get a database exception telling me to upgrade my database to version 3.5!
First of all, I tried running the Repair() method to upgrade the database file, but then I get an exception telling me the password is incorrect (it most certainly is not, I didn't change a thing), so it won't even let me upgrade it.
Secondly, I even tried removing the reference to System.Data.SqlServerCe and manually adding the verison 3.1 reference back, but it still for some reason loads version 3.5 instead of version 3.1.
So! Please either tell me how I can properly upgrade my users' database file to version 3.5 and have it work with the latest libraries, or tell me how I can at least use the old libraries like I was under VS2005. The .dll files are all present in the project and I haven't changed them at all, they're being properly copied to the output directory and everything. I even checked the "Specific Version" attribute on the reference in the project, but no help.
Do I have to do something special to tell my application to load the local copy of the assembly as opposed to, say, one in the GAC?
View 1 Replies
View Related
May 10, 2008
I've just upgraded my C# app from .NET 2.0 to 3.5 in VS 2008. Now my SQL Server CE database file won't open. When I run the app, it falls over on the connection.Open() method call, saying I have to upgrade the database to 3.5. It says if it was created in 3.0 or 3.1 to run the compact/repair utility. Well, I did that - a full compaction - but it didn't help at all. According to somewhere on MSDN, I should get an option to upgrade if I reconnect to the database in Server Explorer. Not so. It connects quite happily. If I try to connect to some earlier copies of the database, I do get this dialog, so I am assuming that it has already been upgraded. But then why won't the damn thing work?
I tried running the command-line upgrade.exe too, but being a bit clueless when it comes to the command line, I couldn't get it to work. Kept telling me the thing wouldn't run in Win32 mode, even though I was running it from the command prompt (sigh!).
View 2 Replies
View Related
Feb 4, 2008
we're getting an error that says "C:....rptproj' cannot be opened because its project type (.rptprroj) is not supported by this version of Visual Studio. To open it, please use a version that supports this type of project." when trying to open RS projects created in VS2005 with VS2008.
We concluded from the specs on VS2008 that the DB Version of VS2008 wouldnt be necessary for RS projects. Were we wrong? Is there some other add in that we need, perhaps BIDS? Is there some conversion step that we need to follow?
View 1 Replies
View Related
Apr 28, 2008
I'm using VS2008 (as shipped with SQL CE 3.5 as shipped).
I want to write a database app and started with a quite simple example:
One table "Master" has 2 columns: int MasterID, int Value (where the MasterID is the primary key and is an identity column.
For the GUI I used the typed dataset components (based on the namespace: System.Data.SqlServerCe) which were automatically generated by VS2008. I just dropped the table from the datasources view to a form and got a DataGridview, a Navigator and some DB components, quite fine so far.
When i run the app i can add new rows and the identity column is filled with -1, -2 ... as expected. When I hit the save button, the rows are saved to DB, but the values of the identity columns are not updated (the still have -1, -2..)
When I use the exact same example with SQL Express evrything works fine: the identity Column's values are updated automatically and have +1, +2, ...
Sure there is a statement "SELECT @@IDENTITY"... but I'm just using automated code so far, and i expect that code to work (automatically). Next problem: if i want to insert that "Select @@identity" stuff (I don't want to do that, but perhaps I have to?) where can I do this, I did not found a OnInsertedRow-Event?
This problem is part of a bigger one: I want to use Master/Detail, but inserting the Details fails because the inserting of the master rows didn't return the correct Indentity values, so the detail rows cannot be inserted (the foreign keys -1, -2... will raise an error).
thanks in advance, Bernd.
View 6 Replies
View Related
Dec 12, 2007
When I try to convert a report project from 2005, it seems to convert fine but then the project closes because VS2008 doesn't support that project type (.rptproj ?). I see that there is a report project type under VB (and I assume C#) but there is no Business Intelligence project catagory. It's a new machine and I did install SQL Server 2005 before VS2008.
I'm in the process of moving a bunch of projects and websites from another machine and got hung up on this one. Any pointers greatly appreciated.
View 1 Replies
View Related
Jan 26, 2008
Parser Error Message: Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
I'm not sure what to do to fix this. I've downloaded the redistributable for the report viewer. Please help, I need to have this before the weekend is over.
Thanks,
View 4 Replies
View Related
Mar 12, 2008
Dear,
I Had VS20005 and SQL 2005 Working perfectly. For some errors, I did formatted my PC and installed VS2008. After doing that, I am trying to install MSSQL2005, when installation be in "Integration development environment with 2005" Phase, An error appears, and the installation stopped. What I have to Do to solve this?
Note: I ahve XPSP2 32 bit installed.
View 5 Replies
View Related
Apr 11, 2008
Hi,
A simple question. I installed successfully Visual Studio 2008 Standard edition on my VISTA Ultimate 32bits machine. During install process, I also checked SQL Server Express 2005 item.
Which version of SQL Server Express 2005 did it install? Are we talking about SP2? If so, can I install without problem a more complete SP2 package using following links
SQL Server 2005 Express Edition with Advanced Services SP2 http://go.microsoft.com/fwlink/?LinkId=65109
Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?LinkId=65111
without screwing the now existing SQL Server Express setup VS2008 installed?
Thanks in advance,
Stéphane
View 14 Replies
View Related
Apr 10, 2008
I have a problem installing BIDS. On a XP machine with Visual Studio 2003 and Visual Studio 2008 installed, i tried to install SQL Server 2005 DE with SSIS and Client Tools. All works fine, but the devenv.exe where BIDS start menu shortcut points to doesnt exist.
In SQL Server installation dialog, i tried uninstalling BIDS (168 MB disk space will get free'd...) then again installing BIDS (...needs 168 MB disk space...), a lot of harddisk activity, but all the same.
I searched for devenv.exe on drive c:, only two hits: The VS2003 and VS2008 files.
I tried uninstalling VS2008, VS2003, .net3.5, .net3.0, .net2.0 and SS2005, then installing SS2005 with BIDS, again BIDS start menu shortcut points to nowhere. No devenv.exe on drive c:
Now i used system recovery to go back to the point before uninstalling all the stuff, so i can do all my work beside BIDS/SSIS, seaching for a solution...
I thought about installing VS2005 prof., but the license is lost because i upgraded to VS2008.
Note: The VS2008 is installed without installing the SQL Server coming along with VS2008.
Any help?
alberich
View 4 Replies
View Related
Apr 15, 2008
I have previously installed SQL Server 2005 Client tools on my machine (XP Professional). When I launch Visual Studio 2005 and go to create a new project, I can see all of the Business Intelligence Templates (i.e. Report Server Project, Integration Services Project, etc).
I recently installed Visual Studio 2008. When I go to create a new project in VS2008, none of the Business Intelligence templates appear.
How would I go about getting these BI Templates to appear so that I can create new Report Services projects in VS2008?
Thank you in advance for your assistance.
View 5 Replies
View Related
Feb 12, 2008
Using the new Visual Studio 2008 I created a setup project for a small program, and added SQL Express 2005 SP2 to the list of prerequisites.
I checked the box so the setup project will contain all necessary files in a sub directory of the setup project.
My setup starts nice (on windows vista) prompts me to install SQL Express, setup of SQL Express runs for some time, I get an UAC prompt, then setup fails with error 1706.
The last lines of the setup log file:
Installing using command 'C:UserswilfiAppDataLocalTempVSDE5B7.tmpSqlExpresssqlexpr32.exe' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1'
Process exited with code 1706
Status of package 'SQL Server 2005 Express Edition SP2 (x86)' after install is 'InstallFailed'
I really would like to install SQL Express as part of the setup project, can someone help me with this problem?
Thanks in advance,
Sam
View 8 Replies
View Related
May 31, 2008
Ok so here's what happened:
Installed Server 2008 (64bit)
Installed VS2008 (+SQL 2005 Express, by default)
I've always installed SQL 2005 Dev (including the SQL Management Studio) before installing VS. Now I am trying to install just the management studio on this machine without success.
I tried installing the SQL workstation tools package from the SQL 2005 DVD but the installer detects the tools installed by SQL express (osql, etc.., but no management studio GUI) and the installer refuses to install anything else. I also tried downloading the separate installer for SQL management studio but it doesn't like something also: first thing the installer does is display this mesage:
"Installation of this product failed because it is not supported on this operating system For more information on supported configurations, see the product documentation."
Any way to do this without having to reinstall VS?
Thanks.
View 4 Replies
View Related
Jun 17, 2015
I am in the process of importing an Excel Spreadsheet using the natively connection manager in SSIS 2008. There is one column however that is causing me grief.
SSIS has natively chosen the problematic column to be a DT_WSTR(255). I have gone into the Excel connection manager's Advanced Editor and altered it to be a DT_WSTR(1000) (see image 1 attached).
I am still getting truncation issues though, as per image 2 attached. why this is?
View 6 Replies
View Related
Jan 15, 2008
Hi 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
View 2 Replies
View Related
Feb 19, 2008
I have both vs2005 and vs2008 installed. I'm working with a .Net Compact Framework 3.5 Smart Device Project.
If I refrence the System.Data.SqlClient.dll (Version 3.0.3600.0 Runtime v2.0.50727)
C:Program FilesMicrosoft SQL Server Compact Editionv3.5DevicesClientSystem.Data.SqlClient.dll
When I deploy the application I get an error ".Net Compact Framework v2.0 could not be found Please install it and run the setup again"
Studio is :
Deploying 'C:Program FilesMicrosoft Visual Studio 8SmartDevicesSDKSQL ServerClientv2.0wce500ARMV4isql.ppc.wce5.armv4i.CAB'
We tested this on a PC without vs2005 and it seems to work fine.
Any suggestions?
jlj
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
Oct 21, 2007
Hi all,
I couldn't debug SQL Server by "Step into Stored Procedure" on Server Explorer of VS2008 (or VS2005) to SQL 2005 Developer on remote Windows Server 2003 machine, it allway issue exception "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"
1) The environment:
The Client: Windows XP SP2 (WORKGROUP)
Visual Studio 2008 (or VS2005)
The SQL Server Machine: Windows 2003 Server Sp1 (DOMAIN)
SQL Server 2005 Developer
2) User account and Permission login:
I create the same user account for both Client and Domain Server with the same password, i also add that user to "Administrators" group in both machine.
At the SQL Server on Server machine, i added that account to ServerSecurityLogin with 'sysadmin' role already
3) Connection and authentication:
I used "Windows Authentication" for my connection to SQL server, and i checked sure my account of the connection by SQL command
SELECT SYSTEM_USER,
IS_SRVROLEMEMBER ('sysadmin')
4) Firewall:
I checked firewall like MSDN helping (i also tried to test by turn off firewall in both machine)
5) Visual Studio Remote Debugger:
I read "How to: Enable SQL Server 2005 Debugging" on MSDN with comment "The SQL Server can run on the same machine as the application or on a remote machine. If you are debugging T-SQL code only, then no remote setup is required."
so i didn't config Visual Studio Remote Debugger any thing.
Note: If i "Step Into Store Procedure" at Server locally, it works okey, so on at my PC client locally. But if i move debugging from my client to my Server, it occur error "Unable to start T-SQL Debugging. Could not attach to SQL Server process on 'Server'. Click Help for more information"???
If i execute store procedure on Server Explore, it works okey!
Please help me to find out what problem is???
Thanks,
Haiasc
View 2 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
Jul 20, 2005
No one answered in another group, please help.Using access 2000 /msdeI know how to compact the access project file (.adp), there's a menu choicefor that.How do I compact the tables and stored procedures on the server? ( The .MDFfile)I only have the DOS promp OSQL utility to work with.thanks
View 1 Replies
View Related
Aug 20, 2007
I'm trying to add an SQL Compact Edition database to my application running on a CE 6.0 platform that I am also developing. Unlike PB 5.0, I don't see sql CE listed as an option in the catalog and when I try to run my application I get a pInvoke sqlceme30.dll error. I have found a number of references to this same issue elsewhere but no real good solutions. Most seem to point to the cab files not being deployed. I am thinking that I should have the necessary support files deployed in the CE image and I have downloaded and installed every sql CE version/update that I can find but none of them seem to add support to PB 6.0.
I am trying to add the cab files manually but I would appreciate any suggestions if there is a better solution............ Thanks
View 1 Replies
View Related
Jul 5, 2007
Hi,
Is SQL Server Compact Editon 3.1 supported on Windows CE 6.0?
When I install the cab file sqlce30.wce5.armv4i.CAB in CE 6.0 it says that it might not be compatible. If I continue anyway it seems to work fine, but only the first time the application starts and accesses the database. When restaring the application it fails to connect to the database until I have reinstalled the cab file.
Any clues about this?
Thanks!
/ Joel
View 1 Replies
View Related
Feb 11, 2007
Hi,
I have an application where I need a desktop Application to manage the data and I have PDA application which talks to RFID and gathers the data. I am a bit confused if i can have only one database which can work both on PDA and Desktop. Can you please help me decide if i should use compact or express for this purpose. Also I might have to use both compact and Express but is there a way to have common database for both where they can be replication and easily synchronised.
Help is much appreciated.
Regards
Trushar
View 3 Replies
View Related
Feb 11, 2007
Hi,
I am wondering why a database that was 2Gb in size would come down to just 300Mb when I copy all the data from the origional database into a blank new one.
I ran a database shrink on the origional database but that only reduced it from 2.1 Gb to 2Gb.
I was shocked to see the size difference when I copied the data.
As far as I can tell the copied database still contains all the records of the origional.
I remember that MSAccess had a Compact function that literally copied all the data from one databse into a new empty one - is there the equivalent for SQL?
Any thoughts?
Thanks
View 8 Replies
View Related
Apr 5, 2007
Hi,I just deleted about 1 million records from a SQL Server 2000 database. Iaccess it using Access 2000.I have Compact and Repair available in the adp under Tools. Should I do thatfrom Access? Will it not mess anything up?Thanks!J~
View 2 Replies
View Related
Jul 20, 2005
Is there a stored procedure that allow the compact database programmaticallyin SQL Server?
View 2 Replies
View Related
Mar 1, 2007
Can SQL Server Compact Edition do RDA with SQL Express? or I need to have SQL Server 2005(standard) instead of SQL Express? I will use RDA to synchronize the Compact Edition database on the phone and SQL Server database on desktop.
Thanks!
View 1 Replies
View Related
