Entity_X's Q&A profile

• Visual Studio Express Editions Access Databases!! Without Databindings

  Hey there, I have foun the way to connecto to an access database and use it without the DataBinding and the BindingNavigator First: You will need to add the Database into your Project, its better if you create the database in Microsoft Access first and then add it into your project as an existing item, use the general help to do this, when you finish adding the Database to your Project, it will create and add a DataSet into the Project too, that will contain the info from your Database. Second: You will have to add a DataSet Control to your principal form or the one into you are going to write the co ...Show All

• SQL Server Why I cant add key attribute into the hierarchy of the dimension?

  Hi, all here, I was trying to create some dimensions, I found that the key attribute of each dimension cant be added to the hierarchy. Is it that key attributes cant be used for hierarchies Also, we can create different hirarchies for the same data source view Thanks a lot in advance for any guidance and help. Hi, You should be able to add the key attribute to a hierarchy, just make sure it is added as the last level. In the dimension editor, do you get an error when trying to drag-and-drop the key attribute onto the hierarchy About creating multiple hierarchies from the same data source view: yes, you can do that. In a dimen ...Show All

• Visual FoxPro video control

  While waiting for answers to my other post I tried to play with a video control. It gives me an error I cannot understand: cFileName = JUSTSTEM ( JUSTFNAME ( cLine )) THISFORM . O_VIDEOPLAYER1 . cfilename = cLine THISFORM . O_VIDEOPLAYER1 . playvideo ( cFileName , 100 , 100 ) cLine is the complete path to an .AVI file. The error is that "no parameter statement is found" Is anybody familiar with this control Thanks. Alex, While you're reading other:) go to VFP9 tools\task pane. Click more panes (chevron) and check solution samples. There at least 2 samples for playi ...Show All

• SQL Server SSIS Execute Task problem

  Hi! I want to make an Execute Process Task that will make a connection with VCP.exe (Secure FTP from SecureCRT, you need to install all components from SecureCRT to have this one. It also fixes your system paths so you dont need to include the working directory). In Expression Window i managed to create an expression that will create the connection string that looks like this: "vcp.exe -pw password username@222.222.222.222:/home/username/tickets/" + "grnti_" + RIGHT("0" + (DT_STR, 4, 1252) YEAR( GETDATE() ), 4) + RIGHT("0" + (DT_STR, 2, 1252) MONTH( GETDATE() ), 2) + RIGHT("0" + (DT_STR, 2, 1252) DAY( GETDATE() ), 2) + "0000" + " c:\\DATA\\" ...Show All

• SQL Server Creating Unique Indexes on Partition table..

  In partition tables, SQL Server forces to include the Partition column as part of unique index/unique constraint or primary key. Is there a way to over-ride this option. We have a table, which is partitioned on a Calculated Column (generated using custom logic). Also we need to enforce uniqueness based on few other columns. But SQL Server does not allow indexes/contraints on these columns without including the partition column. Thanks for your help. Well, you can create a non-aligned unique index on a partitioned table, but doing that will in essence not allow meta-data-only partition switching. Depending ...Show All

• Windows Forms BindingSource + Object + nulls = problems

  Ok, so we have a business object, and there's a grid bound to the binding source that holds the objects.  If you clear a string field and move to another row you get an error about not being able to convert DBNull.value to a string. First of all, why isn't the grid saving string.empty instead of null Second, I tried using string for the property but got this error message: Error    1    The type 'string' must be a non-nullable value type in order to use it as parameter 'T' in the generic type or method 'System.Nullable<T>' A. I don't understand what it's saying, and B, how do I get around this so ...Show All

• Visual Studio Express Editions Is the VS 2005 Webbrowser really ready for prime time?

  I am trying to use the Webbrowser control that is available in VS 2005 C# Express (.NET 2.0) to automate navigation through a set of web pages programmatically. I've run into two situations where I cannnot access the OuterHtml property of an HtmlElement. Looking at the debugger seems to say that some kind of underlying exception occurs. 1. I want to select an item in a listbox on a web page by changing the OuterHtml of two of the member elements from: <OPTION value="default" selected> <OPTION value="mychoice" > to <OPTION value="default" > <OPTION value="mychoice" selected> The ...Show All

