SQL 2012 :: Error - Project Type Is Not Supported

Jul 7, 2015

When I opened the Microsoft SQL Server Management Studio(Administrator), the message below is shown up.

`C:Program FilesMicrosoft SQL Server1 10 ToolsBinnManagementStudioSQLWorkbenchProjectsSSMSEmptySqlProject.ssmssqlproj` cannot be opened because its project type (.ssmssqlproj) is not supported by this version of the application.

To open it, use a version that supports this type of project.

View 0 Replies


ADVERTISEMENT

Problem In Opening The Project..Make Sure The Application For The Project Type (.dtproj) Is Installed.

Jun 24, 2007

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

View 4 Replies View Related

Open SSIS Project Error: Unable To Cast COM Object Of Type

Oct 4, 2006

When 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)).

View 32 Replies View Related

SQL 2012 :: Error Executing Packages In SSIS Project On Server After Editing On Client

Sep 24, 2014

I am building a bunch of packages on our new server and all was going well until I edited the project using the client tools on my PC. I now receive the below error if I try to execute any of the packages on the server (all is still fine on the client). I have scoured the net but I don't seem to be able to come up with a solution. I have tried altering the folder & object permissions for my login (that created the project on the server and edited using the client) but I still get the error.

ERROR:

TITLE: Microsoft Visual Studio
------------------------------
Failed to start project
------------------------------

ADDITIONAL INFORMATION:

Exception deserializing the package "Access to the path 'G:VisualStudioTestTestbinDevelopmentTest.ispac' is denied.". (Microsoft.DataTransformationServices.VsIntegration)

------------------------------
Access to the path 'G:VisualStudioTestTestbinDevelopmentTest.ispac' is denied. (mscorlib)
------------------------------
BUTTONS:

OK
------------------------------

View 4 Replies View Related

Data Type Not Supported Issue.

Dec 4, 2006

EXEC master.dbo.sp_addlinkedserver @server = N'DM', @srvproduct=N'DM Association', @provider=N'MSDMine', @datasrc=N'ray620', @catalog=N'DM Association'

select * from openquery (DM,'SELECT * FROM [Model Association TB].Content where NODE_TYPE = 8;')

Msg 7354, Level 16, State 1, Line 2

The OLE DB provider "MSDMine" for linked server "DM" supplied invalid metadata for column "NODE_DISTRIBUTION". The data type is not supported.I'm getting an error with the metadata. Appreciate any assistance. Thank you in advance.

View 1 Replies View Related

SQL 2012 :: Error When Inserting To Text Type Field

Mar 8, 2015

See attached image...

The columns are of type text

I made this insert stmt using a stored proc...

I mean the [text] field values from another table is converted to varchar(max) and then to VARBINARY(max) and then to HEX value.

Why this error only when I try to insert to this particular column [[Conclusions]] ?

Other columns ( of type text ) did not have this issue

View 1 Replies View Related

Code Page Translations Are Not Supported For The Text Data Type. From: 1252 To: 950.

Jul 23, 2005

Code page translations are not supported for the text data type. From:1252 To: 950.I would like to know what this message means. I also installed thelanguage packs in advanced settings, Everything is set to English. Mywindows XP computer is XP English. For some reason I cant get an updateto go thru using ADO. like Recordset.UpdateAlthough other routines using .update workAny ideas?

View 6 Replies View Related

SQL Server 2005 Issue - The Cursor Type/concurrency Combination Is Not Supported.

Jun 19, 2007

Hi



I have recently upgraded from SQL 2000 to SQL 2005 and I'm getting the following problem, can you suggest me if this is a issue with SQL 2005 or suggest me an asnwer for this.

Below is the exception from my log file

