mcdonaldn's Q&A profile

• Visual Studio Express Editions newb question, namespaces & application wide database access

  I have been looking through the various documentation and it differs from what I have to type in, and was just wondering why. For instance the documentation says Using connection As New OleDbConnection(connectionString) But to get the same I have to type Using connection As New OleDb.OleDbConnection(connectionString) Am I missing something or is it normal to have to prefix everything with what I assume is the namespace My second question is more of a design issue. In terms of data connections my thoughts are that it would be more efficent to have a persistant data connection for the whole application and pass it to each object I create rather than initiate a new one whenever an object that requires data access is cre ...Show All

• Internet Explorer Development Strange memory read error with BHO

  I have a BHO which launches my Explorer Bar. It has been working fine for some time now. But now I am seeing some strange behavior which I am unable to debug or explain. With my BHO enabled and my Explorer Bar in expanded state, when I close the browser it throws some memory read error. If I go to manage addons and disable AcroIEHlprObj BHO and Yahoo IE Services BHO on different combinations, the error doesn't show up. Even with those two BHOs enabled, if I browse to some web site in the main browser or click anywhere in the browser (like minimize and maximize) and then close the browser, then also no error is thrown! If my Explorer Bar is in minimized state then also closing the browser doesn't throw the error. When I debug ...Show All

• SQL Server programs!!!!

  i repaired my problem with the SQLserver Express.....now i know how to use....but nowadays i have some problems with my DataBase....i would like you people share your DataBase to see what is my problem......mi msn is jmontes32@hotmail.com .......if you give some programs....i will learn more about SQL server.. sorry if you find some grammmathical mistakes....i'm learnig english see you jamie You most likely will not have many folks 'sharing' their databases with you. However, you can download and install sample databases that Microsoft makes available. Here are three. Databases -AdventureWorks http://msdn2.microsoft.com/en-us/library/ms124659.aspx Databases -Northwind and Pubs http://www.microsoft.com/dow ...Show All

• SQL Server Server: Msg 8621

  Since upgrading to 2005 Server Sp1 we are unable to delete users from our user table, we have around 128 foreign keys and I suspect this is the problem.   We are getting server Msg 8621, however I can not simplify the query as it is a simple delete <table> where <id>=<value> The deletion fails from our app, from sql server manager and will fail even if the only row is in the user table (ie no fk data) Any suggestions     Hi all, we are having exactly the same problem, has it been confirmed to be a bug is there any workaround Thanks in advance ...Show All

• Windows Live Developer Forums Custom Navigation

  I love this stuff.. I'm using: <a href='javascript:map.ZoomIn();'>Zoom In</a> | <a href='javascript:map.ZoomOut();'>Zoom Out</a><br /> <INPUT id="pan" type="button" value="UP LEFT" name="pan" onclick="map.Pan(-900,-600);"> <INPUT id="pan" type="button" value="UP" name="pan" onclick="move();"> <INPUT id="pan" type="button" value="UP RIGHT" name="pan" onclick="map.Pan(900,-600);"><br /> <INPUT id="pan" type="button" value="LEFT" name="pan" onclick="map.Pan(-900,0);"> < ...Show All

• SQL Server Calculating Age in a Stored Procedure

  Currently, I'm having an issue with patients under the age of 1 year. I had a patient 9 months old and it calculated 8 weeks. Can anyone see where there may be an error in this This is the section pertaining to the "Patients Age" -- Full SP below this. '308.PatientAge' = CASE WHEN datediff(day, pp.birthdate, @ApptDate) <= 6 THEN cast(datediff(day, pp.birthdate, @ApptDate) as varchar(10)) + ' dys' WHEN datediff(day, pp.birthdate, @ApptDate) <= 112 THEN cast(floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 7) as varchar(10)) + ' wks' WHEN floor(cast(datediff(day, pp.birthdate, @ApptDate) as decimal) / 365.25) < 2 and day(pp.birthdate) <= day(@ApptDate) THEN cast(datediff(month,pp.birthdate, @ApptDate) ...Show All

• Visual Studio Team System VSCover80.dll Vista 64bit, VS .Net 2005 TS

  Hi, I have a strange problem, I installed VS .Net 2005 Team Suite edition with full install. My tests can't run code coverage becuase VSCover80.dll is missing. I reinstalled VS but same problem. Does anyone know why Is this a Vista known problem I also tried SP1 beta for 2005 but no VSCover80.dll either. So anyone know why thanx Johan / NSquared2 www.johannormen.com/blog Johan, No this is not a known problem with VSTS. So after running a full install all of the profiling dlls are installed except for VSCover80.dll VSCover80.dll should install to either system32 or SysWOW64 depending on the 64-bitness of the OS, have you checked both of those location for this file Also, if you do not see the file there could you l ...Show All