• Microsoft ISV Community Center Forums What MSDN editions have non-English Windows XP?

  I have a client that wants me to test his VB6 application on various foreign language Windows XP installations. He's willing to pay for me to get the OSs to test on. I'm wondering what is the cheapest version of MSDN that has all the languages like the old MSDN Universal did. I assume the MSDN Operating System subscription is just English, right I would also assume that MSDN Pro doesn't have it since the old Pro didn't, right Does MSDN Premium have them I looked around the MSDN site a bunch and I found various places that let you compare versions none of them seemed to have anything about non-English Windows. Is VS Pro with MSD ...Show All

• .NET Development ServicedComponent RegistrationException - Invalid Derived Classes

  I am having difficulty with code that used to work in 1.1 working in 2.0. I have an n-tier application that uses ServicedComponents for persisting database information within a single transaction. Because I want these classes to be able to participate in transactions, I derive them from System.EnterpriseServices.ServicedComponent. In 1.1, this worked just fine, however in 2.0, when remoting these components using .NET remoting over TCP, I recieve a RegistrationException stating that: Invalid ServicedComponent-derived classes were found in the assembly. (Classes must be public, concrete, have a public default constructor, and meet all other C ...Show All

• Visual C++ CBitmap - Simple example

  Hi, I am trying to load some images in a Picture Area. I only have the pointers to the images, and this pointers are of the type unsigned long* (I can also convert it to IplImage* to use with OpenCV). This unsigned long* get the images grabbed from an camera and I would like to display these images in this Picture Area (it is real time, I get the images from my camera and display them). I have tryied to use this (HBITMAP)LoadImage function, but the last parameter is always LOADIMAGEFROMFILE but this is not real in my application. So, can you help me with convert my unsigned long* to an Bitmap and than load it on the exacly place that I want ...Show All

• SQL Server Updating a record from table with data from a column of another record from the same table

  Hey guys, I have a table say as follows id, id2, field1, field2, date1, date2 I want to update the date1 field to the date2 field of the very next record with the same id2. In short I want to update a record id(x) by putting in the date2 field if id(y) in the date1 of id(x) where id2(x) = id2(y) and id(y) > id(x) (as id is a sequence). I have written a query as below: update t_remarks te set out_date = (select TOP 1 date_remark_entered from t_remarks ta where ta.record_id = te.record_id and ta.remark_id > te.remark_id order by ta.remark_id) the above query throws an error: Line 1: Incorrect syntax near 'te'. Incorrect syntax near t ...Show All

• Visual C++ Deprecated vsprintf

  I have the following code: char buf[1024]; va_list va; va_start(va, s); vsprintf(buf, s, va); va_end(va);   The Visual Studio 2005 Express Edition compiler gives the following error: Compiling... strgen.c .\strgen.c(87) : error C2220: warning treated as error - no 'object' file generated .\strgen.c(87) : warning C4996: 'vsprintf' was declared deprecated What do I do What do I replace it with Please help. Thank you. Thanks for the help, I've managed to solve the problem :) Glad to see such enthusiastic support. ...Show All

• Smart Device Development Problem with GPSAPI

  I am writing a small app for a treo 700w, convenienty having an sdio card slot. Anyway, I am trying to write an app that can get the gps information from the gps device for that SDIO slot. I already know it works (and not too badly I might add) from the software it came with. However, I am getting the LNK2019 error with the use of any function from GPSApi.h. If I use the wizard to make a new app and I add only the include and the GPSOpenDevice function call, I still get the error. It looks like this in the fresh app: test.obj : error LNK2019: unresolved external symbol GPSOpenDevice referenced in function WinMain Windows Mobile 5 ...Show All

• Visual Studio 2008 (Pre-release) DLinq submit error

  On Windows XP when call db.SubmitChanges(); An unhandled exception of type 'System.Transactions.TransactionManagerCommunicationException' occurred in System.Data.dll Here is the code:             AccountingDataContext db = new AccountingDataContext ();             var prj = db.Projects.ToList();             var prj_new = db.Temps.ToList();             foreach ( var p in prj)         ...Show All

• SQL Server Replication to IP addressed server

  we have an outside company that replicates to us and we are known to them via an IP address.   We get an error now...Sql Server 2005 now does not support a server Alias, IP address, or any other alternate name are not supports.  Specify the actual Server Name I tried putting in the hosts file on their server 168.168.110.2       SQL2005 able to connect to our server through Studio Manager...no problem.... replication....no dice what is the work around to make this happen, I am not a network guru...know enough to kill someone, but I need to get this to work before I can move to the ne ...Show All