error during installing SP3

Hi
I've got following error during installing SP3
by running this file Sql2kasp3.exe after successfully
installation sql 2ksp3.exe,
(SQL server 2000,server station)
"an error occurred during move data process : -145"
Thanks for any reply
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Are you running analysis services?
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1kakxwshqligo@.msnews.microsoft.com...

quote:

---

> Hi
> I've got following error during installing SP3
> by running this file Sql2kasp3.exe after successfully
> installation sql 2ksp3.exe,
> (SQL server 2000,server station)
> "an error occurred during move data process : -145"
> Thanks for any reply
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---

error during install SP3

Hi
I've SQL server 2000 on server station and wanted
to install SP3,at first installation of sql2ksp3.exe
was completed successfully,and following error appearred
on running sql2kasp3.exe:
"An error occurred during move data process : -145"
why ?
what's wrong?
any help would be greatly appreciated.
--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/Hi
Sql2kasp3.exe Updates Analysis Services is this actually installed?
John
"RM" <m_r1824@.yahoo.co.uk> wrote in message
news:opr1linpoqhqligo@.msnews.microsoft.com...

quote:

---

> Hi
> I've SQL server 2000 on server station and wanted
> to install SP3,at first installation of sql2ksp3.exe
> was completed successfully,and following error appearred
> on running sql2kasp3.exe:
> "An error occurred during move data process : -145"
> why ?
> what's wrong?
> any help would be greatly appreciated.
> --
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

---

|||no ,I didn't install completely
an error casued to exit it,
On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
<jbellnewsposts@.hotmail.com> wrote:

quote:

---

> Hi
> Sql2kasp3.exe Updates Analysis Services is this actually installed?
> John
> "RM" <m_r1824@.yahoo.co.uk> wrote in message
> news:opr1linpoqhqligo@.msnews.microsoft.com...
>

---

Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/|||Hi
Sql2kasp3.exe will update your existing install of Analysis services,
you need Analysis services to already be installed and working before
applying this patch.
John
RM <m_r1824@.yahoo.co.uk> wrote in message news:<opr1nbozoghqligo@.msnews.microsoft.com>...[QUOTE][c
olor=darkred]
> no ,I didn't install completely
> an error casued to exit it,
> On Sun, 11 Jan 2004 12:07:47 +0000 (UTC), John Bell
> <jbellnewsposts@.hotmail.com> wrote:
>

Error Deployiong Analysis Services Cube

Hi:

I am getting the following error when deploying the cube on my laptop.

"The project could not be deployed to the 'localhost' server because of the following connectivity problems : A connection cannot be made. Ensure that the server is running. To verify or update the name of the target server, right-click on the project in Solution Explorer, select Project Properties, click on the Deployment tab, and then enter the name of the server."

I confirmed that all the services are running. Can you someone guide me here? This is the first time I am trying to deploy the cube in analysis services 2005. Please let me know.

Thanks

Try using machine name instead of the "localhost". Try connecting to your Analysis Server using SQL Management studio.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

sql

Error creating DSN

Hi
I'm trying to set up a DSN and get a 18456 error
Here is what I do
start->programs->administrative tools->data sources (ODBC).
On system DSN sheet I press add
A window opens and I choose SQL Server
Another window opens (create a new data source to sql server)
Field name = XML description = XML, server = local ( I have 2 options local
and moshik).
I press next and the window changes here I choose "with sql server
quthentication using a login ID and password entered by the user"
Bellow I enter loginid = moshik, password=XXX
I press next and get the follwoing error message
"connection failed;
sql state: '28000'
sql server error : 18456
[microsoft][odbc sql server driver][sql server]login failed for
user
'moshik'."
I loged into the computer using moshik's user and opened enterprize manager
and manipulated the data on the database so user moshik has rights to the
database.
I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
stand alone and not connected to a network and not in a domain.
Any help will be appreciated
Moshik AmitWhen you specify the local server, did you use:
(local)
You may also want to type the name of the server yourself in
the server drop down. Specify the machine name instead of
using (local). You aren't limited to just what is displayed
in the drop down - you can type any server, machine name in
there as well.
-Sue
On Tue, 9 Aug 2005 09:30:05 -0700, "Moshik Amit"
<MoshikAmit@.discussions.microsoft.com> wrote:

