JosepMola's Q&A profile

• SQL Server Import an Access Database

  I am trying to import an Access database and I am using SQL Server Express. The instructions say to In SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks , and then click Import Data or Export data . When I point to Tasks, the Import Data is not listed. If someone can help. Should I be able to use the Import Wizard Thanks, Dougins http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx ...Show All

• .NET Development table adapters - update

  Can anyone explain why this code will not work- it will not add a new record everything else works fine. switch ( this .my_action) { case "Edit" : this .bsNCRdetail.EndEdit(); this .nCRdetailTableAdapter.Update( this ._2000NCRDataSet1.NCRdetail ); MessageBox .Show( "Record has been updated" ); this .nCRdetailTableAdapter.Fill( this ._2000NCRDataSet1.NCRdetail); break ; case "Add" : this .nCRdetailTableAdapter.Update( this ._2000NCRDataSet1.NCRdetail); MessageBox .Show( "Record has been added" ); this .nCRdetailTableAdapter.Fill( this ._2000NCRDataSet1.NCRdetail); break ; case "Delete" : this .nCRdetailTableAda ...Show All

• .NET Development Error on using multiple data reader

  Dear All, I have a multiple number of reading done so for the first one I have actually done the reading and close the the reader. Then upon reading the second one I also have close the datareader. But when I run my third reader is gives me this error "There is already an open DataReader accosicated with this Connection which must be closed first.". I have even check using the method IsClosed for the first and second and both shows that is true. What is the possible error. I dont think so that I must open and close my connection always rite. Thanks for your kind replies Hi, There MUST be datareader open... because its a problem when you have more than one data reader open associated ...Show All

• Visual C++ Fatal Error RC1102: too many arguments to RCPP

  The msdn documentation on this error says it can be caused by too many includes (/I) or too many define symbols (/D). I was curious what the limits on these two options actually were. Thanks! (I posted this yesterday, but it disappeared...) The post disappearing most likely means that it has been moved to a forum which is better suited. Check the "my threads" link at the top of your browser, and see if it's not still there somewhere. ...Show All

• SQL Server data being repeated.

  Hello, I have merged a master and detail tables into a fact table in order to create a cube, the master table let's say it's a sales table, and the detail the products of the sale, I merged both tables into a single fact table, so the data for one sale is being repeated once for each detail, this is the way I want. So if my sale has a total, let's say $100, and the detail has 3 products, when I visualize the cube the total for the sale is $300, and obviously this is incorrect, and let's say too, if there are many sales with different totals and differents details, the calculation can not be a simple MAX function or AVG, so, somebody know how I can show the data as I want Thanks in advance! odin_dark@yahoo.com.mx Dear , ...Show All

• Windows Networking Development Feature inqury (WinInet - SOCKS 5)

    First of all sorry if this message/thread wouldn't appear at the right place, I'm new to the forums, and dunno where to post it.   What I'd like to know is whether the WinInet API supports HTTP connections through a SOCKS5 proxy. I've successfully authenticated on a HTTP proxy server, and non-authenticated SOCKS (SOCKS4) connection works fine (gained some experience the old-fashioned trial-error way...), but SOCKS5 still refused to work.   In case some would have idea how to make it work, and would be as kind as sharing some details, I've mostly tried the InternetOpen(), InternetConnect(), HttpOpenRequest(), HttpSendRequest(), HttpClose() functions, together with InternetOption() called with&nb ...Show All

• SQL Server Failure sending mail: The system cannot find the path specified.

  I have had a development XP workstation with RS2000 and IIS sending reports via email for 6 months straight with no problems. Today my subscriptions are failing with Failure sending mail: The system cannot find the path specified. Been searching and digging for hours, and if anyone has any ideas they are greatly appreciated. I need some info to troubleshoot... Replicate the issue, then go the Report Server log (ReportServer_xxx_xxx.log) and email the log to me for review. markcam80@hotmail.com What I will be looking for is explicit error messages versus the displayed message. ...Show All

• .NET Development Proxy server

  Is there any way in the BCL to detect what proxy server settings are configured through IE (i.e. Tools-Internet Options->Connections tab->LAN Settings->Use a proxy server for your LAN...) Furthermore, if a proxy server is problematic (i.e. non-existant or is intermittant), is it possible for the BCL to distinguish between a bad network connection (e.g. a disconnected NIC) and a bad proxy server (e.g. unreachable proxy) Any thoughts Thanks. BTW, you can use the Ping class to test if a particular IP is responding or not. ...Show All

• Visual FoxPro SELECT .... INTO TABLE <existing table>

  G_TempDBF = "C:\scratch\" + SUBSTR(SYS(2015), 3) + ".DBF" SELECT field1, field2 FROM myTable INTO TABLE (G_TempDBF) USE (G_TempDBF) ALIAS CUSTOMER INDEX ON field1 TAG field1 I have created a temporary table, stores the retrieved records into it and alias it CUSTOMER How can i reuse this temporary table for other SELECT statements SELECT field3, field4 FROM myTable INTO CURSOR CUSTOMER ---> results in an error saying Alias CUSTOMER has been used. CetinBasoz wrote: Is there a reason you're using a table and not a cursor select field1, field2 from myTable into cursor customer readwrite would do what you want in most situations. ...Show All

• Windows Forms Handler don't work

  Hello to any one. I've a big problem with handler about applicationdeploy. Ive create a simple project with this code found on msdn site: Private sizeOfUpdate As Long = 0 Dim WithEvents ADUpdateAsync As ApplicationDeployment Private Sub UpdateApplication() If (ApplicationDeployment.IsNetworkDeployed) Then ADUpdateAsync = ApplicationDeployment.CurrentDeployment ADUpdateAsync.CheckForUpdateAsync() End If End Sub Private Sub ADUpdateAsync_CheckForUpdateProgressChanged( ByVal sender As Object , ByVal e As DeploymentProgressChangedEventArgs) Handles ADUpdateAsync.CheckForUpdateProgressChanged DownloadStatus.Text = [String].Format( "{0:D}K of {1:D}K downloaded." , e.BytesCompleted / 1024, e.BytesTotal / 1024) End S ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. DrawModel Memory Problem

  Hey all, i have used the code from the MSDN documentation which draws a model but i have run into a problem. private void DrawModel(Model m) { Matrix[] transforms = new Matrix[m.Bones.Count]; float aspectRatio = 640.0f / 480.0f; m.CopyAbsoluteBoneTransformsTo(transforms); Matrix projection = Matrix.CreatePerspectiveFieldOfView(MathHelper.ToRadians(45.0f), aspectRatio, 1.0f, 10000.0f); Matrix view = Matrix.CreateLookAt(new Vector3(100.0f, 150.0f, -150.0f), Vector3.Zero, Vector3.Up); foreach (ModelMesh mesh in m.Meshes) { foreach (BasicEffect effect in mesh.Effects) { effect.EnableDefaultLighting(); effect.View = view; effect.Projection = projection; ...Show All

• SQL Server Report Execution timeout after 60 minutes (1 hour) - Execution cannot be found (rsExecutionNotFound)

  Dear Colleagues I wonder if you could help me. I have a report that runs for from 0 to 1,5 hours when executed. If the report executes and renders output file in less than 60 minutes - it works fine, but if only it takes more than exactly 60 minutes to run it generates the following ASP.NET exception: ReportServerException: Execution 'lmxn1q3k3zdxwjvavsargonw' cannot be found (rsExecutionNotFound) At the same time if I make a subscription to save report for example to network share it does not stop at 60 minutes and saves data to the required folder (I've scheduled it this night and the report was saved after 1,5 hours of execution). The report server Report Execution Timeout setting is set to never expire . I also tried to ...Show All

• Visual Studio Modifying File/Item Content Programmatically

  Hi All, I've posted this question some time ago along with another question. But because it is not answered yet, I repost it again. This question is about modifying the content of an item in the project. The item could be a C# file, or XML file, or text file etc. I found a DTE automation interface, EnvDTE::FileCodeModel, that has methods that do similar thing with what I want. The differences are: 1. I want to be able to not only modify source codes, but also other files (XML, text, etc). 2. I'm really trying to not use DTE automation. My scenario is, I find the item that I want to change with IVsRunningDocumentTable.FindAndLockDocument(), and then I want to modify its content with an event, for instance. Then the questions are: 1. Is the ...Show All

• Visual C++ Another Error while compiling

  while compiling this error happened error C2661: 'UtlHashMap::UtlHashMap' : no overloaded function takes 2 arguments JavaSUAListenerDispatcher::JavaSUAListenerDispatcher() : OsServerTask(m_sTaskName) , m_htSipListeners(8, TRUE) , m_htLineListeners(8, TRUE) { // <-- here it’s where the error happened } there’s someone that knows what can i do to solve this error http://msdn2.microsoft.com/en-us/library/064x9y7c.aspx contains the possbile causes of such error. Thanks, Ayman Shoukry VC++ Team ...Show All

• Visual C# XML Comment problem...

  if I add an attribute for the property browser it cancels my xml comments from displaying. Is there something I'm doing wrong here is a typical example of what I have... Thanks In Advance, Devin [ Description ( "Gets or sets whether to allow editing of this control. This will enable the drawing and draggin of edit grips to move and resize the control." ), CategoryAttribute ( "Editing" )] /// <summary> /// Gets or sets whether to allow editing of this control. This will enable the drawing and draggin of edit grips to move and resize the control. /// </summary> public bool EditMode { get { return this .editMode; } set { if ( value != t ...Show All