I was wondering if there was a way to set a default project to open in Microsoft SQL Server 2005 when the application launches.
Perhaps there's a certain registry key I could edit?
I have a Visual Studio 2005 solution which contains a Sql Server Integration Services (SSIS) project.
In this solution I have explicitly set a Web application project as startup project, but whenever I edit a DTS package within the SSIS project, VS automatically sets the SSIS project as startup project and the package I edit as startup object.
Needless to say, this may cause some really unwanted incidents when running the solution - thinking that you're about to run the Web application project (that was explicitly set as startup project), but instead, you run the edited package in the SSIS project.
Is there any way to avoid having the SSIS project automatically setting itself as startup project, any workaround here at all? :)
Thanks.
Hi,
I have been working on some SSIS packages for a while now and today while i was working i was trying to create a new connection and in the process there was an error and it said the BIDS has to be closed and i closed it but later when i open BIDS and try to open my project(.sln) from the file menu to work on the half done package it pops up an error which shows the path to my project location on the first line and next statement on the pop up error box says:
"Make Sure the application for the project type (.dtproj) is installed."
I tried to check some forums in which some suggested to try installing SP1 which i tried but ..i dont know why but the SP1 fails to install (i dont know if its causing problem becoz i already installed SP2 as i had some other problem before for which the cure was to install SP2).
Did anyone here face such a problem before ?
I'd really appreciate if the experts here can tell a cure for this problem.
thanks,
Ravi
Hi,
with reference to the following thread:
http://forums.microsoft.com/msdn/ShowPost.aspx?postid=740855&isthread=false&siteid=1&authhash=775a583435c503730bf96695fe78ffc77f04a290&ticks=632942355374528292
Which in summary is that I am trying to execute DTS packages containing OLAP tasks to process cubes from an application. It hangs and fails after an hour and some minutes.
the code :
Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;
package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref VarPersistStgOfHost);
package.Execute();
I have launched the DTS on command prompt using DTSRUN on the computer I am trying to execute my code, and it executes marvellously.
DTSRUN can also execute a DTS on another physical server Alpha for instance which process a cube of AS2000 found on another physical server Beta for instance.
Since I need to check that each steps have been executed properly and that running DTSRUN from the application is not a possibility to do so, I need a way to be able to launch the DTS and get to know which steps is failing. the above code is supposingly a way but its failing on LoadFromSQLServer() method.
I am using SQL Server 2000 and AS2000 and .net 1.1 (modifying a legacy system to enable the above facility).
Any views please?
Thanks
Hi all,
I don't know if this is possible or not but what I want to do is include a few images on a report that will launch a little VB6 application when clicked. I've tried messing with the Navigation - URL properties of the image but am getting nowhere fast!
Anyone any ideas?
Cheers
Ninj
I get the below error only when my IDE open. It connects well when it is found closed.
[SqlException (0x80131904): Cannot open user default database. Login failed.Login failed for user 'JPASPNET'.]
I could solve this by giving the logged in windows user to impersonate under IIS window > WEBSITE > ASP.NET tab > EDIT CONFIG > APPLICATION tab
But I wish someone could give me the proper solution.
I almost tried all from giving ASPNET user as a administrator to configuring the same in Express management tool.
Environment: XP pro, VWD and SQL Express
I am building code to look into the database and create "CRUD" stored procedure scripts automatically for each table.
I am in the finishing stages as my procedures take into consideration all necessary parameters and keys wheter they are natural or identity. It also takes into consideration User Defined Types.
I am working on the section which defines the parameters and their default values. ie.
CREATE PROCEDURE [dbo].[TransactionHistoryInsertOne]
(
@ProductID Int = 0,
@ReferenceOrderID Int = 0,
@ReferenceOrderLineID Int = 0,
@TransactionDate DateTime = '1/1/1900', <-- Possibly arbitrary
@TransactionType nchar(1) = '?' <---- How to get this.
@Quantity Int = 0,
@ActualCost Money = 0,
@ModifiedDate DateTime = '1/1/1900'
)
AS...
I have three problems remaining.
1. Using the AdventureWorks database as a data model, I run into the TransactionType field in the TransactionHistory table, a non-nullable nchar(1). How do I determine and use any default values that may be defined for this object?
2. Do UDTs have default values already defined?
3. How do I make sure I am not arbitrarily setting the default values?
Here i my select statement into the system tables:
SELECT C.*, T.name as xtypename, U.name as xutypename, S.*, so.*
FROM syscolumns C
left join systypes T on (C.xtype = T.xtype) and (T.xtype = T.xusertype)
left join systypes U on C.xusertype = U.xusertype
left join sys.all_columns S on (C.id = S.object_id) and (C.name = S.name)
left join sysobjects so on S.default_object_id = so.id
WHERE (C.id = [TableId])";
Thanks for any help
Hi,
I have been working on an SSIS project for sometime now. The project files are located on a remote server. Suddenly I am not able to open the solution I get a lot of error messages and all the data flow taks are gone. I later found out that SSIS encrypts packages, so that other users will not be able to see them. Fine, but I have been using the same windows user account for months now. What could be the problem?
This is what I get when trying to open the solution:
There were errors while the package was being loaded.
The package might be corrupted.
See the Error List for details.
And the error list also contains messages saying "Could not load from xml".
Any pointers will be much appreciated.
TIA
I developed a project (web application) using the Express editions.
How do I migrate the project from Express (SQL Server Express & VWD Express) to Visual Studio 2005 Standard and SQL Server Standard?
Thanks if you can answer this.
Ken
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!).
Hi all.I use VWD 2005 Express with SQL Server 2005 Express as a database.I copy my project to IIS and try to run it at the IIS Web Server.I already amended the connection string at web.config file as below: <connectionStrings>
<add name="GeekSpeakConnectionString" connectionString="Data Source=SEN-M09SQLEXPRESS;Database=GeekSpeak.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
</connectionStrings>But, I got this error:Cannot open database "GeekSpeak.mdf" requested by the login. The login
failed.Login failed for user 'SEN-M09ASPNET'. I also has granted to user SEN-M09ASPNET . Still, I got this error. Why?
hi there,
we canīt open most of the sql server tables from our Access
project any more, which has to be related to collation or
extended property problems.
trying to open any table will result in the information
"The stored procedure has been executed but did not return
any records" after the first try
and later on nothing will happen any more; tables wonīt
open.
basically this started to happen after recreating the sql
database due to resolution 1 in Microsoft Knowledge Base
Article - 318989:
collation of the server is Latin1_General_CI_AS
collation of the old database was
SQL_Latin1_General_CP1_CI_AS, which led to the error
described in the article.
collation of the new database is set to <Database
Standard>, now i have the problems described above.
anybody some good help on that?
ps: we canīt really rebuild the user database all the
time, because we got flight data in about 4 billion
records in there, so we will need anything quick and
easy...
thanks
ron
I installed SQL Server 2008 R2 and Visual Studio 2008. However, after several installations and un-installations. I could no longer use the SSIS to create New Projects. I cleaned out the registry with a Registry cleaner from Wise. I deleted the SQL Server and Visual Studio folders as well.
When I create a New SSIS Project, I immediately get an error as follows:
"Microsoft Visual Studio"
"An error prevented the view from loading."
"Additional information:"
"Specified Module cannot be Found. (Exception from HRESULT: 0x8007007E)"
"(System.Windows.Forms)"
What this means is that I cannot create any new SSIS Projects.
hi everyone,
A couple of issues.
1)I usually connect to my remote server via TS using a specific login (it belong to Admins) and through that user I open my SSIS projects (30 packages). Now, I have a new user and the same operation take a long time and I don't know why (same permissions) the reasons for this big delay.
2)When I'm gonna to press "Delete all Breakpoints" from Debug menu BIDS is closed. Previously appears a Microsoft dialog (Microsoft has encountered an error...) asking if you inform or not of these errors.
Thanks in advance and regards,
I have created a report, and am setting default values for the parameters. Once the default parameters is set, the report automatically generates. Is there a way to make it not automatically generate the report? We are setting the parameters with values that will get the end user the most recent data, but alot of times, they will want to pull older data as well. We don't want them to have to wait for the report to automatically generate before they can change the parameter values
View 1 Replies View RelatedIf all the parameters for a report have default values, the report runs automatically as soon as you open it. Is there a way to prevent this?
View 9 Replies View RelatedHello!
I am trying to open a SSIS solution and get the error:
"The application for the project 'c:C....dtproj' is not installed
Make sure application for the project type(.dtproj) is installed."
I have been running this application for nearly a month and suddenly it dose not work. It still works for my college that execute through a different user.
I have checked what is associated with the file type .dtproj and it seems to be correct.
What has happen? Thankful for any suggestions.
Best regards,
Tina
Does anyone know why this happens? When I run one of the packages in my project (by hitting the play button in the designer), all of the other packages in that project open before it starts running?
Thank you.
I have a solution that contains SQL Server Reporting Services 2005 project. I upgraded the solution to VS 2008. The report project shows that it is not loaded. Trying to load it gives me the error - "cannot be opened because its project type (.rptproj) is not supported by this version of visual studio". Okay, so I do I convert it?!
View 14 Replies View RelatedI have a sql server project where I have added 1 stored procedure (named StoredProcedure1) and 1 class (named MyClass). MyClass has two functions Func1() and Func2(). The stored procedure simply instantiates MyClass and calls Func1().
Func1() creates a SqlConnection object using "context connection=true" - opens the connection and then calls Func2(). Func2() also creates a SqlConnection object using "context connection=true" - and attempts to open the connection. However when attempting to the Open() call inside Func2(), the code just exits. What gives? The code is pasted below, thanks!
*******THE STORED PROCEDURE**************
using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
using SqlServerProject1;
public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void StoredProcedure1()
{
// Put your code here
MyClass obj = new MyClass();
obj.Func1();
obj = null;
}
};
*******THE CLASS "MYCLASS"**************
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;
public class MyClass
{
public MyClass()
{
}
public void Func1()
{
using ( SqlConnection conn = new SqlConnection("context connection=true") )
{
conn.Open();
Func2();
conn.Close();
}
}
public void Func2()
{
using ( SqlConnection conn = new SqlConnection("context connection=true") )
{
if ( conn.State != ConnectionState.Open )
conn.Open();
if ( conn.State == ConnectionState.Open )
conn.Close();
}
}
}
Dear Friends
I am unable to open e new project using SQL Server management Studio Express. On the File menu it displays only "Query with current connection" and "Data base Engine Query". Please help me on thi Do I have to Install SQL Server management Studio instead of using express version. Cant I use SQL Server and SQL server management studio for deploy to make a small database for my a wharehouse. Please help me
Amila
I'm a database newbie, trying to decide whether to create an SQL Server or Windows Application project that uses SQL Server 2005 Express. As I understand it, the advantage of an SQL Server project is that the app deploys somehow as part of the database. If that's the case, how would I handle the scenario where the database has been updating at customer site and I need to install just a new release of the software? Would I be better of creating a Windows Application project and connecting to the database explicitly? Thank you.
View 5 Replies View RelatedWhen I open up my existing SSIS project, I always get this error. Does anyone know what was wrong ?
TITLE: Microsoft Visual Studio
------------------------------
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass' to interface type 'Microsoft.SqlServer.Dts.Runtime.IObjectWithSite'. This operation failed because the QueryInterface call on the COM component for the interface with IID '{FC4801A3-2BA9-11CF-A229-00AA003D7352}' failed due to the following error: The application called an interface that was marshalled for a different thread. (Exception from HRESULT: 0x8001010E (RPC_E_WRONG_THREAD)).
I am working with a vendor application called Cisco Unified Attendant Console - it operates on a Windows server with a SQL express database. The CUPs function of the application needs to reference a "contact" field with only the user portion of the contact's email address - generally, the contact's User ID will match the user portion of their email address, however, for this customer it does not (they use the employee number as the User ID and firstname.lastname as user portion of the email address.
Writing a script to accomplish the following:
The dbo.Contact_Properties table of the ATTCFG database has the following fields that we can work with:
Â
- First_Name
 - Last_Name
 - Email
 - User_Field_2
 - Contact_Unique_Ref (appears to be the field that ties all other contact tables together ?)
Is it possible to create a script that could run daily to either, combine the First_Name and Last_Name fields (with a period between) and populate the User_Field_2 field for each user, or populate the User_Field_2 field with everything before the @ symbol in the Email field for each user?
Also, by default the servers that this application is installed on does not have SQL Server Management Studio installed - is it possible to accomplish with PowerShell script triggered from the Windows Scheduler?
Hi,
We are running :
- Visual Studio 2005 Team Edition for Software Developers
- SQL Server 2005 Express (SQLEXPR32.EXE)
Installed :
- SQL Server with Advanced Services (SQLEXPR_ADV.EXE) incl. Reporting Services
- SQL Server Toolkit (SQLEXPR_TOOLKIT.EXE)
We have a VS Solution with a Reporting Project
When opening Visual Studio, the following message appears :
"Make sure the application for the project type (.rptproj) is installed."
I have no idea why this message appears.
Is this a known problem/bug ? Anybody any idea how I can solve this ?
Many thanks in advance.
Vincent
Hi,
We are running :
- Visual Studio 2005 Team Edition for Software Developers
- SQL Server 2005 Express (SQLEXPR32.EXE)
Installed :
- SQL Server with Advanced Services (SQLEXPR_ADV.EXE) incl. Reporting Services
- SQL Server Toolkit (SQLEXPR_TOOLKIT.EXE)
We have a VS Solution with a Reporting Project
When opening Visual Studio, the following message appears :
"Make sure the application for the project type (.rptproj) is installed."
I have no idea why this message appears.
Is this a known problem/bug ? Anybody any idea how I can solve this ?
Many thanks in advance.
Adding a value to a non-queried default report parameter value does not update on the target server after deployment.
To recreate
1. Create a report in Visual Studio and add a report parameter with the following properties:
Multi-value is checked
Available values = "From Query"
Dataset = [create a dataset that returns a table w/ a Id and Description column]
Value field = [the Id field from the table]
Label field=[the Description column from the table]
Default values = "Non-queried" (add several values the match the IDs from the table so that some of the values in the report dropdown will show up as checked when rendering the report)
2. Build and deploy the report to the reporting server. View the report and verify the specified items are checked in the report parameter.
3. Go back to Visual Studio and add a value to the Non-queried Default values.
4. Build and deploy the report again. View the report. The newly added item is not selected.
Notes
I verified that the newly added ID exists in the rdl file (as xml) on both the development box and the server where the report was deployed. However, when I view the report parameter using Management Studio (connect to the reporting server), the newly added value for the report parameter does not exist. I verified that changes are being deployed by adding new parameters and changing other properties of the parameter. I thought maybe the rdl itself was being cached somehow - I tried restarting IIS, SQL Server, and SQL Reporting services. None worked. Note that running the report on the development box by running the project through Visual Studio DOES reflect the change to the parameter.
Work-arounds
1. Create a dataset for the report that returns a table of the Ids that you want pre-selected. The query could be something like this:
SELECT '4' AS SelectedId
UNION
SELECT '5' AS SelectedId
UNION
SELECT '6' AS SelectedId
2. Delete the report in Management Studio, then redeploy.
I have issue w/ both workarounds because for 1) it is not intuitive and you have to remember to do this for every similar case, and 2) this extra step has to occur each time the report is deployed w/ changes to the report parameter.
Whenever I open a .sql file in QA, the dialog box always displays the files in the 'list' format (you need to scroll side-to-side to see the files). However, I prefer the 'details' format, where I can see the file size and the date created (and sort by them).
Does anyone know how to change the default so I can open files the way I want to open them?
Hi all,We recently upsized two Microsoft Access Databases to SQL. We'reusing an ADP (2002) as the front end.All the conversion issues have been resolved, except for one:Whenever we insert a record into a table, the table isn't sorted byprimary key like I would expect. Instead, the record can be found atthe end of the table. This makes finding a particular record(especially as time goes on) very difficult.I've tried eliminating all indexes except for the primary key, andalso writing AFTER INSERT triggers, but the table still does not sortcorrectly.Any suggestions would be greatly appreciated!Matt
View 4 Replies View RelatedHi Team
I am working on a .net project, sql server 2000 based one. Now when iam connection to database server (remote) then me getting an error that the user cannot open the default database. I have made the database > all tasks > take offline. But after that I cant open the sql server thru the enterprise manager and query analyzer. How can I do the database online?
Thanks
Rajesh
When i try to open the Adventureworks database with SQL Server 2005 Express, it throws the following error:
Cannot open user default database. Login failed.Login failed for user 'SK-RIY37EQBYCYZsk'.
Dim connString As String = ConfigurationManager.ConnectionStrings("AdWorkConnectionString").ConnectionString
<add name="AdworkConnectionString" connectionString="Data Source=.SQLEXPRESS;AttachDbFilename=C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDataAdventureWorks_Data.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
providerName="System.Data.SqlClient" />
Guys
I am currently getting the error Cannot open user default database. Login failed.
Login failed for user '<user name>'. (Microsoft SQL Server, Error: 4064)
I took a backup of my Production Database but when I try to restore it I get this error. I cant do anything at the moment without getting this error.
Can you please help.
Hi,
I'm developing a windows forms app with a local database to be deployed on a couple of users machines. To aid deployment I'm using 'user instance' with a connection string of:
Data Source=.SQLEXPRESS;AttachDbFilename=|DataDirectory|gma.mdf;Integrated Security=True;User Instance=True;Connection Timeout=15;
I've started with a backup function based on the blog 'Backup and Restore with User Instance' linked to from this forum. Problem is I always get the error message 'Cannot open user default database. Login failed for user xxx'. This happens when I run in debugger or just run the exe directly.
Any help appreciated.
Dave