Mark Willer's Q&A profile

• SQL Server The AcquireConnection method call failed with error code 0xC0202009.

  I've seen the previous threads on this (although maybe not all of them). However, i don't think I'm getting the error for the same reason. The full error I'm getting is: - Pre-execute (Error) Messages Error 0xc0202009: {F1B3B35C-FAE3-48F6-A169-4E4D8D99F9B6}: An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.  Source: "Microsoft JET Database Engine"  Hresult: 0x80004005  Description: "Unspecified error".  (SQL Server Import and Export Wizard)   Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "DestinationConnectionExcel" failed with error code 0xC0202009.  (SQL Server Import and Export Wizard)   Error 0xc004701a: Data Flow Task: ...Show All

• SQL Server 0xC02090F5 DTS_E_DATAREADERSRCUNABLETOPROCESSDATA

  I am moving over 100 tables from mainframe to SQL Server 2005 using SSIS all but 2 tables have worked to some degree. 2 of the packages when executed write 0 rows to SQL Server becaue they are getting this error 0xC02090F5 = DTS_E_DATAREADERSRCUNABLET OPROCESSDATA I have looked at the definitions on the mainframe and SQL Server side all looks good. I have looked at the data on the Mainframe side and there is nothing unusual. The Mappings are simple one to one mappings At one time I could even preview the data while in designer building the package but when the packages for those 2 tables are executed I get the same error. Other tools can read the data. Does anyone know what could possibly be wrong ...Show All

• SQL Server How to check the dependencies of a SQL Table in SQL Server 2000

  Hi all, I m using SQL Server 2000. I want to know the Dependencies of a particular table in my database. I want to know the details inorder to delete the records which are not referenced from other related tables. (e.g) Customer, CustomerTax, Invoice tables are there. CustomerID is primary key in Customer table. CustomerID is Foreign keys in CustomerTax and Invoice tables. When i create new customer i enter customer tax also. So both Customer and Customertax details are stored in the tables. Once i created the customer details it not yet reference in invoice table i can deactivate(later i can again activate the customer) the customer, because it is not refered in Invoice table(eventhough it is refered in CustomerTax table). In ...Show All

• Visual Studio Team System Code Analysis Failing to build due to comdef.h

  I get the following error when trying to run code analysis on one of our apps. When VSTS tries to compile it it bombs in comdef.h Error 1 error C2220: warning treated as error - no 'object' file generated C:\Program Files (x86)\Microsoft Visual Studio 8\VC\include\comdef.h 264 Warning 2 warning C6386: Buffer overrun: accessing 'argument 1', the writable size is '1*0' bytes, but '32' bytes might be written: Lines: 233, 234, 241, 251, 252, 253, 254, 258 c:\program files (x86)\microsoft visual studio 8\vc\include\comdef.h 258 Any Clues on a work around It is VS 2005 team system configured for a tester on Vista 64 bit RC2 build 5744. I did find by running code analysis on the release config it ...Show All

• Visual Studio Express Editions PrintPreviewDialog malfunctions when certain printers are default.

  I have found that my programs (Made with Visual Basic Express) do not display correctly the print preview when certain Lexmark printers are selected as the Windows deafult printer. When that happens, only a dot in the center of the print preview area is shown. ...Show All

• SQL Server Automatic failover failure

  Hello, we're running a mirrored database with High Availability for Automatic failover including a Witness instance for a web application. When doing a manual failover on the database in Management studio, the roles are switched correctly and the database is in "Principal, Synchronized" and "Mirror, Synchronized/Restoring" mode. The web application has no problems switching servers by using client failover with the jdbc driver. There is no problem accessing the database with Management Studio. However, if we stop the SQL service on the Principal server the role is automatically failed over to the Mirror server by the Witness. The database is then in the mode "Principal, Disconnected" which should be f ...Show All

• Visual Studio Express Editions Debugging information cannot be found or does not match

  I wanted to try learnign some C++ with Visual C++ Express but when i try to build even the simplest program: #include <iostream> using namespace std; int main() { cout << "Hello world!\n"; return 0; } I get the error below: Debugging information for "project.exe" cannot be found or does not match. Binary was not built with debug information. What does this exactly mean and how to fix it Thanks. Just encounted the same issue.. the answer above pretty fixed it. thanks ...Show All

