jadog's Q&A profile

• SQL Server Problems with Parameterized insert SQL with OLEDB Destination

  Hello, I've searched around and can't find any references to the problem I'm having. I'd appreciate any ideas or input. I'm trying to use the OLEDB Destination for an insert at the end of a long data flow. I need to parameterize the input, and for some of the columns I need to use literal values instead of parameters. It seems like this should be the most common thing in the world, but I'm at a loss to get it to work. I type in the SQL statement ...Show All

• Visual Basic Resolving Assembly Usage.

  How can i resolve if some .Net ...dll is used by any (or defined) .Net application, not touching this application. Ok, I say in another way. "Not touch" i mean - not to correct code in it and add some methods. But the main thing is that i need to do it in runtime, that mean when my programm runs it has to check if some .Net dll (determined) is already used by another programm, and it's great to know wic ...Show All

• .NET Development Using partial trust client with fully trusted assembly

  I'm trying to understand what happens when a web client set to medium trust calls a fully trusted assembly in .Net v2.0.  I have a simple assembly that is signed with a strong name, and has been granted full trust using: caspol -af fulltrust.dll.  The fulltrust code has an assembly level attribute to allow partially trusted callers:  [assembly: AllowPartiallyTrustedCallers]. In most cases, this works as I would expect.  That ...Show All

• SQL Server Schedule Stored Procedures

  Hello all, I created a stored proceduce to delete specific records from a table. I want it to run every week. How can I schedule a stored procedure I tried with SQL Server Agent -> Jobs, but it isn't a transact SQL-script. Any ideas Thanks in advance. Hello Konstantin, Thanks for the quick reply. It's working! That simple... Best regards. ...Show All

• .NET Development Creating POPUP WINDOWS IN ASP.NET

  Hi While my surfing through the net , i came across a website that d espite the popup blocker installed (whether Yahoo, in-built for IE, Google etc) was able to show popup window , but it happens only the first time as i think it is cookie based ...when deleted the cookies it again popuped up. The name of the site is www.netscape.com , can anybody explain how it is done Not 100% sure but I would imagine that the popup you are talkin ...Show All

• Windows Forms Regarding DataGrid

  In VisualBasic.net (Windows Forms) I need to be able to search a DataSet by typing a few letters in a textbox. UI has  a textbox, a DataGrid, 3 labels. When the user type the first few letters of the name they are searching for, the&n ...Show All

• Visual Basic Question about screenshots

  I'm building a program in vb6 that is supposed to get a screenshot of all windows and paste them on 3d boxes using truevision 3d. Is there any possible way that i could get the active image of the windows and have them update without having to cycle through all the windows, ie. bringing them all to the foreground then calling screenshot method then reminimizing them all I would much rather have the windows off the screen and then get the image f ...Show All

• Visual Basic Can't run SnippetEditor.exe

  it says, "Unhandled exception has occurred in your application. If you click....will close immediately. "Object reference not set to an instance of an object." Details: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.NullReferenceException: Object reference not set to an instance of an object. at SnippetEditor.Snippe ...Show All

• SQL Server problems to conect a cube in client due to panda antivirus

  I have the next problem: i have MS sql server 2005 installed in a server. We have some olap cubes in the server deployed with analysis services 2005. When we try to connect to the analysis server from a client pc using pivot tables we obtain this error: "Errors in network layers. Error code=0XC10D0009, External code=0x00000000" The client pc has panda antivirus (corporate) with true prevent When i unisnstall it, we can connect to the a ...Show All

• Visual Studio Team System Team System and Small Business Server 2003

  Does anyone know if Team System (when released) will install on Windows Small Buisness Server 2003.  I have had the Beta 3 running on a development Win 2003 server, but the office server on which we would finally use it is SBS2003. The problem seems to be the sharepoint configuration.  I have removed the default SBS share point install, removed the sharepoint databases as discussed in another thread and installed the sql ...Show All

• Visual Studio Referencing Properties that contain free form XML

  If you have a property group with a property that contains free form XML and you want to reference the value, of say, OutputPath, what is the syntax for doing so $(ConfigOptions) gives you the entire XML string, as you would expect. I'd like to get to the CodePath within $(ConfigOptions). I played around with a few variations, but none seemed to work. Are free form XML properties only intended for logging and tasks that actually know how to par ...Show All

• SQL Server Can it be a bug in SQL CE?

  Hi! I use SQL CE with VS.NET 2003. I find the following bug second time. The table has an " ID int IDENTITY(0,1) PRIMARY KEY,". That is my row identity. I add rows to the table, then I made some select and update queries. Then I realized that the ID order not in the general order (from 0 to ........) For example: 6,7,8,0,1,2,3,4,5. Of course row 6,7 and 8 was added the very last. The content of each row is not mixed, ...Show All

• Visual Studio Express Editions TextBox/Label indexing

  Hello Is there a way to display a string value in a textbox or label and then be able to overwrite that value for the next instace of the string. For example I am reading a battery voltage off of a probe and I want to display that value and then when a new value is available I want it to be overwritten where the old value was without using the TextBox.Clear(). I was thinking if there was a way to reset the testbox index back to 0 so that ...Show All

• Visual Studio Team System SQL Express only?

  Not a big deal, but I currently have my test machine without Express installed and it will not allow me to work a database project. Is Express the only version that works for these types of projects at this time TIA, Greg Hi Greg, it works also with other editions, eg. developer, but afaik it must be running since it's used as a local repository. If you have another instance of SQL around, not the default MSSQL$SQLEXPRESS one, yo ...Show All

• Visual Studio Team System Excel workItems menu doesn't appear

  Hi, I have installed VS 2005 Team Suite and finished OK. I previously installed Word, Excel and Project 2003. VS seams to work fine but I can't access the workitems menu in MS Excel. If I tried to open Excel from a WorkItems List in VS (for example from Active Bugs query results) I get an error message that says: "Old format or invalid type library. (Exception from HRESULT 0x80028018 (TYPE_E_INVDATAREAD))" The workItems menu in MS Project works ...Show All