>Hi
>I'm trying to set up a DSN and get a 18456 error
>Here is what I do
>start->programs->administrative tools->data sources (ODBC).
>On system DSN sheet I press add
>A window opens and I choose SQL Server
>Another window opens (create a new data source to sql server)
>Field name = XML description = XML, server = local ( I have 2 options local
>and moshik).
>I press next and the window changes here I choose "with sql server
>quthentication using a login ID and password entered by the user"
>Bellow I enter loginid = moshik, password=XXX
>I press next and get the follwoing error message
>"connection failed;
>sql state: '28000'
>sql server error : 18456
>[microsoft][odbc sql server driver][sql server]login failed for
user
>'moshik'."
>I loged into the computer using moshik's user and opened enterprize manager
>and manipulated the data on the database so user moshik has rights to the
>database.
>I have a Win 2000 server sp 4 and sql server 2000. The win 2000 server is
>stand alone and not connected to a network and not in a domain.
>Any help will be appreciated
>Moshik Amit

Error Creating CLR UDF

Hi:

I am trying to create a CLR UDF in SQL 2005 and cosnistently run into the following error. What am I doing wrong?. Please correct me and show me the right way of doing this.

Msg 6551, Level 16, State 2, Procedure EmailSplitter, Line 3

CREATE FUNCTION for "EmailSplitter" failed because T-SQL and CLR types for return value do not match.

Here is what I am trying to achieve. Split a Email field in the database. For that I am trying to return an array using C# and then trying to call the UDF for the C#.

--1).CLR Code. (EmailSpitter.cs)

using System;
using System.Collections.Generic;
using System.Text;

namespace SQLTools
{
public class EmailSplitter
{
public static string[] Parse(string data)
{
string[] columnData;
string[] separators = new string[1];
separators[0] = " ";

if (data != null)
{
columnData = data.Split(separators, StringSplitOptions.None);
return columnData;
}
return null;
}
}
}

--2). Assembly code.

CREATE Assembly SQLArrayBuilder

FROM 'E:\CLR\EmailSplitter\bin\Debug\EmailSplitter.dll'

WITH PERMISSION_SET=SAFE

Select * from sys.assemblies.

--3). Create the function.

CREATE Function dbo.EmailSplitter

(@.EmailString NVARCHAR(4000))

RETURNS VARCHAR(4000)

AS

EXTERNAL NAME SQLArrayBuilder.[SQLTools.EmailSplitter].Parse

Run into the error:

Msg 6551, Level 16, State 2, Procedure EmailSplitter, Line 3

CREATE FUNCTION for "EmailSplitter" failed because T-SQL and CLR types for return value do not match.

Please help me.

Thank you very much.

AK

Your CREATE FUNCTION returns a string, but your CLR function returns an array of strings, that is why you are getting an error. If you want to return an array of strings you will have to create a CLR function that returns an IEnumerable object and define a table valued function in T-SQL. Look up CLR table valued functions in the BOL for the details.

Dan

Error converting data type varchar to numeric.

HI
i have a very big problem.
i have a cloumn name Revenue and i have differt types of revenue in it such as A, B, C.
what i want to do is that i want to say that when the Revenue column is A then sum the tola mount and put in in a new column name A when b then again same thing.
this is my code

case when Revenue='A' then Sum(total_amt) else ' ' end as A

but it is giving me and error Error converting data type varchar to numeric.
please help

Quote:

Originally Posted by voroojak

HI
i have a very big problem.
i have a cloumn name Revenue and i have differt types of revenue in it such as A, B, C.
what i want to do is that i want to say that when the Revenue column is A then sum the tola mount and put in in a new column name A when b then again same thing.
this is my code

case when Revenue='A' then Sum(total_amt) else ' ' end as A

but it is giving me and error Error converting data type varchar to numeric.
please help

first, why the error.

because your case statement said when revenue = 'A' return the sum of total_amt else return blank...the case statement should return (the then part and the else part) the same datatype or at least can be converted to the same datatype.

