Ceres629's Q&A profile

• Visual Studio 2008 (Pre-release) svcutil errors on wsdl name attribute

  Hello, I am trying to generate WCF client and service code from a WSDL file provided by a third party. The wsdl file passes validation in several verification tools. However, svcutil generates an error when run as such: svcutil importedfile.xsd thirdparty.wsdl The error is this: Error: Cannot import wsdl:binding Detail: The WSDL binding named ReferApplicationSOAP is not valid because no match for operation ReferApplication was found in the corresponding portType definition. XPath to Error Source: //wsdl:definitions[@targetNamespace='http://www.fake.org/schemas/referApplication_1_3_1.wsdl']/wsdl:binding[@name='ReferApplicationSOAP'] If I remove the "name" attributes from the wsdl:input and wsdl:output elements under the wsdl ...Show All

• SQL Server limiting the number of child rows

  Hi I have got two related tables (tblMembers and tblTickets) that have a 1 to 2 relationship i.e a member can have 1 or 2 tickets, but not more. How do I enforce this condition in SQL . Please help Hello, There are several ways to implement this. I assume you have a table similar to tblMemberTicket in which you have a 1-n from tblMemebers and a 1-n from tblTickets... 1. Triggers 2. Check constraints 3. Application login in stored procedures. If you need enforcement at the schema level, then only options 1 or 2 are applicable. Cheers, Rob ...Show All

• SQL Server how to install SQLDMO without install SQLserver?

  Hi, I want to using SQLDMO futures and I want to connect to remote SQL server but i don t want to install SQL server. Can I install SQLDMO without SQL server Thank you. Hi, can I use this MSI for using to connect to MS-SQL2000 I need install MCMS and SW reports: This feature cannot be selected for installation as the following pre-requisite(s) are not installed: SQL-DMO (from SQL SP2) or above. I have MSWin3k and installation of MCMS 2002 1a. Thanks. ...Show All

• Visual Basic Help on creating a strange programme that types things you dont type...

  What I need to know for my next programme is how to get it so that you have a textbox and you start typing in it, it says "hello" or whatever I want it to say no matter what the user types. Sorry its a bit difficult to explain. But say the user types "1"(could be any key they choose) in the textbox I want it to come up as "H" then the second letter they choose it would come up as "e". you mean like an auto predicting type feature This would be achieved using a KeyPress event I believe, then check the key they pressed and go through your dictionary/collection of words and filter the results or whatever. a Combobox does this for you automatically after setting a couple of ...Show All

• SQL Server Export SSRS 2005 Report to Excel

  Hi, I have created a report in SQL Server 2005 Reporting Services. After I export it to Excel format, if I try to print it (Hardcopy), my Excel crashes. It shows an error and shut down. I'm using Excel 2000. It even shows me same error when I click on "Print Preview", in Excel. Everytime I try to print the excel worksheet, a window pops up with the heading "Visual Studio Just-in-Time Debugger". The error is: "An unhandled win32 exception occurred in EXCEL.EXE [3460]". Any help is greatly appreciated. Perm This sounds like an Excel issue, but maybe I can help narrow down the problem. What report objects do you use in your report and how are they formatted You can send the RDL and\or this infor ...Show All

• Visual Basic adding a pause between instructions

  Hi all, I'm trying to display on a listbox say some sentences on different lines but I need a functions that "wait" say a couple of second between each line is add. I tryied this code: Listbox1.Items.add("1st line") System.Threading.Thread.Sleep(2000) Listbox1.Items.add("2nd line") but what I have is a 2 seconds delay and suddenly both lines appear togheter as the "sleep"instruction was the first one How can I fix this issue Thanks in advance Arcan Found the solution... just after long search in the forum I added this line just before the Sleep function My.Application.DoEvents() It works fine now I hope it is the right way to do it... my bes ...Show All

• SQL Server fuzzy lookup taking too much time

  I have a SSIS package where a small table of 270 rows are fuzzy looked up with a table in another sql server and inserts the records to a temporary table. This takes more than 3 hours in debug mode or so and never goes beyond this step.I have used a OLE DB destination to insert to temporary table and temporary table doesn't get a value. How big is that other table The fuzzy will build an index to start with, and this can take time. Review the options on the second tab to influence the index. Also check obvious things like blocking or such like What about a profiler trace, anything untoward ...Show All

