Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







Invalid Character Value For Cast Specification


Dear All,

I am using the backend SQLServer with Powerbuilder, I write a stored procedure and tried to create a datawindow to use that procedure but failed, it returns error code 22005 -Invalid Character value for cast specification. I tried to change any setting in ODBC but still failed.

Is anyone can give help? Thanks in advance.

Terrence.


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
Invalid Character Value For Cast Specification
I get an ODBC error message from a program i use.
We have SQL Server 6.5 installed.
The error message is "Invalid character value for cast specification"
Does anyone have any idea?

//Johan

View Replies !   View Related
Invalid Character Value For Cast Specification
Hi All,

accessing through ODBC a frond end application which is running on MS SQL Server 2005, works just fine with a specific setup as concerned as the decimal/thousands separators ("," for thousands and "." for decimals). If i switch these settings alternatively ("." for thousands and "," for decimals), i get this error:
[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification.

I tried to search forum and internet but no luck.
Thanks in advance

View Replies !   View Related
Invalid Character Value For Cast Specification
I'm getteing an error saying "[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification" when i try to debug a store procedure.
The Store Procedure parameters are as below.
PROCEDURE clCreateUnpostedTrxEarnType
(
@SERIES int,
@PERIODID int,
@YEAR int,
@PTRATIO float,
@CPTYPE int,
@CPTRXTYPE int,
@Startdate datetime,
@Enddate datetime,
@O_iErrorState int = NULL output
)

I'm passing the values as below

3, 8, 2007, 3, 1, 3, '2007.08.01', '2007.08.31', Null

I tried passing '20070801', '20070831' & 2007.08.01, 2007.08.31 for date.

How should i fix this issue to debug the below issue?
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=83297


Thanks & Regards

Pradeep M V

View Replies !   View Related
Invalid Character Value For Cast Specification
hello,
i have a problem with SQL Server Agent. Sometimes, when a scheduled job runs i get this error:
 
 Error: 2008-03-13 06:04:50.50     Code: 0xC0202009     Source: Load Current OLE DB Destination [124]     Description: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.  An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Invalid character value for cast specification".  End Error  Error: 2008-03-13 06:04:50.52     Code: 0xC020901C     Source: Load Current OLE DB Destination [124]     Description: There was an error with input column "collectDate" (217) on input "OLE DB Destination Input" (137). The column status returned was: "Conversion failed because the data value overflowed the specified type.".  End Error  Error: 2008-03-13 06:04:50.52     Code: 0xC0209029     Source: Load Current OLE DB Destination [124] 
 
the code i use looks like this
 
DECLARE @Report_date datetime
SET @Report_date = dateadd(dd,-1,convert(varchar(10),getdate(),121))

select
 CollectDate = @Report_date

 
the destination column is datetime.
Is this a known issue / bug? Because this doesn't happen everytime, and when it does happen all i have to do ia run the job again.
 
 
Thank you in advance

View Replies !   View Related
Invalid Character Value For Cast Specification
 
I have a Data Flow task that is simply copying data from table A to table B. (there is a derived column in between however)
 
All the columns in table A are varchar(255). The columns in table B vary: floats, decimals, etc
 
However, I am getting a bazillion errors when I run this, each of them to the effect that:
 
 Error: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Invalid character value for cast specification". An OLE DB record is available.  Source: "Microsoft SQL Native Client" 
 
I don't understand why this is happening... I've succesfully run similar scenarios with other packages, ie) moving data from one table to another table even though the tables have different data types.
 
Help
 
Thanks
 
 

View Replies !   View Related
Invalid Character Value For Cast Specification: SQL Server 2000
Hi,I used SQL Server 2000 Personal Edition. I created a stored procedurehaving input parameters as smallint,tinyint,char,varchar andsmalldatetime. When I executed it by Query Analyzer, it's ok. But whenI executed it by ASP code that used ADODB.command, it showed error:Invalid character value for cast specification .Though SQL Server debugger, it showed:[Microsoft][ODBC SQL Server Driver]Invalid character value for castspecificationWhat did I do wrong? How do I fix this problem?TIAKrungPS: One of input parameters was smalldatetime, but I casting it in ASPas date as:Const adDate=7datetxt='2004/6/28'cmd.Parameters.Append cmd.CreateParameter("CoopId",adChar,adParamInput, 8, coopid)cmd.Parameters.Append cmd.CreateParameter("Addr",adVarChar,adParamInput, 100, addr)...cmd.Parameters.Append cmd.CreateParameter("Cdate",adDate,adParamInput, , datetxt)....cmd.execute

View Replies !   View Related
&"Invalid Character Value For Cast Specification&" From VC++ When I Execute A Proc
Hi Everybody,

I have a question regarding the running of a procedure from VC++ in SQL server.

well this is the scenario.

i have a procedure in SQL server and i am running that thru my VC++ code.
:eek:
i have a recordset class and i create an object of it and then do a obj.Open(). the procedure is fetching 24 records correctly in the query analyser and in my while(!(obj.IsEOF())) loop it gets the first record correctly but the moment it encounters obj.MoveNext(); it bombs and gives me the following error..

"Invalid Character value for cast specification ".

i don't know why this is happening

Thanks for you help.

View Replies !   View Related
Specific &&"invalid Character Value For Cast Specification Problem&&"
Hi, I'm a new DBA and am a rookie when it comes to working with SQL Server 2005.  I have been tasked with transfering an Access database to SQL Server 2005.  Now I understand to use the import/export wizard, but am having problems fixing an error I am receiving.  Here is the error...

 
Problem I
- Copying to [IS_Shared_ServicesTest].[dbo].[tblResource] (Error)
            Messages
            * Error 0xc0202009: Data Flow Task: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
            An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Invalid character value for cast specification".
             (SQL Server Import and Export Wizard)
           
            * Error 0xc020901c: Data Flow Task: There was an error with input column "Contract Start Date" (115) on input "Destination Input" (80). The column status returned was: "Conversion failed because the data value overflowed the specified type.".
             (SQL Server Import and Export Wizard)
           
Here is the short version of the error.  I realize that there is an error with the conversion and the error is in tblResource in column Contract Start Date.  It is still transfering the column over, and on spot check they seem fine.  Should I be really worried about an error?  Or is there something that I can do with the Access or SQL server database to fix this?
           
 

 

View Replies !   View Related
&&"Invalid Character Value For Cast Specification&&" Error Upon Importing Text File
Hi all--Given a table called "buyers" with the following column definitions in a SQL Server 2005 database:

 

[BUYER] [nvarchar](40) NULL,

[DIVISION] [nvarchar](3) NULL,

