Steve Abel's Q&A profile

• SQL Server query output into xml file

  I want to create a package that will execute the sql and the output will be store in some file. Following are the steps I took in SSIS package. Please advice if this is the way to do and what I am missing. How should I retrieve the output into a file In Execute SQL task, In General following are the selections Connection Type: OLEDB Coonection: src1.dbTest SQL Source Type: Direct Input SQL statement : Select fname,lname from employees for xml auto ByPassPrepare: False Resultset: XML In Result set I created a user variable Result Name: 0 Variable Name: User::Variable Thanks! ...Show All

• Visual Studio Express Editions how to send SMS using AT commands in VB

  Hi, Im tryin to develop a VB application to send and receive SMS, I have tried in the Hyperterminal and it works fine.But when I try to do the same with VB It gives me some Hresult exception. What should I do. I am attaching my code below, Imports MSCommLib Public Class Form1 Dim mscomm1 As MSComm Dim VbUnicode As VbStrConv Dim Msg As String Private Sub Form1_Load( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase .Load Msg = Txtmessage.Text mscomm1 = New MSComm mscomm1.InputLen = 0 mscomm1.RThreshold = 5 mscomm1.CommPort = 3 mscomm1.InBufferCount = 0 mscomm1.PortOpen = True MsgBox( "port open" ) End Sub Privat ...Show All

• Windows Forms I don't understand Visual C# 2005 Express publish

  I don't understand how publish works. In the Visual C# 2005 Express Edition IDE, instead of the old setup template like you had in Visual Basic 6.0, you have only "publish", and you can "publish" to a website, shared folder on a network, or some folder on your hard drive. Now, I have written some very simple little test apps and published them, then installed them on my PC and they do not function properly. My file dialogs don't work right because the application directory is so different from what it was when I was working on the project. It seems these setup.exe programs generated by the IDE's "publish" command install the application on my system in "C:\Documents and Settings\Owner\Local Setting ...Show All

• Windows Forms Project server 2003 login issue

  Hi All, i have a project server 2003 login issue. i used single server installation method to configure project server.when i trying to login thru PWA i am getting this error "Project server was unable to login you at this time (5006).i have tried editsdite utility and i haven't faced any problem with installation. please help me to resolve this issue. Thanks in advance... Rajeesh Hi, Please post your question in the following newsgroups for project server. http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx dg=microsoft.public.project.server thank you, bhanu. ...Show All

• Visual C# Get MAC address of client machine using C#

  How to get MAC address of client machine using C# Not looking for remote machine MAC Address. PadamPadam wrote: Thanks for your great help. It is throwing a NullReferenceException after executing a code of thread. Was your code running with hardcoded computer name but with not the change I made I think this is not the situation, Try to elaborate your problem that where actually you getting this error which object has nul reference Best Regards, ...Show All

• Visual Studio Express Editions "DataView" that "Joins" two tables from a dataset?

  Is it possible to create something like a "DataView" that "Joins" two tables from a dataset If Yes then how I have the same question. I can't do this in a query or view because I want the two DataTables to be able to come from different data sources. I wish you could have a DataView that could return the columns of your choice using the relation that is set up in the DataSet. Anyone have any suggestions I know I could do this manually. I would have to handle it differently depending on the join/relation. ...Show All

• Visual C++ Class Template Source Code in External Files (Link Error)

  I have tried both Visual Studio 2005 and VC++ Express 8. I'm experiencing the same problems. Using class templates, I get a link error when I move the source code for class members from the main file to another file. If I place the following code in one file, main.cpp, it will run: #include "Node.h" #include <iostream> using namespace std; template <class T> Node<T>::Node(T newData) : data(newData) { } template <class T> T Node<T>::getData() { return data; } void main() { Node<int> myNode(2); cout << myNode.getData() << endl; } with the following code in "Node.h" #ifndef _NODE_H_ #define _NODE_H_ template <class T> class Node { public: Node(T newData); T ge ...Show All

• Visual Studio 2008 (Pre-release) .NET 3.0 / Orcas / C# 3.0 / LINQ - I'm Confused

  Hi, I'm wondering if someone could clarify for me the relationship between .NET 3.0 (which is currently RC1) and all of this LINQ stuff we're seeing in the May CTP. I apologize if this is addressed elsewhere but I haven't been able to find it. As I understand it, .NET 3.0 is supposed to be released with Vista. C# 3.0 and LINQ will be released together as the next version of Visual Studio (AKA Orcas ), but separately from .NET 3.0 and probably well after Vista. This situation confuses me a little bit because the .NET Framework has a C# compiler built into it, right So I'm guessing that the C# compiler included in the .NET Framework 3.0 will not be able to compile C# 3.0 code (LINQ, etc.) Does that mean there will be another framew ...Show All

• .NET Development DataReader problem (My final straw)

  As a newbie to VB.NET I am rather please with a project that I am completing for my university course. There is one problem that has kept me from completing my project so far, and that is that I can not extract a value from the table of and Access database. To set the scene, I have a form that inserts the values from text boxes into variables and from variables to a database table. This works fine and I have no problems here. (see code below) What I need to do next is retrieve the customerID that is auto generated in the data base, this needs to be stored as a variable in the form and then passed to the next form so that it can be used to make a booking. I have got the code that passes the variable across the ...Show All

• SQL Server How to Add Reporting Services in Microsoft Dynamics CRM 3.0

  How to Add Reporting Services in Microsoft Dynamics CRM 3.0 Hi Download SQLReportPackCRM.msi and SQL2KRSSP2-ENG.EXE, it will start working. Cheers, Subodh ...Show All

• SQL Server Having problems deploying a report.

  I am working with a MS 2005 SQL Server database. I have the following error message. A connection could not be made to the report server http://localhost/ReportServer . I am trying to develop these on a network server. Is this a configuration issue, that it is expecting this on the local machine. Thanks! Terry B When I go on the internet and type in Http://localhost I receive a not found error message. It claims to be Under Construction and references the IIS Help. But other reports from the server do deploy and I cannot see them from either machine Thanks! Terry ...Show All

• Game Technologies: DirectX, XNA, XACT, etc. Using textures with a custom pixelshader SpriteBatch

  Hello World, Running SpriteBatches with a custom pixel shader is no problem. Works perfectly. (For those that wonder how, just write an effect with a sampler state and a pixel shader and no vertex shader and run it around your spritebatch that uses Immediate). Now If I want the pixelshader to use an additional texture to the one sent to the draw call it simply doesn't work. Every sample state contains the texture in from the drawing call. Can't get access to my custom set texture. Anyone got a clue to get this working Or should I just give up and draw my own quad and set the textures myself hello :)   Malmer wrote: Hello World, Running SpriteBatches with a custom pixel shader is no problem. Wor ...Show All

• SQL Server [Transfer SQL Server Objects Task] Error: Table "MySchema.MyTableName" does not exist at the source.

  Does anyone know what could be causing the error on Transfer SQL Server Objects Task   I tried to develope a SSIS project in the Business Intelligence studio to transfer table between databases on the same server.  However, I have been getting the following error: [Transfer SQL Server Objects Task] Error: Table "XXXXXX" does not exist at the source. Is there a setting that I need to change to make this work   Thank you for your help.   I think your problem is related to the schema of the table you are trying to copy. I created table "testtable" in testdb1. The schema was "dbo". I could transfer this table to another database named testdb2 in the same server ...Show All

• Visual Studio Express Editions so gentle

  I would appreciate any help someone could give me. I have searched this forum endlessly trying to find a way to save 60 or so text boxes on form1 to a file and then later read the information back into the same text boxes. It seems like I have tried every bit of sample code that I can find and nothing works. I have 5 books on VBE and VB5. I am a complete novice at this so please be gentle. Thanks in advance for any ideas/help. Glenn Well... I'll step out. You see, I think your intital approach is not that great and it's going to cause you problems and you will end up building a bi-plane. Why not take it a step at time. Break your problem up into small discrete steps. The first th ...Show All

• Software Development for Windows Vista MFC CSocket problem in Vista

  Dear Newsgroup, I've got the problem, that CSocket::Create gets the error 0000273F (german error text: "Es wurde eine Adresse verwendet, die mit dem angeforderten Protokoll nicht kompatibel ist.") if the program uses MFC DLL in a shared library with Vista Beta2 (Build 5384). To reproduce the behaviour: - create MFC project (I've done it with VC6) - use MFC in a shared library (_AFXDLL defined!) - activate Windows Sockets Put the following code into a function: ----------------------------------------------------------------- CSocket *s = new CSocket (); if ( 0 == s->Create ( )) { LPVOID lpMsgBuf; DWORD dwErrorNo = GetLastError(); if ( 0 == dwErrorNo) return; FormatMessage ( FORM ...Show All