Empty Field From Web Service
All of our RS report have web service datasources. If the first row from the datasource is empty, that is:
<Legacy />
Then I, get the following error and the column is not handled by the report:
[rsMissingFieldInDataSet] The data set €˜Journal€™ contains a definition for the Field €˜Legacy€™. This field is missing from the returned result set from the data source.
[rsErrorReadingDataSetField] The data set €˜Journal€™ contains a definition for the Field €˜Legacy€™. The data extension returned an error during reading the field. There is no data for the field at position 20.
Any suggestion to get around this?
Phil
View Complete Forum Thread with Replies
Sponsored Links:
Related Messages:
Empty Field
I have a comment field with data or no data. The problem is when I transfer the data into AS400 if field is empty it translates to end of record, however in reality it is not. How do I fix this issue?
View Replies !
View Related
Empty Field Query
Hi Friends, I have one query that i have to Replace the Empty Value of a filed with some other value how can i do in SQL?? ID Phone Name 1 122 abc 2 xyz 3 444 mmm 4 525 ccc 5 nvb Now i want replace the blank (Empty) filed with some charaters Numbers how can i do that?? any Help Ashu
View Replies !
View Related
Checking If A Field Is Empty
i want to check if one of the fields is empty. however i cant seem to get it working string strSQL = "select * from 15Course_Listing where Package_listingNo =''"; it does not return anything, however i have empty fields in package_listingNo i have been trying to get around this for some time and its killing me. need help please
View Replies !
View Related
Web Service Dataset With Null Or Empty Spaces.
HI, I am using XmlDataDocuments returned by webservices and query in the reports to populate the reports. The issue I have is if the dataset used to populate the XML document has any nulls or empty spaces in any field the whole column or row is missing in the data generated by my query in the Reports. Sometimes the whole data is not being returned to the reports. Sample query I use <Query> <SoapAction>http://xxxx.webservices.org/SelectReportRegisters</SoapAction> <Method Namespace="http://xxxx.webservices.org/" Name="SelectReportRegisters"> <Parameters> <Parameter Name="p_registerType"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_registerName"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_asOfDate"> <DefaultValue>7-1-2009</DefaultValue> </Parameter> </Parameters> </Method> </Query> I have tested the webservice with sample data and it works well, returns data. I use the ISNULL() in my stored procedures to avoid nulls but with empty strings, replacing them with a default value in the managed code is expensive and slows down the reports. Is there some feature I am missing because of which nulls and empty strings are causing this problem. I am using Reporting services 2005. Any pointers will be truly appreciated.
View Replies !
View Related
Web Service Dataset With Null Or Empty Spaces.
HI, I am using XmlDataDocuments returned by webservices and query in the reports to populate the reports. The issue I have is if the dataset used to populate the XML document has any nulls or empty spaces in any field the whole column or row is missing in the data generated by my query in the Reports. Sometimes the whole data is not being returned to the reports. Sample query I use <Query> <SoapAction>http://xxxx.webservices.org/SelectReportRegisters</SoapAction> <Method Namespace="http://xxxx.webservices.org/" Name="SelectReportRegisters"> <Parameters> <Parameter Name="p_registerType"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_registerName"> <DefaultValue>All</DefaultValue> </Parameter> <Parameter Name="p_asOfDate"> <DefaultValue>7-1-2009</DefaultValue> </Parameter> </Parameters> </Method> </Query> I have tested the webservice with sample data and it works well, returns data. I use the ISNULL() in my stored procedures to avoid nulls but with empty strings, replacing them with a default value in the managed code is expensive and slows down the reports. Is there some feature I am missing because of which nulls and empty strings are causing this problem. I am using Reporting services 2005. Any pointers will be truly appreciated.
View Replies !
View Related
Required Field Empty - How Could This Happen?
Hello! I have a web form in VB.NET & ASP.NET 1.1, with data being saved to a SQL 2005 database with multiple tables. The primary key on all these tables is a unique identifying number that the user enters. However, one record in this database (across all tables) has no identifier. All other information seems to have saved without problem, but there's no identifier, which is very wierd for several reasons: 1) the form should not allow the user to proceed without it; 2) all the tables in the database do not allow nulls for the column, and 3) it's the primary key! Any thoughts on how this might have happened? Thanks! Kaiti
View Replies !
View Related
How To Update An Empty Date-type Field
Hi, I have update function that updating sql database table. In the table I have fields like: name, address, phone, …, install_date updateScreen(txtSName.text, txtSLocation.text, txtSPhone.text, txtSAddress.text, txtSPostal.text, ddSCity.SelectedItem.text, ddSCountry.SelectedItem.text, txtSOwner.text, txtSInstall.text ) The function work fine except the part whent install_date field is empty then I have the following message: System.InvalidCastException: Conversion from string "" to type 'Date' is not valid. Ii would like to use the same update function to make an updates even when date field is empty. If someone has any idea how make it work, I would appreciate that Alex
View Replies !
View Related
SQL - Updating Empty Text Field Is Enterring -1
I'm trying to do a simple update like I have done countless timesbefore.However, when I update the empty fields in this table it places a -1into the field rather than the enterred value.It is indexed with duplicates allowed. It says that zero lenght isset to yes.What can I do about this?if Request.form("ouserid") <> "" Thenvar2 = " and userid = '" & Request.form("ouserid") & "' "Elsevar2 = " and userid is null "End ifif Request.form("orepid") <> "" Thenvar1 = " repid = '" & Request.form("orepid") & "'"Elsevar1 = " repid is null "End if"Update [Website Settings] set userid = '" & REquest.form("userid") &"' and repid = '" & Request.form("repid") & "' where " & var1 & var2& var3Thanks!
View Replies !
View Related
CeWriteRecordProps Failling With A Empty FILETIME Field..
Hi All, Does anyone have already made an application that writes some data into the EDB Pocket database ? I´m trying to insert a record with a empty FILETIME field and I´m getting the Error 87 (INVALID_PARAMETER), I´ve tested with some date in the field and the record is added sucessfull, it seems that the database doesn´t accept anymore empty FILETIME fields? Is it true? I didn't find anything in the docs.thanx in advance.
View Replies !
View Related
How To Pass Null Value To The Database If A Form Field Is Empty?
How can I pass into the database (@User_fax = null) if the fax form field is empty, from a command type Stored Procedure? For example: Dim CmdUpdate As New SqlCommand("Form2_NewUser", strConnection) CmdUpdate.CommandType = CommandType.StoredProcedure CmdUpdate.Parameters.Add("@User_fax", SqlDbType.char, 9) CmdUpdate.Parameters("@User_fax").Value = fax.Text() ... strConnection.open() CmdUpdate.ExecuteNonQuery strConnection.close() And, the stored procedure inside Sql server: USE market1 GO ALTER PROC Form2_NewUser @User_id bigint, @User_fax char(9),... AS SET NOCOUNT ON UPDATE Users SET User_fax = @User_fax, ... WHERE User_id = @User_id SET NOCOUNT OFF GO Thank you, Cesar
View Replies !
View Related
Possible To Create An OPTIONAL Multi-value Field That Can Be Left Empty?
Greetings, I have several reports for which the user has asked to have an optional muti-value parameter. They want to be able to select zero, one, many, or all values in the parameter list. The parm list is created through a query and the values are not static. I would like to allow the user to leave the muti-value field empty if they want to allow all values to appear on the report. I've read some discussion about populating a multi-value default with the same query that produces the multi-value list values - presto, everything is selected. However, this is not a desirable solution for me because I "echo" the users parameter selections in the report heading. Selecting all values (and some parms have a lot of values) would cause the "parm feedback" section to grow large and unreadable. In short, I don't want to tell the user they have to select everything when they really want to select nothing. Is there any way to have a muti-value parm that won't insist the user select one or more values? Thanks, BCB
View Replies !
View Related
Field Names Missing In MDX Data Set When Using NON EMPTY Clause
So I have an MDX query in an SSRS data set. Here is my MDX query: Code SnippetSELECT { [Measures].[Gross Sales Amount USD], [Measures].[Net Sales Amount USD] } ON COLUMNS, { ([Promotion].[Media Property].[Promo Code Description].ALLMEMBERS) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@BeginDateConvert, CONSTRAINED) : STRTOMEMBER(@EndDateConvert, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PromotionMediaProperty, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Promotion].[Campaigns].[Campaign].&[Paid Partner] } ) ON COLUMNS FROM ( SELECT ( { [Products].[Product Line].[Line].&[Merchandise] } ) ON COLUMNS FROM ( SELECT ( { [BusinessUnit].[Business Unit].[Product Business Unit].&[40] } ) ON COLUMNS FROM [Net Sales]))))) WHERE ( [BusinessUnit].[Business Unit].[Product Business Unit].&[40], [Products].[Product Line].[Line].&[Merchandise], [Promotion].[Campaigns].[Campaign].&[Paid Partner] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS This query returns 4 fields. Media Property, Promo Code Description, Gross Sales, and Net Sales. For the given query the measures are empty or null. I do not want any data to show up when the measures are null so I put in NON EMPTY clauses before the COLUMNS and before the ROWS. So now my query looks like this: (I only added the NON EMPTY clauses) Code Snippet SELECT NON EMPTY { [Measures].[Gross Sales Amount USD], [Measures].[Net Sales Amount USD] } ON COLUMNS, NON EMPTY{ ([Promotion].[Media Property].[Promo Code Description].ALLMEMBERS) } DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ( SELECT ( STRTOMEMBER(@BeginDateConvert, CONSTRAINED) : STRTOMEMBER(@EndDateConvert, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@PromotionMediaProperty, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( { [Promotion].[Campaigns].[Campaign].&[Paid Partner] } ) ON COLUMNS FROM ( SELECT ( { [Products].[Product Line].[Line].&[Merchandise] } ) ON COLUMNS FROM ( SELECT ( { [BusinessUnit].[Business Unit].[Product Business Unit].&[40] } ) ON COLUMNS FROM [Net Sales]))))) WHERE ( [BusinessUnit].[Business Unit].[Product Business Unit].&[40], [Products].[Product Line].[Line].&[Merchandise], [Promotion].[Campaigns].[Campaign].&[Paid Partner] ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS Adding the NON EMPTY returns nothing... not even field names. This is a problem because, I have a table in the report that looks at this data set and when there are no fields, the report can't run. How can I still have NON EMPTY functionality and still show the fields? Is this a problem in SSRS?
View Replies !
View Related
Anyway To Check If A Text Field Is Blank (not Null But Just A Empty String '') ?
i have a trigger on a table right now... when fields are inserted, theres a text field inserted and i want to check if that text field = '' (the empty string, not NULL) and if it doesn't equal that, then perform some row updates on other tables, but if it is empty, to not do anything else in the trigger... right now i have this: IF ((SELECT Note FROM XATPoDetail WHERE ReqNbr = (SELECT ReqNbr FROM Inserted)) LIKE('')) Note is the text field, XATPoDetail is the table where its being inserted into. I had to do the select FROM the table because it wouldn't let me select a text data type from the "Inserted" virtual table but it tells me me "Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression" thanks
View Replies !
View Related
Anyway To Check If A Text Field Is Blank (not Null But Just A Empty String '') ?
i have a trigger on a table right now... when fields are inserted, theres a text field inserted and i want to check if that text field = '' (the empty string, not NULL) and if it doesn't equal that, then perform some row updates on other tables, but if it is empty, to not do anything else in the trigger... right now i have this: Code: IF ((SELECT Note FROM XATPoDetail WHERE ReqNbr = (SELECT ReqNbr FROM Inserted)) LIKE('')) Note is the text field, XATPoDetail is the table where its being inserted into. I had to do the select FROM the table because it wouldn't let me select a text data type from the "Inserted" virtual table but it tells me me "Error 279: The text, ntext, and image data types are invalid in this subquery or aggregate expression" thanks
View Replies !
View Related
What Is The Difference Between Updating Null Value Vs Empty String To Varchar/char Field?
Hi, What is the difference updating a null value to char/varchar type column versus empty string to char/varchar type column?Which is the best to do and why? Could anyone explain about this? Example: Table 1 : tCountry - Name varchar(80) nullable Table 2 :tState - Name char(2) nullable Table 3 :tCountryDetails - countryid,state (char(2) nullable) - May the country contain state or no state So,when the state is not present for the country ,i have two options may be - null,'' tCountryDetails.State = '' or tCountryDetails.State = null?
View Replies !
View Related
Concatination Of Empty Field And Removal Of &&"&&" Symbols
Hello... I am going crazy trying to figure out how to do this. I have a flat file which I am massaging the data and loading into a table here is an example of a line out of the flat file: "ABC NUTRITIONAL PRODUCTS","550","","","N","FAIR OAKS","","","COLORADO SPRINGS","C0","","","","","","","","A","","","" My problem is that I have one field which is this address in a concatinated form. The fields that do not apply to this entry are suite#, floor# and other columns which are designated by the "" characters. The final concatinated addres field looks like this: "550""""N""FAIR OAKS""" I would like to remove the "" characters in the concatinated string. I just don't know the best way to do this? I was told DTS had a way of removing the "" from the flat file source. Since I have not used DTS extensively I am not sure if this is true. I was wondering how in SSIS I could go about removing the "" marks without removing the "" say if someone is quoted eg. John said "This is only a test". Removing the quotation marks in this instance would be changing the data. I am not sure how to do this and any help or advice is greatly appreciated! Thank you...
View Replies !
View Related
Format Decimal Field In Reporting Service
Hi All, In the crystall report, it has format option to use ( ) instead of - . It means if the number is negative , then display like (1998) . i just wonder does this feasture availabe in reporting service. Otherwise i have to write IIF function in each field expression area. Thanks Nick
View Replies !
View Related
What Permissions Are Required For SQL Server Service Account To Call Web Service Using CLR Integration?
Hello! I have the following problem. I developed CLR Stored Procedure "StartNotification" and deploy it on db. This sp calls external web service. Furthermore, this sp is called according with SQL Server Agent Job's schedule. On my PC SQL Server works under Local System account and this web service is called correctly (Executed as user: NT AUTHORITYSYSTEM). But on ther other server the following exception is raised during job running: Date 17.04.2007 16:42:10 Log Job History (FailureNotificationJob) Step ID 1 Server MSK-CDBPO-01 Job Name FailureNotificationJob Step Name MainStep Duration 00:00:00 Sql Severity 16 Sql Message ID 6522 Operator Emailed Operator Net sent Operator Paged Retries Attempted 0 Message Executed as user: CORPmssqlserver. A .NET Framework error occurred during execution of user defined routine or aggregate 'StartNotification': System.Security.SecurityException: Request for the permission of type 'System.Net.WebPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. System.Security.SecurityException: at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at System.Net. The step failed. What is the reason of this behaviour? Unfortunately I do not have direct access to this server. I have the following guesses: 1) CORPmssqlserver may have not enough permissions to call web service 2) Something wrong with SQL Server account's permissions 2) Something wrong with SQL Server Agent account's permissions I will take the will for the deed. Thanks.
View Replies !
View Related
X-ref Documentation For DTS-package,views,tables,Reporting Service,Analyze Service
We are using the whole BI-package from Microsoft - from SQL, DTS-package,Raporting Service and Analyze Service. It should be very helpful to be able to create a metadata databases where you could find all releations between different objects (tables,views,reports,cubes,DTS-package,Databases. Just to get answer for: 'where is view xxx used', 'what are Report xxx depending upon'. While everything exists in different SQL databases it should possible to do. Has anyone any comments or the same needs ?
View Replies !
View Related
The SQL Server (SQLEXPRESS) Service Terminated With Service-specific Error 10013.
I have an almost virgin install of SQLExpres running on a WIN2K Pro system. Have been able to create and connect db to Access 2000 without problem. Now I wish to extend to remote connections. Using Surface Area Configuration tool, I changed Remote Connections to Local and Remote. Whenever this setting contains TCP/IP and I try to restart the service I receive the following errors: System Log: The SQL Server (SQLEXPRESS) service terminated with service-specific error 10013. Application Log: Server TCP provider failed to listen on [ 'any' <ipv4> 0]. Tcp port is already in use. TDSSNIClient initialization failed with error 0x271d, status code 0xa. TDSSNIClient initialization failed with error 0x271d, status code 0x1. Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log. SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems. If I change back to Local Connections Only or Local and Remote using named pipes only, the service starts up again without a problem. After five days of investigating, researching, reinstalling and waiting I have to ask for help. Any suggestions or leads? Thank You in advance.
View Replies !
View Related
Conversation Handle Processed By An Activated Stored Procedure Service Can Not Be Invoked By A CLR Service Instance?
I have a initiator and a target service broker peer. Both are controlled by a C# unit test. The initiator uses the Microsoft.Samples.SqlServer class. The target service uses stored procedure activation. Sending a message from the initiator to the target, saves the content of the message, along with its conversation handle in the target's database specific table. The unit test needs - at a later time - to instruct the target to send a message back on the same conversation handle to the initiator service. For this the C# unit test creates a Conversation off of the saved conversation handle: Service client = new Service("cleintservicename", conn, tran); Conversation dialog = null; dialog = new Conversation(client, convHandle); Sending the message on this dialog generates an error "Message body: <Error xmlns="http://schemas.microsoft.com/SQL/ServiceBroker/Error"><Code>-8495</Code><Description>The conversation has already been acknowledged by another instance of this service.</Description></Error>". Is the error due to the fact that a service - using the activated stored procedure already picked up the conversation, so that a new reference to the service can not be created through the Service class in CLR? If so, I might need then to skip the activated stored procedure in favor or a CLR service, alltogether? Any help - greatly appreciated.
View Replies !
View Related
An Error 1069 - )The Service Did Not Start Due To Logon Failure) Occurred While Performing This Service Operation ...
Hi All, We seem to be being plagued by the error below by our SQL Server agent. This happens almost everytime we restart the server that has been running for a day or two. Our SQL Server Agent uses a none expiring domain credential. I understand that this problem only happens when the profile being used by the SQL Servr Agent has changed (password change). What puzzles me is that the login is A ok and no changes has been made to it's password. We always resolve this problem by changing the login used in the SQL Server Agent to local and after that, returning it back to it's original domain login. Unfortunately, we cant always do this everytime something goes wrong. Can anyone please help us shed a light on this? We're using SQL2k with SP3a. Thanks! Error: An error 1069 - )The service did not start due to logon failure) occurred while performing this service operation on the SQLServerAgent service. Regards, Joseph
View Replies !
View Related
Does The SSRS Web Service And Windows Service Share A Common Engine?
All, I am looking at implementing some sort of throttling whereby "expensive" reports are setup as Subscriptions (and hence are run by the Windows Service), while all other requests go the Web Service. My question is: Do the two systems share any underlying systems? I understand (of course) that they use the same DB, etc. etc. However, I can't quite tell whether there is an underlying engine that is a common base or if they really just spin up different instances of the same objects and essentially each host the application separately? Any help is greatly appreciated! Mark
View Replies !
View Related
How To Use SSMSE To Connect To Instance Service Directly (without Going Through Browser Service)?
I have configured an instance to use static port, say 1435, and I turned off the Browser service. I would like to know if I can use SSMSE to connect to the instance database directly. The instance is listening at port 1435 and accepting connection requests from other methods. What I need to put into the "Server name: " field? Normally, it would be like: <serverIP><InstanceID> with Browser turned on. Now how do I add the port information to it, I tried <serverIP>:<portNumber><InstanceID> <serverIP><InstanceID>:<portNumber> <serverIP><InstanceID> <portNumber> None of them worked. Any suggestions? Thanks.
View Replies !
View Related
User Account Per SQL Server Service && SQL Agent Service, Why?
Hi all, I do understand that it is highly recomended to have aserprate user (perfered a domain user account) for each of the SQL Server service and SQL Agent service. What is the reason behind that? (Someone told me to not run the service with an account that has a powerul privilegs! - I don't undrstanmd this point can you explain it please?) What is the diffrent between: 1- Local System account 2 -Network Service account Thanks in advanced! CS4Ever
View Replies !
View Related
How To Connect To Analysis Service Database Through Reporting Service?
Hello, In our project, we would like to use the same data source for our analysis service database cubes and for our reporting service reports. I created the analysis service project first, deployed successfully. When trying to setting up the data source in the report model project, I selected the "create a data source based on another object", and then selected the "create a data source based on an analysis service project". However, there is no analysis service project to select, and no browse button to see where the reporting service is looking for analysis service project either. I have tried creating a new analysis service project with data source views, cubes, dimensions and all the stuff, but still cannot see the analysis service project in the drop down box to be selected for my reporting model project data source. As I am fairly new to the reporting service, I'm sure I'm missing something, but couldn't find much information in the help or on the web. Any suggestion would be much appreciated. Thank you very much, Annie
View Replies !
View Related
Amazon Web Service Call With Web Service Task
With the new improvments to the web service task, we can now use variables as arguments in web service calls. I am trying to setup a call to the amazon web service ECS. I am trying to do a simple sellerlookup. I have played with the settings and gotten nowhere. I get one of two error when I try to execute. I can always use a scripting task or write my own task, but I would like to use the built in task if it is possible. Has anyone used AWS with SSIS? [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Object reference not set to an instance of an object.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". or [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.AWSECommerceService.SellerLookup' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".
View Replies !
View Related
SQLSERVERAGENT: The Specified Service Does Not Exist As An Installed Service.
Hi, I am trying to install MS Sql Server 2000 on my machine. The OS on my machine is Windows XP SP2. During the installation i keep getting an error message, "Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information." I have copied an extract from the sqlstp.log file below: 10:05:28 Process Exit Code: (-1) 10:05:31 Setup failed to configure the server. Refer to the server error logs and C:WINDOWSsqlstp.log for more information. 10:05:31 Action CleanUpInstall: 10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service SQLSERVERAGENT 10:05:31 Process Exit Code: (1060) The specified service does not exist as an installed service. 10:05:31 C:WINDOWSTEMPSqlSetupBinscm.exe -Silent 1 -Action 4 -Service MSSQLSERVER 10:05:31 Process Exit Code: (0) 10:05:31 StatsGenerate returned: 2 10:05:31 StatsGenerate (0x0,0x1,0xf000000,0x200,1033,303,0x0,0x1,0,0,0 10:05:31 StatsGenerate -1,531793) 10:05:31 Installation Failed. Can someone please help me solve this problem? Cheers...
View Replies !
View Related
Proxy Web Service To Call SQL RS Web Service... Issues?
We have a security policy that requires us to have our web site call to an application server, which in turn calls to our database server. Firewalls are in place so only the web server has any exposure to the internet, and even that is proxied. The database server has the processing power and memory to run reports, but since we can't have the web server access it direcly, I thought that maybe we could create a proxy web service on the app server that "appears" to look like the SQL RS web service, and calls the SQL RS web service on the database server where the real work will be done. I figured ReportViewer would be able to point to that as the ReportServerURL. Has anyone tried something like this? Are there any gotchas I should watch out for? Is it a simple matter of using WSDL.EXE to generate a C# proxy class for SQL RS web service, then adding tags to expose the methods in the proxy class as web services? Is there a better way of handling this? Thanks, --Stan
View Replies !
View Related
Pass In Null/blank Value In The Date Field Or Declare The Field As String And Convert
I need to pass in null/blank value in the date field or declare the field as string and convert date back to string. I tried the 2nd option but I am having trouble converting the two digits of the recordset (rs_get_msp_info(2), 1, 2))) into a four digit yr. But it will only the yr in two digits. The mfg_start_date is delcared as a string variable mfg_start_date = CStr(CDate(Mid(rs_get_msp_info(2), 3, 2) & "/" & Mid(rs_get_msp_info(2), 5, 2) & "/" & Mid(rs_get_msp_info(2), 1, 2))) option 1 I will have to declare the mfg_start_date as date but I need to send in a blank value for this variable in the stored procedure. It won't accept a null or blank value. With refresh_shipping_sched .ActiveConnection = CurrentProject.Connection .CommandText = "spRefresh_shipping_sched" .CommandType = adCmdStoredProc .Parameters.Append .CreateParameter("ret_val", adInteger, adParamReturnValue) .Parameters.Append .CreateParameter("@option", adInteger, adParamInput, 4, update_option) .Parameters.Append .CreateParameter("@mfg_ord_num", adChar, adParamInput, mfg_ord_num_length, "") .Parameters.Append .CreateParameter("@mfg_start_date", adChar, adParamInput, 10, "") Set rs_refresh_shipping_sched = .Execute End Please help
View Replies !
View Related
Informix Date Type Field To SQL Server Datetime Field Error
I am trying to drag data from Informix to Sql Server. When I kick off the package using an OLE DB Source and a SQL Server Destination, I get DT_DBDATE to DT_DBTIMESTAMP errors on two fields from Informix which are date data ....no timestamp part I tried a couple of things: Created a view of the Informix table where I cast the date fields as datetime year to fraction(5), which failed. Altered the view to convert the date fields to char(10) with the hopes that SQL Server would implicitly cast them as datetime but it failed. What options do I have that will work?
View Replies !
View Related
Odbc - Binding Sql Server Binary Field To A Wide Char Field Only Returns 1/2 The Daat
Hi ,Have a Visual C++ app that use odbc to access sql server database.Doing a select to get value of binary field and bind a char to thatfield as follows , field in database in binary(16)char lpResourceID[32+1];rc = SQLBindCol(hstmt, 1, SQL_C_CHAR,&lpResourceID,RESOURCE_ID_LEN_PLUS_NULL , &nLen1);and this works fine , however trying to move codebase to UNICODE antested the followingWCHAR lpResourceID[32+1];rc = SQLBindCol(hstmt, 1, SQL_W_CHAR,&lpResourceID,RESOURCE_ID_LEN_PLUS_NULL , &nLen1);but only returns 1/2 the data .Any ideas , thoughts this would work fine , nit sure why loosing dataAll ideas welcome.JOhn
View Replies !
View Related
Retrieving The Description Field Or SQL Comment Field From A View
Hi, I have managed to use the INFORMATION_SCHEMA.TABLES to retrieve a list of all my views. I was wondering if it was possible to retrieve the Description or SQL Comment field from a view via ADO.NET, which can be found in the Enterprise Manager Design View properties (right click - properties) I want to hopefully utilize this field for dynamic page titling of a datagrid bound view. Many Thanks in anticipation!
View Replies !
View Related
Multiple Foreign Keys On Same Field, Based On Other Field
I have a table called BidItem which has another table calledBidAddendum related to it by foreign key. I have another table calledBidFolder which is related to both BidItem and BidAddendum, based on acolumn called RefId and one called Type, i.e. type 1 is a relationshipto BidItem and type 2 is a relationship to BidAddendum.Is there any way to specify a foreign key that will allow for thedifferent types indicating which table the relationship should existon? Or do I have to have two separate tables with identical columns(and remove the type column) ?? I would prefer not to have multipleidentical tables.
View Replies !
View Related
Create Date Field From Substring Of Text Field
I am trying to populate a field in a SQL table based on the valuesreturned from using substring on a text field.Example:Field Name = RecNumField Value = 024071023The 7th and 8th character of this number is the year. I am able toget those digits by saying substring(recnum,7,2) and I get '02'. Nowwhat I need to do is determine if this is >= 50 then concatenate a'19' to the front of it or if it is less that '50' concatenate a '20'.This particular example should return '2002'. Then I want to take theresult of this and populate a field called TaxYear.Any help would be greatly apprecaietd.Mark
View Replies !
View Related
Separating One Field Into Two Fields Based On A Character In The Field
I know there has to be a way to do this, but I've gone brain dead. Thescenario..a varchar field in a table contains a date range (i.e. June 1,2004 - June 15, 2004 or September 1, 2004 - September 30, 2004 or...). Theusers have decided thats a bad way to do this (!) so they want to split thatfield into two new fields. Everything before the space/dash ( -) goes intoa 'FromDate' field, everything after the dash/space goes into the 'ToDate'field. I've played around with STRING commands, but haven't stumbled on ityet. Any help at all would be appreciated! DTS?
View Replies !
View Related
Access Memo Field To SQL Server Text Field
Hi, I'm importing an Access database to SQL Server 2000. The issue I ran into is pretty frustrating... All Memo fields that get copied over (as Text fields) appear to be fine and visible in SQL Server Enterprise Manager... except when I display them on the web via ASP - everything is blank (no content at all). I didn't have that problem with Access, so I ruled out the possibility that there's something wrong with the original data. Is this some sort of an encoding problem that arose during database import? I would appreciate any pointers.
View Replies !
View Related
Grouping By One Field And Combine Data Of Another Field In SSRS
Hi all experters, Please suggest how to build the report in below case: Raw data: ID Member Functions 1 Alan A 1 Alan B 2 Tom A 2 Tom B 2 Tom C 3 Mary D 3 Mary E Report Shows: ID Member Functions 1 Alan A,B 2 Tom A,B,C 3 Mary D,E I group the data by the column ID, but would like to show the functions data by join all functions' values by the same ID. Any good suggestion? Thanks in advance, Steve Wang 2008/4/2
View Replies !
View Related
MS Access Memo Field To SQL Server Text Field
Hi all, i've a reasonable amount of experience with MS Access and less experience with SQL Server. I've just written an .NET application that uses an SQL Server database. I need to collate lots of data from around the company in the simplest way, that can then be loaded into the SQL Server database. I decided to collect the info in Excel because that's what most people know best and is the quickest to use. The idea being i could just copy and paste the records directly into the SQL Server database table (in the same format) using the SQL Server Management Studio, for example. Trouble is, i have a problem with line feed characters. If an Excel cell contains a chunk of text with line breaks (Chr(10) or Chr(13)) then the copy'n'paste doesn't work - only the text up to the first line break is pasted into the SQL Server database cell. The rest is not pasted for some reason. I've tried with MS Access too, copying and pasting the contents of a memo field into SQL Server database, but with exactly the same problem. I've tried with 'text' or 'varchar' SQL Server database field formats. Since i've no experience of using different types of databases interacting together, can someone suggest the simplest way of transferring the data without getting this problem with the line feeds? I don't want to spend hours writing scripts/programs when it's just this linefeed problem that is preventing the whole lot just being cut'n'pasted in 5 seconds! cheers Dominic
View Replies !
View Related
|
TRACKER
