AHooker's Q&A profile

• Smart Device Development Revisited - How to retrieve PPC phone number

  Hello, I am trying to retrieve the phone number of the a HP 6925 device running on the cingular network.  I have not been able to successfuly do this.  I have been succesful getting the device phone number on a HP 6500 running on the Rogers network in Canada. In this forum I found this class:  (which works great on Rogers networks - located below++) .  This is a guess but I think Rogers keeps the phone number in the SIM card, but cingular does not. Here is the question:  Is there a way to get the phone number on a HP 6925 device running on the cingular network public class Sim { private static long SERVICE_PROVIDER = 0x00006F46; [ StructLayout ( LayoutKind .Sequential)] priv ...Show All

• SQL Server Copy data in Sql Server table A to B on same server - Identical schemas

  Greetings, I have two SQL Server tables on the same server and in the same database. I'll call them table A and table B. They have identical schemas. I need to insert all rows in table A into table B. (Don't laugh - this is just for testing and long run the tables will reside on different servers.) Can someone please tell me the correct task to use for this and the connection type I need for both the source and destination Thanks, Black Cat Bone Create an OLE DB Source and perform your data select within that. Then simply attach it to an OLE DB Destination, where you select your destination table. Easy and it will allow you to change your destination later when you move TABLE B to another ser ...Show All

• SQL Server Assign Cube User Access Without Being Admin?

  Is it possible to set up a "low-level" administrator account in Analysis Services that only allows a user to assign other users to a particular Role We have an enterprise app where users in the field will need to call a help desk to gain access to the cube, but we only want the help desk people to be able to perform that one function. We would like to avoid building a custom admin tool that provides the proper restriction. Ideally, the help desk would use SQL Server Management Studio to perform this specific task while prohibiting any other admin abilities. Is this possible -- Joe No, unfortunatelly this is not possible. If you already have tool by which helpdesk can assign users to existin ...Show All

• SQL Server convert getdate() to string dd-mm-yyyy

  I would like to convert getdate() value to string of dd-mm-yyyy format in SSIS... how can I achieve this Hmm... that is ugly clutter of functions! I was hoping for a simple function [as in oracle to_char(date, format) ] How come microsoft didn't provide such a simple and too commonly used function ...Show All

• .NET Development DataSet or DataReader

  I'm in the process of creating a database consisting of a number of tables in SQL 2005.  The 3 main tables being tblAddress, tblContact, tblTransaction, all 3 contain Primary/foreign keys. The database is designed as the address details at the top of a form and a datagrid at the bottom showing all contacts within that address.  The last row of the datagrid contains a button and when pressed brings up another form that shows all the items that a contact has requested. When i started designing this i was using dataAdapters and datasets and using the binding navigator to navigate through records.  I attended the 2541-Core Data Access workshop and showed the lecturer what i was worki ...Show All

• SQL Server Problems on connection during mirroring (Error 1418)

  Hi everyone, I am a newbie on setting up database mirroring and right now I am facing the connection problem during mirroring which is Error 1418 which kinda common problem. I just view through all the threads regarding this problems and BOL also. However, I just based on all the guide to setting it up and the result are still the same. I did tried on both instance names in my server for mirroring and displayed the same results as well. When I type this t-sql on mirror server : ALTER DATABASE AdventureWorks SET PARTNER = 'TCP://TSUYOSHI:5022' -- which is the principal server It shows connection ok to me. However, when I type this t-sql on the principal server : ALTER DATABASE AdventureWorks SET PARTNER = 'TCP://H ...Show All

• Visual Studio Tools for Office compare text columns

  Hi I am trying to create a code in Vba to compare the text of 2 columns in Exel (for finding a list of words that are equal between the two) and create another column with the result of the confront .Can you help me This forum is for a specific Visual Studio technology plug-in for working with Office applications. In other words, it has nothing to do with VBA. To get help with Excel VBA, you need to ask in this newsgroup http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US ...Show All

• Visual Basic I've run this before without a problem, but now I'm getting a warning!

  Okay, I've run this before without a problem, but now I'm getting a warning stating "InvalidArgument=Value of '1' is not valid for 'index'. Parameter name: index" . Why would it begin giving me this error now after running it in debug several times without a problem before Anyone, please help. Hi, The error message sounds like you are getting an IndexOutOfRange exception, or something similar. Chances are you are trying to access an array or collection with an invalid index. You might want to check that the collection you are accessing actually has data in it (look at the length field or Count property). Also, in VB.NET array indicies are 0-based, not 1-based, so the index of the first element in an array is 0, not 1 ...Show All