The cursor type/concurrency combination is not supported.
com.microsoft.sqlserver.jdbc.SQLServerException: The cursor type/concurrency combination is not supported.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.<init>(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.prepareStatement(Unknown Source)



The following is the piece of code where the problem I'm assuming is happening, how can I correct it.

varStmt1 = varConnection.prepareStatement(varCitationSQL.toString(),ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_UPDATABLE);

Have tried using both JDC v1.1 and 1.2 but of no use.

View 5 Replies View Related

SQL Server 2012 :: Arithmetic Overflow Error For Type Varchar

Mar 11, 2014

I have the following code in a SP. The 2 if statements for the @@ Error I added only for testing as I suddenly started get the following error at the 1st @@Error statement

Msg 232, Level 16, State 2, Line
Arithmetic overflow error for type varchar, value = 10000.00000.

I cannot have this SP running minutes it must be done in seconds.

I have tried the folloiwng changes but then it takes to long.

-- set @new = 'x' + right('0000' + convert(varchar(5), round(rand() * 10000, 0)), 4)
-- set @new = 'x' + right('0000' + convert(varchar(4), right(round(rand() * 10000, 0),4)), 4)

declare @newvarchar(5),
@xstsint,
@new_retvarchar(5)
,@Cnt as int /* just for my testing */
set @cnt = 0 /* just for my testing */

[Code] ......

View 6 Replies View Related

This Microsoft Sql Server Native Client Package Is Not Supported On The Current Processor Type

Dec 16, 2007

Hello,I'm trying to install the SQL Server 2005 Standard edition and while I can easily install the first part of the package, the 
document.write(L_LINK_RUNINSTALL_VAR_TEXT)
Server components, tools, Books Online, and samples, when I click
to install the Run the SQL Native Client Installation Wizard  it tells me this:This Microsoft sql server native client package is not supported on the current processor type
I have Windows XP64bit with IIS running on 32bit now.  Why does it do that and how I can get around it  ? :) Thanks.
 

View 3 Replies View Related

SQL Server 2012 :: Arithmetic Overflow Error Converting Varchar To Data Type Numeric

Oct 30, 2014

OK, so I have this query where I'm trying to subtract values like this, when I do this I am getting (Arithmetic overflow error converting varchar to data type numeric.) I have tried many different things, and now of these work, it'll either return 0 because it loses the .XXXXX.

