Answer Questions

• creaturita Import export failed : Data conversion failed

  [Source - chn_employee_vew_test_txt [1]] Error: Data conversion failed. The data conversion for column "Column 42" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.". [Source - chn_employee_vew_test_txt [1]] Error: The "output column "Column 42" (136)" failed because truncation occurred, and the truncation row disposition on "output column "Column 42" (136)" specifies failure on truncation. A truncation error occurred on the specified object of the specified component. I using Locale (People's Republic of China) and code page of 936 (Simplied Chinese GBK) with header row delimiter {CR}{LF}. I am us ...Show All

• suseela Merge replication - changing values from filtered column

  Hi I'm working with merge replication between Sql Server 2005 and Sql Server 2005 Mobile. I'm using dynamic filtering by function HOST_NAME (... where Table.FilteredColumn = HOST_NAME()) When I'm trying to chagne values from filtered column on the client side (Table.FileteredColumn) I get error message that the column is read-only. How can I change data in filtered column Is this possible   Can you post the exact error message ALso, are you using download-only articles I solved this problem. This was my fault, because I used filter option: I row from this table will go to only one subscription. When I changed it to: I row from this table will go to multiple subsc ...Show All

• fiNAL.Y Help: JDBC 1.22 and SQL 2000

  HI, all I need to write a program, which using VM 1.1.8. So I need to find the JDBC driver version 1.22, Can anyone help me Please Reply, a link for download jdbc 1.22 or any other solutions . Thank you! You can take a look at the following links for Microsoft SQL Server 2005 JDBC Driver (recommended) http://msdn.microsoft.com/data/ref/jdbc/ http://www.microsoft.com/downloads/details.aspx FamilyId=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en For SQL Server 2000 Driver for JDBC Service Pack 1 http://www.microsoft.com/downloads/details.aspx FamilyID=4F8F2F01-1ED7-4C4D-8F7B-3D47969E66AE&displaylang=en ...Show All

• aero1 Problem printing reports

  Hello, When print reports in Reporting Services 2005, the default paper is "A4", but our reports have letter size, or even "A3" or "legal". Could we set a default paper for printing for each report thanks, Pablo Orte We solved it. It was a printer drivers problem. Our customers could print with the rigth paper in ther PCs. The size, margins, and textboxes/table size are correct, but the default paper when you click on "print" is "A4", when the report size is much bigger. In the layout tab of the report designer, right click on an area outside your report and selec ...Show All

• aliasx What is wrong with this connectionstring

  Dear readers, I have a .Net function witch gets data from a Cube. This function is called from a Report. when I preview my report from my computer it works fine. But when I deploy the report to the server on wich also the cube is processed I get the following error: Either the user, NL01\SRV03-GC-10$, does not have access to the Invoicing database, or the database does not exist. NL01\SRV03-GC-10$ is not a user in my system, so I'm stunned with this strange error. This is my connectionstring: string connstring = "PROVIDER=MSOLAP;DATA SOURCE=SRV03-GC-10;INITIAL CATALOG=Invoicing" ; I even replaced the servername( SRV03-GC-10 ) with localhost, but I stll get the same error. I would appriciate any reply on this. ...Show All

• VDimitris I am not able to connect to SqlServer 2005

  Hi All, I am trying to connect to SqlServer 2005 whihc is running on another machine. But it is giving error. ie. " An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) " this si my connection string information //SqlConnection cn = new SqlConnection("Server=id03;uid=sa;pwd=infokall;database=TestDB"); SqlConnection cn = new SqlConnection (conn); SqlCommand cmd = new SqlCommand (); string Value; string query = sqlInfo.SQL; ...Show All

• bagjuice Data type problem

  Greetings SSIS friends, I cast one of my fields from a decimal to an int in my data source (generated from a SQL command). But when I try and map that field to another one of my tables, i get an error saying that I can not cvonvert from decimal to Int32. Is there any solution which doest require using the derived column or data conversion components ! Your help would be appreciated. Did you previously have the decimal coming into the source and then later changed the SQL to cast it to an integer In the source column mappings, delete the row that corresponds to the column you are working with, and re-map it. Does that help Hi Phil, Yes you are right. I unmapped the column and then remaped it and reconfigur ...Show All

