DataSource Controls :: Completely Stuck / Trying To Deploy It To WS 2k3?

Jul 15, 2010

I've written a desktop application using VB.NET and SQLEXPRESS. Now I am trying to deploy it to WS 2k3. But getting positive results wiht SQLE is proving difficult. Here is the connection string I am using:

connectionString = "Data Source=.SQLEXPRESS;" + "AttachDbFilename=" + DBPath + ";" + "Integrated Security=True;" + "Connect Timeout=30;" + "User Instance=True"

The problem is the results I get from the setting of 'User Instance'. Like it is, it loads a unique stance of SQLE, which is fine. But the instance just keeps eating memory. I tried limiting memory with sp_configure, but nothing happened. It just keeps growing. If I exclude 'User Instance', it uses the SQLE service running on my machine. It ignores the memory limitation, but eventually settles and stops growing.

Those results came from working on my local machine.When I put it on 2k3, I get the same results with User Instance = True; runaway memory. With User Instance = False, I start getting the 'attempt to attach an auto-named database failed' message. So now I am stuck. I would like to go with the 'User Instance = true' option, but I don't know how to deal with the runaway memory. If all else fails, I could use the =False option, but I just can't get 2k3 to allow.

View 1 Replies


Similar Messages:

DataSource Controls :: Sql Server 2008 Import/export Wizard... Completely Useless

Apr 13, 2010

import/export wizard in 2000 had lots of options.

I could copy databases without a care in the world. Including constraints, stored proc., AND the data, etc.

Now, with v2008, the wizard is dumbed down too much. It's a "stupid" copy function that fails on the first constraint it meets.

"Copy database.." is not an option here: it needs sysadmin on both source and destination server.

Re-adding the constraints manually is not an option either: the database is WAY too large.

I'm actually hoping there is a temporary bug in the import/export wizard. Each option (and you have THREE...) returns with a new error.

Googling, I found I am not alone:

http://itknowledgeexchange.techtarget.com/itanswers/sql-server-2008-export-data-problem/

This post is exactly my situation. Here's what his post says: (bolded key parts)
I'm trying to get used to sql server 2008 having been forced to upgrade by my isp. I need to back up my key db on a weekly remote schedule, so have been trying to use ssms to export data from my remote db to a local copy.

Firstly I created a new empty db on the local machine. Then I scripted the structure of the db on the remote machine and ran the resulting query on the local machine to copy the table structure into the new db. This gave me empty target tables to map to (see
below).