• SQL Server The attribute Key Can not be found

  Hi all, I am processing a cube with two fact tables, one fact table processes successfully and the other doesnot because the attribute key can not be found. The command error is as below; <Batch xmlns=" http://schemas.microsoft.com/analysisservices/2003/engine "> <Parallel> <Process xmlns:xsd=" http://www.w3.org/2001/XMLSchema " xmlns:xsi=" http://www.w3.org/2001/XMLSchema-instance "> <Object> <DatabaseID>Analysis_Trial</DatabaseID> <CubeID>Patient Care</CubeID> </Object> <Type>ProcessFull</Type> <WriteBackTableCreation>UseExisting</WriteBackTableCreation> </Process> </Parallel> < ...Show All

• Smart Device Development problem with NdisMInitializeWrapper

  Hello, I have downloaded the windows CE passthru example. Creating the dll is no problem. The dll get loaded, but stops at NdisMInitializeWrapper. NTSTATUS DriverEntry( IN PDRIVER_OBJECT pDriverObject, IN PUNICODE_STRING psRegistryPath ) { NDIS_STATUS status = NDIS_STATUS_SUCCESS; NDIS_STRING sName; NDIS_PROTOCOL_CHARACTERISTICS ndisPChars; NDIS_MINIPORT_CHARACTERISTICS ndisMChars; Ausg("DriverEntry"); NdisAllocateSpinLock(&g_spinLock); Ausg("InitWrapper"); NdisMInitializeWrapper(&g_hNdisWrapper, pDriverObject, psRegistryPath, NULL); Ausg("Finished"); The "Ausg" function just writes information into a logfile. The green one get called but the red one not. Any ideas what could be the reason Update: Now i have ...Show All

• .NET Development Updating SQL Server using DataSet

  Hello all. I have a DataSet that contains 237 tables. This DataSet is populated using the ReadXml() method and a FileStream connected to an XML document. My question is: How do I insert the rows from my new DataSet into the SQL Server database I have seen examples on how to use a SqlDataAdapter and set the UPDATE command, but I'm not using a SqlDataAdapter. Also, all of the examples I've seen using this method involve using the Fill() method (which I can't use because I'm using XML files to populate my DataSet). Anyone know how to push the data in my DataSet into SQL Server Thanks. Example: DataSet ds = new DataSet(); FileStream fs = new FileStream(@"C:\temp\test.xml", FileMode.Open, FileAccess.Read); ds.Re ...Show All

• Smart Device Development Help Files

  Can anyone recommend a good tool for writing help files for Win Mobile 5.0 devices... ...Show All

• Windows Search Technologies WindowsSearch.exe error

  I previously had WDS 2.6.6 installed and working great with Office 2003. Have just upgraded to Office 2007, which requested WDS 3.0 installed, so I did. Since then, indexing/searching appears like it might be OK (it does seem to return results), however I often get an error with WindowsSearch (Windows Search System Tray) pop up when select something from the desktop reults popup. I can make force this to happen every time by running the WindowsSearch.exe with an Error signature AppName: windowssearch.exe AppVer: 6.0.5824.16387 ModName: windowssearch.exe ModVer: 6.0.5824.16387 Offset: 0000f490 I am running Windows XP SP2, IE7, Office 2007 Pro Plus. Not a major problem, but any ideas Thanks. ...Show All

• SQL Server File System Task Error

  Hi, I am using the 'File System Task ' to create a directory structure (e.g ..\DB; ..\DB\LOG; ..\DB\BACKUP; ) I set following properties for the single tasks: UseDirectoryIfExists = True;  Operation = Create Directory; The task works fine before installing SP1 on the server.  Now it creates an ERROR if the directory already exists and it is not empty. SSIS package "testcreatedirectory.dtsx" starting. Warning: 0xC002915A at Create DB Directory, File System Task: The Directory already exists. Error: 0xC002F304 at Create DB Directory, File System Task: An error occurred with the following error message: "Das Verzeichnis ist nicht leer.". (The Directory is not empty.) Task failed: Create DB Directory ...Show All

• SQL Server AS 2000 DSO loses connection

  We use DSO with ASP.NET 1.1 via COM layer through interop. However, sometimes after awhile the connection can no longer be established. The error occurs somewhere in the following code, most likely the first line: dsoServer.Connect ServerName Set m_dsoServer = dsoServer If m_dsoServer.MDStores.Find(mvarDBName) Then Set m_dsoDatabase = m_dsoServer.MDStores(mvarDBName) Else ' Dont do nothing for now End If The error reads: Error: Cannot connect to the repository. Restarting IIS fixes this problem until it recurs. Any idea Thanks, Boris Zakharin Could you point me to where it says that using DSO from ASP.NET is not supported I have found at least one KB article talking about ho ...Show All

• Visual Studio Express Editions Question about BackgroundWorker & SQL query

  Are there any known issues with running a SQL query in a BGW thread   The datagrid in my app is being filled properly with the query results, but then the UI freezes up everytime & becomes nonresponsive.  Here is the main code:   Private Sub QueryButton_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles QueryButton.Click CheckForIllegalCrossThreadCalls = False BackgroundWorker1.RunWorkerAsync(QueryComboBox.Text) End Sub Private Sub BackgroundWorker1_DoWork( ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork QueryString = e.Argument.ToString() Dim myAdapter As Odbc.OdbcDataAdapt ...Show All