Showing posts with label build. Show all posts
Showing posts with label build. Show all posts

Thursday, March 29, 2012

Error: Could not get a list of SSIS packages from the project.

Hello,

I have a SSIS package and I am trying to build it using devenv.com from command line. It gives me this error:

Error: Could not get a list of SSIS packages from the project.

However if I open the project in Visual Studio it builds properly. In project property I have set CreateDeploymentUtility=true.

This is what I do from command line:

devenv.com MySSIS.sln /Build "Development|Default"

Any idea what I should do ?

Thanks

Deval

Hello,

There is no solution to it as far as I know if we set CreateDeploymentUtility=true. If you uncheck it then it will work fine.

Thanks

Deval

Wednesday, March 7, 2012

Error with my request maybe OWC...

Hi, (sorry for my english...)

I have a probelm to build my Pivot table.

Indeed,

The goal is just to see an example of Table Pivot with our Database...

For that, I use this link :

http://www.csharphelp.com/archives4/archive623.html

I try to adapt the code but some problems...

I use visual developper, and i have installed OWC11 & .NET framework 2.0.

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Office.Interop.Owc11;

public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//determine whether or not the browser supports OWC
if(Request.Browser.ActiveXControls)
{
Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");
//cause the object to load data on the client
Response.Write(@."<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");
Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");

PivotTableClass PTClass = new PivotTableClass();

PTClass.ConnectionString = ConfigurationManager.ConnectionStrings["TimeTrackingDB"].ToString();
PTClass.DataMember = "";
PivotView pview = PTClass.ActiveView;
Response.Write(pview.FieldSets.Count);

}

}
}

When i'm lauching there is an error : HRESULT E_FAIL

http://fists148.free.fr/Error.JPG

If i put the last lines in commentary,

public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//determine whether or not the browser supports OWC
if(Request.Browser.ActiveXControls)
{
Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");
//cause the object to load data on the client
Response.Write(@."<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");
Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");

}

}
}

The component is loading but it seems to be an issue with the connection database...

In my web.config, I Have this :

<connectionStrings>
<add name="TimeTrackingDB" connectionString="Data Source=PORT06139\DEV_2000;Initial Catalog=TimeTracking;Persist Security Info=True;User ID=user_TTT;Password=user_TTT;pooling=false"/>

</connectionStrings>

Error connection (http://fists148.free.fr/OWCscreen.JPG)

If you have any idea, i take it...I'm deseperate :eek:

Thanks By advanceLets find out whether this is a problem with your pivot tool, or your server connection.
Unfortunately, I can only help you trouble-shoot the connection as I know little or nothing about your application coding.
Are you using SQL Server authentication or Windows authentication to connect to your database server?|||I don't much fancy handling the app code either but... there is an error within the class that is not handled with an exceptioon handler hence you get the call to the property highlighted. Use the debugging tools to step through the code line by line - it will take you through the class and then will error once more at the actual line within the class that is throwing the exception. This might not help us fix the problem but at least let you know if we are capable of fixing the problem or if you need to speak to more .NET enabled people :)|||Thanks for your answer.

Nevertheless I believe it's a problem of SQL..

Indeed, in my web.config, we use this connection string in our overall project and we haven't got any issue with this.

That's why I think there is a mistake in the script of creation of the pivot.

If anybody see this mistake or think to another issue, please let me know.

(Sorry for my very bad english...:rolleyes: )|||Nevertheless I believe it's a problem of SQL..

Indeed, in my web.config, we use this connection string in our overall project and we haven't got any issue with this.

That's why I think there is a mistake in the script of creation of the pivot.Well if your class is creating invalid SQL then it really is a c# problem rather than a SQL one. As mentioned - the error is to do with your class. Without delving around in your class you are not going to get anywhere. Your code does pretty well nothing but retrieve a connection string, submit it to the class, call a class property and report an error in the class. If you say the connection string is wrong then there is nothing to do but step through your code.

HTH|||Thanks for the interest of my issue :)

As i have say, i test just to put this :

public partial class _Default : System.Web.UI.Page
{
private void Page_Load(object sender, System.EventArgs e)
{
//determine whether or not the browser supports OWC
if(Request.Browser.ActiveXControls)
{
Response.Write("<OBJECT id='pTable' style='Z-INDEX: 109; LEFT: 8px; WIDTH:502px; POSITION: absolute; TOP: 8px; HEIGHT: 217px' height='217' width='502'classid='clsid:0002E55A-0000-0000-C000-000000000046'VIEWASTEXT></OBJECT>");
//cause the object to load data on the client
Response.Write(@."<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");
Response.Write("<script>document.all.pTable.ResourceID = 'RESOURCE'</script>");

}

}
}