• Smart Device Development Access command prompt in the emulator

  Can any way we can go to the command prompt in the emulator. I want's to start one service using services.exe on the command prompt Thanks JR Lyon We are working on a smartphone application which is a conversion from pocket pc. In pocket pc we have a application in which a dll is registered in the today item.Whcih have to be always runing. Now as it is [Today] not supported in smartphone so we have decide to install it as a service. We we are using C# with CF2. ...Show All

• Internet Explorer Development IE extention can not prevent a image from being downloaded and displayed!

  I want to write an IE extention that can prevent image from being displayed. I know that when I got the DISPID_DOCUMENTCOMPLETE event, I can walk the DOM object of that web page and set the image object to invisible. But at that time the image has beed downloaded, Is there some solution that can prevent the image being downloaded Can IE extension support that Thanks! Actually, there is a third option, an Asynchronous Pluggable Protocol , which is probably the way to do it. Not easy, though. ...Show All

• .NET Development maximum size of file that can be used with XMLdocument?

  Hi is there any limit to the size of the file to be used with the load method of XMLDocument I think for XMLReader's it is 2 GB also which is the most effiecient way to load a XML document of size in MB's 1. XMLDocument 2. XMLreader 3. XPATHDocument I need to create an application that can load the entire XML (irrespective of size) in the cache INSTANTLY!! Regards, n3sachde XmlReader is most efficient way to process large documents but it doesn't cash. I don't think you would be able to load 2G file in the XmlDocument or XPathDocument. ...Show All

• SQL Server Subscription not displayed

  Hi, I have setup Merge replication with 2 publishers and one subscriber. On the subscription machine I can see publisher 1 listed under local subscriptions but not publisher 2 . I have created the second subscription on publisher 2 and also tried to create the subscription again on the subscription machine but i get an error saying the 'Subscription already exists'. Neither do I see the second subscription nor does it work as if it is subscribed to Publisher 2 . What could be going wrong. I would appreciate any help. Thanks tribal   Thanks for the reply Mahesh,   The sysmergesubscriptions has two entries allright but one of them is Publisher 1 and the other is the ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Rendering to multiple full screens

  For a special application we need to do the following using a NVidia Quadro FX 4500 X2 (2 GPUs with 4 outputs) on a system with 4 CPUs. - we get 8 input images from acquisition devices - these 8 images must be rendered to 8 textures using fragment shader programs in two render passes - the resulting images must be rendered to 4 render contexts fullscreen in full HD Resolution (1920x1080) again using a fragment shader program All this should happen as parallel as possible with 25 fps. We do not need any user input or any animation. We have not yet decided, how to do the implementation. As we see it, our possibilities are: - using DirectX 9.0 with unmanaged C++ - using DirectX 9.0 with managed C++ or C# - using OpenGL with unmanaged C++ - us ...Show All

• SQL Server Touble with text being truncated

  I am trying to send a large string to my table where I have typed the field as "text". The data is truncated ( I am only sending about 5kb and it is being truncated to about 4kb). I am using SQL 2000. My web page is classic.asp and I am sending a parameterized query to my stored procedure. This is the relevelant code for the parameter I'm sending: objCmd.Parameters.Append = objCmd.CreateParameter("@PostBody",adLongVarChar,adParamInput,20000,PostBody) This is the typing in my stored proc: @PostBody text, I can either INSERT or UPDATE using Query Analyzer and the data is NOT truncated. Wondering if it was my parameterized query that was causing me trouble, I rewrote the code to send the SQL upfront (skipping the stored ...Show All

• Visual Studio Team System Connect to Excel

  hi, how do i connect to excel data source from webtest. thanks, Check out Sean Lumleys blog post here: http://blogs.msdn.com/slumley/archive/2006/02/08/adding-different-types-of-data-sources-to-a-web-test.aspx There's a section for adding excel data sources. ...Show All

• Visual Basic accessing com+ object using ASP

  Hello all, Perhaps you can help me. I have a com object which I converted from VB6 to VB.NET. I am using this com object with other .Net applications without any problem. However, I am now trying to use this com object in some old ASP code which I have not yet converted. I want to use the com object because it contains some additional functionallity that the original com object did not possess. The ASP code works fine when calling the old com object. BUT..if I change the code to call the new com object, it takes a very very (60secs.) long time for the object to be instantuated. In other words, when the code hits the CreateObject line, it takes 60 secs to execute. The rest of the calls to the methods of that com object execute normally. Wha ...Show All