Help---&&> How I Can Work With Primavera Integration API In Visual Studio 2008 ??

Apr 30, 2008



someone please tell me how
im using primavera V5.0 (www.primavera.com) and i want to export the data from the .net to primavera and versa versa
please tell me soon

View 3 Replies


ADVERTISEMENT

Sqlserver 2008 Can't Work With Visual Studio 2008

Dec 23, 2007

when I try to make a sqldatasource with visual studio 2008 and SQLServer 2008 . I found that there are a message that the visual studio 2008 can support only SQLServer 2005 and SQLServer 2000how to make my visual studio 2008 support SQLServer 2008 

View 1 Replies View Related

SQL CLR Integration With Visual Studio 2005/2008

Mar 20, 2008



Dear all,

I am trying to integrate Sql Clr with Visual studio 2005, but i am getting the following error when i try to deploy the solution:



CREATE ASSEMBLY for assembly 'SQLCLRIntegrationDemo' failed because assembly
'SQLCLRIntegrationDemo' is not authorized for PERMISSION_SET = EXTERNAL_ACCESS.
The assembly is authorized when either of the following is true: the database owner (DBO)
has EXTERNAL ACCESS ASSEMBLY permission and the database has the TRUSTWORTHY database
property on; or the assembly is signed with a certificate or an asymmetric key that has
a corresponding login with EXTERNAL ACCESS ASSEMBLY permission. If you have restored or
attached this database, make sure the database owner is mapped to the correct login on
this server. If not, use sp_changedbowner to fix the problem. SQLCLRIntegrationDemo


I have even set the Permission to External in the Project --> Properties --> Database tab.
But still i am getting the above solution while deploying the solution.

One of the blogs suggested that the checkbox beside 'Trustworthy Database' should be checked. But i dont see any checkbase in the database tab of the Project properties.

Any help would be appreciated.

Thanks in advance.

Regards,
Sunny.

View 1 Replies View Related

How To Export Files From ReportViewer In Visual Studio 2008 Frame Work 2.0

May 13, 2008


I want to export file such as .csv, xml , word from ReportViewer in visual studio 2008 but when I run on ASP.NET .net framework 2.0, it can export only excel & pdf files. But in business intelligent project in Visual Studio 2005 I can export all files that I want.
How can I export file from reportviewer in visual studio 2008 run on web application?

Regards,
NPeng

View 1 Replies View Related

Business Intelligence Project/Integration Services Project Not Showing Up In Visual Studio 2008

Mar 31, 2008

I have visual studio 2005 and sql server 2005 with integration service installed on my machine. Couple of days ago, I installed visual studio 2008 professional. When I go to create SSIS project I dont see it in visual studio 2008. What do I have to do to make it appear in visual studio 2008 so that I can create SSIS projects.

Thanks.

View 7 Replies View Related

Deploy From Visual Studio Doesnt Work

Apr 27, 2007

Hello, I created a new Rs server, but when I try to deploy from visual studio, it asks me for username and password multiple times and never deploys.



I am an administrator on the RS server, even on the report folders.

I can access via IE to the report manager.



View 17 Replies View Related

Cant Add Sql Endpoint To My Visual Studio Project. Trying Add As Web Reference Does Not Work.

Jun 3, 2007



i have created a database endpoint that just retuns some data. i am trying to call this endpoint as a web service in visual studio by adding a web reference, but i cannot find my endpoint. it seems to just check iis for endpoints, but how do i make it look for my sql endpoint? here is the code for my endpoint.



create endpoint testEndpoint authorization [FINTAN-PCFintan]
state=STARTED
as http
(
path ='/sql',
authentication=(INTEGRATED),
ports = (CLEAR),
site='SERVER'
)
For SOAP
(
webmethod'ProvideSQLData'(name='adventureWorks.dbo.testEndpointProcedure'),
WSDL=DEFAULT,
SCHEMA=STANDARD,
DATABASE='adventureworks',
NAMESPACE='http://thenamespace.org'
);
GO



the account that visual studio is running under has been granted connect permissions on the endpoint. can anyone say where im going wrong here?

View 2 Replies View Related

Visual Studio Team System And SSMS - Anyone Got The Plugin To Work?

May 30, 2006

We have a large number of SPs in our databases and decided it was time to get some source control. I have VSTS team explorer installed and working in visual studio, but I cannot get the plugin for SSMS to work - it just says none in the current source control plug-in dialogue box - nothing when I drop it down either.

Any ideas what I am doing wrong?

View 1 Replies View Related

Not Connecting To SQL Through Visual Studio 2008

Jun 15, 2008

