thiagooooo's Q&A profile

• SQL Server Job scheduling for Packages in SQL Server 2005

  ---------------------- MS Win XP Pro 2002 SP2 MS SQL Server 2005 MS Visual Studio 2005 ---------------------- Can anyone help me (even by pointing me to a documentation) in order to schedule Packages (from file system source) in SQL Server 2005. I've configured providers logging, but still the error file doesn't give me any explanation why the error happens: "#Fields: event,computer,operator,source,sourceid,executionid,starttime,endtime,datacode,databytes,message OnPreValidate,PC1234,NT AUTHORITY\SYSTEM,D_AGR,{8A4FA774-F5F0-40DE-AB16-A93F27950E09},{8A918844-8E43-403D-A606-C8CB4B7D8238},31/08/2006 16:42:55,31/08/2006 16:42:55,0,0x,(null)" I've also done the same on the Step properties under 'Logging' In Manageme ...Show All

• Visual Studio Express Editions Webbrowser Progress bar

  can someone please point me to some code that will trigger a progress bar when a webbrowser control is navigating and return to 0 when complete. Put a Progress bar on your form and name it Progress. Then add the following: Private Sub WebBrowser1_ProgressChanged( ByVal sender As Object , ByVal e As System.Windows.Forms.WebBrowserProgressChangedEventArgs) Handles WebBrowser1.ProgressChanged Dim p, d, t As Integer d = e.CurrentProgress t = e.MaximumProgress If t < 1 Then t = 1 p = Int(d / t) * 100 If p > 100 Or p < 0 Then Exit Sub Progress.Value = p End Sub Forgot who I "borrowed" this from, but, it does work!! j ...Show All

• Visual FoxPro Not a table message...

  Hi All, I have a Visual FoxPro table which I use as a backup table. I have a lot of records in it at the moment. When I was trying to open it yesterday I got the following error: Not a table. I can't seem to open the table at all. The table must have got corrupted etc. Is there any way I can retrieve the contents of this table without having to do a restore from a previous backup. Pablo. It is possible to have a corrupt table that can be repaired. You may try to re-create header or use a recover software like: http://fox.wikis.com/wc.dll Wiki~TableCorruptionRepairTools~VFP http://www.dbf-repair.com/faq.htm http://www.hallogram.com/datatool/ ...Show All

• Architecture don to not use "Inheritance"

  Have anyone try to design with no Inheritance at all I think *Inheritance* is not good as we think. It's force us to somthing we don't need, It's ok in some cases that better to be solved with no need to it. what do you think regards, dotHuman. I forgot to mention that inheritance is a good way for a framework to get context information (like current user or other security or environment info) to a component. Rather than passing this stuff in directly in function declarations, the framework can instantiate the component and initialize the context data privately through the base class. I've also seen this done using thread-local storage, though. ...Show All

