Helen Cool Granny's Q&A profile

• Visual C++ fatal error LNK1181: cannot open input file 'libc.lib'

  We're converting our code from VS 2003 to VS 2005 and have a one problem... Our Managed assemblies can't link anymore.. It says it can't find libc.lib.. when looking into the lib directory there is no libc.lib anymore for VS 2005. What lib file do I need to link with What work around I need to do for this problem Setting the linker to ignore it doesn't work. Advance Thanks for your answers Visual Studio 2005 did away with the single-threaded c libraries, there are now only multi-threaded libraries.  You shouldn't need to directly link to these libraries.  You project settings tell the IDE how to invoke the linker.  In particular, the project property "Runtime library" on the Configuration ...Show All

• SQL Server what will be happening to the SSRS while DB mirroring?

  hi there, can the SSRS works with DB mirroring If yes, how to do it I just tried to enble mirroring for reportserver and reportservertempDB, but it doesnt work after failover. Any idea Hi, How do you specifiy the connect string for the SSRS data source to support a mirrored source database I receive an error while running the report when the datasource includes Failover Partner in the connection string. Connection String: Data Source=<DB Server>;Failover Parter=<Failover DB Server>;Initial Catalog=<Database> Error running report: An error has occurred during report processing. Cannot create a connection to data source 'DefaultDataSource'. Keyword not supported: 'failover ...Show All

• Windows Forms BindingSource.DataSource = <Interface>

  My problem is at design time, dealing with setting the datasource value on BindingSource objects and the resulting display or lack thereof of some or all properties in the design-time DataMember dropdown lists. The problem only happen sometimes, but I haven't yet isolated exactly when it happens. I have the following interfaces: public interface IFoo { string Name { get ; set ; } int Age { get ; set ; } IBar Bar { get ; set ; } } public interface IBar { string Name { get ; set ; } string Address { get ; set ; } } My Problem: I set the value of the DataSource property of a BindingSource "binding1" to IFoo. Now I try to create a binding to Name from a textbox &q ...Show All