I used the export data wizard and selected my remote tables, then highlighted the tables to be copied and used the Edit Mappings option. Here I need to do two things, firstly checking'Enable Identity Insert' (because I have a unique id in most tables which is identity seeded, and I've read that if this is not checked sql server will helpfully renumber your entire table, rendering all your foreign key references useless). Secondly I need to decide what to do with the data already in the destination table. SQL 2k DTS simply dropped the destination table and recreated it. SQL 2008 will either keep the structure and delete the rows therein, or drop the table and recreate it. Because I intend to save this package and call it on a schedule in the future, I need to choose one of these options, because next time the target db won't be empty.

If I choose the delete rows option, when the package runs I get the following error when the process gets ot the first table with an identity ID which is used elsewhere in the db as a foreign key.

Error 0xc002f210: Preparation SQL Task 4: Executing the query "Truncate TABLE [dbo][tblCompany] failed with the following error 'Cannot truncate table tblCompany because it is being referenced by a foreign key constraint. Possible failure reasons: Problems with the query, "Result Set" property not set correctly, parameters not set correctly or connection not established correctly'

Half a dozen preceding tables did seem to transfer fine, but the process falls down on this one table. What I want is for the process to ignore constraints whilst it does the backup.

Undeterred I tried the other option, dropping each table and creating a new version. This time I get the error:

Error 0cx0202009: Data Flow Task 1: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code 0x80004005. An OLE DB record is available. Source MS SQL Server Native Client 10.0. Hresult 0x80004005 Description "The statement has been terminated".
An OLE DB record is available. Source MS SQL Server Native Client 10.0. Hresult 0x80004005 Description "Violation of Primary Key constraint 'PK_LoginClasses'. Cannot insert duplicate key in object 'dbo.LoginClasses'.

Then I try unchecking the Enable Identity Insert option to see what happens. This happens:

- Validating (Error)Messages
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "UserID".
(SQL Server Import and Export Wizard)

Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
(SQL Server Import and Export Wizard)

Error 0xc004706b: Data Flow Task

1: "component "Destination - Login" (40)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)

I can't see any more options to try. So how do I get SSMS 2008 to do what Enterprise Manager 2k did with no drama?

View 11 Replies

DataSource Controls :: Stuck With Sql Query - Get Total Salary Employee Who Got Highest Salary Last Year

Jan 13, 2010

I have an employee salary table with fields empId, month, year, salary. I need query for the following - Total salary drown each employee last year - Id of the employee who got highest salary last year. i am getting wrong o/p for these queries.

View 3 Replies

DataSource Controls :: Deploy Database Project Under Different Schema?

Jan 7, 2010

I've created a Data Base project with some CLR functions and stored procedures.

I'd like to deploy the assembly under different schema then the default dbo.

Is it possible?

View 4 Replies

DataSource Controls :: How To Deploy SSIS Packages From SQL Server 2008

Feb 26, 2010

I have a number of existing SSIS packages on SQL Server 2008 and want to deploy them to another server. What is the easiest way to deploy multiple packages to another server?

View 1 Replies

DataSource Controls :: Deploy / Install .dtsx Files To SQL Server 2008?

Mar 1, 2010

I have 15 .dtsx files that were edited in SQL Server 2008 BUi and I need to deploy them all to dev server that has SQL Server 2008?

How do I go about deploying all 15 at the same time?

View 1 Replies

Forms Data Controls :: GridView And Get Rid Of The Datepart Completely?

Apr 5, 2010

I'm doing a time registrating website and uses VS2008 (C#) and SQL Server database.The employees should enter their date and time, if they need to edit they push edit link in the gridview and textboxes appears (in the gridview).The problem is that not only the time is in there, but also the date like this: 2010-02-14 07:00:00.If they change, let's say they erase all in that textbox and just write like this: 08:00:00 and push update, this will happend: 2010-04-05 08:00:00.Is there a way to avoid this,is there any chance to get rid of the datepart completely?In display view I set the formatting like this: {0:HH:mm},so it shows only time and not date, but when editing date appears again.I have a seperate field for the date and only want time in this field.

View 3 Replies

JQuery :: Turn Off All Input Controls Until The Page Has Completely Loaded?

Jun 9, 2010

using javascript / jquery is there a way we could turn off ALL input controls until the page has completely loaded...

View 4 Replies

Forms Data Controls :: View Of Website Completely Disturbed Due To Update Of Internet Explorer New Version

Oct 3, 2010

Two websites that are being developed by me is online in my office network. Our IT department has updated Internet Explorer and the view my websites is completely disturbed. Now we have Internet Explorer 8.0.6001.18702 In most of my pages the setting is that from top to bottom, in top there is a panel holding dropdown, textboxes and just under this panel there is another panel with gridview. When the pages load the first panel with the search controls are ok.

When i supplied search parameters then gridview resulted overlaping the above panel and it scrolls behind the above panel. When there is one record populates to gridview the whole gridview would not be seen but the count label shows one record.

View 15 Replies

Stuck Configuration Error Message

May 26, 2010

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message:

--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>
<b> Parser Error Message: </b>

It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.<br><br>

<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 24: ASP.NET to identify an incoming user.
Line 25: -->
<font color=red>Line 26: <authentication mode="Windows"/>
</font>Line 27: <!--
Line 28: The <customErrors> section enables configuration </pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> c:inetpubwwwrootenterpriseweb.config<b> Line: </b> 26
<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
</font>
</body>
</html>
<!--

[ConfigurationErrorsException]:
It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

(c:inetpubwwwrootenterpriseweb.configline 26)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_CustomErrors()
at System.Web.Configuration.CustomErrorsSection.GetSettings(HttpContext context, Boolean canThrow)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--.

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message:

--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>
<body bgcolor="white">
<span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>
<h2> <i>Configuration Error</i> </h2></span>
<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">
<b>

Description:
An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

<br><br>
<b> Parser Error Message: </b>It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.<br><br>
<b>Source Error:</b> <br><br>
<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>
Line 24: ASP.NET to identify an incoming user.
Line 25: -->
<font color=red>Line 26: <authentication mode="Windows"/>
</font>Line 27: <!--
Line 28: The <customErrors> section enables configuration </pre></code>
</td>
</tr>
</table>
<br>
<b> Source File: </b> c:inetpubwwwrootenterpriseweb.config<b> Line: </b> 26
<br><br>
<hr width=100% size=1 color=silver>
<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.3603; ASP.NET Version:2.0.50727.3082
</font>
</body>
</html>
<!--

[ConfigurationErrorsException]: It is an error to use a section registered as allowDefinition='MachineToApplication' beyond application level. This error can be caused by a virtual directory not being configured as an application in IIS.

(c:inetpubwwwrootenterpriseweb.config
line 26)
at System.Configuration.ConfigurationSchemaErrors.ThrowIfErrors(Boolean ignoreLocal)
at System.Configuration.BaseConfigurationRecord.GetSectionRecursive(String configKey, Boolean getLkg, Boolean checkPermission, Boolean getRuntimeObject, Boolean requestIsHere, Object& result, Object& resultRuntimeObject)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey, Boolean getLkg, Boolean checkPermission)
at System.Configuration.BaseConfigurationRecord.GetSection(String configKey)
at System.Web.Configuration.RuntimeConfig.GetSectionObject(String sectionName)
at System.Web.Configuration.RuntimeConfig.GetSection(String sectionName, Type type, ResultsIndex index)
at System.Web.Configuration.RuntimeConfig.get_CustomErrors()
at System.Web.Configuration.CustomErrorsSection.GetSettings(HttpContext context, Boolean canThrow)
at System.Web.HttpResponse.ReportRuntimeError(Exception e, Boolean canThrow, Boolean localExecute)
at System.Web.HttpRuntime.FinishRequest(HttpWorkerRequest wr, HttpContext context, Exception e)
-->
--.