Convert(DECIMAL(10,7),CAST([TIME_OF_COMPLETION] as DECIMAL(10,7)) - Convert(DECIMAL(10,7),CAST([OPR_DELIVERED_TIME] as DECIMAL(10,7)) round(cast(cast(hist.[TIME_OF_COMPLETION] AS float) as DECIMAL(15, 5)) - CAST(hist.[OPR_DELIVERED_TIME] AS FLOAT),1 SELECT convert(FLOAT,CAST('735509.00053' AS DECIMAL(10,5))) - convert(FLOAT,CAST('735509.00047' AS DECIMAL(10,5)))

View 1 Replies View Related

SQL 2012 :: SSIS Conversion Between Types Is Not Supported

Nov 18, 2014

As part of an ETL conversion I have dataflow task created that copies data from one table to another, we use it as a way to rename fields and change data types. What is strange is that the OLE DB SQL destination has not issue if I copy data from an int to smallint and in another case from an int to a numeric field and it runs fine. So I decided to test using a SQL Server Destination as I heard it may be faste that using OLE Db.

No I am getting the following error

Error: 0xC02020F5 at Insert into TRANSACTION, SQL Server Destination [32]: The column "ID" can't be inserted because the conversion between types DT_I4 and DT_NUMERIC is not supported.
Error: 0xC02020F5 at Insert into TRANSACTION, SQL Server Destination [32]: The column "ID1" can't be inserted because the conversion between types DT_I4 and DT_I2 is not supported.

I do understand the error but not why it runs fine using the OLE DB but when running it through SQL Server Destination I get this error.

View 2 Replies View Related

How Can I Remove The Workitem Type From The Existing Project?

Jun 11, 2007

When creating a new project using 'Agile' process template, there are 5 workitem types in the list of workitem type by default. After the project being created, how can I delete some workitem type that we don' t need?



For example, my team will never use 'Senario' workitem type for the project and I would like to remove this workitem type from the list. So no team member will see 'Senario' workitem type in the list when creating workitem, and therefore no one will create a workitem using 'Senario' workitem type by accident.



I understand that workitem type can't be deleted if it is used to created any workitem. So what I mean is the workitem type that has never used to create any workitem.



Thanks.

View 2 Replies View Related

SQL Server 2012 :: Determine Which Column Is Causing Error Converting Data Type Varchar To Numeric?

Aug 14, 2014

I'm moving data from one database to another (INSERT INTO ... SELECT ... FROM ....) and am encountering this error:

Msg 8114, Level 16, State 5, Line 6
Error converting data type varchar to numeric.

My problem is that Line 6 is:

set @brn_pk = '0D4BDE66347C440F'

so that is obviously not the problem and my query has almost 200 columns. I can go through one by one and compare what column is int in my destination table and what is varchar in my source tables, but that could take quite a while. How I can work out what column is causing the problem?

View 3 Replies View Related

Message Make Sure The Application For The Project Type (.rptproj) Is Installed.

Oct 3, 2007

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

View 2 Replies View Related

Message : Make Sure The Application For The Project Type (.rptproj) Is Installed.

Oct 3, 2007


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.

View 1 Replies View Related

Business Intelligence Project Type Not Found In Visual Studio 2005

Oct 17, 2006

Hi,

I have installed sql server 2005 and visual studio 2005 on windows server 2003. When I select business intelligence studio from sql server, visual studio editor opens up,but i cannot find business intelligence projects template in visual studio. Please suggest some solution or workaround.

Thanks,

Y Gupta

View 1 Replies View Related

Team Project In TFS - SSIS Project Sets Itself As The Startup Project

May 29, 2008



For some reason in a Team Foundation Team Project that has multiple project types (SSRS, SSIS, WebSite, C# Business DLL...), the SSIS project makes itself the startup project to the team project. If I explicitly set another project as the startup project to the team project and then select an SSIS package in the SSIS project in the team project, the SSIS project becomes the startup project automatically.

I am using Visual Studio 2005 SP1.

View 3 Replies View Related

Named Constraint Is Not Supported For This Type Of Constraint (not Null)

May 13, 2008

Hi, all.

I am trying to create table with following SQL script:





Code Snippet

create table Projects(
ID smallint identity (0, 1) constraint PK_Projects primary key,
Name nvarchar (255) constraint NN_Prj_Name not null,
Creator nvarchar (255),
CreateDate datetime
);

When I execute this script I get following error message:

Error source: SQL Server Compact ADO.NET Data Provider
Error message: Named Constraint is not supported for this type of constraint. [ Constraint Name = NN_Prj_Name ]

I looked in the SQL Server Books Online and saw following:

CREATE TABLE (SQL Server Compact)
...
< column_constraint > ::= [ CONSTRAINT constraint_name ] { [ NULL | NOT NULL ] | [ PRIMARY KEY | UNIQUE ] | REFERENCES ref_table [ ( ref_column ) ] [ ON DELETE { CASCADE | NO ACTION } ] [ ON UPDATE { CASCADE | NO ACTION } ]

As I understand according to documentation named constraints should be supported, however error message says opposite. I can rephrase SQL script by removing named constraint.





Code Snippet

create table Projects(
ID smallint identity (0, 1) constraint PK_Projects primary key,
Name nvarchar (255) not null,
Creator nvarchar (255),
CreateDate datetime
);
This script executes correctly, however I want named constraints and this does not satisfy me.

View 1 Replies View Related

Error: Keyword Not Supported: 'dsn' In Asp.net

Jun 10, 2008

hi,i am trying to connect sql server 2005 from my asp.net applicationi have create DSN for this ..then i am getting the following errorKeyword not supported: 'dsn'. in sql serverplease provide me the solution

View 5 Replies View Related

Locale Not Supported Error

Jan 22, 2007



I am using Vista and when I try to open one of the Business intelligence reports, I get error "Locale 16393 not supported". Any clue on this ?

Thanks

View 1 Replies View Related

SQL 2012 :: Getting Environment Variables For SSIS Project?

Sep 9, 2015

Is it possible to export the environment variables for an SSIS 2012 project? And if so how is it achieved?

View 2 Replies View Related

CASE Is Not Supported Error In A View

Jun 28, 2000

CASE is not supported Error in a View

In SQL 7, when a view parses the below code, it generates a 'CASE is not Supported' error'; however, it will still generate and show the field with the CASE statements correctly; What might cause this error?

(Other useful info: this code is from a converted SQL 6.5 DB and the SQL 7 is running in compatibility mode, i inserted '' to remove concantenation of NULL problems;)

Example of display:
10132 Hampton, VA: A. Deepak Publishing

SELECT PublisherID, Info = CASE WHEN City IS NOT NULL
THEN City + CASE WHEN State IS NOT NULL
THEN ', ' + State ELSE '' END + ': ' ELSE ''
END + Publisher
FROM tblLibraryPublishers

Thank you!
Llyal

View 2 Replies View Related

The Requested Properties Cannot Be Supported - Error

Mar 28, 2007

I have a strange issue on my local test environment (Win XP Pro SP 2 - SQL server 2000 with SP4 and IIS 5.1 ), where I get an error in the Select statement if I do not include the database owner prefix, like "select * from patients where PID< 200".

If I change it to "Select * from hprs.patients where PID<200" it works fine.

However, in more complex SQL, where I have joins, and sub queries, I still get errors on my local test machine, but the live server works fine.

I use the calls in classic ASP pages on a web site and I did not get this before, only after I re-instaled SQL Server 2000 to fix another issue I had on my machine.

On the live server (also SQL Server 2000) I do not get the error.

Is there a setting I can change on my local dvelopment environment so that it is not a requirement to include the DB owner in the SQL?

Any help with this will certainly save me a lot of re writing tons of SQL so I can still test before publishing.

Thanks - Hans

View 2 Replies View Related

SQL 2012 :: Unable To Add Service Reference In A CLR Database Project?

Apr 17, 2014

I created a CLR procedure with a service reference in Visual Studio 2010 that is being used in SQL Server 2008 R2. We recently tried to deploy it to a 2012 SQL Server, but were unable to due to compatibility issues. When I tried to upgrade the package to Visual Studio 2013 I got this error message:

Unable to cast object of type 'Microsoft.VisualStudio.Data.Tools.Package.Project.DatabaseFileNode' to type 'Microsoft.VisualStudio.Data.Tools.Package.Project.Internal.FolderNode'

I tried to create this using the 2012 Data Tools, but was unable to add a service reference with the GUI. It appears Microsoft has removed this functionality. My company has a third party app that we have limited control over, which is why we need this functionality.

[URL]

View 0 Replies View Related

SQL 2012 :: Create And Map Server Environment For Project Deployment

Oct 27, 2015

I know how to "Create and map a Server Environment" using management studio [URL] ......

Is it possible to create the environment in DTS (2012) and have that environment created on the target server?

View 2 Replies View Related

The Requested Properties Cannot Be Supported. Error '80040e21'

Jul 12, 2007

Hi,

I get this error "sometimes" on sql server 2000 (

The requested properties cannot be supported. error '80040e21'

when running the code below multiple times.

Any solutions for this ?

thanks in advance



gr.

Peter





Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Mode = 3 '1 = adModeReadOnly
Conn.Open ConnectString
SqlSend= "Select top 30 * from tab1 WITH (UPDLOCK,readpast) where x<>'' and RecordNumber > 6200000 and Status= 2 and processed <> 3 ORDER BY RecordNumber"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Cursortype=0
rs.Cursorlocation =2
rs.LockType= 3
rs.Open SqlSend, Conn < here it gives the error

View 4 Replies View Related

(Error) Conversion From DT_TEXT To DT_WSTR Is Not Supported.

Feb 6, 2006

Below is the error I get when trying to convert a Visual FoxPro memo field to a DT_WSTR (4000 ) in a SQL table. It does not let me convert a DT_TEXT to a DT_WSTR.

Thank in advance




TITLE: Editing Component
------------------------------

The component is not in a valid state. The validation errors are:
Error at NMF [Data Conversion [6328]]: Conversion from "DT_TEXT" to "DT_WSTR" is not supported.


Do you want the component to fix these errors automatically?

------------------------------
BUTTONS:

&Yes
&No
Cancel
------------------------------

View 5 Replies View Related

Maintenance Plan Error No Such Interface Supported

May 22, 2008



Using the full SQL Server 2005 patched up to build 9.0.3054.

Creating a simple maintenance plan to backup specific databases.

As soon as i try to save the plan i get the popup error :"no such interface supported". It won't allow me to save any plan at all regardless of what I put in there.

I need someone's help!!!!

View 6 Replies View Related

XML Sample Gets Error: CREATE ENDPOINT Not Supported

Jul 14, 2006

I installed the latest version of SQLX and tried to run the XML sample.

C:Program FilesMicrosoft SQL Server90SamplesEnginexmlXmlManuInstructionsReadMe_OnlineManuInstr.htm

The first part of the install.sql ran ok, but it chokes on the CREATE ENDPOINT line: is this really a limitation on the Express edition or did I miss something on installation or configuration?

Msg 7878, Level 16, State 1, Line 3

This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.

View 3 Replies View Related

Encryption Not Supported On SQL Server - Error Message

Jun 17, 2005

Hi,

View 16 Replies View Related

Error 29515 - Encryption Not Supported On Client - Wtf??

Jul 1, 2006

I have tried reinstalling the sqlncl.msi - re-booting etc without success.

I'm on windows vista beta 2 build 5384.

Brand spanking new machine (less that 48 hrs old) and I can't beleive my bad luck with sql express.  My xp pro machine works fine.

 

Hers's the error:

TITLE: Microsoft SQL Server 2005 Setup
------------------------------

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=29515&EvtType=lib%5codbc_connection.cpp%40Do_sqlScript%40OdbcConnection%3a%3aconnect%40connect%40x15

------------------------------
BUTTONS:

&Retry
Cancel
------------------------------


 

Here's the log:

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version      : Professional  (Build 5384)
Time            : Sat Jul 01 08:01:37 2006
 
Machine         : JOHN-PC
Product         : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine         : JOHN-PC
Product         : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine         : JOHN-PC
Product         : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install         : Successful
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine         : JOHN-PC
Product         : SQL Server Database Services
Error           : SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
--------------------------------------------------------------------------------
Machine         : JOHN-PC
Product         : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install         : Failed
Log File        : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQL.log
Last Action     : InstallFinalize
Error String    : SQL Server Setup could not connect to the database service for server configuration. The error was: {Microsoft}{SQL Native Client}Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Error Number    : 29515
--------------------------------------------------------------------------------

 SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.


Time            : Sat Jul 01 08:07:48 2006


List of log files:
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_Core(Local).log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLSupport_1.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQLNCLI_1.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SqlWriter_1.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SQL.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_Datastore.xml
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_.NET Framework 2.0.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_Support.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_Core.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_SCC.log
 c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0008_JOHN-PC_WI.log
 c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG

Some relevant registry settings:

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native Client]

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native ClientCurrentVersion]
"PatchLevel"="9.00.2047.00"
"Version"="9.00.2047.00"
"SP"=dword:00000000
"LCID"=dword:00000409

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Native ClientMSIRefCount]
"Uninstall"="{11111111-1111-1111-1111-111111111111}"

and

 

Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server]

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90]

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90Bootstrap]
"BootstrapDir"="C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\"

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90BootstrapMSIRefCount]
"Uninstall"="{11111111-1111-1111-1111-111111111111},{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F},{2750B389-A2D2-4953-99CA-27C1F2A8E6FD}"

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90BootstrapSetup]
"PatchLevel"="9.1.2047"

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSQLEXPRESS]

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSQLEXPRESSMSSQLServer]

[HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerSQLEXPRESSMSSQLServerSuperSocketNetLib]
"ProtocolList"=hex(7):00,00

 

SQLSetup0001_JOHN-PC_SQLNCLI_1.log snippet (right at the end) says:

<snipped>

MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client -- Configuration failed.

MSI (s) (AC:64) [20:59:38:014]: Product: Microsoft SQL Server Native Client. Version: 9.00.2047.00. Language: 1033. Configuration change completed with status: 1603.


</snipped>

 

and at the end of SQLSetup0001_JOHN-PC_Core(Local).log

<snipped>

Running: ReportChainingResults at: 2006/5/30 20:59:42
Error: Action "ReportChainingResults" threw an exception during execution.
One or more packages failed to install. Refer to logs for error details. : 1706
        Error Code: 0x800706aa (1706)
Windows Error Text: The endpoint format is invalid.

  Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Mon Jan 16 02:06:13 2006
     Function Name: sqls::ReportChainingResults::perform
Source Line Number: 3245

---- Context -----------------------------------------------
sqls::HostSetupPackageInstallerSynch::postCommit
sqls::HighlyAvailablePackage::preInstall
sqls::HighlyAvailablePackage::manageVsResources
ce: 29539

Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JOHN-PC_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0001.cab" Error Code : 2
Running: UploadDrWatsonLogAction at: 2006/5/30 21:0:8
Message pump returning: 1706

</snipped>


 

Can anyone advise.  I'm willing to take a "you'll have to re-build your machine" response if I have to.  But I just need to know if this really is required.

Thank you,

John.

View 15 Replies View Related

Sqlbulkcopy Error : The Given Value Of Type SqlDecimal From The Data Source Cannot Be Converted To Type Decimal Of The Specified

Apr 16, 2008

Hi,

The table in SQL has column Availability Decimal (8,8)

Code in c# using sqlbulkcopy trying to insert values like 0.0000, 0.9999, 29.999 into the field Availability
we tried the datatype float , but it is converting values to scientific expressions€¦(eg: 8E-05) and the values displayed in reports are scientifc expressions which is not expected
we need to store values as is


Error:
base {System.SystemException} = {"The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column."}

"System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column. ---> System.InvalidOperationException: The given value of type SqlDecimal from the data source cannot be converted to type decimal of the specified target column. ---> System.ArgumentException: Parameter value '1.0000' is out of range.
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
--- End of inner exception stack trace ---
at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata)
at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternal()
at System.Data.SqlClient.SqlBulkCopy.WriteRowSourceToServer(Int32 columnCount)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table, DataRowState rowState)
at System.Data.SqlClient.SqlBulkCopy.WriteToServer(DataTable table)
at MS.Internal.MS
COM.AggregateRealTimeDataToSQL.SqlHelper.InsertDataIntoAppServerAvailPerMinute(String data, String appName, Int32 dateID, Int32 timeID) in C:\VSTS\MXPS Shared Services\RealTimeMonitoring\AggregateRealTimeDataToSQL\SQLHelper.cs:line 269"


Code in C#

SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnection, SqlBulkCopyOptions.Default);
DataRow dr;
DataTable dt = new DataTable();
DataColumn dc;

try
{

dc = dt.Columns.Add("Availability", typeof(decimal));
€¦.

dr["Availability"] = Convert.ToDecimal(s[2]); ------ I tried SqlDecimal
€¦€¦€¦.

}
bulkCopy.DestinationTableName = "dbo.[Tbl_Fact_App_Server_AvailPerMinute]";
bulkCopy.WriteToServer(dt);



thx



View 8 Replies View Related







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