• Visual Studio 2008 (Pre-release) Convert WCF Sample AuthorizationPolicy to host in IIS

  I am trying to convert the sample in the SDK located here: WCFSamples\TechnologySamples\Extensibility\Security\AuthorizationPolicy to be hosted in IIS. Here is where I am. I took the project Service and removed the hosting logic to a new project: ServiceHost Changed the Service project be a DLL instead of a console app. Ran the host/client and everything worked fine. I then -- created a new web project -- added the appropriate .SVC file -- copied the system.serviceModel section from the app.config to the web.config -- changed the following line in the web.config to the second line <serviceCertificate findValue="localhost" storeLocation="CurrentUser" storeName="My" x509FindType="FindBySubjectName" /> <serviceCertifi ...Show All

• SQL Server dml without generating log transactions ?

  Hi There I know the answer to this is probably no, but had to ask anyway. Is there a way to perform a dml statement without generating anything in the transaction log The reason i ask is that i have a database that uses simply recovery model, however i need to move a 1 billion row table to this DB, i know that even though it is in simple recovery it is one transaction, it will be written to the log until committed then the space will be released in the log file. I am using a simple: insert into DW_DB..table select * from DB..other_table. I have dropped all indexes before the operation. However this is a big problem, the log for the db in simple recovery that i am moving the data to grew to 128 Gig and the disk ran out of ...Show All

• Smart Device Development Thread Problem

  Hi,          I'm developing smart device application by using CF1.0 on VS 2003. i need your help. I've developed one application. In that application, there are two forms both will be shown thru sub Main(). The first form has a thread which will be invoked on form_load() event. That form will be closed after completing the thread function and show Form2. This is what i want. But Form2 didn't show even the thread function finished.          I attached source code. Please check my application and send your suggestion or link. Note:           In my application, Both forms will show ...Show All

• Visual Studio Express Editions Connect to Lotus

  Hello On our server we have a lot of Lotus databases that we get information from. Now we want to make a small easy program to collect information like product and quantity on stock so our resellers can get the information as well but still not get all the information in that database. Is this possible How do i connect to lotus database I would really appreciate all help I can get. Thanks Rikard aka Biocide So what you are saying is that it’s not possible to connect to a Lotus database from Visual Basic Is it possible to retrieve information from the database in some other way And it’s not an option to use SQL Server instead. This is a 1000+ employees company and it’s ...Show All

• Visual C++ DLL Project migrated from VC6 to VC8 crashes.

  Hi, I am currently maintaining an MFC/ATL COM project that has been compiled till now with Visual C++ 6. I have been assigned the task to maintain the code under the VC8 compiler. The solution has several projects under it. Most of them generate DLLs, and there is also an Application project that uses these generated DLLs. Migrating the code from VC6 to VC8 has meant mainly performing the following minor changes to the code... using the _CRT_SECURE_NO_DEPRECATE macro definition to suppress various warnings (not errors) regarding deprecated function calls etc. removing the @1, @2 ... ordinals from the .def file changing string functions like ltoa() to _ltoa() etc. static_cast<> for conversion errors ...Show All

• Windows Live Developer Forums Virtual Earth javascript seems override some page style

  When I include virtual earth javascript, all images which style is "border: 1px solid" becomes invalid. When I remove virtual earth script, all work fine. Is it a bug Any solution to make "border: 1px solid" work Regards, Bill Ng If you use the same image style on many images, could you just put it in a style sheet, which gets included after your VE includes. Then just set the class of your images instead of the style property. CSS I'm sretty sure would take use the properties of the class over any generic CSS settings that are set up in the VE includes. ...Show All

• SQL Server How can I get a row count of CTE recordset?

  Hi everybody, I want to get a row count of temporary CTE recordset. My query is like this: With SQLPaging As (  Select Row_number() Over (Order by Row_num) as RowNumber,  Row_num,  Column_A,  Column_B From OriginalTable ) Select * from SQLPaging Where RowNumber between 21 and 30 Let's assume SQLPaging definition contains 1,000 rows. If I use @@rowcount, it returns only 10. I.e. number of actual rows per page. What I want is that I want to know row count of SQLPaging CTE without extra counting query. I think SQLServer already knows how many rows CTE definition contains. The reason that I don't want to use extra counting query is that if SQLPaging definition has row performance query (lik ...Show All

• Visual C++ It appears that C++ developers are abandoned in VS2005.

  As a long time C++ developer, I just recently migrated from 6.0 to 2005. There was a learning curve to get used to the 2005 interface but even after that learning curve, it seems that the 2005 interface was designed without C++ developers in mind. RAD development requires high performing tools, 2005 is not a high performing tool, it is a tool that tries to do too much and is good at very little. A couple of observations, The IDE is extremely slow compared to 6.0, if you want to create a new .cpp in 6.0 you went file->new then file->save as (FILE name). In 2005, you do add new c++ file to system, wait 30 - 60 seconds and then you have a cheap dialog that prompts you for what file type you want. Intellisense broken, with large pr ...Show All