View 3 Replies

Stuck On ASP / WCF WSDL Parsing Error

Apr 6, 2010

I have a WCF Web Service that my ASP.NET app uses. It has been working fine for quite some time. I just added in a Dev Express Grid (and the Dev Express DLLs) and a new page that uses them and now I am getting parsing errors on the WSDL. But the weird part is that it works fine on my machine but fails on the web server machine. (Both are connecting to the same web services WSDL.) Here is the error message I am getting:

Server Error in '/MyWebAppWebDev' Application.

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Reference.svcmap: Failed to generate code for the service reference 'MyWebAppService'.

Cannot import wsdl:portType

Detail: An exception was thrown while running a WSDL import extension: System.ServiceModel.Description.DataContractSerializerMessageContractImporter

Error: Referenced type 'WebClientApp.MyWebAppService.ReferenceUpdatesDataContract, WebClientApp, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null' with data contract name 'ReferenceUpdatesDataContract' in namespace '[URL] cannot be used since it does not match imported DataContract. Need to exclude this type from referenced types.
XPath to Error Source: //wsdl:definitions[@targetNamespace='[URL]wsdl:portType[@name='IMyWebAppReferenceDataServiceLib']
Cannot import wsdl:binding

Detail: There was an error importing a wsdl:portType that the wsdl:binding is dependent on.
XPath to wsdl:portType: //wsdl:definitions[@targetNamespace='[URL]/']/wsdl:portType[@name='IMyWebAppReferenceDataServiceLib']
XPath to Error Source: //wsdl:definitions[@targetNamespace='[URL]/']/wsdl:binding[@name='MyWebAppServicesDefaultEndpoint']
Cannot import wsdl:port