This should be simple - using the server explorer I select the server and then the database that's running on that server. It lets me test the database connection at that point - which does work.

Then when I try to add the database it says -

Could not load file or assembly Microsoft.SqlServer.Management.Sdk.Sfc, Version=10.0.0 ... The system cannot find the file specified.

So far as I can see the specified file is Microsoft.SqlServer.Smo.dll which has a current version of 9.0.242.0 and sits within the SQL Server files. That is also the version number held in the registry.

The version of SQL is 2005. The database was created using Create Database through VS 2008, .net 3.5.

Also, I installed VS 2008 first, which puts in SQL Compact. And then tried installing SQL 2005 Development which still gave the same error message. So I uninstalled SQL Compact and SQL 2005. And then did a clean install of SQL 2005 Developer. Does VS 2008 cope with this?

Is there a version 10 of SMO? Or is there somewhere within SQL or Visual Studio where it could be holding a version number of 10 for the dll? Or any other ideas?

Thanks Mike

View 2 Replies View Related

Visual Studio 2008 And SSIS

Sep 1, 2007

I have recently installed Visual Studio 2008 Beta 2 on a development machine that was running SQL Server 2005 SP2a without any issues. Not I find that I can no longer run any of my SSIS packages and I keep getting the following error:

Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154

Per other posts, I have reinstalled MSXML 3.0 to no avail and I have looked for every SQL Server patch I can find - I appear to have all of the latest patches for SQL Server.

Can somebody please help?

View 6 Replies View Related

SQL CE 3.5 Visual Studio 2008 TOO SLOW

Sep 14, 2007



Hi,

I have a desktop application that uses an Access DB.
Now i have converted it to Visual Studio 2008 and tried the SQL CE Edition.
I wrote all the methods, create the database and the tables on the fly and seems to work really fine.
The database is 20MB big, but the performance is vey bad.
I mean with Access it's very fast, you actually don't see how slow it is, and with the SQL CE now,
it takes 7 seconds !!!! for a few access instead of under 1 second with Access.

I can't imagine that this is normal, there must be something i am really missing in my code.
Looks something like this:




Code Snippet
SqlCeEngine engine = new SqlCeEngine("Data Source = URANO.sdf");
engine.CreateDatabase();
engine.Dispose();
// Verbindung öffnen
sqlConnection = new SqlCeConnection("Data Source = URANO.sdf");
sqlConnection.Open();
// creating the tables here with data
sqlCommand = new SqlCeCommand("SELECT ID FROM Laender WHERE Name=@Name", sqlConnection);
sqlCommand.Parameters.Add("@Name", SqlDbType.NVarChar, 30);
sqlCommand.Parameters[0].Value = land;
sqlDataAdapter = new SqlCeDataAdapter(sqlCommand);
sqlDataSet = new DataSet();
sqlDataAdapter.Fill(sqlDataSet, "Laender");
landID = "" + (((int)sqlDataSet.Tables["Laender"].Rows[0][0]) + 1);






this takes 1 - 2 seconds


btw: the whole class is static and the variables also are static.

Would it be better to load all the database tables into datasets, and only work with the datasets in memory ?
Well i thought that the SQL CE Engine, would load the database into memory and be just fast.
I mean we have 2 GB of memory or 1 the most of us, 20MB isn't that much.

Thanks !

Nick

View 9 Replies View Related

RS2005 And Visual Studio 2008?

Jan 24, 2008

Can I author report projects in VS Studio 2008 that I deploy to a RS2005 Report Server?

Our development staff has upgraded to VS2008 for our DLLs, Web sites, and console apps... no problem there whatsoever. But we have SQL2005... obviously, since SQL2008 appears to be along way off.

So, it seems like an obvious question... although I'm dreading the response. My experience with getting RS2005 installed and configured correctly was simply horific. In fact, so bad, I'm considering dumping RS altogether and going with a more reliable 3rd party tool... MS has truly done everything in the power to botch this one or so it would seem.

View 1 Replies View Related

Visual Studio 2008 And SSIS

Sep 1, 2007

I installed Visual Studio 2008 Beta 2 Professional yesterday and now none of my SSIS packages will function. Each time I attempt to run the transform, I obtain the folloiwing error:



Retrieving the COM class factory for component with CLSID {7816B7A3-CD60-4539-BD38-C35AFC61F200} failed due to the following error: 80040154.

I have tried to apply every patch I can find for SQL Server 2005 - inclduing both the SP2 and SP2a patches. I have tried reinstalling MSXML 3.0 - nothing seems to work.

Can somebody please help?

Thank you!

View 5 Replies View Related

Whether SQL Server 2005 Express Edition Can Work With Visual Studio 2003 (Ver 1.1)