• SQL Server Forcing Function recompilation in SQL 2000

  A stored procedure in the cache is automatically recompiled when a table it refers to has a table structure change. User defined functions are not. Here's a simplified code sample: set nocount on go create table tmpTest (a int, b int, c int) insert into tmpTest (a, b, c) values (1, 2, 3) insert into tmpTest (a, b, c) values (2, 3, 4) go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[fTest]') and xtype in (N'FN', N'IF', N'TF')) drop function [dbo].[fTest] GO CREATE FUNCTION dbo.fTest (@a int) RETURNS TABLE AS RETURN (SELECT * from tmpTest where a = @a) GO select * from fTest(1) CREATE TABLE dbo.Tmp_tmpTest ( a int NULL, b int NULL, d int NULL, c int NULL ) ON [PRIMARY] IF EXISTS(SELECT * FROM dbo. ...Show All

• Visual Basic Drawing Control

  Hi all I am trying to create a control to do something similar as a Visio drawing, but I don't have Visio on my PC to use their drawing tool. I want to drag images from a ListView into a PictureBox or something more usefull and at the end of the day have a flowchart with alot of custom functionalities that Visio does not offer at this stage. I have managed to get the dragging and dropping done, but it drops the image in the top left corner of the PictureBox, and I want the image to be dropped at the point where the mouse is. I would also want to be able to resize the image as well as possibly reposition it once it has been added to the PictureBox. Is this possible, or are there another control that I can use/download for free Thank You ...Show All

• SQL Server Dynamic data flow source query

  I currently have a requirement to be able to create a package which will execute a SQL statement provided by a user at runtime, probably by using package configurations. The package needs to run the dynamic query against an Oracle database, but then it needs to transform the result set which was the output of the runtime query based upon the data types of the fields in the result set. So basically the SQL statement and the transforms for it all need to be dynamic. My question is, can a data flow task source component of any kind be configured to use a dynamic value, such as from a package variable, or even the result set of a control flow execute SQL task For example, could the SQLcommandtext property of an OLE DB source component ...Show All

• .NET Development question on Insert a New Data into .sdf file,need help!!

  Hi, I have questions on insert a new data, i wrote the codes as below and i run it. It's no problem on the codes part, but when i open my order table from order.sdf file, it is empty record. do i miss some codes or do i write it wrong why my order table is empty record since i added "123" for it does anyone know about this private void addbutton1_Click(object sender, EventArgs e) { ABCDBDataSetTableAdapters.orderTableAdapter ota = new this.ABCDBDataSetTableAdapters.orderTableAdapter(); ABCDBDataSet.orderRow newOrderRow = aBCDBDataSet.order.NewOrderRow(); newOrderRow.Items = "123"; aBCDBDataSet.order.Rows.Add(newOrderRow); ota.Update(aBCDBDataSet.order); } Check the following to see if ...Show All

• Software Development for Windows Vista Drive letter access for DVD in Vista

  I'm a software developer, and have an app that currently uses Roxio Drag-to-Disc on XP for drive letter access to DVD and CD media for write and read. It appears that Vista now contains this type of functionality built-in. Windows Explorer for instance can format a DVD with a UDF file system, and when ejecting a DVD, the user may close the file system, etc. How is this functionality accessed from a user mode app I've searched the SDK docs, but can find no mention of this. Hi Henry; Thanks for your reply. Some more detailed questions now... My program is a backup application. It can use DVD or CD media, either write once or rewritable. For example, using Roxio Drag-To-Disc (on XP), a write onc ...Show All

• SQL Server My First time trying to deploy a cube

  Hi I'm going through an online training trying to deploy my first AS 2005 cube and i've fallen at the first hurdle. I'm getting the following error: Error 1 Errors in the high-level relational engine. The following exception occurred while the managed IDbConnection interface was being used: Login failed for user ....... Where is the app. getting this login from because it 's not one i've set up. Thanks Hi. Check the authentication in your data connection in the project. It can be related to impersonation(the second tab in the connection). If you are part of the local administrators group on your workstation and both the database and Analysis Services are installed he ...Show All

• Microsoft ISV Community Center Forums Opening af text file in VBA

  I want to open a random text file in Visual Basic for Applications under MS Access. First, I just want it to open. Down the road, I would like to also be able to parse it and take some parts of the file and put those in one table, other parts in another table, do some looking up in the table based on the fourth parts and depending on the result of that look-up insert some fifth parts of the text file in a specific cell. I've tried the regular import function but it can only put data into one table and there's no mean of manipulating data. One of the entries in the text file is "05MAY2006" which I want to have read as a data. I only have little experience in the mystic world of VBA and really advanced MS Office usage. I do, howe ...Show All

• Visual Basic Reset AutoIncrement Primary Key. See the SQL videos.

  Using VS05 SP1 Pro... Is there anyway to reset a Table's a primary key to 1 that is Identity Specification Yes autoincrement by 1 seed 1 We are using SQL Express, but never touch SQL directly. The problem is I have one data table where the primary key is up to 2,366,784 - this table gets added to extensively, but then deleted extensively. If we could do it in code or even manually it would be OK. Thanks! Bob First, I'm not a SQL Expert. This is, how I would reset the primary Key. 1. Create a temporary Table, which is exactly the same as the table you want to reset 2. Insert all Data from the original Table into the temporary Table. 3. Truncate the original Table (here is the counter reset) 4. Insert all Data from the ...Show All

• Visual Studio Calling project method within VS IDE from an Add-In

  Hello, I've designed an Add-In that parses and displays VB Project Methods in a treeview using extensibility. The VB project scan its own assembly to retreive its own methods and displays them in a treeview. I can run a method within this project using the "InvokeMember" method by double-clicking treeview nodes. This project knows VS 2005 instance it lives in. The executed method is in the IDE as when I put a breakoinp in method code it stops where the breakpoint is set. What I would like now is to call VB Project methods by double-clicking on Add-In treeview method's name, then execute the method within the IDE. The only mechanism I can think of so far is to fire an EnvDTE event from the add-In whe ...Show All

• SQL Server Inserting to Dimension on Failed Lookup

  First, I'm very new to SSIS, so forgive any stupid questions. I'm trying to normalize some data by creating rows in a dimension table as I find new values in the original table. My first thought is to use a Lookup to replace string values with id's to the Dimension table, and when the Lookup fails, insert the value into the Dimension table with a new key. Does that make sense This would be relatively easy to do with TSQL, but surely there is a way to do this in SSIS. Thoughts Thanks! I will read that thread... Responding to your suggestion, however, I can't use a default value because if the lookup doesn't work then a new record needs to be inserted into the Dimension table. For example, if my row has "XXX" as a value and ...Show All

• Visual Studio F5 does not work ! : Need to use "Start new instance"

  Hello, I am trying to debug an application with my Visual Express 2005 c++. It compiles nicely a "hello world". However, to debug, if i use F5, it doesn't do anything.. I have to right click on the project and use the debug->start new instance or debug->step into new instance. And sometimes the debugger becomes unstable. I "think" that when the debugger starts, it goes to __tmainCRTStartup and hence I need to force the debugger to jump to my "main" .. Is this normal I would like my debugger starts in my main. Can anybody help me please thank you So to be clear - initial pressing of F5 - or going to the debug menu and saying "start debugging" fails completel ...Show All

• SQL Server Partitions and Slices without query binding

  I have a fairly straightforward cube in SQL 2005 SSAS, with date as one of the dimensions.  I created a partition for each year and quarter, and set the slice appropriately.  However, in order to create the partition, I had to use a source query, because I got an error about re-using the same table.  I then created a single partition that was based off the table and set a slice and reviewed the SQL that SSAS issued, and it did not restrict based on the slice. My question is:  Can you make SSAS (2005) work like SQL 2000 where it automatically generated (albeit not perfectly) a where clause to restrict the partition Thanks,   Doug Hi Doug, The way I got this t ...Show All