.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Post New Web Links

Unable to correct data formats on host

Posted By:      Posted Date: September 23, 2010    Points: 0   Category :ASP.Net
 

I created web pages that used an SQL database on my home computer.  That DB allowed me to use data types such as 'date' and 'time'.  But when I transferred my website to a host server, I discovered that its DB does not accept these types.  They only use 'datetime' and 'timestamp'.  I changed the tables in the DB on my computer to conform to the same format as on the host computer.  I also changed the properties to the new data types with the O/R Developer and re-published the website files to the host server.  But I keep getting the same error message that states the server does not support 'date' data types whenever I execute a web page that uses that table column.  The C# code states "officetable.StartDate = DateTime.Today;"  What should I do?  Please help.


Maurice




View Complete Post


More Related Resource Links

Unable to open BCP host data-file

  
I am having trouble with BCP. I get the same error with xp_cmdshell as I do with entering bcp as a DOS command. I have checked and rechecked the file names and permissions and even restart the PC.

Does BCP even work when SQL Server 2005 Express on a PC?

declare @sql varchar(8000)
select @sql = 'bcp SYMITAR..ACCOUNT in C:\test\EXTRACT.ACCOUNT -T -f C:\test\ACCOUNT.FMT -S'+@@servername
exec SYMITAR..xp_cmdshell @sql
GO

Volume in drive C has no label.
Volume Serial Number is 08E5-2414

Directory of C:\test

02/13/2007 08:44 AM <DIR> .
02/13/2007 08:44 AM <DIR> ..
08/31/2006 09:11 AM 27,503,161 EXTRACT.ACCOUNT
08/31/2006 09:12 AM 6,879 FMT.ACCOUNT
02/07/2007 08:46 AM 220 ACCTTYPE.FMT
02/13/2007 08:44 AM 0 filelisting.txt
02/07/2007 08:33 AM 220 ACCTTYPE.xml
5 File(s) 27,510,480 bytes
2 Dir(s) 54,344,847,360 bytes free

Could the fact that it's actually pulling BCP from c:\Program Files\Microsoft SQL Server\80\Tools\binn\ be a problem? I know this because it doesn't recognize the -x extensionof the bcp command.

PATH:
%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;C:\Program Files\Common Files\GTK\2.0\bin;C:\Program Files\Microsoft SQL Ser

Data form web part not displaying - Unable to display this Web Part. ....

  

Hi,

I am designing a data form - adding some formatting etc.  I am able to see the webpart correctly in SPD split view, but when I trying to preview it, it gives me the following error

Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Windows SharePoint Services-compatible HTML editor such as Microsoft Office SharePoint Designer. If the problem persists, contact your Web server administrator.
ANy help would be welcome, I have spent a lot of time on this page and don't want to do it again.  THere are a lot of fields and it's a tedious process to move them to the correct location.  I am at my wits end, I am not sure how to debug this!!
Thanks,

Srini

Unable to validate data

  

Hi All,

Thank you for advance.

I created the web application using asp.net 2.0, c# and sql server 2005

sometimes i am getting the following error,

Message: Unable to validate data.

Source: System.Web

TargetSite: Byte[] GetDecodedData(Byte[], Byte[], Int32, Int32, Int32 ByRef)

StackTrace:    at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)
   at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)




System.IO.IOException: Unable to read data from the transport connection

  
Hello,   I have an xml webservice calling another xml web service and occasionally i get the following error - any ideas why?Does this happen when the request is made or when reading the response? Also how i can prevent it from happening? Thanks   System.IO.IOException: Unable to read data from the transport connection: A blocking operation was interrupted by a call to WSACancelBlockingCall. ---> System.Net.Sockets.SocketException: A blocking operation was interrupted by a call to WSACancelBlockingCall   at System.Net.Sockets.Socket.Receive(Byte[] buffer, Int32 offset, Int32 size, SocketFlags socketFlags)   at System.Net.Sockets.NetworkStream.Read(Byte[] buffer, Int32 offset, Int32 size)   --- End of inner exception stack trace ---   at System.Net.ConnectStream.Read(Byte[] buffer, Int32 offset, Int32 size)   at System.IO.StreamReader.ReadBuffer(Char[] userBuffer, Int32 userOffset, Int32 desiredChars, Boolean readToUserBuffer)   at System.IO.StreamReader.Read(Char[] buffer, Int32 index, Int32 count)   at System.Xml.XmlTextReaderImpl.ReadData()   at System.Xml.XmlTextReaderImpl.InitTextReaderInput(String baseUriStr, TextReader input)   at System.Xml.XmlTextReaderImpl..ctor(String url, TextReader input, XmlNameTable nt)   at System.Xml.XmlTextReader..ctor(TextReader input)   at System.Web.Services.Protocols.SoapHttpClientProtocol.GetReaderForMessage(SoapClientMessage message, I

WCF issues sending large data - "An existing connection was forcibly closed by the remote host"

  
Hi Guys I have posted the following on www.asp.net but thought it might be productive posting here too.I have been pulling my hair out trying to fix an issue with sending data over WCF, I have read pretty much every THREAD on this forum regarding or similar to this issue without any successful solution.  I have a simple data object which has a [DataMember] with a data type of byte[]. I use this to send binary data from my web app as follows: Asp.net MVC website --> WCF Client (Has my Service References) --> My Services (MyServices.svc) --> Business/Data Tier Everything is being executed from within VS 2008 Pro.   Now I have successfully sent data up to 2.2MB, however it fails if i try and send a file such as 2.3MB or larger i get the following exceptions: General Exception Exception rethrown at [0]:    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)   at SoftApp.WCFClient.MyServiceReference.IMyService.Document_Save(DtoDocument dtoDocument, Int32 usercode)   at SoftApp.WCFClient.MyServiceReference.MyServiceClient.Document_Save(DtoDocument dtoDocument, Int32 usercode) in c:\dev\softapp\softapp.wcfclient\service references\myservicereference\refe

