Jack210's Q&A profile

• SQL Server compile a store proc again

  Hi there!! Can we force stored procs in a database to recompile and see if there is any compile time error in the stored procs then and there. Something like sp_recompile which marks Stored Proc for recompilation and compilation occurs later on. I am looking for something which will force the existing stored procs to compile and let me see the error if any. Best Regards Rahul Kumar, Software Engineer, India Thanks Louis this '=*' was just one issue I cited for example, there are and can (which i dont know) many more, which give error on sql server 2005 and even SQL Server 2005 Ugrade Advisor didnt catch. Can we rewrite your given code as select object_name ( id ) from sys ...Show All

• SQL Server VARBINARY(MAX)

  Hi all, Could anyone let me know whether VARBINARY(MAX) or File system is BEST for storing large files Any pros & cons Also , whether SSIS can pick a file from a table with from a VARBINARY(MAX) column and process it Thanks in advance, DBAnalyst That highly depends on the use of the files stored in SQL Server. Are they either small or big, are they retrieved often or seldom.... HTH, Jens K. Suessmeyer. --- http://www.sqlserver2005.de --- ...Show All

• Visual FoxPro How to handle transaction consisting of different data sources?

  I want to know how to handle transaction consisting of different data sources (e.g. VFP dbfs and MS SQL tables). Thanks, Peter The only way to manage transactions across multiple databases is to have an external transaction manager. Windows ships with the Distributed Transaction Coordinator. If you create components and then host them in COM+, the COM+ transactions automatically use the DTC. When talking to SQL Server you don't need to do anything special as the DTC knows about SQL Server transactions. For VFP data, you need a COM+ feature called Compensating Resource Managers (CRM). You can kinda, sorta get this to work with VFP data. I have an updated COM+ article going up on my web si ...Show All

• .NET Development How to identify Country from where I am surfing

  Hi, Can any one tell me that How to identify Country from where I am surfing http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1228924&SiteID=1 The Idea presented in the above post may help you with some modifications. Best Regards, Rizwan aka RizwanSharp ...Show All

• Visual Studio VS2005 works bad with Vista

  Hi, Folks. The VS2005 has known compatibility issues working under Windows Vista Ultimate, in other words, the message displayed like this: the fatal error C1001: An internal error has occurred in the compiler. Thus, if you have the problem mentioned above and proper solutions for that, please let me know. It will be much appreciated. Xiao, That looks like a compiler issue.You would be better off posting that to a more appropriate forum. This one is specific to debugging. In general on Vista with UAC enabled if you run Visual Studio with elevated administrator permissions things should work fine. You can create a shotcut icon for VS with option to always run elevated with administrator permissions. Look at the article below for ...Show All

• SQL Server still struggling with flat file into multiple tables

  So here's the issue 16 flat files all fixed width. Some over 350 columns. Open flat file 1 extract id and go see if its in table 1, if true update table 1 with first 30 columns otherwise insert into table 1 first 30 columns. goto table 2, lookup id, insert/update next 30 columns...etc..etc..for 10 different tables So I've got my flat file source, I do a derived column to convert the dates, i've got a lookup for table 1, then 2 ole db commands, 1 for update if lookup successful, 1 for insert if lookup fails. How can I pass the id as a param into the update command so it updates where x = 'x' also I need a pointer on doing the next lookup, eg table 2, would I do this as some sort of loop . If you can help great, bu ...Show All

• Visual J# Importing external jars to use in J#

  Hi, I have an external jar library that I want to use within the Visual Studio J#. I want to instantiate a class from the external jar into one of my J# classes. How do I do that I don't seem to find a way to import the external jars. Any help will be appreciated. Thanks Hi, No, there is a way. You can't directly use them but you can convert them to a .net dll and then refer in your addin. We ship a tool called jbimp which actually does the conversion job. Please take a look at http://msdn.microsoft.com/library/default.asp url=/library/en-us/dv_vjsharp/html/vjgrfJavaBinaryConverter.asp . Also there are some useful posts on this forum on issues faced with conversions using jbimp. I would ...Show All

• Visual Studio Team System Quesry on Database Testing.

  Hi. I am working on an E-Banking application which requires large database to be tested. I am puzzled about how to carry out this testing and how to start(like is it with procedures/triggers/assertions). I request the members to assist me and guide me to carry out database testing in a smooth manner. I would advice to look at Sachin Rekhi his blog which goes in to detail on unit testing and data generation http://blogs.msdn.com/sachinre/ There will also be a MSDN webcast that will show you the basics coming on line in the coming days, watch Sachin his blog and an announcement and link to this. -GertD "DataDude" Development Manager ...Show All