• SQL Server help pls: procedure 'LoginListInput' failed because 'LoginListInput' is a table object

  When I execute the script on my machine it works but when we send it to the client it gives the error: procedure 'LoginListInput' failed because 'LoginListInput' is a table object Here is my script: use mosaikDB737 exec sp_MSforeachDB ' use [ ] insert into mosaikDB737.dbo.SearchOutput1 select sk.loginname COLLATE SQL_Latin1_General_CP1_CI_AS as searchedTxt , object_name(id) AS ProcName ,Len(SubString(o.text,1, PatIndex(''%'' + ltrim(rtrim(sk.loginname COLLATE SQL_Latin1_General_CP1_CI_AS))+ ''%'', o.text)))-Len(Replace(SubString(o.text,1, PatIndex (''%'' + ltrim(rtrim(sk.loginname COLLATE SQL_Latin1_General_CP1_CI_AS)) + ''%'', o.text COLLATE SQL_Latin1_General_CP1_CI_AS)),char(13),''''))+1 AS Line, PatIndex(''%'' + ltrim(rtrim( ...Show All

• Visual Studio Need help building web projects with MSBuild?

  If you're interested in building your web project using MSBuild, we can save you the trouble of posting the question and waiting for an answer :) To build web projects with MSBuild you need the Web Deployment Project add-in. You can get it from http://msdn.microsoft.com/asp.net/reference/infrastructure/wdp/ . Another option is to use Web Application Projects , which give you the VS2003 model of working with ASP.NET projects, but the benefits of ASP.NET 2.0 and VS2005. Happy building! Neil BradleyB wrote: You can use Web Deployment Projects with Web Application Projects. This will allow you to pre-compile the pages and create a deployment image. Brad I've tried creating Web Deployment Projects with WAP ...Show All

• SQL Server Installation of Service Pack 4 for SQL 2000

  All, I have a problem with installing SQL 2000 Sevice Pack 4. Please see Part II. Service Pack 4 comes in four parts and each one is to be used to apply to different SQL server components. Part I - Analysis Service Pack - Complete . Part II - MSDE component - Problems . The original problem was that it needed a strong password. I got around that by supplying the sa password. Now it says that the sql server instance name specified is invalid. I spent some time researching this and have tried to add parameters in an ini file to specify the instance to be updated. So far everything I tried has failed. Currently, I am not sure what to try next. Setup will not run from the dos prompt. Here is what my setup.ini file looks l ...Show All

• Visual Studio Express Editions Simple client and server applications

  how do i make server and client (but very basic, just to transmit a string would do). I've been programming in VB.NET for a year so im good, but not great. Transmit the string from where to where From server to client or from client to server From or to a database or a text file Where does the string reside We need more information.... ...Show All

• Visual C++ DLL linking error in release verson compilation

  For release version compilation, I got the following errors, Debug version is OK. Anyone knows why 'CABCApi::~CABCApi' : is marked __declspec(dllimport); must specify native calling convention when importing a function. Form1.obj : error LNK2028: unresolved token (0A00000E) "public: __clrcall CABCApi::~CABCApi(void)" ( 1CTrueChannelApi@@$$FQAM@XZ) referenced in function "public: void * __clrcall CTrueChannelApi::`scalar deleting destructor'(unsigned int)" ( _GCTrueChannelApi@@$$FQAMPAXI@Z) Many Thanks! Bluejay_2006 Thanks, Mike. In project configuration, I changed "Common Language Runtime Support" from "/clr:pure" to "/clr" and it co ...Show All

• Smart Device Development Telnet Client in Pocket PC

  Hi I want to develop a Telnet client for pocket PC using C#.net. But I am not getting any resource to do that. Pleae suggest me how to do that. If you know some resources that will help me please send me Regards Bijaya. Here's everything you need to know: http://www.faqs.org/rfcs/rfc854.html Device implementation would include opening TCP connection (say, using TcpClient class), transmitting/receiving data according to the document above and printing it on the screen whatever way you like. ...Show All

• Microsoft ISV Community Center Forums Post-Empower ISV Options

  Hi all, The company I work for has been in the Empower ISV program for almost two years. During that time, we have completed version 1.0 of a very large (about 800,000 LOC) enterprise application. We have made a few sales, but we're not rolling in the cash yet (hopefully that will change soon). We are still adding new features to our product, fixing bugs, etc, and as such we still need development tools. Since all of our tools are covered under the Empower ISV program, we'll have to switch to something else once our subscription expires. What exactly are our options Is there anything that isn't going to cost us an arm and a leg I doubt there's anything that's as cost effective as the $375/year we've been paying for Empower ISV, but is th ...Show All

• SQL Server Hierachy drill down stops at point

  I have the following scenario I have a Staff Parent child hierarchy and that links down to a division. A staf member is in charge of a division but we want the managers to drill down into the children and see which divisions they are in charge of etc. So here is what the data looks like Staff Lev1 | Staff Lev2 | Staff Lev3 | Staff Lev4 | Division | Value ------------|------- -------|--------------|-- ------------|----------- |--------- A | B | C | D | DivA | 1000 A | E | | DivB | 2000 the problem is, with drilling down though the staff hierarchy I can never see DivB, I can see the value associated to the Staff member E but when I try drill down it j ...Show All

• SQL Server SQL Syntax Error

  Thanks in advance Below is basic sql script. I don't know why it has syntax error. Please explain why and advise correct answers. DECLARE @Date_Range VARCHAR (200); DECLARE @RowCount int ; SET @Date_Range = '(Date BETWEEN CONVERT(DATETIME, ''2006-11-1 00:00:00'', 102) AND CONVERT(DATETIME, ''2006-11-30 00:00:00'', 102))' ; SELECT @RowCount = Count (*) FROM MyTable WHERE (EmployeeID = 1111) And + @Date_Range; Line 9: Incorrect syntax near ';'. ManiD -You are NOT correct! Mugambo's suggested WHERE clause will return all records, including all times, starting midnight (00:00:00.000) on the @LoDate up to, but not including midnight (00:00:00.000 ...Show All

• Visual Basic Groupbox Question

  On my mainform I have 9 groupboxes(size to about 1/2 of the screen, each box contains 2 - 8 comboboxes) They are not visible until they are called upon by a command button To keep from clutering up my mainform(I know in the app no one will see them, but I cant see my form) - if they are slide over to the side(showing the mainform only)and as long as I position them by code is this fine I didnt know if the form would think its wider that I actually want to show. Just curious! David Learning ...Show All

• SQL Server Exporting Database using Microsoft OLE DB Prvider

  Hello, I'm trying to export a database using the 'DTS Import/Export Wizard', I need to use the 'Microsoft OLE DB Provider for SQL Server', but it does not appear on the 'Data source' Drop-Down list of that Wizard. What can I do to get that OLE DB Provider installed I'm running SQL Server 2000 Personal on a Windows XP Media Center PC and I have MSDAC 2.8 SP1 installed. I also checked that I have the file sqloledb.dll on the 'C:\Program Files\Common Files\System\Ole db' directory. I'll appreciate any help. Thanks. Anybody I'm having the exact same problem. how do you "re-install" and register the standard data source items like " Microsoft OLE DB Provider for SQL Server " ...Show All