Dietz's Q&A profile

• SQL Server VS2005sp1 deploys SqlServer Mobile 3.0 instead of Compact Edition CABS

  Hello installed: VS2005 Sp1 SSCE31VSTools-ENU.exe SQLServerCE31-EN.msi When creating mobile project in VS2005 it automaticaly adds reference to System.Data.SqlServerCe, version: 3.0.3600.0 path: C:\Program Files\Microsoft Visual Studio 8\SmartDevices\SDK\\SQL Server\Mobile\v3.0\System.Data.SqlServerCe.dll instead of: C:\Program Files\Microsoft SQL Server Compact Edition\v3.1\SDK\bin\wce400\System.Data.SqlServerCe.dll version: 3.0.5300.0 When creating desktop solution I don't have this problem. Please help! Thanks I'm seeing the same thing. When I set a reference and look at the properties, it's the 3600 version. What needs to be done for this to be th ...Show All

• SQL Server copy content of txt file

  Hi Guys, What approach should I use to copy content of a text file. Is BCP capable of doing this How about SSIS Example of the text file's content: Date, "20060101" ST_Code, "101" A_Code, P_Code, T_Code, amount, price "0001", "1111", "0101", 550, 230 "0002", "1111", "0102", 345, 122 "2001", 0212", 0930", 410, 90 In the example above, I just want to copy the rows Date, "20060101" and ST_Code, "101" into a table. Regards, Lars hi, if you know the location of the row you want to copy you can use the -f anf -l switch of BCP which stands for -f = the first r ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XNA IDE

  hello, The installation instructions for XNA sort of infer in the download you get a modified CLR and an ide based on visual studio express. I use the full version of visual studio 2005 professional, can I use this instead or do I need to have two IDE's running thanks. Neil. Better asked over in the GSE forum... It is probably already answered there. I think you can just reference the XNA libraries in Pro and use it. But there's no tutorials or templates built for Pro, yet. ...Show All