Detail: There was an error importing a wsdl:binding that the wsdl:port is dependent on.
XPath to wsdl:binding: //wsdl:definitions[@targetNamespace='[URL]wsdl:binding[@name='MyWebAppServicesDefaultEndpoint']
XPath to Error Source: //wsdl:definitions[@targetNamespace='[URL]wsdl:service[@name='MyWebAppReferenceDataServiceLib']/wsdl:port[@name='MyWebAppServicesDefaultEndpoint']

Source Error:

[No relevant source lines]

Source File: /MyWebAppWebDev/App_WebReferences/MyWebAppService/ Line: 1

I am completely stumped on this. I have checked my web.config endpoint address and it is spot on (and notably is not in the error message above).

Things I have tried:

Giving permissions to C:Windows emp to my Website user name
Giving permissions to C:Windows emp to my App pool user name
Checking to see that none of my data contracts are generic and have IsReference=true in them.

View 1 Replies

MVC :: Stuck. Trying To Create A Cms With Nested Partials?

Aug 21, 2010

I am currently trying to display multiple items on a single page. I am not sure as to how to tackle this. What I have is a database table that has all the page data in. I have this run as a PagesController and this works fine. However what I would like to do is, if say the Products page is selected via the menu, I want to pull back not only the Products page html but also get all the products, and even be able to pull them through via category. I was trying to use a partial view, but I can't get it to work. The same would be for other pages, having partial views to display the other content, ie if Gallery is selected, the page html for Gallery shows and it then can push to a partial view that pulls all the gallery images from the gallery db table and so on.

Maybe I am tackling this the wrong way. I have the pages stored in the db to allow for a CMS system I have setup. Maybe I need to use models for all the other items(Products, Gallery, Videos and such) and use the partial for the page html?

fixed on my own. couldn't figure out how to pull stuff in from multiple tables into one view.

View 3 Replies

Asp.net - Stuck With Enable Session State?

Jun 1, 2010

i have an application wherein i am accessing the Session object in the CommonCode.cs file that resides in the App_Code folder. But when the session object is accessed the application throws me an error Session state can only be used when enableSessionState is set to true, either in a configuration file or in the Page directive. Please also make sure that System.Web.SessionStateModule or a custom session state module is included in the \ section in the application configuration.Now i have already enabled the session state property in the web.config file, here is my code from the web.config file:

[code]...

View 1 Replies

Object Data Source Is Stuck In First

Jun 21, 2013

I set up a DAL layer in a dll. This had a couple poorly named methods such as GetData(), which is the default name offered up in the tableAdapter wizard. I also added a few other methods for various reasons, all with better names. I then built the dll and referenced it in an ASP project. On one page, I added an ObjectDataSource, and set it to that tableAdapter (which isn't what I wanted to do, but that's a different story). Under the Select tab, I see the GetData and the other methods. Under the Update tab I see a variety of Update methods. Under the Insert and Delete tabs....I see the same methods as I saw under the Update tab. The Insert and Delete methods that exist for the tableAdapter were not available.

I figured that I did something wrong, and I didn't like that GetData name, so I went back to the dll and changed some things around (I think I added an Insert and Delete method, but by now I can't remember, except to say that I wasn't all that surprised not to see those two methods the first time). I also changed the GetData name to something else, then rebuilt the dll.

Since that time, I have yet to be able to change what shows up in the Object Data Source configuration. The Select adamantly insists on the GetData method, which no longer exists under that name, while the other three tabs all show a variety of Update methods, but neither Insert nor Delete. I noticed that just adding a reference didn't have any impact until the ASP project was built, which moved the dll to the bin folder where it needs to be for the Object Data Source configuration wizard to see it. Therefore, I deleted the dll from the bin folder, then rebuilt. I've also removed the reference, deleted the dll from the bin folder, rebuilt, added the reference, rebuilt again to get the dll back into the bin folder, and anything else I can think of. It still seems to be retaining the original schema from the tableadapter without ever updating to the new name for the GetData. Since that hasn't updated, the rest doesn't surprise me.