[MOD_DATE] [datetime] NULL

 

This table is laden with Unicode data and the MOD_DATE contains no data--not even NULL values, and is giving me a headache as a result.  I can export this data fine to a text file, but when I create an SSIS package to attempt import to another table defined exactly the same as above in another place, I get the following messages:

 

SSIS package "buyers_import.dtsx" starting.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x4004300A at Data Flow Task, DTS.Pipeline: Validation phase is beginning.
Information: 0x40043006 at Data Flow Task, DTS.Pipeline: Prepare for Execute phase is beginning.
Information: 0x40043007 at Data Flow Task, DTS.Pipeline: Pre-Execute phase is beginning.
Information: 0x402090DC at Data Flow Task, Source - buyers_txt [1]: The processing of file "D: emp3uyers.txt" has started.
Information: 0x4004300C at Data Flow Task, DTS.Pipeline: Execute phase is beginning.
Information: 0x402090DE at Data Flow Task, Source - buyers_txt [1]: The total number of data rows processed for file "D: emp3uyers.txt" is 232.
Error: 0xC0202009 at Data Flow Task, Destination - buyers_tst [22]: SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80004005  Description: "Invalid character value for cast specification".
Error: 0xC020901C at Data Flow Task, Destination - buyers_tst [22]: There was an error with input column "MOD_DATE" (45) on input "Destination Input" (35). The column status returned was: "The value could not be converted because of a potential loss of data.".
Error: 0xC0209029 at Data Flow Task, Destination - buyers_tst [22]: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "Destination Input" (35)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "Destination Input" (35)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047022 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Destination - buyers_tst" (22) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running.  There may be error messages posted before this with more information about the failure.
Error: 0xC0047021 at Data Flow Task, DTS.Pipeline: SSIS Error Code DTS_E_THREADFAILED.  Thread "WorkThread0" has exited with error code 0xC0209029.  There may be error messages posted before this with more information on why the thread has exited.
Information: 0x40043008 at Data Flow Task, DTS.Pipeline: Post Execute phase is beginning.
Information: 0x402090DD at Data Flow Task, Source - buyers_txt [1]: The processing of file "D: emp3uyers.txt" has ended.
Information: 0x402090DF at Data Flow Task, Destination - buyers_tst [22]: The final commit for the data insertion has started.
Information: 0x402090E0 at Data Flow Task, Destination - buyers_tst [22]: The final commit for the data insertion has ended.
Information: 0x40043009 at Data Flow Task, DTS.Pipeline: Cleanup phase is beginning.
Information: 0x4004300B at Data Flow Task, DTS.Pipeline: "component "Destination - buyers_tst" (22)" wrote 0 rows.
Task failed: Data Flow Task
SSIS package "buyers_import.dtsx" finished: Failure.


Among the customizations in this package is the flag "ValidateExternalMetadata" set to False.  The data itself is surrounded by " and delimited by semicolons for each field, with the header row set as the name of each column.  It looks like this:

 

"BUYER";"DIVISION";"MOD_DATE"
"108 Joon-Hyn Kim";"TAD";""
"109 Kang-Soo Do";"TAD";""
"FS07 John Smith";"TAD";""

...

 

Can anyone suggest a course of action on how to handle the error when the MOD_DATE field is completely empty?

 

Thanks in advance,

Jonathan

View Replies !   View Related
&&"Invalid Character Value For Cast Specification&&". &&"The Value Could Not Be Converted Because Of A Potential Loss Of Data.&&".
 

Why would I get these errors:
" SSIS Error Code DTS_E_OLEDBERROR.  An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available.  Source: "Microsoft SQL Native Client"  Hresult: 0x80040E21  Description: "Invalid character value for cast specification".
 
There was an error with input column "UniqueID" (3486) on input "OLE DB Command Input" (3438). The column status returned was: "The value could not be converted because of a potential loss of data.".

Error: 0xC0209029 : SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.  The "input "OLE DB Command Input" (3438)" failed because error code 0xC0209069 occurred, and the error row disposition on "input "OLE DB Command Input" (3438)" specifies failure on error. An error occurred on the specified object of the specified component.  There may be error messages posted before this with more information about the failure."

 
I read related posts but could not figure out the error?
 

View Replies !   View Related
ODBC Error 22018: Invalid Caharacter Value For Cast Specification
Hi,
 
I'm connecting to MS SQL server 2000 (version 8.00.2039) via odbc to copy one table to the other in my C++  program
 
The tables Table1 and Table2 have same definition i.e.,  name varchar(20), empid numeric

Through my program written in C++ I use odbc functions to connec to sql server and copy records form Table1 to Table2.
Into Table1 I inserted 20 records through SQL query analyzer.
To insert records that have been read from Table1 to Table2, I use the following odbc functions.
SQLBindaParam()
SLQExecute()
Once the table1 is copied to table2 I find that every 10th record has the data from previous record for the second field which is of numeric type.
 
At times the insert statement that's executed through sqlExecute to table2 gives the error:
[ODBC SQL Server Driver]Invalid character value for cast specification
 
Funny thing is if I change the data type for the second field to integer, the insertion is successful.

Also, instead of SQLBindParam if I use SQLBindParameter() the insertion is successful.

Please let me know what could be the problem.
 
System info:
 
Windows XP
SQL Server 2000 with SP4 
Odbc version 3.2
 
radhika.ganganna@oracle.com
 

View Replies !   View Related
BCP Error Invalid Character Value For Cast Specif
I'm usung bcp to move data from one table to another. 202 million rows. The source/original table had 32 fields. The new table has 33 fields. I added a PK column to the destination/new table. The new PK column is the first field in the new table, it is set to autoincrement by 1 on each insert. The data file only has 32 fields of data per row.


The error is :SQLState = 22018, NativeError = 0 Error = [Microsoft][SQL Native Client]Invalid character value for cast specification

10 times, then bcp shuts off (default errors is 10).

C:>bcp dbname.schema.TP_LOG_NEW in e:alltplog.dat -S
dbsvr -T -f tplognew.fmt

tplognew.fmt:
9.0
33
1 SQLCHAR 0 41 " " 1 TP_LOGID_PK ""
2 SQLCHAR 0 41 " " 2 TP_LOG_ID ""
3 SQLCHAR 0 20 " " 3 PROCESS_TYPE SQL_Latin1_General_CP1_CI_AS
4 SQLCHAR 0 20 " " 4 SEVERITY_CODE SQL_Latin1_General_CP1_CI_AS
5 SQLCHAR 0 41 " " 5 TP_ERROR_REF_ID ""
6 SQLCHAR 0 41 " " 6 TP_PARTNER_ID ""
7 SQLCHAR 0 41 " " 7 TP_CUSTOMER_ID ""
8 SQLCHAR 0 500 " " 8 DESCRIPTION SQL_Latin1_General_CP1_CI_AS
9 SQLCHAR 0 255 " " 9 PROCESS_REF_ID SQL_Latin1_General_CP1_CI_AS
10 SQLCHAR 0 255 " " 10 PROCESS_NAME SQL_Latin1_General_CP1_CI_AS
11 SQLCHAR 0 24 " " 11 PROCESS_ARGUMENT_1 ""
12 SQLCHAR 0 24 " " 12 PROCESS_ARGUMENT_2 ""
13 SQLCHAR 0 24 " " 13 PROCESS_ARGUMENT_3 ""
14 SQLCHAR 0 24 " " 14 PROCESS_ARGUMENT_4 ""
15 SQLCHAR 0 41 " " 15 PROCESS_ARGUMENT_5 ""
16 SQLCHAR 0 41 " " 16 PROCESS_ARGUMENT_6 ""
17 SQLCHAR 0 41 " " 17 PROCESS_ARGUMENT_7 ""
18 SQLCHAR 0 41 " " 18 PROCESS_ARGUMENT_8 ""
19 SQLCHAR 0 500 " " 19 PROCESS_ARGUMENT_9 SQL_Latin1_General_CP1_CI_AS
20 SQLCHAR 0 500 " " 20 PROCESS_ARGUMENT_10 SQL_Latin1_General_CP1_CI_AS
21 SQLCHAR 0 500 " " 21 PROCESS_ARGUMENT_11 SQL_Latin1_General_CP1_CI_AS
22 SQLCHAR 0 500 " " 22 PROCESS_ARGUMENT_12 SQL_Latin1_General_CP1_CI_AS
23 SQLCHAR 0 41 " " 23 USER1 ""
24 SQLCHAR 0 24 " " 24 USER2 ""
25 SQLCHAR 0 255 " " 25 USER3 SQL_Latin1_General_CP1_CI_AS
26 SQLCHAR 0 255 " " 26 USER4 SQL_Latin1_General_CP1_CI_AS
27 SQLCHAR 0 255 " " 27 USER5 SQL_Latin1_General_CP1_CI_AS
28 SQLCHAR 0 32 " " 28 CREATED_BY SQL_Latin1_General_CP1_CI_AS
29 SQLCHAR 0 24 " " 29 CREATED_DATE ""
30 SQLCHAR 0 32 " " 30 CREATED_PROCESS SQL_Latin1_General_CP1_CI_AS
31 SQLCHAR 0 32 " " 31 MODIFIED_BY SQL_Latin1_General_CP1_CI_AS
32 SQLCHAR 0 24 " " 32 MODIFIED_DATE ""
33 SQLCHAR 0 32 "
" 33 MODIFIED_PROCESS SQL_Latin1_General_CP1_CI_AS


New table definition:

CREATE TABLE [schema].[TP_LOG_NEW](
[TP_LOGID_PK] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[TP_LOG_ID] [numeric](18, 0) NOT NULL,
[PROCESS_TYPE] [varchar](20) NOT NULL DEFAULT (),
[SEVERITY_CODE] [varchar](20) NOT NULL DEFAULT ('0'),
[TP_ERROR_REF_ID] [numeric](18, 0) NOT NULL DEFAULT ((0)),
[TP_PARTNER_ID] [numeric](18, 0) NULL,
[TP_CUSTOMER_ID] [numeric](18, 0) NULL,
[DESCRIPTION] [varchar](500) NULL,
[PROCESS_REF_ID] [varchar](255) NULL,
[PROCESS_NAME] [varchar](255) NULL,
[PROCESS_ARGUMENT_1] [datetime] NULL,
[PROCESS_ARGUMENT_2] [datetime] NULL,
[PROCESS_ARGUMENT_3] [datetime] NULL,
[PROCESS_ARGUMENT_4] [datetime] NULL,
[PROCESS_ARGUMENT_5] [numeric](18, 0) NULL,
[PROCESS_ARGUMENT_6] [numeric](18, 0) NULL,
[PROCESS_ARGUMENT_7] [numeric](18, 0) NULL,
[PROCESS_ARGUMENT_8] [numeric](18, 0) NULL,
[PROCESS_ARGUMENT_9] [varchar](500) NULL,
[PROCESS_ARGUMENT_10] [varchar](500) NULL,
[PROCESS_ARGUMENT_11] [varchar](500) NULL,
[PROCESS_ARGUMENT_12] [varchar](500) NULL,
[USER1] [numeric](18, 0) NULL,
[USER2] [datetime] NULL,
[USER3] [varchar](255) NULL,
[USER4] [varchar](255) NULL,
[USER5] [varchar](255) NULL,
[CREATED_BY] [varchar](32) NULL,
[CREATED_DATE] [datetime] NULL,
[CREATED_PROCESS] [varchar](32) NULL,
[MODIFIED_BY] [varchar](32) NULL,
[MODIFIED_DATE] [datetime] NULL,
[MODIFIED_PROCESS] [varchar](32) NULL,
CONSTRAINT [PK_TP_LOG_NEW] PRIMARY KEY CLUSTERED
(
[TP_LOGID_PK] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

View Replies !   View Related
Error At Destination For Row Xx Data Overflow. Invalid Character Value For Cast Spec
I am receiving this error message when using DTS to import data from an Access db to SQL:

Error at Destination for Row number 18409. Errors encountered so far in this task: 1.
Insert error, column 1 ('Date'), DBTYPE_DBTIMESTAMP), status 6:
Data overflow.
Invalid Character value for cast specification.

I have deleted 10 rows before 18409 and 10 rows after 18409 and the error message when trying to import is always the same, same row number. The datatype in Access is Date/Time and in SQL Server it is datetime Length 8 allow nulls. I have tried changing Access datatype to Text and SQL to VarChar and still same error exact error message. I am not sure where to go from here. Any help / suggestions would be greatly appreciated!! Thanks!
Brian

View Replies !   View Related
Invalid Authorization Specification
Hi:
I'm trying to connect to a data base of "sql server 2005 enterprise" named BCR.The server name is "server1"I'm using Windows Authentication to connect to serverThe operating system is Windows Server 2003 Enterprise Edition Service Pack 1
When I run the aspx I get this error at line 21
System.Data.OleDb.OleDbException: Invalid authorization specification Invalid connection string attribute at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at ASP.pruebaLeeSqlServer_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in Z:DigitalpruebaLeeSqlServer.aspx:line 21
This is my code:
Dim str2 As String = "Provider=SQLNCLI; Server = server1; Database = BCR"Dim cnn2 As OleDbConnection = New OleDbConnection(str2)Dim cmd2 As New OleDbCommand()Dim drd2 As OleDbDataReaderTry cnn2.Open() cmd2.Connection = cnn2''''''''''''''''''''''''''''''''''''''''''''''''''''line 21 cmd2.CommandText ="SELECT LastName FROM Employees" drd2 = cmd2.ExecuteReader       Do While drd2.Read %>  <%=drd2.GetString(0)%><br> <% Loop drd2.Close()Catch exc1 As Exception %> <%=exc1.ToString()%> <%Finally cnn2.Close()      End Try
What could be wrong?Do I need enable permission for asp.net in sql server?how I can do it?
Thanks!!

View Replies !   View Related
Invalid Authorization Specification
Hi:

I'm trying to connect to a data base of "sql server 2005 enterprise" named BCR.
The server name is "server1"
I'm using Windows Authentication to connect to server
The operating system is Windows Server 2003 Enterprise Edition Service Pack 1

When I run the aspx I get this error at line 21

---------------------------------------------------------------
System.Data.OleDb.OleDbException: Invalid authorization specification Invalid connection string attribute at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() at ASP.pruebaLeeSqlServer_aspx.__Render__control1(HtmlTextWriter __output, Control parameterContainer) in Z:DigitalpruebaLeeSqlServer.aspx:line 21

---------------------------------------------------------------

This is my code:

------------------------------------------------------------------
Dim str2 As String = "Provider=SQLNCLI; Server = server1; Database = BCR"
Dim cnn2 As OleDbConnection = New OleDbConnection(str2)
Dim cmd2 As New OleDbCommand()
Dim drd2 As OleDbDataReader
Try
cnn2.Open()
cmd2.Connection = cnn2''''''''''''''''''''''''''''''''''''''''''''''''''''line 21
cmd2.CommandText ="SELECT LastName FROM Employees"
drd2 = cmd2.ExecuteReader
Do While drd2.Read
%>
<%=drd2.GetString(0)%><br>
<%
Loop
drd2.Close()
Catch exc1 As Exception
%>
<%=exc1.ToString()%>
<%
Finally
cnn2.Close()
End Try
------------------------------------------------------------------

What could be wrong?
Do I need enable permission for asp.net in sql server?
how I can do it?

Thanks!!

View Replies !   View Related
Invalid Authorization Specification
Hi,

We are testing our product on Windows Vista with SQL Server 2005 SP2 and are encountering an "invalid authorization specification". We make the connection through a Windows service using a standard ADO connection. I have tried changing the provider in the connection string to SQLNCLI without any success. The application is written in Delphi 5 and has worked on previous versions of Windows running SQL Server 2005.

Thanks.

Steven

View Replies !   View Related
ERROR 28000 Invalid Authorization Specification
a customer is getting on mS SQL 2000ERROR ODBC 28000 Invalid authorization specificationI dont understand because all the rigth are OKASP NET USER, IISS user and so on !i am trying to connect the to SQL from ASPX pages (it works for me and a few customers but not that one)what can be the problem ?thank you

View Replies !   View Related
'Invalid Authorization Specification' From IDBInitialize::Initialize (c++)
Hi

I've been trying to connect to my local SQL Server instance (SQL Server 2005) using the SQLNCLI interface from c++ without success. I consistently receive an 'Invalid authorization specification' error (SQL state 28000 and SQL error number 0) when I call IDBInitialize::Initialize to connect to the database. I was hoping someone here could shed some light on this and help me out.

The strange thing is that I get no error if I leave the user blank (L"" in vValue.bstrVal) and try to connect. Also, IDBProperties::SetProperties returns 0 when the user is blank but 40eda when the user is set. This seems to be a message from the pipeline facility but I haven't found the description of the code (0xeda).

The user in the database is configured with no password and I can successfully connect to the server and open the database using that user through Management Studio.

I've also tried using the SQLOLEDB provider with the same results.

Suspecting that I'm setting the properties wrong I include a code snippet below showing how I'm setting the properties:

    for (int i = 0; i < sizeof(dbprop) / sizeof(dbprop[0]); i++)
        VariantInit(&dbprop[ i ].vValue);

    // Server name
    dbprop[0].dwPropertyID = DBPROP_INIT_DATASOURCE;
    dbprop[0].vValue.vt = VT_BSTR;
    dbprop[0].vValue.bstrVal = SysAllocString(L"localhost");
    dbprop[0].dwOptions = DBPROPOPTIONS_REQUIRED;
    dbprop[0].colid = DB_NULLID;

    // Database
    dbprop[1].dwPropertyID = DBPROP_INIT_CATALOG;
    dbprop[1].vValue.vt = VT_BSTR;
    dbprop[1].vValue.bstrVal = SysAllocString(L"test");
    dbprop[1].dwOptions = DBPROPOPTIONS_REQUIRED;
    dbprop[1].colid = DB_NULLID;

    // Username
    dbprop[2].dwPropertyID = DBPROP_AUTH_INTEGRATED;
    dbprop[2].vValue.vt = VT_BSTR;
    dbprop[2].vValue.bstrVal = SysAllocString(L"jph");
    dbprop[2].dwOptions = DBPROPOPTIONS_REQUIRED;
    dbprop[2].colid = DB_NULLID;

Cheers,
JP

View Replies !   View Related
Invalid Authorization Specification Connecting To Sql Server 2000
I have a vb 6 program that has been running for several years against a 6.5 db. I convert the db to 2000, and now when I repoint the software to the 2000 db, I get "Invalid Authorization Specification" when I try to open the connection. The connection string is:Dim conn As ADODB.ConnectionSet conn = New ADODB.Connectionconn.Open "Provider=SQLOLEDB" & _            ";Data Source=" & sServer & _            ";Initial Catalog=" & sDB & _            ";User Id=" & goProcess.UserID & _            ";Password=" & goProcess.Password & ";"All of the variables are filled out correctly, when I go against a 6.5 it works, Sql Server 2000 doesn't.

View Replies !   View Related
[Microsoft][ODBC Text Driver] In The File Specification '...', The Col1 Option Is Invalid.
I'm trying to connect to a tab-delimited text file using the ODBC data access. I set it up using Administrative Tools - Data Sources (ODBC) from the start menu, and clicked the 'Guess' button under Define Format.

The schema it created looks like this:

[cims_output_data.txt]
ColNameHeader=True
Format=TabDelimited
MaxScanRows=0
CharacterSet=OEM
Col1=SIMNAME
Col2=TIMESTAMP
Col3=SIMTYPE
Col4=REGION
Col5=SECTOR
....etc.

It looks OK, but if I go back to Define in Administrative Tools and try to review it, I get a similar error message:

Ini File (or Registry) C:Program FilesCIMSschema.ini is corrupt.
Section: cims_output_data.txt, Key: Col1.

Has anyone seen this before? There is nothing on MSDN as far as I could find. I read on another forum that if you replace the label 'Col1' with 'Col' the problem is solved but it still reports that the schema is corrupt when I try to open it in Administrative Tools.

Bill.

View Replies !   View Related
Invalid Char Value Cast Spec Error
First, I hope this is in the correct spot.
 
I'm trying to build a SS 2005 db from a Sqlbase database and I have coded a program to bring over the data and insert. The problem I'm having is that on some of the tables, I'm getting an "Invalid character value for cast specification" error on an insert. I've found the offending row and discovered that it's an integer that is null in the source table.
 
The weirdness is, that in SqlServer, it is defined as an "int" column that can be null. I can insert the row through both Management console (connected natively) and through a sql utility from Sqlbase/Gupta (called sqltalk) connected thru ODBC. The problem is when I try the insert through OLEDB within the application, that's when I get the error. I changed the value from null to zero in the source table then it works. I think there must be a "set **** on" on the connection that I'm missing if I can enter the SAME data using Management console but I'm not sure what that is. I don't want to have to find ALL occurences of null integers in my entire database just to insert it into SqlServer.
 
Has anyone else had this problem??
 
 

View Replies !   View Related
Passing GUID Into Dtexec, Invalid Cast To A String Variable. Solution??
I am getting an invalid cast specification when I call dtexec and try to /SET a user variable within the package that is defined as a string data type. Is there any solution to this? I have tried passing the GUID with {} w/o {} w/ '' w/ "" etc.. many variations... and still get an invalid cast specification. Is there a data type that I need to set the User variable to besides String?  The User Variable is used to Select records from a SQL data source where the GUID is stored. I do not have an option of GUID data type for a User Variable.

Thanks for any help! Aaron B.

 

 

View Replies !   View Related
Invalid Character In A Report
Hi!

Trying to generate a report (using WebForm ReportViewer, from dynamically created RDL report and SQL Server 2005 OLAP cube), if a database field contains control characters (code < 0x20), Reporting Services generate following message:

' ', hexadecimal value 0x02, is an invalid character. Line 1, position 2376.

Is it possible to ignore that? I don't care if browser shows an octopus, the report must work.

Thanks, Andrei.

View Replies !   View Related
CLR Function - Invalid Character In The Given Encoding
Hello!

 

I wrote a CLR function, which is receiving some XML parameters. In certein situations it gives me the following error message:


Msg 6522, Level 16, State 1, Line 58
A .NET Framework error occurred during execution of user-defined routine or aggregate "svmScale":
System.Xml.XmlException: Invalid character in the given encoding. Line 1, position 27.
System.Xml.XmlException:
at System.Xml.XmlTextReaderImpl.Throw(Exception e)
at System.Xml.XmlTextReaderImpl.Throw(String res, String arg)
at System.Xml.XmlTextReaderImpl.InvalidCharRecovery(Int32& bytesCount, Int32& charsCount)
at System.Xml.XmlTextReaderImpl.GetChars(Int32 maxCharsCount)
at System.Xml.XmlTextReaderImpl.ReadData()
at System.Xml.XmlTextReaderImpl.ParseText(Int32& startPos, Int32& endPos, Int32& outOrChars)
at System.Xml.XmlTextReaderImpl.ParseText()
at System.Xml.XmlTextReaderImpl.ParseElementContent()
at System.Xml.XmlTextReaderImpl.Read()
at System.Xml.XmlTextReader.Read()
at System.Xml.XmlWriter.WriteNode(XmlReader reader, Boolean defattr)
at System.Data.SqlTypes.SqlXml.CreateMemoryStreamFromXmlReader(XmlReader reader)
at System.Data.SqlTypes.SqlXml..ctor(XmlReader value)
at UserDefinedFunctions.svmScale(SqlXml sql_problem, Boolean perChannel, Single x_factor, Single y_factor)

 

The call:

declare @data xml, @param xml

set @data = '<root>
  <d>
    <y>3.950000000000000e+002</y>
    <v>3.896900000000000e+004</v>
    <v>3.950000000000000e+002</v>
    <v>0.000000000000000e+000</v>
    <v>0.000000000000000e+000</v>
    <v>0.000000000000000e+000</v>
    <v>1.517142857142857e+001</v>
    <v>1.027035714285714e+003</v>
    <v>1.241071428571428e+000</v>
    <v>5.185714285714286e+000</v>
  </d></root>'


set @data = dbo.svmScale(@data, 1, 0.5, 0.5)


If I cahnage one of the zeros in the given tag, the error message disappears. If i cut the given tag, the error message disappears. If I cut the given tag, and then paste the previous one in place of it, the error message APPEARS. So my conclusion is, that any tag can be wrong on a specific position in the XML. This makes me wonder.

Another wonderfull thing is, that if I take this CLR function, and the same TSQL code, and I do run it on my notbook with my SQL Express, no error message. But if I try to use it on the server, with SQL 2005 it drops me this error message. The resulting XML is coming from an SELECT FOR XML AUTO, so i suspect it not having illegal characters inside. This is probably true, becouse the above replace procedure can make the message disapear.


The server:
Product: Microsoft SQL Server Enterprise Edition
Op System: Microsoft Windows NT 5.2 (3790)
Platform: NT INTEL X86
Version: 9.00.3027.00
Language: English (United States)
Memory: 4095 (MB)
Processors: 2
Collation: SQL_Latin1_General_CP1_CI_AS
Clustered: False


The notebook:
Product: Microsoft SQL Server Express Edition
Op System: Microsoft Windows NT 5.1 (2600)
Platform: NT INTEL X86
Version: 9.00.1399.06
Language: English (United States)
Memory: 1015 (MB)
Processors: 1
Collation: SQL_Latin1_General_CP1_CI_AS
Clustered: False

 

I would be very greatul for any suggestions.


Thanks


Arpad Varga

View Replies !   View Related
Invalid Non-ASCII Character Conversion Over JDBC
Hi,

I'm working on a database conversion from Sybase to SQL Server 2005 and have hit a wall with a character conversion problem when reading non-ASCII characters (encrypted password string) via JDBC.

My application runs on Solaris and accesses a SQL Server 2005 database via the Microsoft JDBC driver. The server was unfortunately specified as having a SQL_Latin1_General_CP1_CI_AS collation at installation time, and the database being accessed has taken this default. After creation the data was migrated across via DTS.

The invalid character is a dagger '†'. When read over JDBC it is converted to a question mark '?'.

In my original environment a Sybase database was accessed via JDBC driver from Solaris and the correct value was returned. The Sybase database used Latin1_General_BIN as it's collation. By way of experimentation I have modified the default collation sequence within the SQL Server 2005 database, and created a new table to hold the password. I am then able to correctly return strings containing this character from within SQL Server Management Studio, but the same problem still exists when accessing it via JDBC.

I am not sure where to focus my investigation and would be grateful for any useful pointers/advice. To me it looks like it's a JDBC driver issue as with the change in collation it works from a non-JDBC client.

Many thanks

Alistair

View Replies !   View Related
&"Invalid Authorization Specification&"
Hello,

I have a web application (ISAPI) that accesses a SQL Server 2000 (sp3) database in the same machine as the Web Server (IIS 6). Windows 2003 Standard Edition is the operating System. So, when users access the aplication through the web it runs ok until display the error message "Invalid authorization specification" or, sometimes, another message about failure to inform ODBC DSN, although I dont use ODBC.

When the error occurs, the user press F5 in the browser and the operation goes ok. It's an intermitent and curious error.

Can somebody help me?

Thanks in advance.


Adão.

View Replies !   View Related
Invalid Character In Flat File Or Turncate Problem
 

My source is a csv flat file.  Currently I use that same flat file on SQL 2000 and SQL 2005. 

On SQL 2000 it runs fine and it inserts that character as part of the string (varchar), however, it gives me truncate error on sql 2005.  I already use the "Suggest Types...." and my Output columns have the correct lenght (specially that lehght of that column is only 30 char which is less than the default anyways).  If I remove that character it runs fine for that column.....

This is the values that I get in my flat file for the trouble coulmn is "ATTN: JON OLSEN €€œ CTRL8       "

And the error that I get when running the SSIS is

[Flat File Source OrderDetail [1]] Error: Data conversion failed. The data conversion for column "Column 15" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

[Flat File Source OrderDetail [1]] Error: The "output column "ShipToAddr1" (63)" failed because truncation occurred, and the truncation row disposition on "output column "ShipToAddr1" (63)" specifies failure on truncation.
A truncation error occurred on the specified object of the specified component.

[Flat File Source OrderDetail [1]] Error: An error occurred while processing file "C:Inetpubftprootorderdetail.csv" on data row 6.

 

Any help greatly approciated.....

Thank you,

Maria

 

View Replies !   View Related
Remove Invalid Character From TXT File Value In Copy Column Transformation....!
In DTS/SSIS packages, How do to data validation or check for special characters and remove them at Copy column level.

thanks,

View Replies !   View Related
Invalid Non-ASCII Character Conversion Over JDBC To Solaris Client
Hi,

I'm working on a database conversion from Sybase to SQL Server 2005 and have hit a wall with a character conversion problem when reading non-ASCII characters (encrypted password) via JDBC.

My application runs on Solaris and accesses a SQL Server 2005 database via the Microsoft JDBC driver.  The server was unfortunately specified as having a SQL_Latin1_General_CP1_CI_AS collation at installation time, and the database being accessed has taken this default.  After creation the data was migrated across via DTS. 

The invalid character is a dagger '€ '.  When read over JDBC it is converted to a question mark '?'. 

In my original environment a Sybase database was accessed via JDBC driver from Solaris and the correct value was returned.  The Sybase database used Latin1_General_BIN as it's collation.  By way of experimentation I have modified the default collation sequence within the SQL Server 2005 database, and created a new table to hold the password.  I am then able to correctly return strings containing this character from within SQL Server Management Studio, but the same problem still exists when accessing it via JDBC.

I am not sure where to focus my investigation and would be grateful for any useful pointers/advice.  To me it looks like it's a JDBC driver issue as with the change in collation it works from a non-JDBC client.

Many thanks

Alistair

View Replies !   View Related
When Opening The Reports Site, I Get &&"A Name Was Started With An Invalid Character.&&" Error
Hello, I am running out of ideas on how to get SSRS to work.  I am trying get this setup with the intention to replace our Crystal Reports server.  Currently I have set up the RS Virtual Directory on a Win XP box.  The ReportServer database sits on another SQL2000 box. 

I can connect to the http://localhost/ReportServer/ on the XP box to display the page the depicts "Microsoft SQL Server Reporting Services Version 9.00.2047.00"  

When I connect to the http://localhost/Reports/, I get this error "A name was started with an invalid character. Error processing resource 'http://leej/Reports/'. Line 1, Position 2"   I checked my IIS Virtual Directory properties for Reports and ASP.NET is set to v2.0.50727.   I also executed "aspnet_regiis.exe -i" in the "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727" directory.  

Any thought on how to fix this?  I hate to let this blocker deters us from deploying SSRS.

Thanks,

John

View Replies !   View Related
Aspose License .Lic File Error &&"Invalid Character In A Base-64 String&&"
 

Hi,

   I am using ASPOSE License(3rd party licensing tool).

  Getting Error when using encrypted License file (*.lic) in my Application .

Error is .

 

"Invalid character in a Base-64 string "

 

What does it means ?????

 

But Demo License file *.lic is working fine.

 

Please provide solutions.

 

Reply is highly appreciated.

 

Rishi

 

 Error is
Invalid character in a Base-64 string.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.FormatException: Invalid character in a Base-64 string.

Source Error:





Line 59:
Line 60: //license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v7GAA==", licenceFile);
Line 61: license = new Licensing("Ghezt4vbwif7r9cf7ra2ttbKzv76+v==", licenceFile);
Line 62:
Line 63:
Source File: c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs    Line: 61

Stack Trace:





[FormatException: Invalid character in a Base-64 string.]
System.Convert.FromBase64String(String s) +0
Aspose.License.Licensing.M0(String key, String encryptedString) +627
Aspose.License.Licensing.A0() +753
Aspose.License.Licensing..ctor(String key, String licenseFile) +72
Demo.Initialize() in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:61
Demo..ctor(String licenseFolder, Page page) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseApp_CodeDemo.cs:37
_Default.Page_Load(Object sender, EventArgs e) in c:Documents and SettingsAdministratorMy DocumentsVisual Studio 2005WebSitesTestLicenseDefault.aspx.cs:18
System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +31
System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +68
System.Web.UI.Control.OnLoad(EventArgs e) +88
System.Web.UI.Control.LoadRecursive() +74
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3035


 

View Replies !   View Related
Select Part Of Character String Based On A Character
I have data in a column that starts with 1-4 characters followed by a dash then followed by an number of characters (ex: EU-Surgery).

How do I select everything to the right of the dash when the number of characters to the left of the dash varies?

View Replies !   View Related
XML Parsing: Line 26, Character 5, Illegal Xml Character
 

I have a Table with 5 million rows and a column that is "Text" and some of the column lengths are 690,000 characters. Most of the data in this one column is XML data and it is taking a long time to find and replace values in the XML nodes.  In another post it was recommended that we just change the column to XML and then do an update to the values.
 
When I try this in a test environment with a small sample of data it works fine and I change it from Text to XML, update the values, and then change it to VARCHAR(MAX) and then back to Text (to avoid having to mess with code releases, etc.)
 
In a production environment the switch from Text to XML fails after 14 hours saying that "XML parsing: line 26, character 5, illegal xml character" which I have to assume that there is data in at least one of the rows that is not a valid XML character.
 
I think I read that when changing the column type to XML it has to go through all of the rows and validate that there is valid XML in the column.
 
Is there a way to turn this validation off?  (like NOCHECK or something)
Is there an easy way to search through these column values for the illegal characters?
Does anyone know which specific characters are illegal?
 
Keep in mind that this is a very wide column in a big table where just this one table makes up about 400GB or more of this DB size.
 
Cursoring through the rows and leaving the column as text, the script below takes 3 seconds per row to grab the data for 1 row, convert it to xml, replace 7 of the values and then convert it back.  (I tried a "while loop" with no performace gain as well)
 
3 seconds times 5 million rows would take about 600 hours in a production environment where I would probably not be able to run this during the day.
 
ANY help would be much appreciated!!!
 


  Select @snapShot = CONVERT(xml, SnapshotText) from Audit_ProductInstances where Audit_ProductInstanceID = @AuditProdID

  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[LogoLarge]"]/Value/text())[1]
        with ""')
  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[LogoExtraSmall]"]/Value/text())[1]
        with ""')
  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[LogoMedium]"]/Value/text())[1]
        with ""')
  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[LogoMediumLarge]"]/Value/text())[1]
        with ""')
  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[LogoSmall]"]/Value/text())[1]
        with ""')
  Set @snapShot.modify('replace value of (/WorksheetData/MergeFields/MergeFieldBase[Name="[Seal]"]/Value/text())[1]
        with ""')
  Update Audit_ProductInstances set SnapShotText = Convert(varchar(max), @snapShot), FixedFlag = 1, SQLUser = 'FixedSnapshot'
  where Audit_ProductInstanceID = @AuditProdID
 

Thanks,
Brian

View Replies !   View Related
SQLDescribeParam With Subselect: Invalid Parameter Number/Invalid Descriptor Index
Hello,

I've got the following query:

SELECT zA."ID" AS fA_A
, zA."TEXT" AS fA_B
, (
  SELECT COUNT(zC."ID")
  FROM Test."Booking" AS zC
  ) AS fA_E
FROM  Test."Stack" AS zA
WHERE zA."ID" = ?

With this query I call:
- SQLPrepare -> SQL_SUCCESS=0
- SQLNumParams -> SQL_SUCCESS=0, pcpar = 1
- SQLDescribeParam( 1 ) -> SQL_ERROR=-1, [Microsoft][ODBC SQL Server Driver]Invalid parameter number", "[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index"

Is there a problem with this calling sequence or this query? Or is this a problem of SQL Server?

Regards
Markus

View Replies !   View Related
Read Chinese Character From SQL(SQL Server 2005) Database Table Column And Display Chinese Character
Hi!

I have a table like this below and it doesn't only contain English Names but it also contain Chinese Name.
CREATE TABLE Names
(FirstName NVARCHAR (50),
 LastName NVARCHAR (50));
I tried to view the column using SQL Query Analyzer, It didn't display Chinese Character.
I know that SQL Server 2005 is using  UCS-2 Encoding and Chinese Character uses Double Byte Character Set (DBCS) Encoding.
I want to read the FirstName and LastName columns and display in Window Form Data Grid and ASP.NET Grid View.
I tried to use this code below and it didn't work. It convert some of the English Name to Chinese Character and it display the chinese character and some still in the original unreadable characters.
Does anybody know how to read those character from SQL Table and display the correct Chinese Character without converting the English Name into Chinese also?
Thanks
       
        int codePage =  950;
        StringBuilder message = new StringBuilder();
        Encoding targetEncoding = Encoding.GetEncoding(codePage);
        byte[] encodedChars= targetEncoding.GetBytes(str);
        .
        message.AppendLine("Byte representation of '" + str + "' in Code Page '" + codePage + "':");
        for (int i = 0; i < encodedChars.Length; i++)
        {
            message.Append("Byte " + i + ": " + encodedChars);
        }
      
        message.AppendLine(" RESULT : " + System.Text.Encoding.Unicode.GetString(encodedChars));
        Console.Writeline(message.ToString());

View Replies !   View Related
Identity Specification
I am not very clear about the use of 'identity specification properties'. There does not seem to be a great use of identity increments and seeds, it seems something that saves manual work, but to a very little extent
Anyone willing to shed some light?

View Replies !   View Related
Identity Specification
Hi,
How do I determine what the next "id" will be in a collumn where the Identity Specification is turned on with Identity Increment?
I have two tables, the one contains product information and the other is a photo album. When I create a new product, then I automatically create an associated photo album. It all works fine, but I have found some problems after using this setup for a while to manage products.
For example, say I have created 10 products (id's 1 to 10) , and then I decide to remove the last 5 products from the list. The next time I add a new product, it will be product number 6, but the id will be 11 (seeing that the id's will always be unique). How do I determine what the next Identity value will be seeing that the actual last id might not be the last one that was allocated?
RegardsJan

View Replies !   View Related
Port Specification
Hi,I need to specify sql server 2005 express TCP connection port duringinstallation. Is it possible?Thanks for answer.

View Replies !   View Related
BCP Native Specification
Anyone have the specification for the output of BCP in native? I would like to generate a BCP-able file from a C++ service. I don't want to put the data in a database and then BCP. I want to create files that are equivalent to the output of a BCP comment that I can then use BCP to input to a database (SQL 6.5 or 7.0 in the future).

From binary dumps of the data it looks pretty simple, what is missing is a description of what a 'datetime' is (8 bytes of what?) and what terminators between rows and at the end of a rowset.

???

/harry

View Replies !   View Related
SQL3 Specification........
I want to know whether SQLServer -7 supports SQL3 Specification so that I can

use structured data types.Thanks in advance.

View Replies !   View Related
New Server Specification
I am building a Data Warehouse for a Steel Manufacturing company. 
 
They have SAP environment but they want to build Data Warehouse with MS SQL BI stack.
 
I will have to pull approximately 70000 records into Data Warehouse every month from SAP.
 
 I have to generate reports from SSRS.  
 
I have configure a Dell server but need a second opinion, if I am missing something some items 
 






Item Description 

Quad Core Xeon Processor E53452x4MB Cache, 2.33GHz, 1333MHz FSB, PE2900 

Information,No Second Processor 

8GB 667MHz (8x1GB), Dual Ranked DIMMs 

Keyboard, USB, Black 

Broadcom TCP/IP Offload EngineNot Enabled 

146GB 10K RPM Serial-Attach SCSI 3Gbps 3.5-in HotPlug HardDrive 

PERC 5/i, Integrated Controller Card 

No Floppy Drive 

Windows Server 2003 R2 Enterprise Edition with SP2 Includes 25 CALs 

Mechanical Two-Button Mouse USB, Black 

Embedded Broadcom NetXtreme II5708 GigabitEthernet NIC 

48X IDE CD-RW/DVD ROM Drive for PowerEdge 2900 

Tower Bezel Included 

Electronic Documentation and OpenManage CD Kit, PE2900 

146GB 10K RPM Serial-Attach SCSI 3Gbps 3.5-in HotPlug HardDrive 

Integrated SAS/SATA RAID 1 PERC 5/i Integrated 

Tower Chassis Orientation 

Redundant Power Supply with Y-Cord for PowerEdge 2900 

UPS,1500,Stand Alone,120 Volt

View Replies !   View Related
Computed Column Specification
Hello,I want to assign a column a computed value, which is the multiplicationof a value from the table within and a value from another table.How can I do that?Say the current table is A, column1; and the other table is B, column3.What should I write as formula?I tried someting like;column1 * (SELECT column3 FROM B WHERE A.ID = B.ID)but it didn't work.

View Replies !   View Related
Datasource Specification In MS Excel
Hello,

I am new to database programming & I would like to know if there is some place I can specify ( in MS Excel ) as to where the data should be picked from i.e. where do I specify the "datasource" value??

Also, is there anyway I can find out all the SQL queries that have been used in an Excel spreadsheet??

Thanks & Regards,
Ashok

View Replies !   View Related
Clarification On Product Specification
http://www.microsoft.com/sql/editions/compact/sscecomparison.mspx
The above link says the pros and cons of two SQL Server 2005 editions.
Document says Compact Edition is not good for €˜When you need a multi-user database server
€™.
What is the meaning of multi-user database?
Does this means the database strictly will not support two database connections at a time?
-Thank you,
Gish
 

View Replies !   View Related
Identity Specification Limit
what happens when a column marked as Identity Specification reaches the limit? for example, I have some code tables using tinyints as keys, the actual number of entries will be 20 or so but there is some volatility, so eventually the 255 limit will be reached, what happens then?

the same thing applies to ints or bigints used as keys, eventually the database must run out of numbers

information will be appreciated

David Wilson.

View Replies !   View Related
If Statement In Computed Column Specification
I want to use an if statement to compute the value of a column in SQL Database using other columns. I am supposed to check if a column is null or not and do the computations accordingly. Can anyone help?
 

View Replies !   View Related
Connection String - Does Not Conform To The OLE DB Specification
I'm trying to build a connection string to SQL Server 7.0 from ASP.net w/ C#

I get the following error:
Format of the initialization string does not conform to the OLE DB specification. Starting around char[100] in the connection string.


What the heck does this mean? What am I doing wrong.. My connection string is below:

string strConnection = "Provider='Provider=SQLOLEDB; server=XXXXXX.XXXXXXXXXXXXX.COM;'UID=XXXXXX;PWD=XXXXXXX;DATABASE=XXXXXX'";


Is there a way to make good connection strings like a tool or something?

Thanks for your time.
thunk

View Replies !   View Related
Server Specification Advice Needed...
Hi All,I need a little help with some specs. for a new server (we are a small company, so the budget is a bit tight). Specifically whether we should consider a 64bit platform instead of playing safe with 32bit.The role of the server will be as an Application Server running SQL Server 2005 on Windows Server 2003, and hosting ASP.NET 2 web applications.We are considering a Dell PowerEdge 2850 with an Intel Xeon processor, 4GB RAM, 400GB Raid 10 storage.We will have 4 developers using Visual Studio 2005 running on our current Windows XP P4 desktop machines.The developers will also need to retain the ability to maintain existing systems running on SQL Server 2000 on a 32bit Windows Server 2003 SBS box.Also, the new server will be for our live systems. Our Development and Test servers will be implemented using a couple of old 32bit boxes gathering dust in our server room. They will be running 32bit Windows Server 2003 and SQL Server 2005.Question 1:If we are developing, testing and compiling .NET applications on a 32bit development machine, will the product work ok when hosted on a 64bit server? or are we better off sticking to a 32bit server.Question 2:If we do go with a 64bit server with the 64bit versions of Windows Server 2003, and SQL Server 2005, would we experience problems with copying databases between the server's 64bit SQL Server 2005 and 32bit SQL Server 2005 installations on the developer's PCs and Dev/Test servers?Thanks

View Replies !   View Related
Tabbed Data Stream Specification
I was wondering if anyone has the specs for the TDS protocol (4.2, 7)
Any help would be appreciated.

Thanks, Phil

View Replies !   View Related
Inserting Data Into A Row With An Identity Specification
 
I am trying to build a Windows application using: Windows XP Pro ; VS Pro 2005, C#  and SQL2005.
 
I have a database table as follows:
eg
1) myGameRecency which contains columns : GameId  (identity specification column/primary key/not null), Date (not null), [1], [2], [3], [4]
 
Using the myGameRecencyAllBalls table ---
 
I wish to insert a date into a new row but have not been able to determine how to with the identity specification on the GameId column.
 
Can anyone please assist?
Thank you.
lpbcorp

 

sqlCmd.CommandText = "DECLARE @date datetime SET @date = '" + Date +

"DECLARE @lastRowGameId int " +

"DECLARE lastrow_gameidcursor CURSOR SCROLL FOR " +

"(SELECT GameId FROM " + DBGameName.ToString() + "RecencyAllBalls) " +

"OPEN lastrow_cursor " +

"FETCH LAST FROM lastrow_gameidcursor INTO @lastRowGameId " +

"' INSERT INTO " + DBGameName.ToString() + "RecencyAllBalls.Date VALUES (@date) WHERE GameId = @lastrow_gameidcursor + 1";

sqlCmd.ExecuteScalar();

View Replies !   View Related

Copyright © 2005-08 www.BigResource.com, All rights reserved