And i Have the error connection that i've mentionned :

http://img411.imageshack.us/my.php?image=owcscreenvl3.jpg

According to me, the issue is there

Response.Write(@."<script>document.all.pTable.ConnectionString ='" + ConfigurationManager.ConnectionStrings["TimeTrackingDB"] + "'</script>");

But I'm not able to see it. If someone see a BIG or a small :p mistake, please let me know.|||So, i've several answer in other forum. It really seem an SQL issue.
But nobody know how to fix it.
Maybe someone knows here :)

Response.Write(@."<script>document.all.pTable.ConnectionString ='Provider=MSDASQL.1;Persist Security Info=True;Extended Properties=\'DSN=MSAccess Database;DBQ=C:\Program Files\MicrosoftOffice\OFFICE11\SAMPLES\Northwind.m db;\';Initial Catalog=C:\ProgramFiles\Microsoft Office\OFFICE11\SAMPLES\Northwind'</script>");

This is the code I ve find on Internet with a connection to access file.

I want to adapt it with my Microsoft sqlServer 2000 and visual Studio

Database Name : TimeTracking
Pass : USER_TTT
login : USER_TTT
Provider : ??
Data Source = PORT06139\DEV_2000;
Initial Catalog=TimeTrackingDB
Persist Security Info=True

Does anybody can make the sql request according to the previous information?

Thanks you very much in advance. :rolleyes:

Sunday, February 26, 2012

Error with conn string

Just installed AJAX for VS2005 and started to build a AJAX enabled web site. I got the following message after creating a database (SQL) and Dataset "FOLLOWING ERROR OCCURED WHLE GETTING CONNECTION STRING INFORMATION FROM CONFIGURATION:'CANNOT GET WEB APPLICATION SERVICE'.

I didn't have this problem before,can it be related to AJAX?

Thank you in advance,

close your VS 2005 and open it again The SQLConnection error might go away.

Friday, February 17, 2012

Error while loading code module

I have created a custom assembly and referenced it. The class can be
instantiated, so I have specified the class and instance name.
So, when I build the solution, the compiler returns these errors:
Error while loading code module: â'XXX, Version=Y.Y.YYYY.YYYYY
Culture=neutral, PublicKeyToken=nullâ'. Details: File or assembly name XXX, or
one of its dependencies, was not found.
Should there be a directory that this assembly be placed? As a test, I
placed the .dll in the GAC and experieced the same error.
Any help would be appreciated.
Thanks - JMLYes, you must place dll file in
\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
directory
Regards
"AgentSmith" <AgentSmith@.discussions.microsoft.com> escribió en el mensaje
news:754CB514-27F9-40F3-82EE-6D46D143DB05@.microsoft.com...
> I have created a custom assembly and referenced it. The class can be
> instantiated, so I have specified the class and instance name.
> So, when I build the solution, the compiler returns these errors:
> Error while loading code module: 'XXX, Version=Y.Y.YYYY.YYYYY
> Culture=neutral, PublicKeyToken=null'. Details: File or assembly name XXX,
or
> one of its dependencies, was not found.
> Should there be a directory that this assembly be placed? As a test, I
> placed the .dll in the GAC and experieced the same error.
> Any help would be appreciated.
> Thanks - JML
>|||What if the report server is not on your machine? Should I just create the
directory?
"plmartinez" wrote:
> Yes, you must place dll file in
> \Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin
> directory
> Regards
> "AgentSmith" <AgentSmith@.discussions.microsoft.com> escribió en el mensaje
> news:754CB514-27F9-40F3-82EE-6D46D143DB05@.microsoft.com...
> > I have created a custom assembly and referenced it. The class can be
> > instantiated, so I have specified the class and instance name.
> >
> > So, when I build the solution, the compiler returns these errors:
> >
> > Error while loading code module: 'XXX, Version=Y.Y.YYYY.YYYYY
> > Culture=neutral, PublicKeyToken=null'. Details: File or assembly name XXX,
> or
> > one of its dependencies, was not found.
> >
> > Should there be a directory that this assembly be placed? As a test, I
> > placed the .dll in the GAC and experieced the same error.
> >
> > Any help would be appreciated.
> >
> > Thanks - JML
> >
>
>