SqlException: Unknown Error

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
    - Debugging Problem Hi all, I am trying to debug an application developed by another developer. if i run it in Debug mode(locally), the application hangs and does nothing (basically dies and makes me wanna kill myself),... "does not reach the break point.... nada....." but if I try to run the application from another machine while the application is under debug mode, it hits the break point. Please advice, Stephen Noronha Tag: SqlException: Unknown Error Tag: 102324
  - 2
    - Enterprise Library really su#$%"#!"ks Hello, long days these days than i had trying to setting up the Enterprise Library Blocks in the production server. Why? I will told you all my sad history, I had installed in my computer the enterprise library of june with the ilussion than that will keep me away from the database connections problems, scalability problems, and all that things!, and I had tested that in my developer machine, and I dont had these problems, but when I had started to setup the server, wow, what a fu"#$%#$#$!"cking problem, the assemplies of the Enterprise Library doesn't work. I had runned without results the installutil for each assembly, I had compiled in command line the source code of these blocks in the server and i dont had results, i had do everything possible (but not install the Visual Studio 2003), and i dont have positive results. Hey Microsoft guys, what is the problem with yours??, Keep it simple, why the DAAB had worked so good, so easy, and with that enterprise library everithing had changed, and you had send us a stupid problem. For all you gouys, the problem than I got is that message error: The type initializer for "Microsoft.Practices.EnterpriseLibrary.Data.Instrumentation.DataConnectionFailedEvent" threw an exception. Tag: SqlException: Unknown Error Tag: 102322
  - 3
    - SQL Server Mobile on Tablet PC I'm trying to load data on a SQL Server CE database. Doing it on the Pocket PC takes very long. I though I'd load it on the desktop using the tablet PC API, using Visual Studio 2005 Beta 2 and Sql Server 2005 (Mobile). I'm following instructions provided in the help file for Sql Server 2005 - "Building a SQL Server Mobile Application for Tablet PCs". I'm having 2 problems. 1. I can't find "Microsoft Tablet PC API" under .NET assemblies, to add a reference. 2. I did the rest - added "System.Data.SqlServerCe.dll" as a reference. The application builds fine, but when it runs, it immediately stops with this error: System.IO.FileLoadException was unhandled Message="Could not load file or assembly 'System.Data.SqlServerCe, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040)" Tag: SqlException: Unknown Error Tag: 102321
  - 4
    - Custom TransformerProvider in Configuration Application Block Hello, How can we create a custom TransformerProvider (deriving from = XmlSerializerTransformer with some minor changes) and make it work with = the Enterprise Library Configuration Application Block? Thank you! Best wishes, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: SqlException: Unknown Error Tag: 102319
  - 5
    - regex result is it OK to get regex result of pattern which has duplicate reference names like StrDatePattern As String ="\b(((?<year>\d{4})-(?<month>\d{1,2})-(?<day>\d{2}))|{(?<month>\d{1,2}) (?<day>\d{2}), (?<year>\d{4})))"? my code segment StrDatePattern As Sttring ="\b(((?<year>\d{4})-(?<month>\d{1,2})-(?<day>\d{2}))|{(?<month>\d{1,2}) (?<day>\d{2}), (?<year>\d{4})))"? Dim strDate As Sttring = "", _ strYMD As Sttring = "" Dim r as regex = New Regex(StrDatePattern , RegexOptions.IgnoreCase) Dim m as match = r.Match(myStringHoldingDateInfo) If m.Success Then al_posn = m.Index + 1 strDate = Mid(StringIn, al_posn, m.Length) ' works so far strYMD = m.Result("${year)-${month}-{$day}") ' at best, I get the year component only Else al_posn = 0 strDate = "" strYMD = "" End If I did not have much luck using match.result to re-arrange the extracted date string. However I was able to extract the matched date string. I even try with anoth match on strYMD and then use that result to re-arrange the date string and still no luck. What did do wrong? thank you for your time. I was Tag: SqlException: Unknown Error Tag: 102318
  - 6
    - server side http for a non-web server I'm evaluating using http to carry data between a client and a non-web (C#) server application. This sounds great as the browser already has an http implementation and http is an open protocol. I was expecting to find a server piece that implemented the server side without requiring a full web server. I've looked around and found http.sys which sounded ideal but which doesn't seem have a C# API until Framework 2.0. Is anyone aware of either some kind of a C++ wrapper for http.sys or an alternate http implementation? If not, I can fairly readily build a wrapper on top of existing TCP functionality but I believe in reusing software when possible. I could also introduce IIS and create an ASP.NET "proxy" that could take http POSTS and relay them in the existing TCP format. Thanks Mike Tag: SqlException: Unknown Error Tag: 102317
  - 7
    - asynchronous logging with enterprise library logging application block. I am trying to use asynchronous logging using MSMQ and I have configured the properties as defined in the help (see below) I don't understand where the property 'MsmqPath' is in the app.config for MSMQDistrbutor.exe is it meant to be an aplication settings or an enterprise library setting in the app.config? I have tried creating an application setting value for it but it still fails to write to the logging destination? Also is this meant to be registered as a service? To choose asynchronous logging. 1.. In the Enterprise Library Configuration Console, expand Client Settings, right-click Distribution Strategies, point to New and then click MSMQ. 2.. Select the strategy and then specify the QueuePath for the strategy. 3.. Select Client Settings, and then modify the DistributionStrategy property to select the MSMQ distribution strategy you created. 4.. Open the MSMQDistributor.exe.config file with the Configuration Console, located in the directory containing the file MSMQDistributor.exe. Modify the MsmqPath property of the MSMQ Distributor Service to match the QueuePath property of the MSMQ distribution strategy you selected in step 2. This distribution strategy will be used for all messages that are not filtered out. Note Do not use the In Process distributor strategy and the MSMQ distributor strategy to log to the same flat file sink. Using both the In Process and MSMQ distributor strategies with the same flat file sink may result in simultaneous attempts to write to the same file. This will result in failure due to the file resource being in use by another process. Has anyone got any ideas? I followed the instructions below to allow for an MSMQ not registered with AD. http://mvwood.com/blogs/blog/archive/2005/03/04/321.aspx Cheers Ollie Riches Tag: SqlException: Unknown Error Tag: 102316
  - 8
    - Monitoring the existence of multiple files What's the best way to monitor an arbitrary set of files? In a program like a CD burning app, you've got a an explorer-like file system listview that you pick your files from and a listview for the CD compilation. If you populate the CD listview with 100 different files from 100 different folders, is there a good way to monitor any changes to the files in that listview (deletions, renames, moves, etc.)? This is mostly a GUI thing. I can easily check the existence of the files just prior to performing any operations on them, but I'd like to provide realtime feedback to the user so that they know when one of the files they've chosen is unavailable. I know there's the FileSystemWatcher class, but I suspect it's unwise to create 100 FSWs, each monitoring one file per directory. Tag: SqlException: Unknown Error Tag: 102314
  - 9
    - calling SQLLDR from C# (ASP.NET) Hi, I'm trying to call SQLLDR from ASP.NET (C#) to load data from a text file into a table. I'm not a windows/microsoft person so if you could give me a hint I'd appreciate it. I have tried a few ways to call sqlldr but it looks like the line with sqlldr command is just not being executed... There are no errors... I was told that it very well might be a permissions issue but I'm not sure where to look. I can execute my bat file from a command line with no problems and it works fine. Only from C# it doesn't work Here are my code samples: version 1: --------------- String strRunCommand = "SQLLDR "+p_DbConnection+" data='"+ p_LoadSourcePath+strTxtFileName+ "' control="+strFileType+".ctl log="+strLogFileName+" SKIP=1 ERRORS=10 BINDSIZE=1048576"; System.IO.File.Create(p_LoadDestinationPath+"load_run.bat").Close); StreamWriter sw = new StreamWriterp_LoadDestinationPath+"load_run.bat"); sw.WriteLine(strRunCommand); sw.Close(); System.Diagnostics.Process p = new Process(); p.StartInfo.RedirectStandardOutput=false; p.StartInfo.FileName = p_LoadDestinationPath+"load_run.bat"; p.StartInfo.UseShellExecute = false; p.StartInfo.WorkingDirectory = p_LoadDestinationPath; p.StartInfo.RedirectStandardError = true; p.Start(); p.WaitForExit();//wait with no time limit p.Dispose(); --------------- version 2: --------------- String strRunCommand = "SQLLDR "+p_DbConnection+" data='"+ p_LoadSourcePath+strTxtFileName+ "' control="+strFileType+".ctl log="+strLogFileName+" SKIP=1 ERRORS=10 BINDSIZE=1048576"; System.IO.File.Create(p_LoadDestinationPath+"load_run.bat").Close); StreamWriter sw = new StreamWriterp_LoadDestinationPath+"load_run.bat"); sw.WriteLine(strRunCommand); sw.Close(); System.Diagnostics.ProcessStartInfo psi = new System.Diagnostics.ProcessStartInfo("cmd.exe"); psi.UseShellExecute = false; psi.RedirectStandardOutput = true; psi.RedirectStandardInput = true; psi.RedirectStandardError = true; System.Diagnostics.Process proc = System.Diagnostics.Process.Start(psi); System.IO.StreamReader strm = System.IO.File.OpenText(p_LoadDestinationPath+"load_run.bat"); System.IO.StreamReader sOut = proc.StandardOutput; System.IO.StreamWriter sIn = proc.StandardInput; while(strm.Peek() != -1) { sIn.WriteLine(strm.ReadLine()); } sIn.WriteLine("EXIT"); proc.Close(); sIn.Close(); sOut.Close(); --------------- Tag: SqlException: Unknown Error Tag: 102304
  - 10
    - thread.abort and thread.suspend Hi to all. I have a little problem. I'm working with threads, and I need to abort or suspend them, but many experts dissuade from use Thread.Abort and Thread.Suspend. As I didn't find other way, how can I do? Thanks a lot! Tag: SqlException: Unknown Error Tag: 102289
  - 11
    - How to control order of properties in a class Hi, I have created a class with some properties Class Manager Private msName a s string Private msSurnaname as string Private mdSalary as double Public Property Name() as string .....Implementation ....Similarly implemented all the properties ...Some functions End Class To make class bindable I created a custom collection class Class Managers Inherits CollectionBase Public Function AddManager() as Manager 'implementation code.... End Function Public ReadOnly Property Item(byval index as integer) as Manager 'implementation code.... End Property End Class When I create instance of Managers class and added some manager objects to it. I tried to bind this to a third party grid (Data grid wont bind). It worked..But my problem is how I can control order of properties in columns. I see Columns in Surname, Name, Salary order...What should I do to ensure that my columns come in Name, Surname abd Salary order? I wonder How dataset achieve this? In dataset you'll always se fields in same order as they appear in XSD schema..Is there any way to achive this functionality? Thanks, Abhishek jain_abhishek_77@yahoo.co.in Tag: SqlException: Unknown Error Tag: 102285
  - 12
    - Networking program to send multiple files for multiple clients hi I'm writing a small windows service for sending multiple files for multiple clients when the request is got from the client . i need suggestion to implement this concept would you prefer multiple ports to be used to send the files at a time to the requested clients using multithreading? Tag: SqlException: Unknown Error Tag: 102282
  - 13
    - processModel/memoryLimit Windows Service Can anyone tell me does the memoryLimit attribute in the machine.config also affect Windows Services. I know this does apply to ASP.NET applications, but I am unsure for Windows Services. Thank you Tag: SqlException: Unknown Error Tag: 102278
  - 14
    - Store date permanently Hi, I'm writing an activation system for a software, which allows a 15 days grace period. Now the question is... how can I store the date? It has to be kept even if the software is reinstalled, and it must not be too easy to find/delete. I could write a hidden file somewhere in the system or hide it in the registry, but if it is a limited XP account, I'm quite limited. Any genious idea!? I tried Isolated Storage, but just moving the assembly files creates a new Isolated Storage, so it's of no use. Thanks! Etienne Getting a beta version out soon... Tag: SqlException: Unknown Error Tag: 102268
  - 15
    - .NET versions forward compatibility I posted this originally in microsoft.public.dotnet.framework.windowsforms -- but this is probably a better place... I am developing with VS 2003 -- .NET framework 1.1 I want my app to also run on .NET framework 1.0, so I define a .config file with the following: <configuration> <startup> <supportedRuntime version="v1.1.4322" /> <supportedRuntime version="v1.0.3705" /> </startup> </configuration> As a test, I am doing this on a plain-vanilla Windows app -- with a single form and a single textbox. But it does not work, on a .NET framework 1.0. Is there a way to debug a config file? Where should I look to make progress? Tag: SqlException: Unknown Error Tag: 102265
  - 16
    - Web Service Always returns 404 Hi, I'm using VS2005 beta 2 to make an asp.net web service. When I try to run any webservice (even a helloworld example) I get a 404 error: Server Error in '/QNSEmulator' Application. The resource cannot be found. Description: HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly. Requested URL: /QNSEmulator/Service.asmx Version Information: Microsoft .NET Framework Version:2.0.50215.44; ASP.NET Version:2.0.50215.44 It started happening when i was trying to publish the website somewhere else on my local machine using the Build>>Publish ... thing. Does anyone know how i can fix this? Will uninstalling and reinstalling VS do anything? Tag: SqlException: Unknown Error Tag: 102264
  - 17
    - Creating the Double2 type Hi, I have some problems with the default rounding method of C# check an earlier post of my : http://groups.google.be/group/microsoft.public.dotnet.framework/browse_frm/thread/12ed0c44b2ffbddf/a410c5e788c35f06?l=nl#a410c5e788c35f06 To create a workaround for this problem, I wan't to create my own double type ! the 'Double2' would act like a standard double but when assinging a value to it, it will always my own rounding method to round the value to 2 decimals. Double2 d = 1.235; d -> 1.23; How can I create my own type like this ? Kind regards Frank Vandelinden Tag: SqlException: Unknown Error Tag: 102260
  - 18
    - Banker's Rounding by default, a big mistake !! Check the following example: it's a simple presentation of a ticket. double[] lines = new double[5]; //Set some VAT's lines[0] = 1.245; lines[1] = 1.246; lines[2] = 1.241; lines[3] = 1.275; lines[4] = 1.255; //Print and calc total double tot = 0; foreach (double val in lines) { tot += val; Console.WriteLine(" {0:0.00}", val); } Console.WriteLine("-----"); Console.WriteLine(" {0:0.00}", tot); Console.ReadLine(); This is the result : 1,25 1,25 1,24 1,28 1,26 -------- 6,26 Now take our your calculator (or excell if you like) an add the 5 lines manualy ! Your result wil be 6.28. -> 0.02 difference !!!!!!!!! If I give this ticket to a client he demands to now where the 0.02 euro has gone to. I know this has to do with the way C# round's its doubles (it is using the Banker's Rounding method) What i don't understand is why it's the default. To put it simple : How do I explain to someone (that is not a computer wiz), that 1 + 1 = 1.1 ???? Kind Regards Frank Vanderlinden Tag: SqlException: Unknown Error Tag: 102256
  - 19
    - web.config file hi i have a web.config file that specifies the connection string for my database. the database server on the ISP is using a different port than 1433. how do i specify in the connection string to use a specific port number? i tried the <ip address>:<port number> and that didn't work. any ideas? thanks Tag: SqlException: Unknown Error Tag: 102251
  - 20
    - Q re class layout with embedded structs A friend and fellow programmer asked, and I didn't know the answer: When a CLR class contains fields of non-scalar types (structs, say), are these structs then laid out in memory immediately within the class instance image, or are they converted implicitly into reference types and only references to instances of these stored in the class instance? According to him, the reflection APIs leave the impression that the latter takes place, whereas the SOS documentation suggests the former. To clarify, I'm referring to fields of types that are not usually reference types (structs) as opposed to arrays and strings that are of course always stored by reference. TIA - Per Tag: SqlException: Unknown Error Tag: 102250
  - 21
    - Bulk Import - Thread was being Abort I am facing a unique problem where i am reading an XMl stream(8000 records) using open XML into SQL server > The problem is that whenever i execute the stored procedure it starts inserting data but suddenly stops at about 1 min 45-50 secs time. The import stops and the error is "Thread was being aborted". The whole stuff works fine when i connect to the database server from local machine. The database server is located at a remore place and the live application resides in the same place as of the database server. I get this problem when i try doing import logging in to the live server. i dont get this problem when i try doing this locally to the remote database server Settings : IIS6.0 and ASP.NET, SQL Server please suggest if there are any web server based settings which are forcing the import to time out. Arnab Kumar Dutta Associate-Technology BMS Team D03044 Tag: SqlException: Unknown Error Tag: 102247
  - 22
    - Compiler disallows for loop in ASPX ... what's up? Hi All, In effort to write a loop in ASPX to generate a set of labels, I tried this: <form id="Form2" method="post" runat="server"> <script language="C#" runat="server"> int nCols = 8; int nRows = 20; int iHeight = 25; int iWidth = 50; int iVertGap = 5; int iHorGap = 5; for (int iRow=0; iRow<nRows; iRow++) { <asp:Label ID="Lbl" RunAt="server" /> [snip] intending to assign values to the properties of the Lbl object. But the compiler announced: CS1519: Invalid token 'for' in class, struct, or interface member declaration What can I do to generate a bunch of object programmatically in ASPX? Thanks in advance, Richard Tag: SqlException: Unknown Error Tag: 102244
  - 23
    - Cannot receive data across socket connection by .NET app I have a .NET app that connects to a third-party server on a socket and sends data. This works with a test server on the local network, but does not work across the frame connection to the third-party server. They see a connection, but never see any data coming across. This works with Win32 app using winsock. However, if I use [DllImport] and call a Win32 dll that uses Winsock from my .NET app, it does not work. Is there some setting in .NET framework security or my code that I am missing? Any ideas? Thanks Tag: SqlException: Unknown Error Tag: 102241
  - 24
    - AppDomain unloading problem Hi, I have a main assembly (assy1). That assembly creates a type in another assembly (assy2). That type creates an AppDomain, load it's parent assembly (assy2) into it and creates a type in the AppDomain. Problem: when I call AppDomain.Unload(_myAppDomain), the application just crash. No exception, no message box. Nothing. Just a plain old "native days" type of crash... I really have difficulties understanding what is happening. What I'm doing is the simplest of all the AppDomain usage scenario, and yet it crash my application... Any idea? Tag: SqlException: Unknown Error Tag: 102236
  - 25
    - ReaderWriterLock acquire timeout values ??? According to the documentation for the Acquire methods on the ReaderWriterLock class: -1 Infinite. 0 No time-out. > 0 The number of milliseconds to wait. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemthreadingreaderwriterlockclasstopic.asp Does someone want to explain to me the difference between -1 (infinite) and 0 (no time-out)??? I've been using 0, but occasionally get a time-expired exception that traces back to an attempted acquire ??? I thought 0 was /not/ supposed to time out. I've switched to Timeout.Infinite (-1) to see if that fixes the problem. Regardless, I'd like to know the difference(s) between the two values. Tag: SqlException: Unknown Error Tag: 102235
- Next
  - 1
    - Create Access Database with ADOX I'm using asp.net referencing ADOX to create access database on server side. Using C#; Two problems: the ASPNET process doesn't let go of the access file, so I can't access it after I've created the file. I've set the ADOX.CatalogClass variable to null, but it doesn't let go of it...is there a connection close command? second problem, with one of my table create, I have a access YES/NO field. when I have: tableClients.Columns.Append("fldField" + i,DataTypeEnum.adBoolean,0); then later on: cat.Tables.Append((object)tableClients); it gives me: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. " else if I don't append that column, it runs fine. what's wrong?? Thanx Tag: SqlException: Unknown Error Tag: 102231
  - 2
    - NDoc not working How coul I resolve the following error with NDoc. Note I did add in NDoc comment to some private/protected method and in the NDoc Project, I did specify Document{Internals,Privates,Protected} to True An error occured while trying to build the documentation. Exception: NDoc.Core.DocumenterException There are no documentable types in this project. Any types that exist in the assemblies you are documenting have been excluded by the current visibility settings. For example, you are attempting to document an internal class, but the 'DocumentInternals' visibility setting is set to False. Note: C# defaults to 'internal' if no accessibilty is specified, which is often the case for Console apps created in VS.NET... Exception: NDoc.Core.DocumenterException There are no documentable types in this project. Any types that exist in the assemblies you are documenting have been excluded by the current visibility settings. For example, you are attempting to document an internal class, but the 'DocumentInternals' visibility setting is set to False. Note: C# defaults to 'internal' if no accessibilty is specified, which is often the case for Console apps created in VS.NET... Stack Trace: Exception: NDoc.Core.DocumenterException at NDoc.Documenter.Msdn.MsdnDocumenter.Build(Project project) at NDoc.Gui.BuildWorker.ThreadProc() Exception: NDoc.Core.DocumenterException at NDoc.Documenter.Msdn.MsdnDocumenter.Build(Project project) Tag: SqlException: Unknown Error Tag: 102230
  - 3
    - custom logging sink for logging application block I have written a custom logging sink for the enterprise library logging application block (June 2005). I have been able to configure it as expected from the UI config tool (EntLibConfig.exe). I have built a console application to test it with and I am getting the following error message write to the default trace log when I attempt to use my custom logging sink. 'An error occurred while the Distributor was processing the message. Please check your configuration files for errors or typos. Verify that your sinks are reachable (queues exist, permissions are set, database exists, etc...)' This might be security related can anyone give me the answer on how to fix this? I can see from VS that the module for my custom logging sink is loaded at runtime but I am unable to break into the assembly which indicates to me that any of the 'LogSink' overridden methods are not being called. Cheers Ollie Riches Tag: SqlException: Unknown Error Tag: 102229
  - 4
    - strong name using al.exe and csc.exe I'm very much a beginner with C# and the .NET Framework environment, and am writing and building C# programs using the command line CSC.EXE compiler. What I'm trying to do now is try out some of the evidence options and the security policy settings. Code Signing and using this via certificates and Publish evidence is working fine, but I'm a bit stumped by strong naming at the moment. I've created a key pair using sn.exe, and read that I sign with this to an assembly before it's built (so not to a completed .exe). This seems to be the way to go from what I've read: AL.EXE /out:testapp.exe testapp.netmodule /keyfile:keypair.snk So far I've been using /target:winexe in CSC.EXE, so don't have the module files AL.EXE wants. I tried changing the CSC.EXE command line to: CSC.EXE /target.module /reference:... testapp.cs This allowed AL.EXE to complete without error messages, but the resulting .EXE says it's not a valid Win32 executable. Can anyone point me in the right direction to getting a valid Win32 executable that is strong named, using only the command line tools of the SDK? Danny. Tag: SqlException: Unknown Error Tag: 102223
  - 5
    - Math.Round Hi, C# uses Banker's Rounding to round decimals 1.75 -> 1.8 1.65 -> 1.6 How can I disable this Banker's rounding !!! I would prefere that when the double ends on 5, it gets roudend up (ignoring even/odd numbers) 1.75 -> 1.8 1.65 -> 1.7 Kind Regards Frank Vanderlinden Tag: SqlException: Unknown Error Tag: 102221
  - 6
    - Relfection and assmelby build date How could I use relfection or another mean to fetcth the DLL's modification date? Tag: SqlException: Unknown Error Tag: 102218
  - 7
    - WSE TIME synchronisation between server and client machines Hi friends, I am stuck with a problem. I have a ASP.NET(C#) based web service program which acts as the server program and a client program, both the programs residing at different locations. I am passing parameters using WSE methods, from client program to server program and viceversa. Say for ex, the server program has the system time of 10:00 AM and the client program has the system time of -5 hours to the server program. now, when i want to login to my client program, i have to pass on my username and password to the server program. In doing so, since there is a time difference of -5 hours, and i get back an error saying "Creation time can not be in the future". I put up the following code at the server program to resolve this issue..but it is giving syntax errors. <configuration> <microsoft.web.services2> <security> <defaultTtlInSeconds>86400</defaultTtlInSeconds> <timeToleranceInSeconds>86400</timeToleranceInSeconds> </security> </microsoft.web.services2> </configuration> Please let me know if there are any other methods to resolve this problem or any other configuration settings to be done! Thanks, Indiresh. Tag: SqlException: Unknown Error Tag: 102213
  - 8
    - code generation tool My company is thinking of using a code generation tool to generate DAL classes, Typed DataSet, Entity Objects, as well as basic WebService to access the DAL classes. As we do not have much experience about these kind of tool here, I would like to ask someone if they know any professional and reliable tool for that. I have heard of CodeSmith but I don't know if there are any other better / more complete tool. The cost is not an issue. The real issue is to find out one of the best tool on the market as once we would start to use it we would stick to it for the all enterprise application. If anyone of you as an idea of what are the best tools around then please let me know. Best, Francois Malgreve Tag: SqlException: Unknown Error Tag: 102202
  - 9
    - Problem Security Hello. I use a web service that I created through a custom control on a windows form and it works fine. However, if iput this control on a webform, i get an security error when i call the web service saying: "The application attempted to perform an operation not allowed by the security policy. The operation required the SecurityException. To grant this application the required permission please contact your system administrator, or use the Microsoft .NET security policy administration tool. Request for the permission of type System,Net.WebPermission..." What can i do? I don't know how to explicitly trust the assembly. Thanks Tag: SqlException: Unknown Error Tag: 102200
  - 10
    - Problem coding logic in a webform Hi All, I used VS.Net to build a webform app. I used the toolbox to drag a bunch of labels onto a form to form a matrix. In the HTML code I saw a bunch of <asp:label ...> lines with various LEFT: xxx and TOP: xxx values. I want to tear them out and replace them with some script that looks something like this (ignoring all the other generated parameters beside the LEFT and TOP parameters: <script language="C#" runat="server"> int nCols = 8; int nRows = 20; for (int iRow=0; iRow<nRows; iRow++) { int iRowOffset = 10+35*iRow; string sRowOffset = iRowOffset.toString + "px"; for (int iCol=0; iCol<nCols; iCol++) { int iColOffset = 15+80*iCol; string sColOffset = iColOffset.toString + "px"; <asp:label COL: sColOffset TOP: sRowOffset> } } </script> Can you point to a WebForm coding sample that has real, working code that has any elements relating to my pseudocode? Thanks in Advance, Richard Tag: SqlException: Unknown Error Tag: 102190
  - 11
    - Connection as a static class Is it alright if I took a static class that wrapped around a SQLConnection object on a web application? Or should I make it an instance class? If I have a static class, would there be just one code instance of the class in the server process/app domain for all the clients/browsers? So, if a page on a particular request/context does a MyConnectionClass.Close() in its Unload event handler for the Page, would this close the connection for all clients if it were implemented as a static class? Tag: SqlException: Unknown Error Tag: 102187
  - 12
    - *this* keyword Does the *this* keyword refer to the class or the instance? Tag: SqlException: Unknown Error Tag: 102185
  - 13
    - Debugging issue Hi, Is there a way of debugging a web application other than hitting F5 on VS .NET. I have a box that has less RAM and the bloody application dies on me. it makes me put my hair. I want to debug my application to check whether my application is taking correct values. Thanks, Stephen Tag: SqlException: Unknown Error Tag: 102172
  - 14
    - Problem with serializing multiple collections with a base class I have the following code. When I serialize the DriverCollection I would like to get both the Driver Collection and the DeletedItems collection. I end up with only the Driver collection. I have tried numerous attributes with no success. Any help would be appreciated... using System; using System.IO; using System.Text; using System.Xml; using System.Xml.Serialization; using System.Runtime.Serialization; using System.Runtime.Serialization.Formatters.Binary; using System.Collections; namespace SerialTest { #region BusinessObjectBase /// Summary description for BusinessObjectBase. /// </summary> [Serializable()] public abstract class BusinessObjectBase { public BusinessObjectBase() {} } #endregion //BusinessObjectBase #region BusinessObjectCollectionBase /// <summary> /// Summary description for BusinessObjectCollectionBase. /// </summary> [Serializable()] public class BusinessObjectCollectionBase : CollectionBase { public DeletedItemCollection _deletedItems = new DeletedItemCollection(); public BusinessObjectCollectionBase() {} public DeletedItemCollection DeletedItems { get{return _deletedItems;} set{_deletedItems = value;} } } #endregion //BusinessObjectCollectionBase #region DeletedItemCollection /// <summary> /// Summary description for BusinessObjectCollectionBase. /// </summary> [Serializable()] public class DeletedItemCollection : CollectionBase { #region Constructors public DeletedItemCollection() {} #endregion public BusinessObjectBase this[int index] { get{return (BusinessObjectBase)List[index];} set{List[index] = value;} } public int Add(BusinessObjectBase value) { return List.Add(value); } } #endregion //DeletedItemCollection #region DriverCollection /// <summary> /// Summary description for DriverCollection. /// </summary> [Serializable()] public class DriverCollection : BusinessObjectCollectionBase { #region Constructors public DriverCollection() {} #endregion #region IListMethods public Driver this[int index] { get{return (Driver)List[index];} set{List[index] = value;} } public int Add(Driver value) { return List.Add(value); } public bool Contains(Driver value) { return List.Contains(value); } public bool Contains(int driverNumber) { Driver d = GetDriver(driverNumber); return d == null ? false : Contains(d); } public bool ContainsDeleted(int driverNumber) { foreach(BusinessObjectBase bob in _deletedItems) { Driver d = (Driver)bob; if(d.Number == driverNumber) return true; } return false; } public int IndexOf(Driver value) { return List.IndexOf(value); } public int IndexOf(int driverNumber) { Driver d = GetDriver(driverNumber); return d == null ? -1 : IndexOf(d); } public void Remove(Driver value) { List.Remove(value); } public Driver GetDriver(int driverNumber) { for(int i = 0; i < this.Count; i++) if(this[i].Number == driverNumber) return this[i]; return null; } public void DeleteDriver(int driverNumber) { Driver d = GetDriver(driverNumber); Remove(d); _deletedItems.Add(d); } #endregion } #endregion //DriverCollection #region Driver /// <summary> /// Summary description for Driver. /// </summary> [Serializable()] public class Driver : BusinessObjectBase { #region Constructors public Driver() { } #endregion #region Number int _number = 0; public int Number { get{return _number;} set { if(value != _number) { _number = value; } } } #endregion } #endregion //Driver /// <summary> /// Summary description for Class1. /// </summary> class Tester { /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main(string[] args) { DriverCollection drivers = new DriverCollection(); Driver driver1 = new Driver(); Driver driver2 = new Driver(); Driver driver3 = new Driver(); Driver driver4 = new Driver(); driver1.Number = 1; drivers.Add(driver1); driver2.Number = 2; drivers.Add(driver2); driver3.Number = 3; drivers.Add(driver3); driver4.Number = 4; drivers.Add(driver4); drivers.DeleteDriver(2); drivers.DeleteDriver(3); //**************************** // XML serialization //**************************** // Creat a Serializer try { XmlSerializer serializer = new XmlSerializer(typeof(DriverCollection)); // Create an XmlTextWriter using a FileStream. Stream fs = new FileStream(@"C:\NewPolicy.xml", FileMode.Create); XmlWriter writer = new XmlTextWriter(fs, Encoding.Unicode); // Serialize using the XmlTextWriter. serializer.Serialize(writer, drivers); writer.Close(); } catch (System.Exception e) { throw e; //Handle exception here } } } } -- Gonzo Tag: SqlException: Unknown Error Tag: 102168
  - 15
    - regasm issue, VB.net com dll I have created a DLL using VB.net for com interopt for use within my VB6 application. It works fine on my machine - I run the regasm, it registered and drag the dll in to the assembley folder. However, when I distribute the DLL to a end-user machine witht the .NET 1.1 framework I have some issues. Obviously, the COM isnt registered so I get a ActiveX can't crate obkjct error in my VB6 app. So, I go and try to run regasm to register it.. but when I run regasm, it's not a reconized interneal or external command in windows XP. RegAsm is in the .NET framework folder, so I assume the windows PATH enviroment variable is not pointing to this path. So, how do I distributee and regasm a dll file? How do I determine the path the regasm? Thanks Jason Roozee Tag: SqlException: Unknown Error Tag: 102167
  - 16
    - Otpimization of vb.net application using NTD Hi All, We had developed a .Net application which has the following environment Uses the No touch deployment concept Uses framework 1.1 on client and server machine, Visual studio 2003, Sql server 2000, Deployed on a windows 2003 box. Reporting is done using Crystal reports 10 A third party component grid from DevExpress has been used on all the forms in the application. And the No touch deployment exe uses webservice hosted on the web server which call the .net dlls for communicating with the database which is hosted on its own machine. We use SOAP for validation. All of my tables have indexes on them. Application uses customized SOAP headers to communicate with the webservice. The application is deployed over the internet in CT and the client is using it in Houston over the internet using a T1 connection. Most of the times it is ok, but at time the performance of the application, which depends a lot on the speed of the internet connection is very slow. Very soon we are going international on this application which mean that there would be clients in Europe, Asia who would be using our application hosted in CT. My question is considering this environment the application is developed and deployed in, can any one suggest ways of optimizing this .net application, either database wise or .net optimization or configuration. I know there is already a latest framework out there, 2.0(if I am no wrong), can any one give me reviews on it and also tell me if in any way it optimize the application to run any faster. Thanks Muzammil Tag: SqlException: Unknown Error Tag: 102166
  - 17
    - .net exception 'profiler'? Does anyone know how I might be able to find all the possible external method calls of my app (external meaning calls to assemblies that I have not written) that could possible throw execeptions? Do any tools exist to do this? I'm not sure what such a tool might be called...an exception profiler? Thanks, Jason Tag: SqlException: Unknown Error Tag: 102162
  - 18
    - Information on Input Button Hi all, I have an input button <input type="button" id="Button2" name="Button2" value="More" onclick="openPage()"> this input button onclick opens another page. this "More" button is for additional information only (say I have extra notes), and if there is none available then it should not appear. How can i make this button visible or invisible? Thanks, Stephen Tag: SqlException: Unknown Error Tag: 102159
  - 19
    - System.Treading.Timer stops firing events Hi everybody. Recently I ran into situation with System.Threading.Timer in my ASP.NET application. I reinstalled Windows on one of my servers and got timers stop firing events after while, they just stop functioning one-by-one. Here is detailed explanation. I run application on 2 dedicated Win 2003 servers. Server A serves about 1000 active simultaneous users (150-200 aspx page requests per second), Sever B serves about 400 users (80-100 aspx requests per sec). Application is the same. Machine.config is identical. maxWorkerThreads and maxIOThreads bumped to 40. minFreeThreads = 8. There are about 25 static timers throuout the application and there are some dynamicly created timers. Recently I realized that hosting company did not install SP1 for some reason, but applied critical hotfixes. I asked to reinstall OS on the servers, so far they did it on server B. Now, after installing Win 2003 on server B, with SP1 and all recent updates, and installing my application there, I'm getting my timers stop working. Possible exceptions in timer events are silenced. Logging shows that timers work normally for a few minutes and then next event just never happens. If I force timer by calling it's Change method, it works for a few minutes and then dies again. Below is simplyfied code sample and a result log. Again, it works fine on Win 2003 without servicepack, and does not on Win 2003 SP1. The timers are not accessed from any other place, they are being created on app init and then managed in Change method in timed event (see code). Eventlog does not show any threads being terminated. Also, I noticed that even though .Net version is the same on servers A and B (1.1.4322.573), the behavior is a bit different. In particular, on server A bad viewstate causes exception with message "The viewstate is invalid for this page and might be corrupted." while on server B exception message includes as well client IP, requested URL, and viewstate. Does anybody have any idea what all this about? Any hint? For now I had to shut down server B and let server A handle all the work. I've had similar problem with System.Timers.Timer before. Since I switched to System.Threading.Timer, it was gone. And now... ups... Code sample. Global.asax.cs namespace VR { public class Global : System.Web.HttpApplication { private Common.AppTimers appTimers; protected void Application_Start(Object sender, EventArgs e) { appTimers = new Common.AppTimers(); } } } vrTimers.cs using System; using System.Threading; namespace VR.Common { public class AppTimers { private Timer tmTimedWork; static private AppTimers appTimers; public AppTimers() { try { VR.Logger.Log(VR.enumLogs.Logic, "Init timers"); tmTimedWork = new Timer(new TimerCallback(OnTimedWork), null, 7000, 10000); appTimers = this; } catch(Exception ee) { VR.Logger.Log(VR.enumLogs.Logic, "AppTimers(): " + ee.Message); throw; } } public void OnTimedWork(object source) { VR.Logger.Log(VR.enumLogs.Trace, "OnTimedWork begin"); try { tmTimedWork.Change(120000, 600000); lock(tmTimedWork) { long period = SomeClass.SomeStatic() * 1000; tmTimedWork.Change(period, period); VR.Logger.Log(VR.enumLogs.Trace, "OnTimedWork end "+period.ToString()); } } catch (Exception ee) { tmTimedWork.Change(5000, 5000); VR.Logger.Log(VR.enumLogs.Logic, "OnTimedWork: "+ee.Message); } } } } The log looks like this: 8/31/2005 4:37:46 AM: OnTimedWork begin 8/31/2005 4:37:46 AM: OnTimedWork end 1000 8/31/2005 4:37:47 AM: OnTimedWork begin 8/31/2005 4:37:47 AM: OnTimedWork end 1000 8/31/2005 4:37:48 AM: OnTimedWork begin 8/31/2005 4:37:48 AM: OnTimedWork end 1000 8/31/2005 4:37:49 AM: OnTimedWork begin 8/31/2005 4:37:49 AM: OnTimedWork end 1000 8/31/2005 4:37:50 AM: OnTimedWork begin 8/31/2005 4:37:50 AM: OnTimedWork end 1000 8/31/2005 4:37:51 AM: OnTimedWork begin 8/31/2005 4:37:51 AM: OnTimedWork end 1000 8/31/2005 4:37:52 AM: OnTimedWork begin 8/31/2005 4:37:52 AM: OnTimedWork end 1000 8/31/2005 4:37:53 AM: OnTimedWork begin 8/31/2005 4:37:53 AM: OnTimedWork end 1000 8/31/2005 4:37:54 AM: OnTimedWork begin 8/31/2005 4:37:54 AM: OnTimedWork end 1000 Dmitry. Tag: SqlException: Unknown Error Tag: 102158
  - 20
    - .NET Programmer Required I need one .NET rockstar for my company. I could pay from Rs.3.6 lakh p.a going upward if I get the right guy. There is no upper limit if you are a rockstar, I would be happy to "invest" in you. You must be willing to relocate to Delhi/NCR/Noida. If you are interested, email me at Sathyaish at yahoo dot com. .NET PROGRAMMER SPECIFICATION Number of resources required: 1 Number Of Years Experience: Not an issue. Anyone with at least one project done in .NET. Level: Advanced Job Profile: Will be an individual contributor to a client, or at the most would work with one other team member. Will talk to the client, understand project requirements, plan the code and database schema and then write the code. Required Skill: Shall have to have good communication skills. Should be able to write code independently for the entire project, although he might not be required to do it alone. Should know how to design databases, understand requirements, think of class/object design and then write the code for it. If he's a pure VB chap, he must've familiarity with even the C++ syntax, as in he must easily be able to switch between C# or VB.NET syntax. This is a minor thing, but let's get it in. Must've a sound knowledge of low-level concepts, strong logical reasoning and analytical skills. Preferred Skills: It will be nice if the candidate knows about converting content into different formatting specifications such as Rich Text Format, XML, PostScript, PDF etc. Even if he doesn't have the expertise, he must be a quick learner to acquire any new skill soon by working hard towards it. Education: Not an issue. Anyone who knows how to write code will do. Tag: SqlException: Unknown Error Tag: 102155
  - 21
    - .NET Programmer Required I need one .NET rockstar for my company. I could pay from Rs.3.6 lakh p.a going upward if I get the right guy. There is no upper limit if you are a rockstar, I would be happy to "invest" in you. You must be willing to relocate to Delhi/NCR/Noida. If you are interested, email me at Sathyaish at yahoo dot com. .NET PROGRAMMER SPECIFICATION Number of resources required: 1 Number Of Years Experience: Not an issue. Anyone with at least one project done in .NET. Level: Advanced Job Profile: Will be an individual contributor to a client, or at the most would work with one other team member. Will talk to the client, understand project requirements, plan the code and database schema and then write the code. Required Skill: Shall have to have good communication skills. Should be able to write code independently for the entire project, although he might not be required to do it alone. Should know how to design databases, understand requirements, think of class/object design and then write the code for it. If he's a pure VB chap, he must've familiarity with even the C++ syntax, as in he must easily be able to switch between C# or VB.NET syntax. This is a minor thing, but let's get it in. Must've a sound knowledge of low-level concepts, strong logical reasoning and analytical skills. Preferred Skills: It will be nice if the candidate knows about converting content into different formatting specifications such as Rich Text Format, XML, PostScript, PDF etc. Even if he doesn't have the expertise, he must be a quick learner to acquire any new skill soon by working hard towards it. Education: Not an issue. Anyone who knows how to write code will do. Tag: SqlException: Unknown Error Tag: 102154
  - 22
    - Logging & Instrumentation App Block & ASP I'm using the June release of the logging & instrumentation block. I have two categories set up, each logs to a different sink (one goes to the application log, the other to a text file.) When I run my test code as a regular windows app, everything works fine. When it runs from within a web service, I only see the message to the event log - the text file never gets created. I don't see any errors, and the second message does not show up in the application log as it would if there were an error. What am I missing here? Thanks, Bryan Tag: SqlException: Unknown Error Tag: 102152
  - 23
    - C# Developer role, NYC Finance 1. IR Derivative Systems C# Developer The candidate should be a senior software developer with min of 2 years experience in C# programming. The etrade team is currently involved in a number of projects but the main focus for next year will be delivering increased trading automation . Working with the Bond Technology team, we aim to deliver automated pricing, quoting, trading and risk management tools, services and systems. The candidate will be expected to take an active role in the design, development, testing and delivery of the system, which are principally written in C# Required Skills: min 2 years commercial experience developing C# (Windows Forms) GUIs firm understanding of the .Net framework and a good working knowledge of the .Net SDK and API Familiarity with GUI design patterns and data binding techniques Understanding of .Net data structures esp. those used in ADO.Net (e.g. DataSet, DataTable, DataView) Multithreaded code development experience esp. with regard to UI programming Pluses: Familiarity with vendor products (e.g. Syncfusion, Infragistics) esp with regards to grids Familiarity with building distributed systems using SOAP/ XML messaging and pub/ sub middleware Familiarity with Visual C++ and the Windows API Contact Kevin M McGann 212 624 9187 kmcgann@cpi-search.com Tag: SqlException: Unknown Error Tag: 102150
  - 24
    - Yeah! proud to be me! Today Americans celebrated their ceremony of slaughtering Iraqi people. Thanks to all you American people. Thanks to you B.U.Sh. Thanks people of liberty and democracy. Thanks for your justice. Thanks for the lies about terrorism you sell the world. And thanks for the weapons of mass destruction that your GREAT army of the globe discovered in Iraq. Lets tell lies, more and more. Lets kill more innocents, and more women and children in the uncivilized world. So that you American might live happily for ever, and in peace...( in your dreams) Now it is time to shout "Yeah! I am proud to be an American" Tag: SqlException: Unknown Error Tag: 102140
  - 25
    - Executing Assemblies on Shared Paths Hi, We are a software development team for a retail company, all of the programs we develop are for use internally on our network. Recently, we have moved towards thin-client technology with everyone running remote desktops using Citrix. This proves to be troublesome when deploying - only domain administrators can actually install anything onto the Citrix Server itself. Since we have a farm of about 30 servers, we have to schedule in a deployment date & ensure the Citrix team carry out the install correctly and replicate it across all servers! We've got around this in the past by deploying onto a network share that has user specific data in. Eg; \\SharePath\data\UserName\Program Files\MyExecutable.exe This ensures we are in control of our programs, we have an auto-update program that rolls out any fixes or amendments we have made to programs - there is no major delay in rolling out a new version. In the .Net framework, there are security issues when running from a shared network drive. What is the best approach to allow us to continue to run an executable from a share path, using resources located locally on the Citrix Server? We have a Strong Name key file for our department that we sign all of our programs with. If the Citrix team amend the security configuration for the .Net framework on each of the servers, can we trust all assemblies signed with our Strong Name Key so that they can run from network shares (as in .7 of .NET Framework Enterprise Security Policy Administration and Deployment FAQ?) Is this the best approach to allow us to continue share deployment? Thanks Tag: SqlException: Unknown Error Tag: 102130

I have some code doing a very simple select "select bonusid from game where
gameid=@gameid" that works about 98% of the time, but somewhere around two
percent of the time it throws an exception. If I go through the sqlerror's
in the exception all it has is the following:

Index #0
Message: Unknown error.
LineNumber: 0
Source: .Net SqlClient Data Provider
Procedure:

Not very interesting is it. I've checked that the input is valid and I have
no problems running the same query manually. I also have yet to find a
consistent way to recreate this error but my clients are having no problems
doing it fairly frequently with no rhyme or reason that I can tell.

Although there are many clients simultaneously using the server they share
one database connection but I am very careful to only use the connection
through a wrapper class that Lock()'s the database connection. I'm really
lost on this one, has anyone else seen this? I could find next to nothing
on google/google groups.

Lloyd Christopher
SLOW30

Top

Re: SqlException: Unknown Error by Mary

Mary
Tue Sep 06 11:42:24 CDT 2005

Without seeing the code and not really understanding your environment
or the technique you are using to "lock" the database connection, it's
hard to guess at what the problem might be. I'd recommend putting a
SQL Profiler trace on it and see if you can pinpoint where it's
failing (when it does fail).

--Mary

On Sat, 03 Sep 2005 00:49:19 GMT, "Lloyd" <lloydspamsodoff@slow30.com>
wrote:

>I have some code doing a very simple select "select bonusid from game where
>gameid=@gameid" that works about 98% of the time, but somewhere around two
>percent of the time it throws an exception. If I go through the sqlerror's
>in the exception all it has is the following:
>
>Index #0
>Message: Unknown error.
>LineNumber: 0
>Source: .Net SqlClient Data Provider
>Procedure:
>
>Not very interesting is it. I've checked that the input is valid and I have
>no problems running the same query manually. I also have yet to find a
>consistent way to recreate this error but my clients are having no problems
>doing it fairly frequently with no rhyme or reason that I can tell.
>
>Although there are many clients simultaneously using the server they share
>one database connection but I am very careful to only use the connection
>through a wrapper class that Lock()'s the database connection. I'm really
>lost on this one, has anyone else seen this? I could find next to nothing
>on google/google groups.
>
>Lloyd Christopher
>SLOW30
>

Top