Mario Cano's Q&A profile

• SQL Server unable to connect to SQL Everywhere in VS2005 designer

  I've just downloaded SQL Everywhere CTP, installed the mobile framework 2.0, and attempted to build a the sample on Steve Lasker's blog http://blogs.msdn.com/stevelasker/archive/2006/06/12/SqlEvCTP.aspx . However, when I attempt to create a new connection to the Northwind.sdf file in VS 2005 designer, I don't get SQL everywhere (or mobile) in the list of available datasources. If I choose "other" and ">NET Framework data provider for OLE DB" as the Data provider, I can then choose "microsoft SQL server 2005 Everywhere Edition OLE DB provider for Windows", but when I browse to the database file and click ok, I get "Multiple-Step OLE DB operation generated errors...No work was done". Clicking ...Show All

• SQL Server Uploading SQL SERVER with remote data.

  Client side: 1. my DSN is CMDB.dsn on a mapped network drive(only way for now that I get a connection) 2. My client does not fail to connect, but I am having a hard time linking my database tables to each other. Through Access 03. 3. My client is remote 4. I can ping the server, 5. but I cannot telnet 6. My application is Access 2003, 7. I am on a different domain 9. I have table names that match, 10. I do not force encryption. Server side: 1. SQL SERVER 2005 2. Standard Edition 3. TCPIP 4. The server starts fine 5. The SQL browser is enabled YES 6. Domain Account 7. Not applicable 8. NO Platform: 1. Client runs Windows XP, Server runs Windows Server 2003 My question then is this: Does anyone know of code that can be used to impor ...Show All

• Visual Studio 2008 (Pre-release) sample service doesn't work on Windows XP 64

  Hello, I tried to make a windows service that hosts a WCF service. Naturally, I've tried the sample first. It crushes raising an error: System.ServiceModel:Incorrect function at System.ServiceModel.Channels.SharedHttpTransportManager.OnOpen() at System.ServiceModel.Channels.TransportManager.Open(TransportChannelListener channelListener) at System.ServiceModel.Channels.TransportManagerContainer.Open(SelectTransportManagersCallback selectTransportManagerCallback) at System.ServiceModel.Channels.HttpChannelListener.OnOpen(TimeSpan timeout) at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout) at System.ServiceModel.Channels.DatagramChannelDemuxer`2.OnOuterListenerOpen(ChannelDemuxerFilter filter, IChannelLi ...Show All

• Smart Device Development How to set the Background Image in windows mobile 5.0

  Hi This may seem like a very simple and trivial request but I am new to c# and windows mobile 5.0 Development and I have been searching the net for the past few hours looking for the answer to this, without any luck. My Question is: how do you set the background Image of a windows form in Win mobile 5.0, I can set it in a regular Windows form using the IDE but the option is not there in win mob 5.0. I tried to manual type in the code that is generated on the regular form this .BackgroundImage = new Bitmap ( @"C:\Documents and Settings\Kevin\image2.jpg" ); but I get the error Could not find type 'Bitmap' . Please make sure that the assembly that contains this type is referenced. If this type is ...Show All

• Visual Basic DataGrid Question

  I have a datagrid called dgrid in a form, and have made this code so far: Public Sub SetupDG( ByVal columns As Integer , ByVal rows As Integer ) For x As Integer = 1 To columns dgridSimulator.Columns.Add(x, x.ToString) dgridSimulator.Columns(x - 1).Width = 10 Next x End Sub   But i don't know how to change the columns so they are image columns (DataGridViewImageCoumn on the Column designer if i was able to do this via the Design View in VS.NET 2005), how do you do this And then set the images in these columns I thought i better post in here since i've figured it out. The new code does like this if anyone needs it in future: Public Sub ...Show All

• Microsoft ISV Community Center Forums Task Scheduler

  I want to open a certain Excel document at the same time every day. I thought about using the 'Programs->Accessories->System Tools->Scheduled Tasks'. But when I choose this it is empty i.e. there are no icons for e.g. 'Add new task'. Is this perhaps due to the fact that I am working on a network and I may not have access to adding new tasks Are there any other explanations I know it is a bit vague but if you know anything then please help me! Thanks! This q is answered here: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=555039&SiteID=1 With proper permissions (I don't what that is, but probably local admin) you will see a "Add Scheduled Task" icon. This tool is a GUI for t ...Show All

• Visual Basic how can i measure an elapsed time in milliseconds?

  hi, im a hischool student and i'm doing my project for graduation in visual basic. The program is about a way to measure the reaction time. I want to measure that in milliseconds, but I was only able to measure the elapsed time in seconds. How can I measure the elapsed time in seconds! a lot of thanx rorro Thank you SGBScourge! it was almost what I wanted. I’m going to detail more about my program. It is in VB 6.0. I have 2 command bottons, 1 timer and 1 shape. First you press cmdbotton 1, it makes that the timer begins. After a x time it apears the shape that was hidden. When the shape apears the timer get off. And you have to press cmdbotton 2 so you can see how fast did you react. The time elapse ...Show All

• SQL Server Cell Calculation for cells that already has values

  Hi, I have the table like this Jan Feb .. Dec account 50 20 ... On the cube i would like to make it using calculated cells and that look like this account 50 70 ... Same cells has before. I have tried a few stuff but i cant put values on top of the ones that are already there, so i get the values in the cell and not the values in the calculated cell. Funny, though, i have put a constant (1) i the 'AS' part of the calculated cell syntax and it adds the cell value with the constant. But if i try to add with the value time.lag(1) SSAS just ignores the value. Is there a way to do this by calculated cell Thank you Have you considered simply creating a calculated measure usi ...Show All

• Visual Studio Express Editions How to show the result to listbox and keep 10 records?

  In VB I have a form with a button,textbox, etc. After I click the button (caluclation behind), I want to show the result to listbox and keep 10 records. How to do that By the way, I want my result only with 1 decimal digit. How to do that Thank you Public Class Form1 ' Click the button more than 10 times to see ' the resultant action Private Sub Button1_Click( ByVal sender As System.Object, _ ByVal e As System.EventArgs) Handles Button1.Click Static x As Integer = 1 Dim singStr As String = _ Format((12 / 3.4) + x, "#########.#" ) If ListBox1.Items.Count <> 10 Then ListBox1.Items.Ad ...Show All

• SQL Server Problem appending to a raw file

  I have subscription records for five different magazine titles that i process by looping each one though a dataflow using a for-each loop. I am using the following instructions to append to the raw file: http://blogs.conchango.com/jamiethomson/archive/2005/12/01/2443.aspx This works fine when I pass four different magazine titles. when i try to run all of the titles(five), i get the following errors: [Raw File Destination [131195]] Warning: The parameter is incorrect. [DTS.Pipeline] Error: component "Raw File Destination" (131195) failed the pre-execute phase and returned error code 0x80070057. Any ideas Thanks. Frank I've tested leaving various titles out, but there is no one ...Show All

• Visual Studio Team System MSSCCI Provider installation error

  Hello! One of the devlopers has .net 1.1 framework installed on his computer. He is using Visual Studio 2003 and wants to access Team Foundation Server. I tried to install msscci provider version 1.1 from the msdn downloads website and it comes up with the message: "The setup requires the .net framework version 2.0.50727. Please install the .net framework and run this setup again. The .net framework can be obtained from the web. Would you like to do this now " The user isn't ready yet to get .net 2.0 framework. Please assist. Thank you! I'm sorry for so short answer, I understand now that there is a setup problem. Starting with version 1.0 TFS Msscci Provider is strong ...Show All

• Visual C++ how to create object from LPDISPATCH

  Dear all, I have an ocx. There are 2 methods: long CVsTelComSECtrl::GetType() { return 1; } LPDISPATCH CTelCtrl::Fax() { m_pcFax = new CFax; m_lpFax = m_pcFax->GetIDispatch(NULL); m_lpFax->AddRef(); return m_lpFax; } When I create an application, insert this ocx into application. I could use the method GetType() from this ocx CTelCtrl m_cTel; long lType = m_cTel.GetType(); //Works OK But I cannot use Fax(). How can I create a object with CFax type from this LPDISPATCH. Please help me, Tuan Tuan Le wrote: Thank you very much. In the last sentence, you mean I should add one more method which returns CFax* in OCX Not OCX only when you want to use in the same module, wh ...Show All

• SQL Server How To Count how many ROWS are returned in SQL Data Reader

  My code keeps reading for another row when none are present.... There's are only unique records in the dB so far, but dupes are possible While reader.has rows reader.read if value not db.null get values end if end while The program gets the row and reads it. After processing the values, it goes to thru the While and reads the next row (none), it then crashes on if value not db.null... because the value is null or no record. The dB has Values Required option on - no empty fields allowed. Is there a way to count the ROWS returned Thanks. That depends on your coding language, which one are you using For example the .NET Framework has the read() metho ...Show All

• Community Chat Any language supports Counter?

  On a lot of occations, I want to use a counter like Counter(3). It ranges from 0 to 2. I can add any number to it. If I have 4 when it is 0, I get 1. It will be cooler if I can subtract 4 when it is 1, and I get 0. And, of course, I can define the Counter count at inistailzation stage. Is there any language supports this data type by nature I don't want to define the data type myself. Thanks. I don't know of any language which intrinsically supports this, but that doesn't mean one doesn't exist. You say you don't want to build this data type yourself -- any special reason why not Obviously if you're working in VB you don't have the option, but in C++ this should be a fairly trivial thing to implement, ...Show All

• Visual Studio Express Editions How to append BSTR data type?

  Dear all, I would like to append double variable and integer variable into BSTR data type. How could I do that Thanks. Following is my part of program, I just want to append the number "k" on the saveBSTR, but don't know how I should do.... Please help. Thanks. CComBSTR saveBSTR(m_editSaveDir); for(double k = 0; k < fr * dur; k++){ hr = pDet->WriteBitmapBits(frame_interval,width, height,saveBSTR); } kawing0510 wrote: for(double k = 0; k < fr * dur; k++){ [ ... ] } A side observation: Although the use of double in the iteration statement is legal, it is quite costly. Doubles require floating-point arithmetic and that's overkill for val ...Show All