View 25 Replies

Web Forms :: Stuck In Condition Based Selection

Jul 30, 2010

I have CheckedListbox and grid. Based on what are the items checked in listbox that much of items need to be shown in grid. My SQL procedure like ;
select * from Emp
where city in (@Names)

Everything is ok if I am checked any of the item and click OK. If I am nothing checked from the listbox I need to display all of the cities from DB. I need to do this work without modifying my procedure. So need to work out in front/end. If I pass nothing from the code the query seemed as select
* from Emp
where city in ('')
So no records getting...

View 7 Replies

Newbie Here -- Trying To Install N2 CMS And Umbraco - Stuck On Passwords?

Jul 1, 2010

I'm all set up with Visual Developer 2010 Express and successfully (yaaah) worked my way through the NerdDinner tutorial (thank you, thank you, thank you!). So, I think I have everything set up correctly so far. I used the "Install Everything" without the prebuilt apps and all went smoothly.

However, my goal is to set up CMS for a small company owned by a relative so they can update their website as necessary. I'd love to do this with MVC.

I have tried to install both N2 CMS and Umbraco, but can't get past the admin and user names and passwords for the database. Since I'm failing with both apps, I think it's something about setting up the database server that I need to understand.Win 7 Home Premium 64, home system, not on a network. what I need to enter for admin / admin passwords and user / user passworks for N2 CMS and Umbraco?

View 2 Replies

Blackberry Application Stuck Trying To Access Server

May 11, 2010

I've built a ASP.NET webservice and I'm trying to access it from a Blackberry. I've been testing it out with multiple devices and the simulator and it works fine, but there's just the one Blackberry 9000 (It's not the model, I've tried it out with another Blackberry 9000), and it's stuck waiting for a response from the server. Relevant section of the code that accesses this -

System.out.println("IN ntwk access thread, start point");
HttpConnection connection = (HttpConnection)Connector.open(serviceURL + WSNAME);
connection.setRequestMethod(HttpConnection.POST);
connection.setRequestProperty("Content-type", "application/x-www-form-urlencoded");
connection.setRequestProperty("Content-length", Integer.toString(postData1.length));
OutputStream requestOutput = connection.openOutputStream();
requestOutput.write(postData1);
requestOutput.close();
final int responseCode = connection.getResponseCode();
if(responseCode!= HttpConnection.HTTP_OK) {
//Process the error condition
}
// Request succeeded process the data.

It seems to be getting stuck after connection.getResponseCode(). Is there some way I can verify what's going wrong with this particular device?

View 1 Replies

WCF / ASMX :: Working On A Web Service Program But Is Stuck?

Jan 18, 2011



I am working on a web service program but is stuck. i dont know what to do after I use the foreach statement to retreive my data.


using System;
using System.Collections;
using System.Collections.Generic; [code]....

View 5 Replies

Web Forms :: Stuck In Barcode Design Path

Sep 9, 2012

I want to print ID with Barcode

I am using this codeĀ 

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head><body>
<form id="form1" runat="server">

[Code] ....

I want to give iD in textbox1 and submit after submitting it Text Box 2 should get ID and Barcode both so that from there I can get print ... how can i do this process..