Mar 3, 2006

We are new to SQL Server 2005 Express Edition. We are going to develope a solution for one of our client and we have to decide on which database to use for the solution. Client wanted to have a low cost solution. Thus we were not in a position to push them for SQL Sever 2000.

In the process, we also thought of having MySQL as one of the option. Another option we have is to use SQL Server 2005 Express Edition.

We wanted to know if SQL Server 2005 Express Edition can be used with Visual Studion 2003 (Ver 1.1) or it can only be used with Visual Studio 2005 (Ver 2.0)?

Hope to get feedback soon.

Regards

Sanjeev



View 1 Replies View Related

SSIS 2005 In Visual Studio 2008

Dec 5, 2007

I can't open solutions created in Visual Studio 2005 in Visual Studio 2008


---------------------------
Microsoft Visual Studio
---------------------------
'TransformFoxData.dtproj' cannot be opened because its project type (.dtproj) is not supported by this version of Visual Studio.

To open it, please use a version that supports this type of project.
---------------------------
OK Help
---------------------------
Does that mean it is a requirement to have SQL Server 2008 installed ( which I don't want ) to make it work in Visual Studion 2008.
I just uninstalled VS 2005.

View 7 Replies View Related

Report Designer In Visual Studio 2008

Nov 21, 2007

How do I install the report designer in Visual Studio 2008?

Edit: I mean, how do I install the SQLRS 2005 Report Designer in Visual Studio 2008?

View 24 Replies View Related

Integration Services Designer (Visual Studio) Very Very Slow

Jan 18, 2007

Hi all

I have some performance issues when developing Integration Service Package ...

It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.

On another pc in the same environment it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??

Thanks for any comments

Best regards
Frank Uray

View 8 Replies View Related

SSCE Visual Studio Setup / Integration Woes

Dec 19, 2007

I have had a heck of a time trying to get SQL Compact Edition 3.5 working in by Visual Studio 2008 environment. I (now) know it comes along with Visual Studio 2008 by default, however, I didn't realize that at first and went and installed one of the SQL Compact Edition MSI's that were available from MS download. Since then I am unable to create a new compact edition database (Add New Item...) in visual studio it says:


The data provider required to connect to the local data file could not be found. The file will be added to the project but the typed DataSet associated with the file will not be generated.

Also, When I try to create a new connection under server explorer, I notice the SQL Compact Edition is not a data source option.


I am running the relased build from the MSDN download iso: en_visual_studio_team_system_2008_development_x86_x64wow_dvd_X14-26382.iso


I have uninstalled the seperate install of the SQL Compact Edition and run repair on the visual studio 2008 installer and it does not fix the problem. I have seen a reference that says the design time installer should be under Program FilesMicrosoft Visual Studio 9.0Common7IDE, but it isn't in my install. I did find it on the source DVD under the folder WCUSSCESSCEDeviceRuntime-enu.msi.


After running that, I no longer get the original error message. Now I get a little further and then the Data Source Configuration Wizard comes up and says

An error occured while retrieving the information from the database:


SQL Server Compact is either not installed or the installation has been corrupted.


OK, so I look under C:Program FilesMicrosoft SQL Server Compact Editionv3.5 which install from the DVD (WCUSSCESSCEDeviceRuntime-enu.msi.) created and notice a readme file that inside has a link for downloading and installing the Runtime for Desktop computers.

Thinking that perhaps the runtime is a seperate install from the design tools I follow the link and setup starts. At this point I notice that the set says Compact Edition 3.5 BETA - hmm that doesn't seem right so I cancel. Not sure why the final product for the design tools would have a readme that points to a download link for the BETA of the runtime, but going back to the DVD I see the file WCUSSCESSCERuntime-enu.msi and run it. This time it says it will install Compact Edition 3.5 - looks good no BETA.

Finish the instal and viola! it works....

So what worked for me in the end:

1) Uninstall any other installs of Compact Edition 3.5 you might have
2) repair visual studio
3) install the design tools from the DVD WCUSSCESSCEDeviceRuntime-enu.msi.
4) install the runtime fgrom the DVD WCUSSCESSCEDeviceRuntime-enu.msi.




View 2 Replies View Related

Visual Studio 2005 Integration Services Error

Sep 13, 2007



Greetings,



I am using Visual Studio 2005 SP1, SQL Server Developers Edition, Both installed recently and updated completely on an XP SP2 workstation (again all updates installed, the necessary ones at least) The issue I am having is when I try to load a solution for Integration services an error message box appears with the following:



An error prevented the view from loading. (Microsoft Visual Studio)

===================================

The specified module could not be found. (Exception from HRESULT: 0x8007007E) (System.Windows.Forms)



This issue was of course occurring before the reinstall of both Visual Studio and SQL Server DE. The issue also extends to creating new projects, in which I am not able to...so the frustration is a little high at the moment, any help would be great...

View 2 Replies View Related

Integration Services Designer (Visual Studio) Is Very Very Slow

Jan 22, 2007

Hi all

I have some performance issues when developing Integration Service Package ...

It is very very slow for example when I try to add new connection in
Connection Manages, it takes about 2 minutes just to open the property window.

On another pc in the same environment (Domain etc.) it works ok.
In the past I have doing a lot of SSIS Packages ... Is there any cache to empty ??

Thanks for any comments

Best regards
Frank Uray

View 1 Replies View Related

Cannot Add Image To RDLC Using SSRS On Visual Studio 2008

Dec 4, 2007

I am using VS2008 and trying to add an Image to a report (RDLC).
The documentation suggests the properties window for the Image field will have a Source and a Value field.
I cannot see them.
Elswhere, the documentation talks about an Image Wizard.
I cannot find that either.

I have added an Image to the Report's Embedded Images list.
How do I add an image to my RDLC?

View 3 Replies View Related

Question About SQL Server Express And Visual Studio 2008

Feb 12, 2008

I already have SQL Server Express 2005 installed from having Visual Studio 2005 installed. How can I tell if it is the SP2 edition? It probably isn't, so my next question is what is going to happen when I install Visual Studio 2008, which I will be doing in a day or two...will the install overwrite SQL Server Express 2005 with the latest edition to SP2, assuming that the latest edition will be on the Visual Studio 2008 installation discs? I have not yet used SQL Server Express, so my knowledge level with it is very weak. What I'm hoping to find out with this question is what I'll have (with respect to SQL Server Express) and the install of Visual Studio 2008. I can't even figure out how to tell what version of SQL Server Express that I now have.

View 9 Replies View Related

CE 3.5 SDK For Native (C/C++) Development (independent Of Visual Studio 2008)

Jan 27, 2008

Hi All-

It appears Microsoft has bundled SQL Server Compact Edition 3.5 SDK for C/C++ development as part of Visual Studio 2008 and is NOT available for download as an independent entity (as 3.1 SDK is).

Is there a work around?

Thanks.

View 3 Replies View Related

Sql Server 2005 Using Visual Studio 2008 And Vista

Feb 8, 2008

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

View 6 Replies View Related

Debugging Stored Procedures In Visual Studio 2008

May 22, 2008

I've followed the steps in http://www.sqlteam.com/article/debugging-stored-procedures-in-visual-studio-2005 & in the MSDN for configuring and setting up debugging SQL 2005 stored procedures in VS 2008 (seems to be the same as in VS 2005). Everything works fine until I Step Into the Stored Procedure. Everything says that a yellow arrow will appear on the left and I can start going line by line. I never get the yellow arrow.

If I set a breakpoint, it is automatically disabled. The pop-up warning says, "The breakpoint will not currently be hit. Unable to bind SQL breakpoint at this time. Object containing the breakpoint not loaded." I can't find anything about this message or problem on Microsoft's site or on the web. Any assistance is appreciated.

P.S.
I'm running VS 2008 Professional Edition Version 9.0.2.1022.8 RTM

View 7 Replies View Related

Problem Using Visual Studio 2008 Winforms ReportViewer

Apr 22, 2008

I have an application built using VS 2008 (3.5 fx). I build a series of
reports (using VS 2005 (sigh)) and am now tryiing to render them using a
Windows form and the ReportViewer control in the VS 2008 app. However I
always get the error message "The source of the report definition has not
been specified" when I execute the line

m_reportViewer.RefreshReport();

When I try to view the very same report in a VS 2005 app it renders without
error. I can also view the report using Report Manager and preview it in the
VS 2005 app I use to build it. Any suggestions?

Thx

Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com

View 1 Replies View Related

Visual Studio 2008 And SQL Server 2005 SSIS Packages

Mar 3, 2008

My home machine has sql 2005 and Visual Studio 2005 installed. I uninstalled VS 2005 (RTM) and installed VS 2008 (RTM) in its place. I then found that the SSIS templates were missing. Lesson: don't uninstall VS 2005 if you want to use SSIS 2005!



1. Is there any "workaround" to this issue?



2. (If the answer to 1 is "No") I will install VS 2008 side-by-side with VS 2005 on the same box. When the SSIS issue is finally resolved, can I uninstall VS 2005 without doing damage to the VS 2008 install?



TIA,