• .NET Development Why is Console in the backgroud?

  When I create an empty project with Express Visual C++ and make a windows form on the fly, I get the console in the background with the title C:\Windows\System32\cmd.exe. Why is that This feature did not exist in 2003 VC++.Net. Is it a part of Express Edition of VC++.Net What can I do not to display the console in the background Regards Modeller. As a matter of fact, I have 8 projects in the same solution and all of them are displaying Console in the background. Just to make sure that I was doing right, I created a new solution and started a new empty project with CLR->Emptyproject. It also gave a console in the background. I have been using VC++ since 2003 this is the first time that I have e ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Including textures in fbx export from MAX

  What is the process for including a texture in an fbx export from MAX Taking the tutorial 1 as an example, I load the p1_wedge.fbx, add the model and texture assets to the project and everything is fine. I presume the texture is referenced from within the model. If I create a simple cube in MAX, export it as an fbx, add these assets to the project, there is no texture. I've tried checking the 'embed textures in export file' option on the exporter and have tried both a MAX standard material and a DX material with the ship.fx effect applied. Excellent! You shouldn't need to add the effects or textures to your project: they will be pulled in automatically by the model. Embedding textures into an ...Show All

• Software Development for Windows Vista TC13

  Hi, How to determine whether the application is using a Non-Self-Containing Bootstrapper or Chainer to install the application Thanks in advance Thanks, Vasu An example of a non self containing boot strapper would be a setup.exe file that sets some parameters up and then starts up an msi that is external to the setup.exe to begin the installation. ...Show All

• .NET Development AS400 and Microsoft Access - Required Columns question

  We are running an AS/400 program and MS Access 2000 with client access odbc. We can link AS/400 tables to the MS Access database, but in every table in MS Access, every column appears to be required, so we are not allowed any null entries in any column . We are not sure if this is an AS/400 issue, or an ODBC Issue or something else. We would appreciate any comments/suggestions as to what to look at in this case. When directly accessing the tables on the AS/400, it is possible to leave null values. Access doesn't automatically set columns to "required" for linked database tables. This is either a function of the middleware (AS/400 drivers or software) or the columns are actually required on ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. reduces texture color depth

  Hi! I can't figure out an issue, and it is somewhat critical for the visual quality. I modified my skybox component to use the content pipeline. This means that the content pipeline should take care of loading all thextures defined in the .x file. And it does that, but the problem is that when i run the program, my skybox textures look as if their color depth has been reduced to 16 or less bits per pixel. For the skybox I used a .x model that contains a cube with faces pointing inwards. I took it form an SDK sample, and modified the textures. I even tried making all textures into .dds What should I try next Did anybody encounter this problem also Yes, I understand what you mean. Thanks I'll try and see ...Show All

• Windows Forms how can i import excel data to a datagridview

  Hi all. I've been searching around for a easy way to import a excel file to a datagrid. I have tried a few of these examples, but nothing works. Why don't this work: private void button1_Click( object sender, EventArgs e) { DataTable test = getDataFromXLS( "c:\temp.xls" ); if (test != null ) dataGridView1.DataSource = test; } private DataTable getDataFromXLS( string strFilePath) { try { string strConnectionString = "" ; strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFilePath + "; Jet OLEDB:Engine Type=5;" + "Extended Properties=Excel 8.0;" ; OleDbConnection cnCSV = new O ...Show All

• Visual Studio Express Editions Process commands

  Hi, I am writing a program that will start a program at a certain time (I have the time thing working) with parameters And at another set time either send that process a command OR end it Are either of these two possible Cameron. well you use the Process class in the System.Diagnostics namespace to run a process, or its assistant the ProcessStartInfo class, which has additional flexibility like redirecting input/output from the application you are going to run and setting the working directory and setting the window style etc... http://msdn2.microsoft.com/en-us/library/system.diagnostics.process.aspx http://msdn2.microsoft.com/en-us/library/system.diagnostics.processstartinfo.aspx ...Show All