• Visual C++ error C2664: 'gethostbyname' : cannot convert parameter 1 from 'class CString' to 'const char *'

  when I use the following code in the unicode project of vc, it has the following error: error C2664: 'gethostbyname' : cannot convert parameter 1 from 'class CString' to 'const char *' Can you tell me how to do this data conversion and make this statement workable Thanks you very much. lpHost = gethostbyname(pstrHost);   Samuel Hobbs wrote: You will definitely get that error whether the string is Unicode or not. So try the following and please refer to the documentation of "CString::GetBuffer". LPTSTR p = pstrHost.GetBuffer( 10 ); lpHost = gethostbyname(p); pstrHost.ReleaseBuffer( ); [...] (In my opinion the GetBuffer / ReleaseBuffer pair is required when we need to build a string. In case of gethost ...Show All

• Visual Basic Error tracking

  Hi, I am currently doing a project using vb.net. i have problem with the program i write.. the output is correct but there are error message occur.. the error message is : System.NullReferenceException: Object reference not set to an instance of an object. may i know what is the problem.. Below is my code: Public Shared Function GetTAT() As ArrayList 'Retrieving data from SQL Server and calculate average TAT Dim i As Integer Dim sum As Integer = 0 Dim avg As Double = 0 For i = 1 To 12 Dim sqlMonth As String = "Select * from Ticketing Where DateClosed Like '" + i.ToString + "%'" sum = 0 Try Dim dsMonth As New DataSet Dim ad ...Show All

• SQL Server Default Parameters Not being set

  Hi there, In my report, I have set the default parameters such that it is supposed to automatically render when the page loads. I have set the defaults in Report / Report Parameters and it even works in the preview pane, however, when I deploy the report, the defaults are not set. This report has subreports, and I've tried setting their defaults. Has anyone come across this Thanks, LBD I created a similar post today describing default values not being deployed. It's very odd that it shows up on the Preview but does not get deployed. The only way I got it to work is setting the default in Report Manager on the properties of the report. ...Show All

• Visual Studio Express Editions About NEtFrameWork

  I am using win. visual studio 2005 and i am trying to do an application. But my application doesnt work without Netframework 2.0 How can my application works in all computer without netframework. Please reply.its very important Sorry for my bad english. It cannot work without the framework. it must be installed on all of the machines your projet is unstalled on. Generally this is part of the installation of your project. ...Show All

• SQL Server Need a leg up on migrating from SQL 7 to SQL 2005 (HOW TO????)

  I have a SQL7 server that runs one database for our company. The rest of the datastore is on a SQL2005 server. How best can I transfer the SQL7 database to SQL2005 I have tried to do that, but the SQL 2005 server balks at the backup. Is there anything special one has to do in order to get the backup to restore properly ...Show All

• Windows Search Technologies Vista: Moved index location, drive died, now not indexing

  >>> Short version: My Windows search configuration is invalid. I would like to set it up cleanly as if I were doing a fresh Vista install. But I do not want to change any other aspect of my current installation. How can I do that Vista Ultimate RTM Indexing Options dialog buttons are disabled >>> Long Version: 1. From a working installation of Windows Vista, I moved the location of the index files from the default to e:\index. 2. Then the E: drive failed. 3. I replaced the E: drive After that, Windows Search no longer worked. The Indexing Options dialog said the indexing service was not running. - I have tried starting the service. At frist, it would not start saying it could not find a particul ...Show All

• Windows Live Developer Forums Firefox Polylines

  I'm trying to add a polyline for tracking of the previous location of mutiple objects. This works fine in IE(Of course) but on Firefox 1.5.0.4 on Mac and Windows all the lines are being put in one place instead of actually having the correct locations. The code is at http://www.wormley.com/t1.html The pushpins were added to illustrate the locations where each line should be(you have to zoom in, the tracks aren't very long) but both polylines are ending up near the left side in firefox. It still doesn't work without the pushpins. Thanks, -Steve Yep...I'm in the frustrating position of not being able to say anything definite. I can't tell you anything more than: "we know all about this" and "soon". Get it ...Show All