• SQL Server SSAS Cube and Report Model

  After creating a cube in SSAS, is it possible to make this visible to users in Report Builder As far as I can see Report Builder uses report models which are based on a relational database for a data source view, so it seems I have to rewrite all the cube logic in order to make it available in Report Builder (otherwise I guess it's a case of telling users to connect to the Cube from Excel ) Thanks Not sure this answer your question or not. Once you deploy and process your cube go to SQL Server Management Studio, connect to Reporting Services. Create "New Data Source" by right click Home to OLAP database. data source type: Analysis Services connection string: data source=OLAPServerName;i ...Show All

• Visual C# global settings - saving problem

  Hi I have a big solutions with many projects. I wanted to create global settings which would be visible from all of the projects. I created one project responsible for dealing with settings. It contains class public class P Settings : ApplicationSettingsBase { private static bool globalProp; [ UserScopedSetting ()] [ DefaultSettingValueAttribute ( "false" )] public static bool GlobalProp { get { return ( bool )globalProp; } set { globalProp= value ; } } etc. This project also contains class which has static fields for dealing with above settings. public class GlobalSettings { private static GlobalSettings instance; static GlobalSetti ...Show All

• Visual Studio Express Editions Date and time in 1 variable

  Hi, I am creating a program that is remotely similar to a calendar manager .What I want is the user to select a date on the date picker and then click on a button that would be eg, 9 am. What it does now is to create a record with date = that of the date picker and integer=9. Is there the possibility that when you click in the 9 am button the program creates a date that has the date picker's date and the hour 9 Thanks. because the datetimepicker value contains a date and time value (even if just formatted for date) you need to strip away the time value and add the hours back to it: MessageBox . Show ( Me . dtpStart . Value . ToString ) Dim d As Date = Date . Parse ( Me . dtpStart . Value . ...Show All

• Visual C# Why i can't locate exceptions to specific code file and code line within vs.net2005?

  In fact, I’m not sure whether this is my problem or vs. net’s problem. There is a solution which migrated from vs.net 2003 and includes several class library projects and a web project. When I build this solution, there are some exceptions appeared in Error list. But, some of them which related to the web project just have error id and the error description but without file/line information. This kind of error info makes me can't locate exception to specific code line. That’s real difficult to do debug works. Anyone ever know the same situation like that Anything I can do to solve this Thx. can't here post some sample images from out of this forum anyway, u can find the sample image here: http://illusions.zo ...Show All

• Visual Studio Express Editions error LNK2019: unresolved external symbol

  Hi, I'm a newbie in c++ and have just installed the VS 2005 express and PSDK. I tried to run the example of drawing a line from ms-help://MS.PSDKSVR2003SP1.1033/gdicpp/GDIPlus/usingGDIPlus/gettingstarted/drawingaline.htm and I get errors like : error LNK2019: unresolved external symbol _GdipCreatePen1@16 referenced in function "public: __thiscall Gdiplus::Pen::Pen(class Gdiplus::Color const &,float)" ( 0Pen@Gdiplus@@QAE@ABVColor@1@M@Z ) Can you please tell me what am I doing wrong Thank you it means that you are not linking the correct libraries to you code, add this to the top of you code: #pragma comment ( lib , "yourlib.lib" ) with yourlib as th ...Show All

• SQL Server Cannot open database "xx" requested by the login. The login failed.

  Hi, we are running a webapplication, using IIS6, Windows 2003 64 bit in classic Asp. In the ASP pages we connect to our SQL server (SQL Server 2005 64bit,windows 2003 64 bit), mirrored on a third sql server (same software /hardware setup as the first sql server). The mirroring is without witness. This works but sometimes we get the following ODBC error in our ASP application : Description: [Microsoft][SQL Native Client][SQL Server]Cannot open database "OBJECTS" requested by the login. The login failed. No error can be seen in the principal SQL error logs. But a failed authorization can be found on the mirror server.. And this of course this makes sense, as t ...Show All

• SQL Server Scheduling simple cdosys email task does not work

  I currently have a simple cdosys email task that has been scheduled to send a simple email from ssis.  The email is sent using an activex script in a "SQL 2000 DTS Package Task".  When executed manually, the email is sent ok.   When scheduled (and run under our SQL agent account), it fails.  Can anyone point me in the right direction  Is this a permissions issue '-- this script seems to cause problems, but only when scheduled --     dim mailer     set mailer = CreateObject("CDO.Message")     dim cdoconfig     const cdoDispositionNotificationTo = "urn:schemas:mailheader:disposition-notification-to"     const cdoReturn ...Show All

• Smart Device Development Trouble conneting to WebService from the phone

  Most of the problems that people encouter are from emulator, my problem is actually on the device itself. I'm using T-Mobile Dash with Windows Mobile 5.0. Everytime I try to connect to webservice from my mobile phone I'm getting similar error I guess like everyone else... Connection could not be established to the Network . I have no problem accessing WSDL page from IE using GPRS or EDGE. The webservice call is very simple call (HelloWorld) Is there any other settings I should check Yes I tried that option, nothing changed... also tried to call TMobile and of course they told me they don't support 3rd apps and since my IE connection works they can't help me. ...Show All

• .NET Development top-level param default value is ignored

  Hi, I have the following line right after the output element in my xslt file: <xsl:param name="selectedColorScheme" select="'default'" /> I set a breakpoint after this point so that I could check the value of "selectedColorScheme" and it shows up as null instead of the string "default". If I change it to a variable instead of a parameter, it works. Unfortunately, that doesn't give me the flexibility of passing in an override value. Am I missing something here Fair enough and I have now confirmed it using the following scenarios. 1) No reference to the param. -- The param statement is skipped and the value is null. 2) Param referenced later in a top-level var ...Show All

• Internet Explorer Development Dont Fire NewWindow3 when new TAB is opened by CTRL+T.

  Our team have made a synchronous tools for IE( http://www.syncplus.net/en/ ). Recently, I am doing an upgrade for IE7 in Vista RC1, but have a problem about the NewWindows3 event. The NewWindows3 event is fired by the following case. 1)Choose the "Open in New Tab" command from a link's shortcut menu. 2)Click the link with the middle mouse button. 3)Click the link while holding the CTRL key. But can't be fired by the following 1) CTRL+T 2) Directly click the empty tab. Would you like give me some advise thank you. I sink the DWebBrowserEvents2 in my Toolbar. AtlAdvise(m_pIWebBrowser2, m_pUnk, DIID_DWebBrowserEvents2, &m_dwCookie); I can receive the NewWindow3+NewWindow2 ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. XACT data loading problems

  Well, after a short discussion of what audio library to use, my team and I have decided to use XACT audio for our 2D game on WindowsXP. I got the framework pretty well set up, but I am having a major issue with loading up a wave or sound bank. Loading up a streaming wave bank gives me an S_OK, but the other two give me a XACTENGINE_E_INVALIDDATA error. Ive tried a number of .xwb's, from the ones given in the XACT samples, to others i created myself using XACT. It reads in the file fine, I believe it maps the file to the void* buffer just fine, but I'm unsure how to check if it is. It also gets a correct file size, but when it goes to create the bank it fails. Any help would be greatly appreciated, as I have spent far too much time checking ...Show All

• Visual Basic Value assignment problem

  I have a function that is supposed to find where a label should be placed to be in the center, but I get a code error. The code looks something like this: Public Class Form1 Dim screensize As Rectangle = My .Computer.Screen.Bounds Sub New () InitializeComponent() Label1.Location.X = centerLabel(screensize, Label1) End Sub Function centerLabel( ByVal rect As Rectangle, ByVal label As System.Windows.Forms.Label) As Integer Return (rect.Width / 2) - (label.Width / 2) End Function End Class The Label1.Location.X part is underlined in blue and the error says "expression is a value and therefore cannot be the target of an assignment". What am I doing wrong here ...Show All