public void CreateBarcode(string data) {
imgPath = string.Format("{0}{1}.png", path, data);
Bitmap barcode = new Bitmap(1, 1);
Font threeOfNine = new Font("IDAutomationHC39M", 60,
System.Drawing.FontStyle.Regular,

[Code] .....

View 1 Replies

Forms Data Controls :: Trying To Create A Nested Gridview, But I'm Stuck At The Editing/deleting Part Of The Nested Gridview?

Mar 1, 2011

I'm trying to create a nested gridview, but I'm stuck at the editing/deleting part of the nested gridview. (Below is my code).The nested gridviews are filling out nice, I've set the DeleteParameter in the SQLDataSource, but I'm still getting this error when trying to delete a criteria: 'The Gridview 'gvCriteria' fired event RowDeleting which wasn't handled.'I've tried to create a method 'gvCriteria_RowDeleting', but that didn't seem to work out.Someone who can give me a piece of advice? Would it be possible to fill the gridview without using gvDomain_rowDataBound? Dries

[Code]....

[Code]....

And the C# behind:

[Code]....

View 10 Replies

Databases :: Page Gets Stuck If User Enters Unicode Characters?

Feb 18, 2010

I have a form that allows users to post text to a MySQL database using an OdbcConnection. Everything works great until a user entered unicode characters into the textbox and sends the data. Suddenly the page freezes and is not redirected to the next page as programmed. When I check the database later it comes up with all of the users data intact, including the unicode characters. I've duplicated this problem several times by entering unicode characters and then entering only ASCII. It happens every time unicode characters are used. Is the problem on the ASP.Net side or the MySQL side? Here is my code. The description string is from a textbox entered on the form.I thought about using a RegEx to get rid of any non-ascii characters before sending the data. Is that recommended? How do I do it?

[Code]....

View 1 Replies

Lock Ever Get Stuck Locked Due To An Unexpected Thread Death Or Similar

Aug 11, 2010

I have an ASP.NET site that I am maintaining. Currently it has code that on first access (and other times too) goes and does a bunch of data caching by writing it to files. Currently it has no locking so we cna get problems with multiple people accessing the site and multiple threads trying to write to the files at the same time. This is obviously bad so I am going to implement some locking.

My current modified code just puts a simple lock around a section of code so that later requests just wait until the first request is done.

My concern is that I haven't used locks much so I just want to check if there is any situation in which that lock could not get released? For example I have no idea what happens if that first thread is killed (eg the web server decides its run too long and shuts it down). Does the lock get automatically freed at that point? Is there anything else I need to think about while doing this?

Edit to add:Here is what I think are relevant bits of Code in case there is anything I am doing stupid...

I am using private lock objects accessed through a dictionary and don't do anything much more than wrap some code in a SyncLock statement (equivalent of C# lock).

Public Shared Sub CheckAllVariables(ByVal SourceName As String, ByVal cn As HttpContext)
...
Do While dr.Read
projectID = dr.GetInt32(dr.GetOrdinal("ProjectID"))
Dim cacheLockObject As Object = GetCacheLockObject(projectID)code]....

Should I wrap access to the GetCacheLockObject function in a lock to prevent the possibility of two threads going in simultaneously and both finding the cache lock doesn't exist and then both creating it and returning different ones? I'm a little unused to having to consider thread safeness (assumign I am using that term correctly).

View 2 Replies

Forms Data Controls :: Using Dot Net Chart Control Last Column Of Chart Is Not Completely Appearing?

Jul 9, 2010

I have an issue in using dot net chart control. In chart last column is not completely shown which give bad appearance and on right side of chart it looks like TickMark are enabled. I set MajorTickMark of AxisY2 disabled but still tick marks on right side.

View 2 Replies

SQL Server :: How To Run Completely A Big Query

Jul 18, 2010

i have a big query and many data

when i try to execute this query i got this error

how can i run this query complete?

View 3 Replies

User Controlcan Be Completely Self Contain?

Feb 17, 2011

I am trying to make a UserControl that have all data process, initialize data, ajax, all self contain into one control.So I can insert to anywhere on my Asp pages.But the problem is, the UserControl contains a Script Manager and the Page that contain that User Control has a Script Manager too, so Asp doesn't allow me to have two Script Manager in one page.In case like this, I wonder if UserControl can completely self contain?Or the proper way of using UserControl is just using it like a template, and all the data process, event handler I have to do on the page that contains the UserControl?

View 1 Replies







Copyrights 2005-15 www.BigResource.com, All rights reserved