• crazyabtdotnet Delete question

  I recently uploaded my old MSAccess database structure/information to the SQLExpress 2005 database. I now need to clean out the data of each table so i can repopulate it with the program i am trying to debug. The problem i am encountering is the same no matter what i do. I think it is just some sort of typo when it comes to the statment, but i am so new to Server that i am not sure. Table: OwnerInfo - fully populated/created SQL Statment: Select * From OwnerInfo SQL Error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'OwnerInfo'. SQL Statment: Delete From OwnerInfo SQL Error: Msg 208, Level 16, State 1, Line 1 Invalid object name 'OwnerInfo'. Am i mistyping the table name or forgetting some sort of punctuation I have tried ( ), [ ...Show All

• gorbett List a city only once

  Hi...I want one listbox showing cities but I dont want to list a city more than one time.... I know that DISTINCT maybe could work...But I dont get it to work correctly.... The code: < asp : ListBox ID ="ListBox1" runat ="server" AutoPostBack ="True" DataSourceID ="DataSource1" DataTextField ="City" DataValueField ="City"></ asp : ListBox > < asp : SqlDataSource ID ="DataSource1" runat ="server" ConnectionString =" <%$ ConnectionStrings:ConnectionString %> " SelectCommand ="SELECT DISTINCT [City] FROM [Location]"> </ asp : SqlDataSource > I got the message: The text data type cannot be selected as DISTINCT because it is not comparable &nbs ...Show All

• okiebugmv Writing UDF for use in Analysis Services with .NET

  Hello, I am having a problem creating UDF Class Library with .NET (C#/VB.NET) I assumeing because I don't familiar with the class structure I should use. Can somebody refer me to an article or a guide or a code demonstration Thank you, Tal. In addition to these resources, there is a CodePlex project that few of us participate, where we implemented all kinds of functions as AS stored procedures. You can browse through them - all the source code is there. http://www.codeplex.com/ASStoredProcedures HTH, Mosha. Thank you very much for the replies. I will use the links you put. Tal. Good idea is to get a book descirbing how to create UDF assemblies. Besides there are quite a few source ...Show All

• Matt Stum File as parameter for SQL Remote Procedure Call (RPC)

  Hello, I need to download a few (~X000) rows of a table (containing millions of rows) from an SQL server (using visual studio ADO.NET), seleted based on the ID Column of table (i.e. SELECT * FROM myTable WHERE ID = @specified_parameter ) However, i don't want to call the corresponding RPC as many times as X000 times!! Is there any way i can create an RPC which would take some sort of a file (xml ) as @parameter, so that i can pass a list/file of specified ID's to the RPC, to be parsed on the SQL server and the corresponding RPC executed that way i would call the RPC once and i would receive the results once. Any help would be so very greatly appreciated. (the more detailed the trasact-SQL, the more appreciated also! ) ...Show All

• Aarkay Error installing SQL Server 2005 editions on Windows VISTA

  There are numerous posts regarding this error when installing SQL Server 2005 on Windows Vista RTM thus I am starting a new thread in order to get resolution one way or another: SQL Server Setup failed to execute a command for server configuration. The error was [SQL Native Client]Windows user or group "\USERNAME\SQLServer2005MSFTEUser$USERNAME$MSSQLSERVER" not found. Check the name again... The error occurs when installing SQL Server 2005 Developer Edition, SQL Server Express SP1, SQL Server Express SP2 CTR (with or without the SP2 Toolkit package installed beforehand). The error occurs with or without UAC. The installation then fails. Please advise if you have any insights. SQL Server Express SP2 CTR was announced as a workable v ...Show All

• giovannigiorgio Error in Scheduling SSIS Package

  Hi, When I am trying to schedule the SSIS package and start the job, I am getting the following error. It is not executing properly. "The job failed. The Job was invoked by User prakash.srinivasan. The last step to run was step 1 (TestSchStep1)." Pls provide some solution to this. Thanks in advance. Regards, Prakash Srinivasan. I had the same problem and replace the user for another one which was domain admin and works properly Change the username under which the Agent service runs. You can do this in the good old Services panel. -Jamie Prakash - have you reviewed the KB article referenced above It describes possible problems due to different protection lev ...Show All

• aragon127 URL image disappear after postback (sorting)

  On first rendering of the report, the URL image (she's into the report header, a logo) is ok i can see her. But when i use interactive sorting (arrow at the right of an header column into a table) the URL image disappear. I made "view source" on the report viewer page and i see <IMG SRC=""/>, so i lost the URL image on postback. I see in previous posts that the SP1 of SQL Server 2005 should resolve this problem but we have it installed and the problem stay. How can i fix or work around it Sorry for my english, it's not my first language ;) Thanks. Thanks. This is known issue and addressed a QFE after Yukon SP1. You should need to apply SP1 rollup build which includes all th QFE's iss ...Show All

• Thomas S. Andersen Document Map

  Problems with Document Map creating a side scroll to get to Up/Down Scroll for the Map itself. There are two scroll bars once you side scroll over in the map window. Anyone seen this or know how to fix Or Anyone know how to change any of the properties on the Document Map or map window Thanks!!!!! Can you try posting a screen shot of what you are describing seriously ! ! ! So no one knows how to change any configuration on the Document map or why it creates a side scroll and a seperate vertical scroll from the main report Hi, I wondered if you ever got a resolution on this. I have a similar pr ...Show All