Error Trying To Open RS Proj In VS2008
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
ADVERTISEMENT
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
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
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
Jun 26, 2006
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks
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 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
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
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
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
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
Sep 20, 2004
Hi,
I have MSDE SP3 and the only thing that I have changed recently is my Windows login Password. In the
Enterprise Manager the SQL server is registered using mixed authentication.
When I try to open any DTS in Design mode, I get a error dialog with the title 'DTS Design error' and
saying that
"Error occured during creation of a DTS package"
and then when I click on the OKAY button I get the 2nd error dialog saying:
"The selected package cannot be opened. The DTS designer has been closed."
Can someone please help me out here.
Thanks.
View 5 Replies
View Related
Nov 25, 2007
System.Data.SqlClient.SqlError: Cannot open backup device '\.Tape0'. Operating system error 5(error not found). (Microsoft.SqlServer.express.Smo)
i have only one sql instance and tape is istalled successfully.
please help me to find solution for this error.
Thanks,
View 2 Replies
View Related
Apr 16, 2008
Looking at the below code you can see that I have a separate Connection for each Insert Statement.'OPEN CONNECTION TO ESOSQL
MyConnection = New SqlConnection("......")
MyConnection.Open()
'check if there are existing charges for this person. The user must enter in atleast 1 charge before proceeding with arrest insert.
MyCheck = New SqlCommand("SELECT * FROM ARREST_CHARGES WHERE ARRESTNO = '" & Session("uid") & "'", MyConnection)
MyCheck.CommandType = CommandType.Text
MyDataReader = MyCheck.ExecuteReader
If MyDataReader.HasRows Then
MyConnection1 = New SqlConnection("...")
MyConnection1.Open()
MyInsert = New SqlCommand("INSERT INTO ARREST_INDEX (ARRESTNO, NOTES) VALUES ('" & Session("uid") & "','" & tx_notes.Text & "')", MyConnection1)
MyInsert.CommandType = CommandType.Text
MyInsert.ExecuteNonQuery()
MyConnection1.Close()
MyConnection2 = New SqlConnection("....")
MyConnection2.Open()
MyOtherInsert = New SqlCommand("INSERT INTO ARREST_COMMENTS (ARRESTNO, NOTES) VALUES ('" & Session("uid") & "','" & tx_notes.Text & "')", MyConnection2)
MyOtherInsert.CommandType = CommandType.Text
MyOtherInsert.ExecuteNonQuery()
MyConnection2.Close()
Label1.Text = ""
Else
div1.Style.Add("display", "block")
Label1.Text = "You must enter charges before proceeding."
End If
MyConnection.Close()One would think I should only have to use one connection. However, if I use only one I get this error:There is already an open DataReader associated with this Command which must be closed first. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidOperationException: There is already an open DataReader associated with this Command which must be closed first.Source Error: Line 60:
Line 61: MyInsert.CommandType = CommandType.Text
Line 62: MyInsert.ExecuteNonQuery()
Line 63:
Line 64: ' MyConnection1.Close()The only way I could get rid of it was to encapsulate each individual INSERT statement within its own connection. This seems to me as very inefficient. Can anyone explain why I couldn't just use one connection?Thanks.
View 5 Replies
View Related
Feb 14, 2005
Hi, I am accessing an MSDE Database from within a C# program. When calling the OleDbConnection.Open() method, I get the following error:
Exception: System.Data.OleDb.OleDbException
Message: Object was open.
at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbConnection.InitializeProvider()
at System.Data.OleDb.OleDbConnection.Open()
Now I do not know what this means, since the Connection isn't open. And I do not know why this occurs. I am accessing the same database (but other tables) in the same program several times in the same way and do not get this error.
Any ideas?
View 2 Replies
View Related
Sep 25, 2001
Hello All,
One of my clients is accessing SQL Enterprise Manager via
Citrix. He is getting an error message 'Unexpected error occured during this operation' while opening tables and displaying all rows in Enterprise Manager.
When I try the same thing through Enterprise Manager installed locally on my PC, I do not get any errors.
Has anybody faced a similar problem?
I am quite new to SQL Server. Please help.
Thanks in advance
Sumathy
View 1 Replies
View Related
Nov 8, 2005
I created a few DTS packages in our Test Server saving them as file.dts. When I try to open them in from the production server I get an Unexpected error and the DTS is not opened. Do you have any fresh idea for me, please? Thanks!! :)
View 1 Replies
View Related
Jul 23, 2005
Help! One of my main databases has been marked as suspect - theinitial problem is that my disk had no space. So I moved some files,made some space, stopped & restarted the service, and now I get thiserror in the errorlogs. There can't be anything else using thedatabase - I restarted the machine to kill everything that might betouching it, including the client application.2005-03-30 14:35:21.96 kernel udopen: Operating system error 32(Theprocess cannot access the file because it is being used by anotherprocess.) during the creation/opening of physical devicec:mssql7data<database>.mdf.2005-03-30 14:35:22.01 kernel FCB::Open failed: Could not open devicec:mssql7data<database>.mdf for virtual device number (VDN) 1.2005-03-30 14:35:22.03 spid6 Device activation error. The physicalfile name 'c:mssql7data<database>.mdf' may be incorrect.
View 1 Replies
View Related
May 8, 2007
I am developing a web service that uses a sql data connection.
The sql database is on a server, and the development version of my web service is on my pc.
I can connect/access the data accross my network when I run the service on my PC, but as soon as I put the web service onto the server(with the sql) it displays, the service wont function - error: 40 - could not open a connection....
I presume that sql is configured correctly as I am recieving data back when I request it accross the network. I dont understand why it wont work when I have the service on the server with the sql?
Any help will be appreciated.
View 4 Replies
View Related
Feb 23, 2008
Hello everyone:
I am developing a PDA application, everything is fine for me, but when I try to open Sdf DataBase (was generated by the Wizard ADS ), it gives me the following error pda:
Unable to load a DLL SQl Server Compact. Reinstall SQL Server Compact. [DLL name = sqlcese35.sys.dll]
I commented that i reset the hardware pda several times and I have reinstalled these files:
sqlce.dev.ES.wce5.armv4i.CAB
sqlce.repl.wce5.armv4i.CAB
sqlce.wce5.armv4i.CAB
They are located at:
C:Program FilesMicrosoft SQL Server Compact Editionv3.5Deviceswce500armv4i
They say that my PDA have Windows Mobile 6.0, i development in Visual Studio 2005 C#, and the processor is a Marvell in uan IPAQ 114 Classic, my doubts are several:
-- Is this the whole package for this processor?
-- How to i konw that the package it is up to each type of processor?
-- If this package ... What should I do to correct the mistake?
Best regards and thanks in advance.
Albert
View 4 Replies
View Related
Jan 4, 2007
Hi there,
I have written a program that loads a package (SomePackage.dtsx) from the physical drive and executes that. The package does nothing but imports data from a csv file to the Sql server 2005. But I can see that the package is failing continuously. I meant the package.Execute() method is returning a DTSExecResult.Failure. I investigated the Package.Errors property that contains the error collection and found that there are two DTSError objects into the collection.
The first one€™s description says that
Cannot open the datafile "D:SOME.csv".
And the later one€™s is
component "SOURCE FLAT FILE COMPONENT" (1) failed the pre-execute phase and returned error code 0xC020200E.
But the most interesting thing is if I execute the package through the Execute package Utility (double clicking onto the SomePackage.dtsx file) ships with Sql server 2005 then it executes fine and works as expected. I have checked the permission of the csv file and it has everyone€™s full access.
Can anyone help me on this?
I will appreciate all kind of suggestions.
Thanks
Moim
View 14 Replies
View Related
Jan 9, 2007
I am getting the following error when running some of my reports that use a Report Model on a recently built Windows 2003 R2 server with SQL Server 2005 SP2 intalled. The reports run fine our SQL Server 2005 RTM server.
W3wp!webserver!7!01/09/2007-12:57:58:: e
ERROR: Reporting Services
error Microsoft.ReportingServices.Diagnostics.Utilities.RSException:
An error has occurred during report processing. ---> Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. ---> System.InvalidOperationException:
There is already an open DataReader associated with this Command which must be closed first.
Any help would be appreciated.
Rick
View 2 Replies
View Related
Mar 1, 2007
Hi,
I am trying to connect to my SQL Server 2005 but it gave me following error message.
TITLE: Connect to Server
------------------------------
------------------------------
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)
So, Please help me to solve this problem.
tnks.
View 20 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
Apr 23, 2008
Hi Friends,
Im using .Net2008 and MS SQL Server2005, I Have a web application , i want to connect to the server machine SQL Server, When i run the application im getting the following error.
Im trying to connect to the database from local machine application to server machine database
An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
My WebConfig File is<connectionStrings>
<add name="NewConnectionString" connectionString="Data Source=sqlserverservername.com;Initial Catalog=Test;UID=User;PASSWORD=Pwd;Integrated Security=True;connect timeout=30" providerName="System.Data.SqlClient"/></connectionStrings>
<appSettings>
<add key="connectionstring" value="Data Source=Sys67;Initial catalog=DB;user id=sa;password=sa;connect timeout=30"/>
</appSettings>
Please Help me to sortout this ISSUe, Its very urgent please
View 7 Replies
View Related
