Running isqlw or bcp from Windows 2003 Web Application

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Framework
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - custom serialization..need help Hi, I'm new serialization concepts....I need some hwlp.. I've a class defined as follows class CustomSerialization1 { private string s; public string Test { get { return s; } set { s = value; } } private int i; public int Test1 { get { return i; } set { i = value; } } CustomSerialization1 obj = new CustomSerialization1(); obj.Test = "vijaya,wajid,vani"; object.Test1 = 3; } if want the the output to be sth below after applying serializatiion <Task> <Test> <TestInnner>Vijaya</TestInnner> <TestInnner>wajid</TestInnner> <TestInnner>vani</TestInnner> </Test> <Test1>3</Test3> </Task> Basically I want to control teh way inwhich my Test property will be displayed during serialization and deserialization.... please help me out..just let me know if this is possible by any means... either thru XmlSerialization or Custom Serialziation... Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129610
  - 2
    - DirectorySecurity's SetAccesControl works/not works? Look at the following example. The ASPNET account is added to the directory but it has no rights. Its marked as special permissions only. No read and execute. What could be wrong? Machine is XP SP2 .NET 2.0 and Visual Studio 2005. AddDirectorySecurity( gatewayPath, "ASPNET", FileSystemRights.ReadAndExecute, AccessControlType.Allow ); private void AddDirectorySecurity( string FileName, string account, FileSystemRights rights, AccessControlType controlType ) { DirectoryInfo dInfo = new DirectoryInfo( FileName ); DirectorySecurity dSecurity = dInfo.GetAccessControl( ); dSecurity.AddAccessRule( new FileSystemAccessRule( account, rights, controlType ) ); dInfo.SetAccessControl( dSecurity ); } Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129603
  - 3
    - Most popular object persistence framework Hi all What is the most commonly used object persistence framework for .NET? Thanks Pete Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129599
  - 4
    - VDPROJ, and install problems Hi group, I have a little problem using the deployement project. I have develop some kind of sp=E9cific file editor, and i install with it some example of those specific files. these file are not necessary, but if i suppress or rename it, and run the program, before it start Windows Installer repair it, and recreated the example files. i search the web, and found that there is event log, with EventID 1001 and 1004, saying that my example files missing. so i have identify the problem. But in my vdproj, i don't know what to do to specify these files are not needed by the rest of te aplication, and specify it to not repair for missing these files, but only repair for others. I have try to modify the vital attribute of the example files, and seek throw all properties what i need to do, but found nothing. how can i do that ? ROM Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129594
  - 5
    - 80131040 Error Hello All, I am calling a c# assembly registered with codebase switch from my VB6 application everything runs perfect. I have compiled same assembly in the separate folder but upon accessing this assembly by instantiating one of the class I get the following error Run Time Error 80131040 (FUSION_E_REF_DEF_MISMATCH) Please note that a Guid attribute has been defined in AssemblyInfo.cs of the assembly. So both versions of assemblies have same Guids. I unregister binary from the first folder (regasm /u) and register the developer version of binary and got the error mentioned above. I tried to run fusion log program but its not showing me anything. Any help in this regard will be appreciated. Regards, Usman Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129589
  - 6
    - checkboxlist query Hi, I've used a checkboxlist control on my windows form.. I've added few obejcts to it dynamically.. now I want to retrieve all unchecked items from this list....how do i it// please help me out... Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129588
  - 7
    - Merging Visual Studio & SDK Help Hi all, I recently installed windows workflow foundation and then realized that I could no longer see .NET framework documentation in my MSDN help. I installed the SDK hoping that it would merge back in. However, I now have two separate help collections, one with the framework classes etc... the other with all other documentation. Is there anyway to merge these two collections together? Is there any type of utility that will allow me to easily see what help is installed and manage it in some form or fashion? Thanks, Cole Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129587
  - 8
    - Right Click Context Menu of a C# windows application not working o Hello, I have developed a C# windows appl using .Net framwork 1.1, it is working fine on Windows XP. But one of my workmate tooks it home to try, when she tried right click to get to the context menu of the application, it doesn't work at all. Does anyone know what causes it? Thank you. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129586
  - 9
    - My manifest loading a reference twice im getting the ol' Could not load file or assembly 'ComponentArt.Charting.WebChart, Version=2007.1.1052.2, Culture=neutral, PublicKeyToken=9bc9f846553156bb' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. as you can see the .net framework wants to use version 2007.1.1052.2 of my 3rd party dll. I recently upgraded the 3rd party dll and expect .net to try and use 2007.1.1126.2 I have tried everything, removing / readding the reference, checking the gacutil (which does not list this assembly) even unloading iis and anything that is running the project before removing/readding this reference. Upon viewing my manifest for the project i see that this reference is being loaded twice .assembly extern ComponentArt.Charting.WebChart { .publickeytoken = (9B C9 F8 46 55 31 56 BB ) // ...FU1V. .ver 2007:1:1126:2 } this looks good, i see the version i want in the manifest, scroll a bit further and i find this .assembly extern ComponentArt.Charting.WebChart as ComponentArt.Charting.WebChart_19 { .publickeytoken = (9B C9 F8 46 55 31 56 BB ) // ...FU1V. .ver 2007:1:1052:2 } why is this in there? it is the wrong version, with the same publickeytoken and some kind or renamed reference to WebChart_19 Im guessing this is my problem, but this 4 lines of text seems impossible to get rid of... Any ideas would be very helpful thanks Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129585
  - 10
    - Code working in 1.1 stops working in 2.0 Hi All, I have this following code which works fine in 1.1 but gives runtime exception 2.0:- Reflection Code to get One Property from COM Object ------------------------------------------------------------------------------- Dim objSession as Interop.ComObj.Session Dim objAgent as Interop.ComObj.Agent Dim objAgentType as Type Dim PropertyName as String Dim itemProperty as PropertyInfo Dim propertyValue as Object objAgent = objSession.Create("Agent") objAgentType = GetType(Interop.ComObj.AgentClass) ' Important to use Class and not Interface. If you use Interface the reflection does not find the property. itemProperty = objAgentType.GetProperty(PropertyName) ' make sure the Propertyname exactly matches the property of COM object( including case) 'Get Property Value propertyValue = itemProperty.GetValue(objAgent, Nothing) If Not (propertyValue Is Nothing) Then ItemValue = propertyValue.ToString() Else ItemValue = String.Empty End If 'Set Property Value Dim NewValue as String = "TestValue" itemProperty.SetValue(objCustomer, System.Convert.ChangeType(NewValue, itemProperty.PropertyType), Nothing) ' This line gives error. The COM Property is String type The error is given below:- Error Description: Object does not match target type. Source: mscorlib Stack Trace: at System.Reflection.RuntimeMethodInfo.CheckConsistency(Object target) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks) at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture) at System.Reflection.RuntimePropertyInfo.SetValue(Object obj, Object value, BindingFlags invokeAttr, Binder binder, Object[] index, CultureInfo culture) at CMBrowser.OnBoardCustomer.SetPropertyValueEx(Type& objType, String ColumnName, String ItemValue, Object& objCom) in C:\SRCREF\CMBrowser\OnBoardCustomer.aspx.vb:line 4314 Class: RuntimeMethodInfo Proc Name: CheckConsistency Any clues as to why this is happening? This exception occurs for all properties irrespective of their types. Piyush Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129580
  - 11
    - System error while calling method for 2nd data adapter Hi, I am having vb2003-net 1.1 Code was working fine yesterday, today getting error ----------------------------------------------------------- error: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. ----------------------------------------------------------- Last line is highlighted. error while calling method for second data adapter ----------------------------------------------------------- My Code is : Dim mDataSet As New DataSet() Dim mConn As New SqlConnection() mConn.ConnectionString = "Data Source=localhost;initial catalog=transport;integrated security=XXX" mConn.Open() Dim mStr1 As String = "select * from mItem" Dim mStr2 As String = "select * from mPump" Dim mAdapter1 As New SqlDataAdapter(mStr1, mConn) mAdapter1.Fill(mDataSet, "mItem") Dim mAdapter2 As New SqlDataAdapter(mStr2, mConn) mAdapter2.Fill(mDataSet, "mPump") -------------------------------------------------------------- Need help... Thanks, Regards, Rachana Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129579
  - 12
    - Using cacheing?? Iâ??m researching the idea of using caching in my application. And I wanted to get other people thoughts that have used it with .NET 2.0. Below is an explanation of the current process: I have an application with several web pages. When any of these pages is first loaded, it retrieves the information from SQL and stores the information in a DataSet. This DataSet is then converted to a Session variable so that it can be used over and over without the need to reconnect to the database to refresh the data. The only time connections to SQL are made is when the user requests to DELETE or UPDATE the physical records. Once the delete/update is complete, I convert the Session variable back to a dataset and perform the same action on the dataset. Next I rebind the dataset back to the control and redisplay the page. All works great and it is fast. But it takes a lot of memory to store those datasets for each user session. Not to mention that if user(A) makes a change to a record, and user (B) is view the same record, b/c they are session variables, user (B) will never see user (A) changes. So I wanted to try using disk caching where user (A) requests a record, it gets cached on the server hard drive. SQL update and deletes happen as they do now, but I update the cache instead of a dataset in memory. If user (B) accesses the same record, and this record is already in cache from another user, it reads the cache instead of connecting to SQL to issue the SELECT statements. This cache would need to reside on the drive for say 24 hrs. All this to say, have any of you done anything similar? What are thing things I should watch out for? Whatâ??s a good resource to get started using this method in C#. I know disk I/O is slower then memory, but its faster then connecting to SQL every time to refresh the data. -- JP .NET Software Developer Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129577
  - 13
    - DoEvents in c#.net Hi, guys, As you know, in VB6, we have have DoEvents. How can we do the same job in c#.net? Thanks. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129574
  - 14
    - Programmatic diagnostic questions about dlls Hi, I am currently working on a diagnostic utility for developers, and some of the things I want to check are whether a dll in a project output folder is locked and cannot be over-written, or if an incorret version of a dll has been cached in the temporary internet files folder. A friend said that I could possibly open a file stream on a dll, and attempt to lock it, and if it failed, it would give info on which process currently had it locked, which might solve the first requirement - does anyone else have any ideas or suggestions on this? As for checking for cached dlls, I was thinking that I could maybe use reflection on the dlls in the temp inet folder to check for inconsistent dll versions, but I'm not sure if this is the best approach, or would even work - suggestions? Thanks, Jason Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129573
  - 15
    - compact framework Abstract The solution scope is to redirect intercept and redirect every call that accomplish with a call number pattern on Windows Mobile smartphones to a toll free number which is a prepaid platform. Solution Components CallListener: This is the component responsable to monitor when an end-user wishes to dial a number. Upon this action, CallInterceptor is triggered. CallInterceptor: This component analyses the digits dialed by the user and based upon the pattern defined by dialing rules, either dials directly as a normal call or just, dial into the prepaid platform and wait for a dial tone and then jump into CallDialer, before to jump to CallDialer it must hung up the user dialed call to start redirecting it. CallDialer: These modules initiates a call session with the toll free number on the prepaid platform and send the dialed digits by DTFM (from a buffer defined in CallInterceptor) into the prepaid platform. Upon completion of this task, then it goes to CallRegister. Problems Area CallInterceptor couldnâ??t finish or hung up the user initiated call (cprog.exe standard Windows Mobile dialer application)because in normal case it isnâ??t the owner the user generated call, we are using TAPI to try to hung up, this is the problem that we need to solve, how to hung up a call not initiated from our application. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129571
  - 16
    - Is This Overkill? I've been maintaining some source code, and I've noticed some radical inconsistency in the code, particularly in the way that parameters are validated. I've noticed that this seems to have been pretty much the case throughout my career. For instance, consider the following block: If siteId <= 0 Then Throw New ArgumentOutOfRangeException("siteId") End If If name Is Nothing Then Throw New ArgumentNullException("name") End If If name = String.Empty Then Throw New ArgumentException("Empty strings are not permitted.", "name") End If If buildingIdToIgnore < -1 Then Throw New ArgumentOutOfRangeException("buildingIdToIgnore") End If Sometimes, this code is collapsed as follows: If siteId <= 0 Then Throw New ArgumentOutOfRangeException("siteId") If name Is Nothing Then Throw New ArgumentNullException("name") If name = String.Empty Then Throw New ArgumentException("Empty strings are not permitted.", "name") If buildingIdToIgnore < -1 Then Throw New ArgumentOutOfRangeException("buildingIdToIgnore") Sometimes, it's omitted altogether. Somtimes, not all of the parameters to the procedure are validated. And in many cases, the messages aren't consistent from one parameter validation to the next. (Resource files would go a long way towards solving that, but that's a whole different thread.) What I've been pondering for some time is a way to make it easier to validate method parameters. My *theory* is that it's a lot of gangly code to write If...Then...Throw...End If, which leads to short-cuts and, eventually, outright omissions. So, a way to abbreviate that and make the code clearer might help to encourage consistent use of parameter validation, which should (in theory) improve code quality throughout the system. So I have this model I'm working on, and before I go completely off the deep end with it, I thought I'd run it by you to see what you thought of it. Essentially, it's based on NUnit asserts to validate parameters consistently and clearly. So, the code above is changed to this: Validate.That(siteId, "siteId").IsNotNegative() Validate.That(name, "name").IsNotNullOrEmpty() Validate.That(buildingIdToIgnore, "buildingIdToIgnore").IsGreaterThan(-2) Validate.That(connection).IsOpenAndIsNotNull() My tests for the model are going very well. I think that once I get it going, it could provide a very cool, extensible validation framework for parameters. The "framework" is in a separate class library, and the messages are in a string resource file, providing consistency. The big caveat, of course, is that there's no guarantee that it solves the *enforcement* problem. There's also the problem that FxCop thinks I'm not validating parameters when I am. So the question I have is, is this even worth doing? When an existing code base is refactored to use it, it looks much cleaner, and appears to be easier to read and maintain. But the question remains: is this a real problem, or am I addressing an issue that doesn't really exist? Your input is greatly appreciated. Thanks! Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129567
  - 17
    - compac framework Abstract The solution scope is to redirect intercept and redirect every call that accomplish with a call number pattern on Windows Mobile smartphones to a toll free number which is a prepaid platform. Solution Components CallListener: This is the component responsable to monitor when an end-user wishes to dial a number. Upon this action, CallInterceptor is triggered. CallInterceptor: This component analyses the digits dialed by the user and based upon the pattern defined by dialing rules, either dials directly as a normal call or just, dial into the prepaid platform and wait for a dial tone and then jump into CallDialer, before to jump to CallDialer it must hung up the user dialed call to start redirecting it. CallDialer: These modules initiates a call session with the toll free number on the prepaid platform and send the dialed digits by DTFM (from a buffer defined in CallInterceptor) into the prepaid platform. Upon completion of this task, then it goes to CallRegister. Problems Area CallInterceptor couldnâ??t finish or hung up the user initiated call (cprog.exe standard Windows Mobile dialer application)because in normal case it isnâ??t the owner the user generated call, we are using TAPI to try to hung up, this is the problem that we need to solve, how to hung up a call not initiated from our application. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129566
  - 18
    - HatchBrush in WPF Hi, is it possible to fill a shape, for instance a Rectangle, with a HatchBrush ? Is it possible to do this in XAML ? Thanks, Joris Spriet Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129564
  - 19
    - serialize a property of a collection Hi, I have a collection, which is a property of a class: public class PostcodeCollection : CollectionBase { // ...collection specific properties [XmlAttribute("Total")] public int Total { get { return List.Count; } set {} } } The main class is: [XmlRoot("PostCodes" )] public class PostcodeReport { // ..other properties [XmlArray("Updated")] [XmlArrayItem(typeof(PostCodeLine), ElementName="PostCode")] public PostcodeCollection Updated { get { return this.updated; } } } I want to add the "Total" property as an attribute to "Updated" node. Using "XmlAttribute" on the property, doesn't do the trick. This is how the xml must look like: <?xml version="1.0" encoding="utf-8"?> <?xml-stylesheet type='text/xsl' href='PostcodeUpdates.xslt'?> <PostCodes Generated="03-05-2007, 17:50"> <Added /> <Updated Total="23" > <PostCode District="2031"... /> </Updated> </PostCodes> How can i do this? Many thanks, Daniel Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129563
  - 20
    - Framework, ProtocolType.Icmp and VISTA Hi all, I did not find any other suitable newsgroup for my question, so I took this one here. I have a little project which has some kind of a network scanning wizard, to find local area computers and access them using the Eventlog or simple pinging them. 1-2 years ago I wrote some code to manually handle pinging of other machines, which worked very fine - till Vista ;) My application is running with highest privileges, but I am not able to get any ping responses from other machines expect my own local machine. Are there any new security methods which prevent an .net application to use ICMP? -- www.adiscon.com Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129562
  - 21
    - MSBuild Zip taks Hi All, I am new to VSTS and MS Build. I want to do a Zip (As in NANT) in MSBUILD proj file. Can anyone please help me in this. Also i want to create labels in Team Foundation Server (for all build files) before building it. Thanks. Regards, Shikhar Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129561
  - 22
    - 2.0: "Debugging failed because integrated Windows authentication in not enabled" Hello, I am writing my first ASP.NET application (I use .NET 2.0, Visual Web Developer 2005 Express Edition and SQL Server 2005 Express Edition). The application builds successfully but when I try to start debugging from Visual Web Developer I receive message box: Unable to start debugging on the web server. Debugging failed because integrated Windows authentication in not enabled. What should I do to solve the problem? Please help. Thank you /RAM/ Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129560
  - 23
    - Setting required framework version Hello everyone, I'm experimenting running side by side fw versions on a test box. One thing i do not understand is how it is determined the version to use when running an app. I wrote a very small proggy that just displays the version of the framework it is run by. If i use vs2003 (with fw1.1) it displays 1.1.4322 which is correct, but HOW does it determine the version to use? Is there a way to force the version used? How? Thanx in advance Paolo Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129559
  - 24
    - Problem : 2 different ASP .Net running in one IIS Hi all, I am having a problem with different version of website. One website written in Dot Net I and another one usig Dot Net II. The 1st website using Dot Net I had successfully run for few years. Until, I am configuring another website in same IIS whcih using Dot Net II. Once I start the service, the 1st website (dot Net I) which previous well run suddently unAvailable. Kindly, please help me. Anything i can configure with my IIs 6.0 or my server 2003 ? Need help -- masita Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129557
  - 25
    - laptop hi, Nigel The laptop that I want to have, has Windows Media Center. I was reading on net that the main differance between Win XP Pro and WMC is that WMC has 'joining a domain capability disabled'. .--------------- Here is an excerpt: Media Center is essentially just an application that's installed on top of the XP Pro operating system. Other than two specific networking features that are disabled (domain joining after installation, and cached credentials), MCE 2005 _IS_ XP Pro. --------------- Questions to IT: 1. What does 'joining a domain capability disabled' mean, does it mean that i cant be on the office network. 2. Ideally i need XP pro installed where do they get their machines from. regards, irfan Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129555
- Next
  - 1
    - What is the significance of link.exe.config and cl.exe.config files in VS2003 Hi, What is the usage of the files link.exe.config and cl.exe.config when compiling the code with cl.exe. ? Does it affect only .NET code? Does if have any effect on unmanaged C++ code ? Thanks, WN Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129552
  - 2
    - How to find the Parent Thread Is there a way to find the Parent Thread that spawned a certain Thread? For example: Thread a Spawns Thread b From inside Thread b's process, can I get to Thread a's TLS (Thread Local Storage)? Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129546
  - 3
    - How to get a mini dump? On some client's computer the XmlDocument.Save() fails with some weird internal error such as: ============== Exception : System.IO.IOException Message : Unknown error "-1". Source : mscorlib Help : Stack : at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share) at System.Xml.XmlDocument.Save(String filename) =============== I have reported such a problem to microsoft and they just told me they need more information such as a mini dump. how do I do one? Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129545
  - 4
    - Execution of managed code upon Ctrl-C or some other "signal" to die? Is there a way to execute any vb.net code when some type of signal to die is given? I found this reference, which may work http://groups.google.com/group/microsoft.public.dotnet.framework/browse_thread/thread/a85b02458bde3bdb/6941695b36d28b8c?lnk=st&q=Ctrl%2BC+VB.NET&rnum=7#6941695b36d28b8c But I was looking for a more general solution. Thanks. Jay Cox Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129543
  - 5
    - Circular References in the .NET Framework Today I stumbled over the following: There are cirular references in the .NET Framework. For example, System.Xml references System.Configuration and System.Configuration references System.Xml. See the following: http://www.stephan-brenner.com/blog/wp-content/uploads/2007/05/circularreferences.png There are a lot of that artifacts in the framework and I'm wondering why? And how does Microsoft manage to build this? Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129542
  - 6
    - Are they the same day? Hello, friends, What is the best way to test if two date values are the same day (same hour) or not in c#.net? As you know, in VB6, we have a fuction DateDiff("d", date1, date2). Do we have a similar one in .net? Thanks. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129538
  - 7
    - VB 2005 Serial Port Close() Method Hey all, I am having problems with the close method of the serial port class in vb 2005. I have a button on a form that calls the Close() method, but every now and then the program freezes. I have go into task manager to end the process to get it to stop. Just before I call the close() method, I discard the TX/RX buffers and RemoveHandler my handles to DataReceived and ErrorReceived. Any insight? Thanks, Steve P Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129535
  - 8
    - DataTable.Merge() I'm a little confused about DataTable.Merge(). I have two DataTable objects with the same structure - dtOrig and dtCurrent. The end result I'm trying to achieve is to get all the rows in dtCurrent that are in some way different from the corresponding rows in dtOrig so those new/ modified/deleted rows can be processed. My idea was to use dtOrig.Merge(dtCurrent), and then call dtOrig.GetChanges(). But what I found is that when the preserveChanges Merge() parameter is 'false' (or not supplied) the values in dtOrig do get updated, but the RowState stays 'Unchanged'. When preserveChanges is 'true' then the RowState for all rows becomes 'Modified' but the values in dtOrig are NOT actually updated! What am I missing here? Is there a better way to go about this? Thanks. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129530
  - 9
    - SslStream caching and Vista: Hi. When my client program runs under XP and calls a server (solaris in this case) via an SslStream all is well. The client may make multiple calls and multiple authentication calls and be fine. Running the client under Vista, when the second authentication call is made it returns the following SSPI error: "A call to the SSPI failed, see inner exception" which reads "the Local Security Authority cannot be contacted" Well that was pretty mystifying so I looked at what was going on with ethereal. Apparently, on the second authentication go-round the client asks the server to re-use a session Id. The client responds and then Vista rejects a re-used session Id (even though it asked to do that). What I have found out is that the .net framework seems to cache SslStream sessions automatically, I have not found any way to turn this off for Vista - any ideas on how to do this? Thanks _Randal Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129529
  - 10
    - Getting 3.0 Facts Straight Ok. If anybody has a url , that'd be great. My IT Department is asking for the exact lowdown on 3.0, from a machine/OS perspective. 3.0 projects can be developed on a. XP SP2 b. Vista c. ( I guess 2003Server, but how uses that as their personal OS) and deployed on 2003Server (some future version of Vista) Oh man. I know I screwed that up somehow. I found a few blogs, but would like group help with the concrete facts with this one. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129528
  - 11
    - case values in switch statement? Hi, guys, I have a switch statement like the follows in a KeyPress event: switch (e.KeyChar) { case '0' - '9': case 'A' - 'Z': break; default: break; } Of course, this did not work. But, how can I do such kind of case values which are in a range without writing each case value one by one? Thanks a lot. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129521
  - 12
    - win32 error i've created a console application whcih reads different file formats and scans for some for words.... the application builds fine and executes finely..but sometimes, the exe automatically becomes 0kb and gives me this error <Application.exe> is not a valid win32 application.. can anyone help me out in fixing this issue... Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129516
  - 13
    - win32 error i've created a console application whcih reads different file formats and scans for some for words.... the application builds fine and executes finely..but sometimes, the exe automatically becomes 0kb and gives me this error <Application.exe> is not a valid win32 application.. can anyone help me out in fixing this issue... Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129515
  - 14
    - Advanced WPF text How to creat text on path? Can I creat non regtagular text box? How to control text tracking, kerning and leading? Thanks. Jim Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129514
  - 15
    - checkboxlist query I've used a checkboxlist control on my form.. i'm populating values dynamically at runtime to this list.. but when i do it, the checkboxes so added are remaining unchecked... but I want a newly added item to be checked by default... how do i do it? any good samples... Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129513
  - 16
    - How can I get volume ID Hello. How can I get volume ID on which I have open file? Alexi. Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129503
  - 17
    - Overriding "OnXXX" versus adding event handler Okay, this has come up in the past but I haven't seen anything that I would call a good, solid general rule. The question applies more generally, but I'm going to ask in the context of a Control. How does one decide whether to write an "override" method to an event and when to simply add an event handler for that event? For example, you can either write a new OnPaint override, or you can register a delegate that the Control's base OnPaint method will execute. My current thought is that when you are not inheriting from the base class, you register a delegate (duh, since you obviously have no way to override the method in that case), and when you are inheriting from the base class, you override the method (the main reason here being that if you're inheriting from the base class, you want your new functionality to always work, rather than relying on your delegate remaining in the event handler list). In other words, override when you can, add an event handler if you can't. Is it really as simple as that? Or are there other factors I should be considering? Many thanks in advance for the wisdom of those who have gone down this road before me. :) Pete Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129495
  - 18
    - convert an object to string and back (in a culture independent fashion) to store user preference in our application we have an 'hand written' XML file. (as opposed to XmlSerializer written one, which crash sometimes, on some user's computer, for some unknown reason.. but I'm digressing) In this XML file I store object value, which I convert to string (when writting) and from string (when reading) with a couple of simple function which (should) do a reversible conversion (using TypeConverter) (functions below). Unfortunately, for some Enum, (namely System.Windows.Forms.Keys) I got a culture dependent string, even though I specify CultureInfo.InvariantCulture as an argument in my ConvertXXX method with the TypeConverter. Even using 'new CultureInfo("en")' do not fix this behavior. Any tip on how to fix these function (below) so they provide a truly culture independent reversible object=>string=>object mechanism? =================================================== public static bool TryGetStringValue<T>(object val, out string ret) { if (val is string) { ret = (string)val; return true; } TypeConverter tc = TypeDescriptor.GetConverter(typeof(T)); if (tc == null) { ret = val.ToString(); return false; } try { ret = tc.ConvertToString(null, CultureInfo.InvariantCulture, val); return true; } catch (ArgumentException) { } catch (NotSupportedException) { } ret = val.ToString(); return false; } public static bool TryGetTValue<T>(object val, out T tval) { if (val is T) { tval = (T)val; return true; } TypeConverter tc = TypeDescriptor.GetConverter(typeof(T)); if (tc == null) { tval = default(T); return false; } if (!tc.IsValid(val)) { tval = default(T); return false; } try { tval = (T)tc.ConvertFrom(null, CultureInfo.InvariantCulture, val); return true; } catch (ArgumentException) { } catch (NotSupportedException) { } tval = default(T); return false; } =================================================== Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129493
  - 19
    - Windows Workflow - What basic tutorials? What's going on here? I thought I was an experienced programmer but I'm looking at the beginning WWF tutorial (Simple Expense Report) and I'm baffled. I feel like I don't know how to even begin reading this. I thought this was supposed to be interactive coding. Since when do we cut and paste into a project file? Is this just a temporary Beta thing? Why this constant use of command prompts? Also I have downloaded other samples onto my machine and none of them seem to work correctly. In the OrderingStateMachine demo, I get the error message: "The project file <C:\data\Visual Studio 2005\OrderingStateMachine\VB\OrderWorkFlows\OrderWorkFlows.vbproj cannot be opened. The project type is not supported by this installation." ?????? Could someone direct me to a more user-friendly, comprehensible tutorial? Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129485
  - 20
    - Truly cross platform? The thread bellow titled 'Determining if two paths are the same' brings to mind some of the first 'things' I had heard way back when DotNet started. It was going to be the panacea of cross platform development. I am asking the question here of the group to find out if everyone (anyone) thinks this has come (or is coming) to fruition. I think that perhaps it has gone a long way towards making it simpler to communicate between platforms but I am not sure if the framework itself has actually made it to the cross platform development hall of fame just yet. What do you folks think is the possibility of truly doing that? Looking at the mono project and actually trying to use it in some productive manner has showed me that this is far off. Just trying to get it working along with GDK and Mono-develop on a fedora Core 6 system was an exercise in futility. While I can understand what drives the open source community I honestly can't understand what keeps it going when stuff is that hard. I can install VS.NET 2005 and be developing in an hour. Hello world in Mono-develop never came to life. But, I digress and that is another rant for another message area. So, what are your thoughts and ideas? Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129483
  - 21
    - Locking Desktop and Threading Issue Hi, I have an application that displays forms on the users desktop, what I am doing with it is having a SystemEvents SessionSwitchEventHandler to capture the lock of the desktop, I would like to kill the forms when this event is captured, that piece is fine, but I would like to sleep the app until the SessionSwitchReason.SessionUnlock happens then I can wake it again and go the correct part of the code? Can I wake a sleeping thread, or should I not sleep the thread at all, is there another way to get the thread to sleep or hibernate and then wake up? Thanks Eamonn Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129478
  - 22
    - .Net Windows Service ...data access problem Hi, I am writing a .NET windows Service that will access the database every 10 minutes. When the service calls the function in the business services layer which in turn calls the correponding function in data access layer, this DAL function fails. The reason 'apparently' being that the it can not read the connection string information and hence can not create the database connection. Please note that that I am using enterprise library. All the projects representing business service layer, DAL, Model, Web UI and also the the windows service project are all in the same solution. Can anyone tell me what should I do to get around this problem. Thanks -Sam Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129470
  - 23
    - Installation problem - MSDN Libs for VS2005 I'm trying to jury-rig an installation of MSDN for VS2005 from ISO disks. The company I'm working for has an 'install drive' so I'm not sure of the pedigree of these directories. Essentially, since I don't have a CD burner at my disposal, I'm trying to run the installation directly from the ISO images using Microsoft's Virtual CD-ROM Control Panel v2.0.1.1. The problem is as follows: It doesn't matter if I run the setup on the first MSDN disk or call MSDN installation directly from VS2005's setup screen. Either way I get an error message saying: "Error 1311. Source file not found. U:\_17693_RTL_x86_enu_NET_Framework_SDK_HxS.cab. Verify that the file exists and that you can access it." I should note that given the current mounting scheme, the 3 ISO images are disks T, U, and V and presumably software on the T drive should be running. So how could it know about the U drive in the first place and why didn't it issue a standard Insert Disk prompt? (The file definitely exists and I can even copy it.) Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129468
  - 24
    - Questions about clickOnce hi, I have couple of questions about clickonce again, I am publishing a Winform appplication using ClickOnce. In the 'Publishing Location' text box I input the directory name (C:\CLICKONCE\Test2\). In the 'Installation URL' what shall i input. Why do i need to input a URL when it is simple Winform Application. Question2: When I publish a new version, The client should be prompted about the new version and it should run that instead of old one. It doesnt do it in my case, even though 'Application Should check for updates' is ON. Thanks in Advance irfan Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129464
  - 25
    - search results dialog box when i open search from the start menu, i get a listing in the task bar, but the box cannot be seen. when i click on the task bar block it appears to fly off the screen to the upper right Tag: Running isqlw or bcp from Windows 2003 Web Application Tag: 129455

Hi,

I have developed a web site for my client on .net 2.0 framework using
asp.net 2.0. This web site will be hosted on Windows 2003 server.

Web application runs the batch file on the user button click. This
batch file runs isql, isqlw or bcp utility of sql server to pull the
data from database. This command generates the .csv file by executing
the query.

Initially this web app was hosted on Windows 2000/XP server and it
worked fine. It had generated CSV file using isqlw but moment I hosted
everything on Windows 2003 and it cannot generate the .csv file. The
batch file is still getting executed so its not a problem in executing
the batch file. The problem is it cannot execute the isqlw command.

On windows 2003, I am using a service account for the application
pool. Now what I don't know is how to give an access to this service
account to execute the isqlw.exe or bcp.exe or to that matter any exe.

Has anyone done like this?? Can any one help me on this?

Help is really appriciated.

Prateek Baxi

Top