Barkingdog




View 17 Replies View Related

Error In Visual Studio 2008 RTM When Attempting To Add Local Database

Mar 16, 2008

I receive the following error when trying to add a local database to my project.

"The data provider required to connect to the local data file could not found. The file will be added to the project but the typed DataSet associated with the file will not be generated."

I've reinstalled VS2k8, SQL Compact 3.1 and SQL Compact 3.5 on my machine and still receive the error.

Does anyone have any suggestions? I saw another similar thread about this in the VB2k8Express forum, but there were no helpful answers there. (for the curious: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2769854&SiteID=1)

I haven't used the SSCE before and so it's possible I've mistakenly omitted some required items.

Any help is greatly appreciated.

View 4 Replies View Related

Sql Reporting Services Sql 2005, Visual Studio 2008, Vista

Mar 17, 2008

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?

View 3 Replies View Related

Database Failed To Update SqlCE With Visual Studio 2008

Feb 15, 2008



I use visual studio 2008 to design a database application.
I am in the peak of finalising the program but I have a snag with updating data in the database.
I could create new rows, add rows and new rows of data to the table but whenever i try to change the data in a cell
it returns an error "Update requires a valid UpdateCommand when passed DataRow collection with modified rows."
I have tried all possible solutions, using table adapter, commands etc but wont get it.

This situation also applies to changes made directly on the data grid and also when using the binding navigator buttons
to edit and save data.

please help me.

Barbara Grayson

View 1 Replies View Related

Integration Services :: Lotus Notes In SSIS Visual Studio Crashing?

Apr 28, 2015

I created an ODBC to Lotus notes server and database.  This ODBC connection works, however, when I put the ODBC into SSIS and test the connection my visual studio 2010 crashes and has to restart.  Is there a fix I am missing on my VS2010?  Or am I doing something wrong in my SSIS project?

View 2 Replies View Related

Integration Services :: Microsoft Visual Studio - How To Get Tasks To Move Up On The Page

Sep 4, 2015

I have all this gray space at the top of my tasks. When I <Ctrl>+<Alt>+<Left-click> to select all of my tasks and then try sliding it up, it creates even more gray space and actually moves it down. If instead when I <Ctrl>+<Alt>+<Left-click> and then <Ctrl>+<Arrow-up> it doesn't move it. Is there any easy way to eliminate all this gray space at the top?

View 3 Replies View Related

Error With Data Mining Viewer Controls In Visual Studio 2008

Nov 20, 2007

Hello:

I have a framework 2.0 winforms application that uses the data mining viewer controls. I upgraded the project to visual studio 2008 and compiled it under framework 2.0. It compiles fine, but when the form with the TimeSeriesViewer control loads, the application throws the following exception:

System.Reflection.TargetInvocationException was unhandled by user code
Message="Unable to get the window handle for the 'AxChartSpace' control. Windowless ActiveX controls are not supported."
Source="System.Windows.Forms"
StackTrace:
at System.Windows.Forms.AxHost.InPlaceActivate()
at System.Windows.Forms.AxHost.TransitionUpTo(Int32 state)
at System.Windows.Forms.AxHost.CreateHandle()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.AxHost.EndInit()
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer.InitializeComponent()
at Microsoft.AnalysisServices.Viewers.TimeSeriesViewer..ctor()
at RMS2.UI.DecisionSupport.ShowModel(String modelName, Int32 tabIndex) in C:UsersDougDocumentsRmsIIRmsIIRMS2.UIDecisionSupport.cs:line 72
at RMS2.UI.DecisionSupport.DecisionSupport_Load(Object sender, EventArgs e) in C:UsersDougDocumentsRmsIIRmsIIRMS2.UIDecisionSupport.cs:line 42
at System.Windows.Forms.Form.OnLoad(EventArgs e)
at System.Windows.Forms.Form.OnCreateControl()
at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
at System.Windows.Forms.Control.CreateControl()
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.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.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
InnerException: System.AccessViolationException
Message="Attempted to read or write protected memory. This is often an indication that other memory is corrupt."
Source="System.Windows.Forms"
StackTrace:
at System.Windows.Forms.UnsafeNativeMethods.IOleObject.DoVerb(Int32 iVerb, IntPtr lpmsg, IOleClientSite pActiveSite, Int32 lindex, IntPtr hwndParent, COMRECT lprcPosRect)
at System.Windows.Forms.AxHost.DoVerb(Int32 verb)
at System.Windows.Forms.AxHost.InPlaceActivate()
InnerException:


The control is being added programatically, as in the wiinforms samples. Can anyone suggest a workaround? Thank you in advance.

- doug

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved