HOW TO CONNECT TO SQL SERVER 2000 DATABASE

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
    - A challenge to all MVP's.......GET A J.O.B. for once in your life You guys who hang around here are some of the sorriest and most incompetent programmers( if you can even be called that) ever!!! The only thing you know are reference books and theory that's been proven wrong in the real world You sit in front of your computer answering the SAME nickel and dime questions day after day, week after week, year after year so you can't possibly have any real experience in making an actual program and all you do is give BAD advice to those seeking it here. As far as I am concerned, Microsoft should end the MVP program as all that it fosters is wanna be programmers who only give bad advice and never DO as they ADVISE. You have essentially ZERO experience in coding .NET to begin with. DEAR MICROSOFT: Kill off the MVP program. It only fosters people who strive for publicity in trying to get a programming job as opposed to being actually able to do the job. The MVP's only make programmers and the software industry look bad as a whole as these people are supposed to be MOST VALUEABLE....when in they in fact are the MOST WORTHLESS programmers ever, especially when they actually do get a job they only sit around with theory, and all that nonsense of architecture and best practices only to not even deliver the project to begin with. Why not put all that theory and knowledge to the test and actually see if it really works? Ha ha ha..like you can even do that? All these people do is get silly certification and they STILL CANNOT GET A JOB!!! Much less actually do the job.....Imagine that!!! It's no wonder companies go off shore, as the quality of software sucks anyway, so why pay extra in the US when it's going to be late, buggy and not what the customer wanted anyway. MESSAGE TO MVP's: WAKE UP!!! START DOING SOME REAL WORK or someone will make sure the world knows how incompetent you MVP's are and if you think you will have a hard time now flashing your MVP and Certification letters around, wait till they know the real truth about you and will think twice about even mentioning you have a certification or MVP status......and no talking in front of user groups don't count as most those groups are also like you, unemployed, can't get the job done right. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97472
  - 2
    - how to marshal an array of unmanaged structure into a managed array of structures. Hi, I am writing some code to Interop with COM=2E I have to= determine the parameters of COM function and I am using= FUNCDESC structure from typelibrary=2E My question is how to= marshal the lprgelemdescParam array structures=2E I have the= following code from another post in dotnet247=2E What I am trying to do is to print the function declaration= defined by FUNCDESC structure in =2Enet=2E Has anyone done this ? IntPtr ElementDescriptionArrayPtr =3D funcdesc=2ElprgelemdescParam; int ElementDescriptionSize =3D Marshal=2ESizeOf(new= COM=2EELEMDESC()=2EGetType()); for (int i =3D 0; i < funcdesc=2EcParams; i++) { COM=2EELEMDESC ElementDescription; int ElementDescriptionAddress; int ElementDescriptionArrayByteOffset; IntPtr ElementDescriptionPointer; ElementDescription =3D new COM=2EELEMDESC(); ElementDescriptionArrayByteOffset =3D i *= ElementDescriptionSize; ElementDescriptionAddress =3D= ElementDescriptionArrayPtr=2EToInt32(); ElementDescriptionAddress +=3D= ElementDescriptionArrayByteOffset; ElementDescriptionPointer =3D= (IntPtr)(ElementDescriptionAddress); ElementDescription =3D= (COM=2EELEMDESC)(Marshal=2EPtrToStructure(ElementDescriptionPointer,= = typeof(COM=2EELEMDESC))); string paramstring =3D= GetStringFromTypeDesc(typeinfo, ElementDescription=2Etdesc); builder=2EAppend(paramstring); if (i < funcdesc=2EcParams - 1) { builder=2EAppend(", "); } } Is this the correct way to do this ? I am not sure if I am= getting correct values back when I executed the above code? I= would appreciate any help on how to marshal an array of= unmanaged structure into a managed array of structures=2E Thanks -Arul -------------------------------- From: amags kumar ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>W5ImLKlkBk2TMJmjnBXagQ=3D=3D</Id> Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97469
  - 3
    - Simple architecture question. Hi I have forty clients applications in different places of the city, they connect to a DB via Internet, until now the clients report information and receive information only when they read the DB.(half duplex) Now I need to be able to send information from the server to the clients using a central Application, I need to send things like messages, enable and disable options from the server . The Internet network is from an ISP and the server is DHCP. How can I send Data to the clients from the server? Do I need a VPN? IP fixed? any sug, any link, any documentation? thks a lot Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97468
  - 4
    - issue sending mail... When sending mail, I sometimes receive the error msg: "Could not access 'CDO.Message' object." I see in my SMTP log that I connect, hold the connection open for 4-5 min and then disconnect doing nothing. I see that I connect to this mailserver in other cases successfully, so I know that the mail server is not at fault. What could I be doing wrong? Thanks for the help. --gloria --------------------- MailServ58-US 06/02/2005 07:54:19 PM SMTP Server: xxx.xxx.com(xx.xx.xx.xx) connected MailServ58-US 06/02/2005 07:59:47 PM SMTP Server: xxx.xxx.com(xx.xx.xx.xx) disconnected. 0 message[s] received --------------------- MailMessage Message = new MailMessage(); Message.To = emailaddressStr; Message.From = this.FromEmailAddressStr; Message.Subject = emailsubjectStr; Message.Body = emailbodyStr; if (attachmentStr != "" ) { if (! File.Exists(attachmentStr) ) { RecordError(CurrentFunction,"Sending Email","Data", "Cannot attach file that does not exists.","","Cannot attach file: " + attachmentStr); return; } try MailAttachment myAttachment = new MailAttachment(attachmentStr); Message.Attachments.Add(myAttachment); } catch (Exception ex) { RecordError(CurrentFunction, "Sending Email", "System", "Could not attach file.", ex.Message, "File: " + attachmentStr + " Full error message output: " + ex.ToString()); return; } } try { SmtpMail.SmtpServer = this.MailServer; SmtpMail.Send(Message); } catch (System.Web.HttpException ehttp) { if (sendtologI == 1) { RecordError(CurrentFunction, "Sending Email", "System", "Could not send mail", ehttp.Message, "Full error message output: " + ehttp.ToString()); this.WriteLine(0,CurrentFunction,"Could not send email. Error Message: " + ehttp.ToString(),0); } } Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97467
  - 5
    - Strange Excel importing problem I have a routine that imports a list of part numbers into a dataview: strExcel = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & boxFile.Text & ";Extended Properties=""Excel 8.0;HDR=NO""" cnnExcel = New OleDbConnection(strExcel) da = New OleDbDataAdapter("Select * from [ODRJYUFI$]", cnnExcel) da.Fill(ds, "Excel") dv = New DataView(ds.Tables("Excel")) This works fine exept when the following condition happens: The part numbers are alpha-numeric. When a numeric only part number (mixed in with alpha's) is read in, NULL is stored. The routine will read in numeric values ONLY when all the part numbers in the spreadsheet are numeric. I've tried formatting the column in the spreadsheet as Text to try and trick the routine, with no luck. Any suggestions? Thanks Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97460
  - 6
    - TextBox .text value will not update I have several TextBoxs in a datalist control and am allowing a user to make changes to them. Everything works fine but when I execue the update command for the datalist and use the FindControl method to read the value of the text box the changes made by the user are lost and the value is what was originally placed there by the databind function. I have seen samples for what I am attempting and I am using it exactly as they are. Has anyone else had this problem? I am pulling out my hair with this because it's taking me so long. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97459
  - 7
    - Windows service Unable to access mapped drives on XP and 2003 Boxe I have written a Windows Service which enumerates the files in a directory. I am trying the enumerate the files of a mapped drive.It works fine on a windows 2000 Box.But the same ,does'nt work on a xp or a 2003 machine. Any Ideas why it would do that??? Thanks MVB Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97455
  - 8
    - shdocvw ow resolve this http://www.tech-archive.net/Archive/DotNet/microsoft.public.dotnet.framework.interop/2004-06/0294.html i put [STAThreadAttribute()] or [STAThread()] int he main() but don't work.... thank Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97454
  - 9
    - My application works fine in debug mode but does not work in release I have an application that works correctly in debug mode but it does not work in release. I am not using anything of the class system.diagnostics. I tried to disable the optimization code, but this did not work please I need a solution quickly!!. Thanks. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97447
  - 10
    - Finalize Queue (WinDBG / SOS) All, I am playing with WinDBG and SOS. If I run !FinalizeQueue I get SyncBlock to be cleaned up: 0 ---------------------------------- generation 0 has 6 finalizable objects (0x0015a370->0x0015a388) generation 1 has 0 finalizable objects (0x0015a370->0x0015a370) generation 2 has 0 finalizable objects (0x0015a370->0x0015a370) Ready for finalization 0 objects (0x0015a388->0x0015a388) All Finalizable Objects Statistics: MT Count TotalSize Class Name 0x00935120 3 36 ConsoleApplication12.GoodClass 0x79bd9a14 3 156 System.IO.StreamWriter why do i see GoodClass? i have called dispose on this, see my code at the end. I am trying to workout if my very large app is disposing objects correctly, using winDBG sugested that it wasent, but i was sure that it was, so i wrote this test project and it also does not seam to dispose objects. Here is the code : using System; using System.Threading; namespace ConsoleApplication12 { class BadClass { public BadClass() { System.Console.WriteLine("Hello"); } ~BadClass() { System.Console.WriteLine("Sleep"); Thread.Sleep(Timeout.Infinite); } } class GoodClass : IDisposable { public GoodClass() { System.Console.WriteLine("Hello"); } ~GoodClass() { System.Console.WriteLine("Sleep"); Thread.Sleep(Timeout.Infinite); } #region IDisposable Members public void Dispose() { // TODO: Add GoodClass.Dispose implementation System.Console.WriteLine("Bye "); GC.SuppressFinalize(this); } #endregion } class EntryPoint { static void Main(string[] args) { /* BadClass b1 = new BadClass(); BadClass b2 = new BadClass(); BadClass b3 = new BadClass(); */ GoodClass g1 = new GoodClass(); GoodClass g2 = new GoodClass(); GoodClass g3 = new GoodClass(); g1.Dispose(); g2.Dispose(); g3.Dispose(); /* System.GC.Collect(); System.GC.Collect(); System.GC.WaitForPendingFinalizers(); */ Console.WriteLine("Done"); Console.ReadLine(); } } } Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97445
  - 11
    - Parameter Methods Performance (val,ref,out) Hi, I would like to know which one of the following parameter types is faster. I think is ref because sending a pointer to a class seems to be much more faster then copy all the class at once in the method call. But when I was having classes about C# programming in Microsoft Official Course, my teacher told me that in .NET val is faster, that's why it is the default parameter type. But he couldn't explain why. Any ideas? Thank you. Roby Eisenbraun Martins Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97441
  - 12
    - article 829977 - A memory leak condition occurs when you run COM+ article 829977 - A memory leak condition occurs when you run COM+ 1.0 on a computer that is running Windows 2000 SP4 When trying to run the hotfix for this on windows 2000 server, I'm having a problem. It doesn't run on windows 2000. Do you have a solution for this problem? - EJ Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97428
  - 13
    - Detecting overriding with reflection? Given a System.Type, I would like to detect whether the method object.GetHashCode() has been overriden or not ? How can I achieve that with reflexion? I have read the MethodBase documentation, but I do not see any solution for now. Thanks in advance, Joannès http://www.vermorel.com Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97426
  - 14
    - String manipulation I am using Microsoft.VisualBasic.Strings.InStr() and Microsoft.VisualBasic.Strings.Mid() to manipulate strings. Is there a better way ? i.e. by using the framework. Thanks, Craig Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97424
  - 15
    - How to tell if PropertyInfo defines a static or instance property Given a PropertyInfo object, how can I determine if the property that it describes is a static or instance property? The same question applies to EventInfo. MethodInfo, ConstructorInfo and FieldInfo all have an IsStatic member, but PropertyInfo and EventInfo do not have this member, which seems a bit strange. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97423
  - 16
    - Process.Start("MyComputer"); Hi, I'm trying to launch an instance of explorer from windows that will default to the "My Computer" branch. Any suggestions? I've tried: string myComp = Environment.SpecialFolder.MyComputer.ToString(); System.Diagnostics.Process.Start(myComp); which fails, is there a special folder that i can give to explorer as an argument? Thanks Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97421
  - 17
    - Checking for implementation of an interface I have an application that accepts plugins. It allows the user to choose which plugins they want to run from a list of available plugins. My problem is that I need to build that list of plugins by checking the assemblies in the plugins folder to see if they implement the plugin interface. If I load each assembly and check it, then I have all those assemblies in memory until the application gets shutdown, even though the user may only want to use a few of them. My idea was to load them all into a separate appdomain to check them and build my list, and then unload that domain. Then I could just load the plugins that the user chooses. My problem is that I don't know how to check the assembly to see if it implements the plugin interface once its loaded into the separate appdomain. Can anyone point me to an article on this, or some sample code? Thanks! Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97414
  - 18
    - EnvDTE and EnvDTE80 I am using Visual Basic Express (May release) and I am trying to create a solution programatically. How do I do this? I know I need to use the AddFromTemplate but how do I determine the path to the template that I want to use, let's say the template is the "winfxapplication" template, which on my machine is "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\VBExpress\ProjectTemplatesCache\1033\WindowsApplication.zip\windowsapplication.vstemplate" Or do I point it at the .vbproj file: "C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\VBExpress\ProjectTemplatesCache\1033\WindowsApplication.zip\windowsapplication.vbproj" I'm assuming there are just a few lines of code required. First of all, I want to create a VS2005 object. I have tried: Dim env As EnvDTE80.DTE2 = CType(Microsoft.VisualBasic.Interaction.CreateObject("VisualStudio.DTE.8.0", ""), EnvDTE80.DTE2) but that tells me it cannot create the ActiveX object. I then tried: Dim env As EnvDTE.DTE = CType(Microsoft.VisualBasic.Interaction.CreateObject("VisualStudio.DTE.7.1", ""), EnvDTE.DTE) and that creates the object, so when I do this: ENV.Solution.ADDFromTemplate("C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\VBExpress\ProjectTemplatesCache\1033\WinFXApplication.zip\WinFXApplication.vbproj", "e:\mytests", "myproject.vbproj") I get the message "The file blah blah is not a valid project file. The project file is missing the 'VisualStudioProject' section." whatever that means. I think I am on the right track here, can anybody out there just straighten me out on this? I am starting to tear my hair out. Thanks in advance, Richard Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97413
  - 19
    - Protecting classes with LicenseManager: COM issue Hello, I have a class (C#) in an assembly that I wish to protect with a licensing scheme. The class is designed to be consumed by any other managed code language, and via COM clients. That is, the class is registered for COM interop, and may be instantiated by VBS code, etc. We are using the inherent .NET Framework licensing classes. We've used the LicenseProviderAttribute to specify a LicenseProvider descendent. The LicenseProvider descendent's GetLicense() method checks the LicenseContext for LicenseUsageMode.Runtime or LicenseUsageMode.DesignTime. This works great when the class is being instantiated by a .NET application. We run into a problem when the class is instantiated via COM interop from, say, a VBS script. When started this way, the GetLicense() method LicenseContext argument is _always_ LicenseUsageMode.DesignTime. This upsets the licensing model we want to use. Is this working as designed? I had hoped a class instantiated via COM interop would be seen to be working in LicenseUsageMode.Runtime mode, not LicenseUsageMode.DesignTime. Thanks in advance, Grant Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97411
  - 20
    - How to convert char[] buffer into Image? Hi, Sorry if this question sound stupid, how do I actually convert a char[] buffer into Image? I am currently using C# and compact .net framework for PocketPC development. Thanks for reading. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97404
  - 21
    - VB 6 app calling C# windows service Hi Guys, Has anyone written a windows service in C# that used multiple threads, then wrote a VB 6 application that called the various methods on the C# Service? Any problems with it? Thanks Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97402
  - 22
    - Call was rejected by callee Hi, I am having a problem with a vb.net mappoint application. Currently in my application I have pushpins that move according to GPS locations that are constantly being updated. Everything seems to work fine but when I start using the toolbar functions in the mappoint object while tracking/updating points I always get this following error: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occurred in TrackBerryMapPoint.exe Additional information: Call was rejected by callee. For example, if i use the location search bar while I'm tracking, the find dialog box pops up and then everything crashes. I'm using a timer for the updates of the tracking points and I think that might cause the exception. If anyone has an suggestions I'd appreciate it very much. Thanks Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97398
  - 23
    - Subform ia unexpectedly closing parent form problem Hi, I'm using the .NET environment, writing in C#. I have a windows form application which is causing me a headache. I have a main form and also a subform, when I close the subform, the main form also closes, which obviously terminates the application. I've checked my dialog result from the subform and it's all looking fine. The form was imported from another project with no apparent issues, I'm not sure if this has any thing to do with it? Many thanks for your input. Stuart Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97397
  - 24
    - Some services stop automatically if they have no work to do, for e I got a Server Class in an executable and I would like to change this in a windows service. The code from the main function of the executable is the following: LoadReportingServer server = new LoadReportingServer (); server->Start (); Console::WriteLine (S"Press ENTER to stop the server..."); Console::ReadLine (); server->Stop (); server = 0; I tried to turn this into a service following two tutorials, and it compiles fine. Whenever I start the Service in the Service Manager, I get the Message that my service started and stopped again. Attempt 1: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Diagnostics; using System.ServiceProcess; namespace SoftwareLoadBalancing { public class LoadReportingService : System.ServiceProcess.ServiceBase { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; private LoadReportingServer server; public LoadReportingService() { // This call is required by the Windows.Forms Component Designer. InitializeComponent(); // TODO: Add any initialization after the InitComponent call } // The main entry point for the process static void Main() { System.ServiceProcess.ServiceBase[] ServicesToRun; // More than one user Service may run within the same process. To add // another service to this process, change the following line to // create a second service object. For example, // // ServicesToRun = new System.ServiceProcess.ServiceBase[] {new Service1(), new MySecondUserService()}; // ServicesToRun = new System.ServiceProcess.ServiceBase[] { new LoadReportingService() }; System.ServiceProcess.ServiceBase.Run(ServicesToRun); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { components = new System.ComponentModel.Container(); this.ServiceName = "LoadReportingService"; } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } /// <summary> /// Set things in motion so your service can do its work. /// </summary> protected override void OnStart(string[] args) { // TODO: Add code here to start your service. server = new LoadReportingServer(); server.start(); } /// <summary> /// Stop this service. /// </summary> protected override void OnStop() { // TODO: Add code here to perform any tear-down necessary to stop your service. server.Stop (); server = null; } } } This does not do anything but displaying the message that it started and stopped again. Attempt 2: using System; using System.Collections; using System.ComponentModel; using System.Data; using System.Diagnostics; using System.ServiceProcess; using System.Threading; namespace SoftwareLoadBalancing { public class LoadReportingService : System.ServiceProcess.ServiceBase { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.Container components = null; private ThreadStart threadDelegate; private LoadReportingServer server; public LoadReportingService() { // This call is required by the Windows.Forms Component Designer. InitializeComponent(); // TODO: Add any initialization after the InitComponent call } // The main entry point for the process static void Main() { System.ServiceProcess.ServiceBase[] ServicesToRun; // More than one user Service may run within the same process. To add // another service to this process, change the following line to // create a second service object. For example, // // ServicesToRun = new System.ServiceProcess.ServiceBase[] {new Service1(), new MySecondUserService()}; // ServicesToRun = new System.ServiceProcess.ServiceBase[] { new LoadReportingService() }; System.ServiceProcess.ServiceBase.Run(ServicesToRun); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { components = new System.ComponentModel.Container(); this.CanPauseAndContinue = true; this.ServiceName = "LoadReportingService"; } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } /// <summary> /// Set things in motion so your service can do its work. /// </summary> protected override void OnStart(string[] args) { // TODO: Add code here to start your service. server = new LoadReportingServer(); threadDelegate = new ThreadStart(server.Start); Thread newThread = new Thread(threadDelegate); newThread.Start(); } /// <summary> /// Stop this service. /// </summary> protected override void OnStop() { // TODO: Add code here to perform any tear-down necessary to stop your service. server.Stop (); server = null; } } } This does not do anything but displaying the message that it started and stopped again. What am I doing wrong? Can anybody help me? Thanks in advance Chucker Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97396
  - 25
    - Create forms from threads Hi, I need to be able to create one or more form(s) from a method that is called from different threads. When this form is created, it appears but it does not receive any message. It looks blank, and when you move your cursor over it, it becomes an hourglass. Can anyone help me with this? Thanx in advance... Kind regards, Kevin Chabot Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97392
- Next
  - 1
    - "scrolling buttons" I would like to make some kind of buttons that can be used to scroll other things. Actually it would like it to be exactly as in Lightwave's Envelope Editor - when you push the button, the mouse pointer should disappear and you should be able to scroll something with moving your mouse up/down and left/right. Perphaps hiding mouse wouldn't be that hard [or would it?], but I wonder about "scrolling" itself - I generally use MouseMove event, and in this case the pointer would quickly leave the button's area and i would get no event to handle... What's the best way to deal with that? Thanks for reading this :-) -- michal.'creed'.szostakiewicz............................coder.of.ultimaa... .creed@tarchomin.pl ....................................................... .ms201103@zodiac.mimuw.edu.pl ............................................. .icq.2482112 ...........................iMMersE.your.soUL.in.lOVE......<><. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97391
  - 2
    - Printing using VB.NET Windows Applications Hi. I developed an application in vb.net. This app send any type of file to print. I selected this printer in my app. I use this following codes: Seting default printer before print Public Sub SetDefaultPrinter(ByVal PrintName As String) Dim WshNetwork As Object = CreateObject("WScript.Network") WshNetwork.SetDefaultPrinter(PrintName) WshNetwork = Nothing End Sub Printing the file Public Sub Imprimir(ByVal FileName As String) Dim pr As New Process pr.StartInfo.FileName = FileName pr.StartInfo.Verb = "Print" pr.StartInfo.CreateNoWindow = True pr.StartInfo.WindowStyle = ProcessWindowStyle.Hidden pr.Start() End Sub My problem: I have 2 printers, Printer A and Printer B . In print A I can print, but in print B I cannot. These printers are installed in the network. I can pirnt in the printer B via MS Word. Does anyone know whatÂ´s hapining? Any ideas? Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97389
  - 3
    - 1.1 and 2.0 Can I install the 1.1 framework with the 2.0 framework on the same server and run VS2003 and VS2005 at the same time? I installed 2.0 on a workstation and it looks like the 1.1 framework stayed put. If anyone can clarify this it would be greatly appreciated. Thanks all, Andy Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97388
  - 4
    - ASP.NET lock up Hi. I'm experiening random lockups of my ASP.NET application. I see lots of these error messages from .NET runtime in the event log: The description for Event ID ( 0 ) in Source ( .NET Runtime ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: .NET Runtime version 1.1.4322.2032- Setup Error: Failed to load resources from resource file Please check your Setup. What does this mean and could it be related to the problem? Casper Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97384
  - 5
    - Emit, MarshalAs & PInvoke This is a multi-part message in MIME format. ------=_NextPart_000_00EE_01C56763.DC1E8CA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable (I post this message again, but with a more appropriate title) I have some problem to control finely the signature of some a PInvoke = Method I want to dynamically generate. Let say, if it was staticaly declared it would look like that: --------------------------- struct MyStruct { int a; int b; } [DllImport("dllname", EntryPoint=3D"name", CharSet=3DAnsi)] string MyFunction( [MarshalAs(LPWStr)] string s1,=20 [MarshalAs(LPWStr)] StringBuffer buf, string s2,=20 ref MyStruct m,=20 out int u); --------------------------- I thought of something like that (but the marshall & ref/out information = is missing, hence my question) --------------------------- AssemblyBuilder ab =3D .......; TypeBuilder ab.DefineType("aType", TypeAttribute.Public); MethodBuilder mb =3D tb.DefinePInvokeMethod( "MyFunction", "dllname", "name", MthdAttr.PinvokeImpl | MthdAttr.Static | MthdAttr.Public, CallingConventions.Standart | CallingConvention.Varargs, typeof(string),=20 // how to setup the out/ref/marshallasattribute for the type below? new Type[]{ typeof(string), typeof(StringBuffer), typeof(string), = typeof(MyStruct), typeof(int) }, CallingConvention.Cdecl, CharSet.Ansi ); // for some reason this flag (below) required // of course I want to preserve the Signature, what kind of flag it is = ?!?!?! mb.SetImplementationFlags(MethodImplAttributes.PreserveSig);=20 I think (but not tested yet) that I might solve part of the problem (the = ref/out) with call to mb.DefineParameter(4, ParameterAttributes.Retval, null)=20 mb.DefineParameter(5, ParameterAttributes.Out, null) but=20 1. I'm not sure it will work (a bit difficult to test) 2. what about the ANSI/Unicode marshalling? Any tip? thanks! ------=_NextPart_000_00EE_01C56763.DC1E8CA0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR> <STYLE></STYLE> </HEAD><FONT face=3DArial><FONT size=3D2> <BODY> <DIV> <DIV><FONT face=3DArial size=3D2>(<EM><FONT color=3D#0000ff>I post this = message again,=20 but with a more appropriate title</FONT></EM>)</FONT></DIV> <DIV> </DIV> <DIV><FONT face=3DArial size=3D2>I have some problem to control finely = the signature=20 of some a PInvoke Method I want to dynamically generate.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Let say, if it was staticaly declared = it would look=20 like that:</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>struct MyStruct</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    int a;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    int b;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>[DllImport("dllname", = EntryPoint=3D"name",=20 CharSet=3DAnsi)]</FONT></DIV> <DIV><FONT face=3DArial size=3D2>string MyFunction(</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    [MarshalAs(LPWStr)] = string s1,=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    [MarshalAs(LPWStr)] = StringBuffer=20 buf,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    string s2, = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    ref MyStruct m, = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    out int = u);</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I thought of something like that (<FONT = color=3D#ff0000>but the marshall & ref/out information is missing, = hence my=20 question</FONT>)</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>AssemblyBuilder ab =3D = .......;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>TypeBuilder ab.DefineType("aType",=20 TypeAttribute.Public);</FONT></DIV> <DIV><FONT face=3DArial size=3D2>MethodBuilder mb =3D=20 tb.DefinePInvokeMethod(</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = "MyFunction",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = "dllname",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    "name",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    MthdAttr.PinvokeImpl = |=20 MthdAttr.Static | MthdAttr.Public,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = CallingConventions.Standart |=20 CallingConvention.Varargs,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    typeof(string), = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    <FONT = color=3D#008080>// how to=20 setup the out/ref/marshallasattribute for the type = below?</FONT></FONT></DIV> <DIV><FONT face=3DArial size=3D2>    new Type[]{ = typeof(string),=20 typeof(StringBuffer), typeof(string), typeof(MyStruct), typeof(int)=20 },</FONT></DIV> <DIV><FONT face=3DArial size=3D2>   =20 CallingConvention.Cdecl,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = CharSet.Ansi</FONT></DIV> <DIV><FONT face=3DArial size=3D2>);</FONT></DIV> <DIV><FONT face=3DArial color=3D#008080 size=3D2>// for some reason = this flag=20 (below) required</FONT></DIV> <DIV><FONT face=3DArial color=3D#008080 size=3D2>// of course I want to = preserve the=20 Signature, what kind of flag it is ?!?!?!</FONT></DIV> <DIV><FONT face=3DArial=20 size=3D2>mb.SetImplementationFlags(MethodImplAttributes.PreserveSig);=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I think (but not tested yet) that I = might solve=20 part of the problem (the ref/out) with call to</FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2>mb.DefineParameter(4, = ParameterAttributes.Retval,=20 null)=20 <DIV><FONT face=3DArial size=3D2>mb.DefineParameter(5, = ParameterAttributes.Out,=20 null)</FONT></DIV> <DIV> </DIV> <DIV>but </DIV> <DIV>1. I'm not sure it will work (a bit difficult to test)</DIV> <DIV>2. what about the ANSI/Unicode marshalling?</DIV> <DIV> </DIV> <DIV>Any tip?</DIV> <DIV>thanks!</DIV></FONT></DIV></FONT></DIV></DIV></BODY></HTML></FONT></= FONT> ------=_NextPart_000_00EE_01C56763.DC1E8CA0-- Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97373
  - 6
    - Pass parameter to the popup window Hi, I have 2 webform in vb.NET application. On Webform1, I have one text box1 and one button. on Webform2, I have one text box . I need transfer the value of textbox 1 in webform1 to textbox2 in webform2. and popup webform2 when user click on the button on webform1. I have code in webform1: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Button1.Attributes.Add("onclic=ADk", "window.open('WebForm2.aspx?a=3D=AD" + TextBox1.Text.ToString + "',null,'height=3D250, width=3D250,status=3D no, resizable=3D no, scrollbars=3Dno, toolbar=3Dno,location=3Dno,menubar=AD=3Dn= o ');") End Sub and following code in webform2: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load TextBox1.Text =3D Request("a").ToString End Sub I could not get the result unless I click on the button1 twice. i know what happen in here but have no solution. I will be appreciated if you could help here.=20 Thanks in advanced,=20 Di Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97371
  - 7
    - Emit PInvoke This is a multi-part message in MIME format. ------=_NextPart_000_0095_01C56758.3ADE0920 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have some problem to control finely the signature of some a PInvoke = Method I want to dynamically generate. Let say, if it was staticaly declared it would look like that: --------------------------- struct MyStruct { int a; int b; } [DllImport("dllname", EntryPoint=3D"name", CharSet=3DAnsi)] string MyFunction( [MarshalAs(LPWStr)] string s1,=20 [MarshalAs(LPWStr)] StringBuffer buf, string s2,=20 ref MyStruct m,=20 out int u); --------------------------- I thought of something like that (but the marshall & ref/out information = is missing, hence my question) --------------------------- AssemblyBuilder ab =3D .......; TypeBuilder ab.DefineType("aType", TypeAttribute.Public); MethodBuilder mb =3D tb.DefinePInvokeMethod( "MyFunction", "dllname", "name", MthdAttr.PinvokeImpl | MthdAttr.Static | MthdAttr.Public, CallingConventions.Standart | CallingConvention.Varargs, typeof(string),=20 // how to setup the out/ref/marshallasattribute for the type below? new Type[]{ typeof(string), typeof(StringBuffer), typeof(string), = typeof(MyStruct), typeof(int) }, CallingConvention.Cdecl, CharSet.Ansi ); // for some reason this flag (below) required // of course I want to preserve the Signature, what kind of flag it is = ?!?!?! mb.SetImplementationFlags(MethodImplAttributes.PreserveSig);=20 I think (but not tested yet) that I might solve part of the problem (the = ref/out) with call to mb.DefineParameter(4, ParameterAttributes.Retval, null) mb.DefineParameter(5, ParameterAttributes.Out, null) but=20 1. I'm not sure it will work (a bit difficult to test) 2. what about the ANSI/Unicode marshalling? Any tip? thanks! ------=_NextPart_000_0095_01C56758.3ADE0920 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2900.2627" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV><FONT face=3DArial size=3D2>I have some problem to control finely = the signature=20 of some a PInvoke Method I want to dynamically generate.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Let say, if it was staticaly declared = it would look=20 like that:</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>struct MyStruct</FONT></DIV> <DIV><FONT face=3DArial size=3D2>{</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    int a;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    int b;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>}</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>[DllImport("dllname", = EntryPoint=3D"name",=20 CharSet=3DAnsi)]</FONT></DIV> <DIV><FONT face=3DArial size=3D2>string MyFunction(</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    [MarshalAs(LPWStr)] = string s1,=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    [MarshalAs(LPWStr)] = StringBuffer=20 buf,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    string s2, = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    ref MyStruct m, = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    out int = u);</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I thought of something like that (<FONT = color=3D#ff0000>but the marshall & ref/out information is missing, = hence my=20 question</FONT>)</FONT></DIV> <DIV><FONT face=3DArial = size=3D2>---------------------------</FONT></DIV> <DIV><FONT face=3DArial size=3D2>AssemblyBuilder ab =3D = .......;</FONT></DIV> <DIV><FONT face=3DArial size=3D2>TypeBuilder ab.DefineType("aType",=20 TypeAttribute.Public);</FONT></DIV> <DIV><FONT face=3DArial size=3D2>MethodBuilder mb =3D=20 tb.DefinePInvokeMethod(</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = "MyFunction",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = "dllname",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    "name",</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    MthdAttr.PinvokeImpl = |=20 MthdAttr.Static | MthdAttr.Public,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = CallingConventions.Standart |=20 CallingConvention.Varargs,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    typeof(string), = </FONT></DIV> <DIV><FONT face=3DArial size=3D2>    <FONT = color=3D#008080>// how to=20 setup the out/ref/marshallasattribute for the type = below?</FONT></FONT></DIV> <DIV><FONT face=3DArial size=3D2>    new Type[]{ = typeof(string),=20 typeof(StringBuffer), typeof(string), typeof(MyStruct), typeof(int)=20 },</FONT></DIV> <DIV><FONT face=3DArial size=3D2>   =20 CallingConvention.Cdecl,</FONT></DIV> <DIV><FONT face=3DArial size=3D2>    = CharSet.Ansi</FONT></DIV> <DIV><FONT face=3DArial size=3D2>);</FONT></DIV> <DIV><FONT face=3DArial color=3D#008080 size=3D2>// for some reason = this flag=20 (below) required</FONT></DIV> <DIV><FONT face=3DArial color=3D#008080 size=3D2>// of course I want to = preserve the=20 Signature, what kind of flag it is ?!?!?!</FONT></DIV> <DIV><FONT face=3DArial=20 size=3D2>mb.SetImplementationFlags(MethodImplAttributes.PreserveSig);=20 </FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>I think (but not tested yet) that I = might solve=20 part of the problem (the ref/out) with call to</FONT></DIV> <DIV><FONT face=3DArial size=3D2> <DIV><FONT face=3DArial size=3D2>mb.DefineParameter(4, = ParameterAttributes.Retval,=20 null) <DIV><FONT face=3DArial size=3D2>mb.DefineParameter(5, = ParameterAttributes.Out,=20 null)</FONT></DIV> <DIV> </DIV> <DIV>but </DIV> <DIV>1. I'm not sure it will work (a bit difficult to test)</DIV> <DIV>2. what about the ANSI/Unicode marshalling?</DIV> <DIV> </DIV> <DIV>Any tip?</DIV> <DIV>thanks!</DIV></FONT></DIV></FONT></DIV></BODY></HTML> ------=_NextPart_000_0095_01C56758.3ADE0920-- Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97370
  - 8
    - media player activeX for Win 98 Hello Iâ??m currently developing an windows forms app that will show video via the media player activeX control. Piece of cake using player 9 and the primary interop assembly. But, how do I develop the same for Win 98 using player 6.4? Since I do not have 6.4 on my developing workstation (win 2003 server) I cannot let VS.NET create an interop assembly for me. Is there a way around this? TIA Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97365
  - 9
    - tool to analyze file differences What will be a good tool to analyze file differences Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97362
  - 10
    - .Net Framework 2 Beta 2 Hi Can anyone tell me what version of mscorlib is shipped with the .net framework 2 beta 2? On my machine it is 2.0.0.0 and on a colleagues machine it is 2.0.3600.0. Which is the correct version? I am havineg problems loading .net 1.1 assemblies when I have the .net2 framework installed on my machine and it seems to be because mscorlib is taking into account the "processarchitecture" attribute when creating the reference identity and comparing it with the definition identity which does not have the "processarchitecture" attribute, so it says the referenced file cannot be located. My colleague does not seem to have this issue, but his mscorlib version is 2.0.3600.0 and mine is 2.0.0.0. Regards Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97361
  - 11
    - Transaction code causing runtime exception Hi, I am currently trying write a windows form without much success to implement an enterprise transaction that will encapsulate a write to an oracle database, write a text file and then open a user control in another windows form an collect a response from this. I have been getting the following run-time error 'System.EnterpriseServices.SerÂvicedComponentException' occurred in system.enterpriseservices.dll then i stop the debug application and the following runtime appears at the same point when i run it again. A first chance exception of type 'System.IO.FileNotFoundExceptiÂon' occurred in mscorlib.dll followed by A first chance exception of type 'System.ArgumentException' occurred in mscorlib.dll Additional information: Type passed must be an interface. If i restart the machine i will receive the first error again. I have added a strong name key to the application, also my actual class that contains the transaction does nothing but open the trnsaction and then complete it, but the class resides within the forms executable and not a complied dll. Any help would be greatly appreciated Cheers D Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97359
  - 12
    - SP vs .NET results Hi Can someone give me guidance on the following scenario? I have a windows service application that kicks off a job that perform complex processing and call a stored procedure that run for +- 45 minutes. I need a mechanism to notify the service to throw an exception when the database connection is lost or there's a critical error on the database server. Currently, if there is an error on the database, say db connection, no notification is sent. The windows service fire the jobs using multi-threading. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97358
  - 13
    - Just a question When will managed Windows forms get as fast of their counterparts in C/C++ ? I think if there is only one weak point in dotNet performance, it is its slow win forms, which make Win developers like me to deny the full power of .NET. It is not just the load time that teases, we have too much overhead with heavy treeViews and listViews that sometimes make us giving up the whole project on .NET and going back to C++. Thanks for any help. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97351
  - 14
    - Exit Code 67 I have a fairly simple Windows Forms application developed using C#. It basically listens to two serial ports and displays the results. There are three threads that each listen to a network socket. Additionally there is the GUI thread, the two serial threads, and some threads to process the data from the serial ports. For the serial communications I am using John Hind's NETSerialComm wrapper library. Occasionally, the tool will exit with error code 67. When you look that up, it is listed as "The network name cannot be found." At the time it happens there are no network connections, just three sockets in listen state. It can happen after 12 hours or 3 days. Or not show up for a while. Any insight into why this might happen is appreciated. Dave Uhrenholdt Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97347
  - 15
    - Transaction spanning multiple business classes Hi I have a problem on how to span a transaction over multiple business classes without using COM+ Example: A existing person get an MailingAddress assigned to public class PersonService { public void InsertMailingAddress(data) { //ask the AddressService to insert an address new AddressService().InsertAddress(); //update the person with the ID from the newly inserted address } } As you can see, this should be in a transaction --> Insert Address --> Update Person How can i span this in a transaction without passing sqltransaction objects in the businesslayer? Any ideas??? Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97346
  - 16
    - problems with Microsoft.Enterprise.Library I am trying to use EnterpriseLibrary packages in an IOC pattern. Note on implementation: I have LoggingServiceManager which is tightly bound to a Logging Application Block and implements an interface ILoggingServiceManager. ILoggingServiceManager is contained within an asssembly CommonServiceManager. My intended user (a class cMain) would refer to the CommonServiceManager and using ILoggingManager interface invoke methods of the Logging Application Block. Issue: The Logging Application Block uses run-time binding and hence needs references of Logging Application Block at the cMain level. And this breaks the IOC pattern completely. Has anyone comeacross such a scenario with Application Blocks. this problem occurs with Logging, Caching and Cryptograpghy Application Blocks (so far...). Ranjit Radhakrishnan Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97344
  - 17
    - WinNT and search for computers in NT4 My application needs to enumerate computers on both AD domains and also on existing NT domains. The search of AD domains was a snap, but the WinNT provider errors out telling me you cannot search on this provider. I need to return a list of computers (and distinguish servers fron workstations) in a particular NT domain. Anybody out there run into this? Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97343
  - 18
    - Windows Service Deployment problem I get the following Log in EventLog on attempting to use a custom action to write to a config file in the to be installed application after a call to the base Install method. The description for Event ID ( 11001 ) in Source ( MsiInstaller ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Product: DOILoadWindowsService -- Error 1001. Exception occurred while initializing the installation: System.IO.FileNotFoundException: File or assembly name DOI, or one of its dependencies, was not found.., (NULL), (NULL), (NULL). Without this custom action, the install works OK, with it, it fails every time. The custom action uses CustomActionData as follows: /WATCHED=[WATCH] UPLOADED=[UPLOADED] ERRORS=[ERRORS] ERRORFILE=[ERRORFILE] where the values are collected from a UserInterface TextBox object. Without the custom action, the folders referred to above are created every time but I want the user defined paths to be written to the config file so that they can be accessed by the Windows service when it is started or running. What is going on here? How can I sort this out? cheers -- PeterW Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97340
  - 19
    - Stop WindowsService Application Hi, How can I stop my Windows Service Application. I looked for something like me.close but found nothing equivalent. Thanks, Tony Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97338
  - 20
    - Execution in Visual Studio vs Native Execution With regards to running a project in the Visual Studio developement environment as opposed to executing the exe directly from the hard drive..... I am developing an application in C# using VS.NET 2003...my application seems to respond differently when i run it using the development environment as opposed to when i run it directly from the exe. For instance, in my code i have a try-catch block and inside the try block i explicitly throw an exception and i handle it , for example, with a msg box or something. This works fine when i run it using Visual Studio (even when running a Release build) but when running it directly from the exe the dreaded "An unhandled exception has occurred in your application. If u...etc" dialog box appears. What is the reason for this? I am really stumped and dont know what i can/should do since this is an intergral part of the application. Any help will be greatly appreciated. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97337
  - 21
    - Write to config file from deployment project I have a deployment project where I collect the paths to 4 user defined directories using user interface textboxes that are then mapped to folders in the file system editor that are always created. This all works fine. What I want to do is update the config file for the application so that if any are changed the application will know what those folders are. I have tried to use a Custom action to write the config file but the install override does not seem to be called at all. If you write an override in an installer class, how and where is this called? I have looked at the Walkthrough for Passing Data to a Custom Action but the method never seems to get fired. Any help is appreciated. PeterW Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97334
  - 22
    - Set Time Zone information Hi, I am trying to set the time zone information for a windows machine from a C# application. I have written a wrapper class for win32 api SetTimeZoneInformation and GetTimeZoneInformation. I am able to get all the time zones and the current time zone information. But when I try to set a new time zone information i see that the registry values get updated but the actual windows clock does not display these changes. I also broadcast the WM_SETTINGCHANGE message so all applications know about the changed time zone information, but with no effect. Also how to determine for whether it is daylight saving time from TZI byte values. Can anyone point me to documentation as to how to set the time zone in C# or give some suggestions. thanks in advance. Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97333
  - 23
    - Intercept POST command from ASP.NET My window console application performs a batch processing job in= a certain interval of time=2E It post (HTTP "POST") data in xml= format to my ASP=2ENET application=2E My question is: 1=2E How does my ASP=2ENET application detects if a data is posted to= it ? Is there any event driven stuffs that the ASP=2ENET= application can deal with when a POST is detected ? Put it= simply, my ASP=2ENET app should always be in "listening" mode=2E At= the moment, I am looking into HTTP handler=2E Am I going for the= right direction ? 2=2E How do I extract the xml data posted(by the console= application) from ASP=2ENET app ? Thanks in advance=2E -------------------------------- From: Quest Quest ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>Vh38BH5W+USQwnJspjbOaw=3D=3D</Id> Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97325
  - 24
    - Problem with creating and verifying multipart/signed SMIME messages in c# Does anybody have an idea of creating SMime multipart signed= messages using CAPICOM/C#=2E I have tried the articles given in= the MSDN and other help i founf on internet for changing IL code= for marshalling of BSTR to native int but i want a solution= which does not require any il code modification=2E If anybody can= provide code that would be great=2E Thanks=2E -------------------------------- From: Vinay Pole ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>0qofPgUQxUqI0RgpqK/4sA=3D=3D</Id> Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97321
  - 25
    - DLL (COM) with .Net I need to rebuild a COM Dll, which is consumed by many ASP pages, and desktop applications. By simply calling the CreateObject,... from each application. The requirment is to use the .Net // C# To do a same funtional DLL, While keeping in mind that it should be still accessable from for all application either ASP pages or desktop applications. So what is the type of the project that should use to rebuild this new (DLL) or Webservice,... Regrds -- MCSD not .Net yet :( Tag: HOW TO CONNECT TO SQL SERVER 2000 DATABASE Tag: 97319

Hi Everyone:

I am writing a Pocket PC applicatrion using VB .net 2003. I need to connect
to a remote SQL server database and load records in DataGrid.

Any help in doing so would be very helpfull.

I try ;

Imports System.Data.SqlClient

Dim connection As New SqlConnection(ConnectionString)
Dim adapter As New SqlDataAdapter(mySqlCmd, connection)

But SqlDataAdapter line is not working... Looks like it does not like it. Is
there is a way, we can call a SQL database records to a pocket PC
application. I do not want to used Windows SQL CE though...

Any help, would be good.

Many Many Many Thanks

Top

Re: HOW TO CONNECT TO SQL SERVER 2000 DATABASE by Frans

Frans
Sun Jun 05 04:39:50 CDT 2005

absolute88 wrote:

> Hi Everyone:
>
> I am writing a Pocket PC applicatrion using VB .net 2003. I need to
> connect to a remote SQL server database and load records in DataGrid.
>
> Any help in doing so would be very helpfull.
>
> I try ;
>
> Imports System.Data.SqlClient
>
> Dim connection As New SqlConnection(ConnectionString)
> Dim adapter As New SqlDataAdapter(mySqlCmd, connection)
>
> But SqlDataAdapter line is not working... Looks like it does not like
> it. Is there is a way, we can call a SQL database records to a pocket
> PC application. I do not want to used Windows SQL CE though...

I really wouldn't use an sqlserver 2000 server accessable through
wireless networks. This opens up hack attempts you can't even see.

Most of the time, data is transported from service to ppc and stored
locally in sqlce, then used on hte ppc, saved in sqlce and when you're
ready, replicated back to the sqlserver, via a service, encrypted.

Frans

--
------------------------------------------------------------------------
Get LLBLGen Pro, productive O/R mapping for .NET: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------

Top

RE: HOW TO CONNECT TO SQL SERVER 2000 DATABASE by Mike

Mike
Mon Jun 13 14:17:08 CDT 2005

Where is mySqlCmd declared?

What is the error message Visual Studio is giving you?

"absolute88" wrote:

> Hi Everyone:
>
> I am writing a Pocket PC applicatrion using VB .net 2003. I need to connect
> to a remote SQL server database and load records in DataGrid.
>
> Any help in doing so would be very helpfull.
>
> I try ;
>
> Imports System.Data.SqlClient
>
> Dim connection As New SqlConnection(ConnectionString)
> Dim adapter As New SqlDataAdapter(mySqlCmd, connection)
>
> But SqlDataAdapter line is not working... Looks like it does not like it. Is
> there is a way, we can call a SQL database records to a pocket PC
> application. I do not want to used Windows SQL CE though...
>
> Any help, would be good.
>
> Many Many Many Thanks

Top