try ...else sum(0) end as A, ...or ....else 0 end as A

Error converting data type DBTYPE_DBTIMESTAMP to datetime

Hi

I am trying to transfer data from Access 2000 database to SQL server 2005 via SSIS. My access database table has a field with data type Date/Time and SQL server table has a field with data type datetime. When I am running the SSIS package, it is throwing the following error and stops execution.

[SQL Server Destination [12466]] Error: An OLE DB error has occurred. Error code: 0x80040E07. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80040E07 Description: "Error converting data type DBTYPE_DBTIMESTAMP to datetime.".

Please help.

Thanks in advance,
Ramzee

According to BOL (http://msdn2.microsoft.com/en-us/library/ms175970.aspx) the types can be converted, so that should work. Have you identified the values that fail? Using the error output is a very easy way to capture this data. My best guess for now is the values are out of range for the SQL datetime type. A derived column transformation could be used to massage these values depending on requirements.|||

Thanks Darren!

I used the script component to identify the wrong date entries. Now it works!

Thanks once again.

|||

I am having the same error. A simple select from Query Analyzer

Select * from HCPROD..HC.UNIT U

Even if I specifically reference a number column I get the same error

Select BLOCK_ID from HCPROD..HC.UNIT U

The way I see it is that there is a column, probably the DATE_MODIFIED column, somewhere in the database that has a date & time value that the driver cannot process. Why the error occurs even if I do not reference the column is a mystery.

I am using Microsoft OLE DB Provider for Oracle

Note that I have insured that every date field in the table is in 20th or 21st century

|||Some more information. We are using Oracle version 10g. I wonder if there is an updated driver from Microsoft? We searched and could not find one ourselves.|||SELECT TOP 10 * FROM [ORACLE_LOOKUP]..[SchemaName].[TableName] AlaisName

Error converting data type DBTYPE_DBTIMESTAMP to datetime

SELECT * FROM
OPENQUERY (
ORACLE_LOOKUP,
'SELECT TO_CHAR(DateColumnName) FROM TableName')

The following workaround was foud on the internet

A workaround would be to use the OPENQUERY function in SQL Server. This
function allows you to execute a pass-through query on the linked server.
By issuing a pass-through query, you can then take advantage of Oracle's
built-in functions to convert the date to a character data type or NULL.
Examples of both are as follows:

In the following example, the column "hiredate" is converted to a string in
the format of MM-DD-YYYY.

SELECT *
FROM OPENQUERY(, 'SELECT empno,
TO_CHAR(hiredate,''MM-DD-YYYY'') FROM scott.emp')

In this example we use a combination of two Oracle built-in functions,
DECODE and GREATEST to convert any hiredate that is earlier than 01/01/1753
(SQL Server's lower bound) to NULL.

SELECT *
FROM OPENQUERY(,'SELECT DECODE (hiredate,
GREATEST(hiredate, TO_DATE(''01/01/1753'',''MM/DD/YYYY'')), hiredate, NULL)
FROM scott.emp')

In case you are not familiar with Oracle built-ins, here is a description of
the two used in the query above.

DECODE is similar to a case statement in SQL Server. Its syntax is as
follows :

DECODE(, , , , ,...,
)

The is compared to each value. If there is a match,
the corresponding is returned. Otherwise, the value is
returned.

GREATEST returns the greatest value in the list of expressions.

GREATEST(, , ...)
Reply With Quote

Error Code = 0x8007000E, External Code = 0x00000000: Exception when deploying the SSAS

Hi
I am getting this error when deploying the Analysis Services Project.

Error Code = 0x8007000E, External Code = 0x00000000:

Can anyone Point me the reason for the same?

Thankyou
Vidya
Test your connection, if it's OK, delete your AS database and deploy it again.

Error Code = 0x8007000E, External Code = 0x00000000: Exception when deploying the SSAS

Hi
I am getting this error when deploying the Analysis Services Project.

Error Code = 0x8007000E, External Code = 0x00000000:

Can anyone Point me the reason for the same?

Thankyou
Vidya
Test your connection, if it's OK, delete your AS database and deploy it again.