Unable to consume ADO.NET Data Services from Silverlight.

  
Hi Everyone, I am having trouble consuming an ADO.NET Data Service from Silverlight.  I am able to get data back from a browser, but not in Silverlight. I am at a loss to figure this out.  Any help is much appreciated.  Let me know if you need more info. Thank you in advance for any help! Here is the the silverlight code: private Uri svcUri = new Uri("http://localhost:64522LocalTariffsDataService.svc"); private void ctrlViewLocalTariffs_Loaded(object sender, RoutedEventArgs e) { svcContext = new LocalTariffEntities(svcUri); svcContext.LocalTariffs.BeginExecute(OnLocalTariffsQueryCompleted, svcContext.LocalTariffs); } private void OnLocalTariffsQueryCompleted(IAsyncResult result) { Dispatcher.BeginInvoke(() => { DataServiceQuery<LocalTariffsEntityDataService.LocalTariff> query = result.AsyncState as DataServiceQuery<LocalTariffsEntityDataService.LocalTariff>; LocalTariffsEntityDataService.LocalTariff returnedLocalTarrifs = query.EndExecute(result).FirstOrDefault(); // Exception is thrown here. dgLocalTariffs.DataContext = returnedLocalTarrifs; }); } Here is the exception: < E2ETraceEvent xmlns = " http://schemas.microsoft.com/2004/06/E2ETraceEvent " >

Unable to Show Edit item Links in Data Form Web Part

  
I have a DFWP connected to custom list and the boxes to Show Edit Item Links, Show Delete item links and Show Insert Item links are grayed out so that they can not be checked. This works fine when I use a DFWP connected to a standard list (i.e., Contacts). Is there something special that needs to be done to activate this functionality?ThanksDean

Unable to get current username via data connection

  
I'm trying to use a browser enabled form.  I've followed the directions on this site to get the current profile username. http://baigadil.blogspot.com/2008/07/get-current-user-for-infopath-and-set.html When i open the form, i get the following error message: An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:6932    

Unable to get current username via data connection

  
I'm trying to use a browser enabled form.  I've followed the directions on this site to get the current profile username. http://baigadil.blogspot.com/2008/07/get-current-user-for-infopath-and-set.html When i open the form, i get the following error message: An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:6932    

Unable to prepare the SSIS bulk insert for data insertion

  
Hi,   I am using SQL Server Destinations in my data flow tasks. I'm running this package in the server until i encountered this error:   OnError,,,LOAD AND UPDATE Dimension Tables,,,10/24/2007 1:22:23 PM,10/24/2007 1:22:23 PM,-1071636367,0x,Unable to prepare the SSIS bulk insert for data insertion. OnError,,,Load Dimensions,,,10/24/2007 1:22:23 PM,10/24/2007 1:22:23 PM,-1071636367,0x,Unable to prepare the SSIS bulk insert for data insertion. OnError,,,Discount Reason, ISIS Condition, ISIS Defect, ISIS Repair, ISIS Section, ISIS Symptom, Job Status, Parts, Purchase SubOrder Type, Service Contract, Service Reason, Service Type, TechServiceGrp, WarrantyType, Branch, Wastage Reason,,,10/24/2007 1:22:23 PM,10/24/2007 1:22:23 PM,-1073450974,0x,SSIS Error Code DTS_E_PROCESSINPUTFAILED.  The ProcessInput method on component "Dim_T_ISISDefect" (56280) failed with error code 0xC0202071. 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. What could be the reason for this? I don't usually have an error.   cherriesh

SQL ServerDestination error - Unable to prepare the SSIS bulk insert for data insertion.

  
Having searched the forum, this one clearly has form... However beyond assisting those who have fallen at the first hurdle (i.e. forgetting/not knowing that they cannot execute the package remotely to the instance of SQL Server into which they are inserting), the issues raised by others have not been addressed. Thus I am bringing nothing new to the table here - just providing an executive summary of problems which others have run into, written about, but not received answers for.   First the complete error: Description: Unable to prepare the SSIS bulk insert for data insertion.  End Error  Error: 2008-01-15 04:55:27.58     Code: 0xC004701A     Source: <xxx> DTS.Pipeline     Description: component "<xxx> failed the pre-execute phase and returned error code 0xC0202071.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  4:53:34 AM  Finished: 5:00:00 AM  Elapsed:  385.384 seconds.  The package execution failed.  The step failed.   Important points It mostly works - It produces no error more than 9 times out of 10. It fails on random dataflows - My package has several dataflows, (mostly) executing concurrently. Where the error occurs it does not do so on the same dataflow each time: on one run it'll fail on dataflow A whilst B,C,D and E succeed, then A-E will all succeed (and continue doing so for the next ten runs thereafter), and

Unable to validate data in User Agent: Mozilla

  
Hi All,Thank you for advance.Error Details : User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows XP)Message: Unable to validate data.Source: System.WebTargetSite: Byte[] GetDecodedData(Byte[], Byte[], Int32, Int32, Int32 ByRef)StackTrace:    at System.Web.Configuration.MachineKeySection.GetDecodedData(Byte[] buf, Byte[] modifier, Int32 start, Int32 length, Int32& dataLength)   at System.Web.UI.ObjectStateFormatter.Deserialize(String inputString)OS Environment : Microsoft Windows Server 2003 Statandard x64 Edition and Service back 1Application Environment : Asp.net 2.0/C#We have lot aspx files but we are getting this error in register and login page only.I added the machineKey in web.config file reference with codeproject article (http://www.codeproject.com/Articles/43637/Weird-Error-Unable-to-Validate-Data-in-ASP-NET-web.aspx)but still i am getting the error.

Unable to load data into a LookUp column in sharepoint using sharepoint destination

  
I have loaded details of a customer on a list and was able to load the data with out any problem using sharepoint list destination. We have a lookup column called customerid looking at customer list  . This lookup column is in another list, called Customer Main, so I am trying to load additional data for customer in this customer Main  list which contains a lookup column called customerID. I was not able to load data into this cutsomerid, whereas rest of the data is coming into sharepoint with out any problem. How should I load data into a lookup column. Thanks  

Unable to export data to an excel file in grid format!!!

  
I'm exporting data to an excel sheet from the ojects list. The data is exporting to excel sheet well, but I'm unable to see the grid format for the data. The data is looking with out the rows and columns lines. I think I'm missing to set some property or somethnig ehwn exporting.   Any help would be really appriciated.

BCS Data List - Unable to Allow Filtering

  
Hello,   I'm using the BCS Data List to display values from the 'Contoso Inventory List' on the Microsoft SharePoint 2010 demo machine.  I'm unable to allow user filtering of data - the options appear grayed out.  Here's what I did: Dropped a BCS Data List web part on my page Selected my External Content Type Data appeared as expected I then clicked the 'Edit View' link to modify the BCS Data List view The selections under 'Items to Retrieve' are grayed out - with "Retrieve All Items" selected by default.   I had hoped to use 'Retrieve items specified by the user' which in SharePoint 2007 BDC gave the user filtering options.I'm hoping someone can help me understand what I'm doing wrong.     Thanks!   Steven   ps - I get the same behavior with different SharePoint sites and External Content Types, so I don't believe it's a problem with my SharePoint site.

Unable to store combo box value to data grid view control

  
Hello,         I am using fw 3.5 SP1 with VS2008. I have bind my object collection with data grid view. I can see different values in combo box inside data grid view. But when I select any one value from combo box the selected value is changed to first value of combo box as soos as user leave the cell of the gird. Can anyone tell me where should I look for this problem so that my selected value remains same as user did select it.   Nilkanth Desai  

Rare exception: Unable to read data from the transport connection: An existing connection was forcib

  
Our .NET 2.0 app relies upon the ability to download xml webpages from URLs.  At startup, we have about 6 boxes in the wild (out of thousands) that are seeing the following inner exception when they try to download an xml page.  System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. (Inner: ) System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. They can get to the URL in their browser just fine, so we know our server is working.  Furthermore, the embedded WebBrowser control in our app can pull up webpages just fine, so I don't think their firewall is blocking our app.  I'm hoping it's just some diagnosible configuration issue.  Here is the snippet of code that does the downloading: WebRequest request = WebRequest.Create(fileToDownload.SourceUri);request.CachePolicy = new RequestCachePolicy(RequestCacheLevel.NoCacheNoStore);request.Timeout = (int)DefaultTimeout.TotalMilliseconds;request.Method = "HEAD";WebResponse response = request.GetResponse(); Nothing revolutionary there. (I've also tried it without the HEAD request, without keepalive, and using HTTP 1.0).  And here is the exception: System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. StackTrace Infor
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend