Phil Cowan's Q&A profile

• Visual Studio Express Editions Missing Microsoft.Office.Interop namespace

  Hello, I have recently been using VB.NET 2005 Express to update code written in VB6. I have been able to migrate everything needed so far with the exception of a block of code which writes a text string to an MS Office Word document. I have followed all the advice I could find on installing the Microsoft Office Object library 11.0 (Office 2003) as a reference to my project. I am then able to add the Microsoft.Office.Core namespace to my project but I am still unable to reference any of the interop namespaces. (e.g. Microsoft.Office.Interop.Word) so I cannot open Word programmatically and write my text string to it. Imports Micro ...Show All

• Visual Studio Team System Trial Edition & Source Control

  I received my trial edition today and am about to install it, and I've put the system on the projected budget for next year. But, I'm concerned about what happens if my employer doesn't cough up the big bucks to buy the thing. Particularly the code that is saved in the source control portion. Will it be available when the trial expires Can I get it out easily Thanks for your time. If you are using the 180-day trial edition, you'd no longer be able to get history, checkin, checkout, etc. You would still have the latest copy of the files on your disk. Buck ...Show All

• Visual C++ Trouble making simple program.

  Hi I am trying to create a simple hello world program and its not working. here is what i do i create a empty project and name it "hello" then I right click on the progect icon and go to ADD > Class > C++ > C++ Class the window pops up and I enter the class name "HelloWorld" while I am doing this the ".h file:" and ".cpp file:" auto file with the same name and their own extentions. Thats all i do and then I click "Finish" I right click on "hello" > ADD > New Item... > Code > C++ File (.cpp) give it a name like "hello2" enter the code #include<isotream.h> using namespace std; int main() { cout<<"hello"; retur ...Show All

• Visual C++ problems with cstdlib + stdlib.h?

  These errors are stumping me. There seems to be a problem with cstdlib and/or stdlib.h. Has anyone seen these types of errors before I am using Visual Studio 2005. Error 47 error C2873: 'realloc' : symbol cannot be used in a using-declaration c:\program files\microsoft visual studio 8\vc\include\cstdlib 26 Error 45 error C2873: 'malloc' : symbol cannot be used in a using-declaration c:\program files\microsoft visual studio 8\vc\include\cstdlib 24 Error 43 error C2873: 'free' : symbol cannot be used in a using-declaration c:\program files\microsoft visual studio 8\vc\include\cstdlib 23 Error 41 error C2873: 'calloc' : symbol cannot be used ...Show All

• SQL Server Where is the Northwind SQL scripts for SQL server 2005

  I am looking for the northwind install script in my SQL server 2005 directory and cannot find it. The introduction to VB 2005 uses it for an example and I would like to walk thru it. Does anyone have the sql If so could you send it to me. I am going to see if I can get it off a 2000 install. Thanks. Hello, Northwind does not ship with SQL Server 2005.  It is available from the Microsoft download site: http://www.microsoft.com/downloads/details.aspx FamilyID=06616212-0356-46a0-8da2-eebc53a68034&DisplayLang=en See the topic Downloading Northwind and pubs Sample Databases in SQL Server 2005 Books Onli ...Show All

• SQL Server Can`t access Report Manager

  Hi to u all, I have installed RS 2005 B2 on Win Server 2000+Sp4, and the installation seems to be OK (I have checked both the Db and the IIS), BUT No matter what I do, I can`t access the Report Manager. When I type http://localhost/reports it opens a dialog box in which I have to enter a user+password+domain. It does not accept any user what so ever (including administrators). In addition, I tried to change the Security configs @ the iis, but it didn`t seem to help. Any Ides Tnx, Tamir RE: This edition of the Reporting Server Database is not supported on the edition of SQL Server 2000 you have chosen, Pleas ...Show All

• SQL Server "...conversion between types DT_I1 and DT_I2 is not supported"

  I created a simple ragged file with 3 lines: 1 2 3 and coupled it to a Flat File Source. The Flat File Source suggested that the type was DT-I1. Next I created a “SQL Server Destination task and connected the output of the Flat File to the Sql Destination. In the Destination editor I created a table, whose one column was declared to be a sql smallint. Here’s the problem: the Sql Server Destination now displays a red circle with a white “x”. The tooltip says that: “The column “Column 0” can’t be inserted because the conversion between types DT_I1 and DT_I2 is not supported” Can anyone explain wh ...Show All

• SQL Server process cube

  I am using analysis server 2000. I have a cube on one of the databases which i am trying to process through the Business Intelligence Development studio. i have specified the Server and the database name in the 'connection managers' through 'New Analysis Services Connection' I added the 'Analysis Services Processing Task' to the Control flow but get the following error when i double click on it: "A connection cannot be made. Ensure that the server is running' Does anyone know what am i doing wrong Any help is appreciated. Edward, Are you from Microsoft's SQL Server Team. Just w ...Show All

• SQL Server Import MSSQL Tables

  Is there a way in SQL 2005 Express Edition to import/export data from another MSSQL Server Something similar to the right click/ import table functionality of MSSQL2000. I've read similar threads which all recommend using MS Access but there has to be a better way, right regards, dj Hi DJ, SQL Express, and Management Studio Express, don't include the Import/Export wizard because that wizard is dependent on SSIS, a component that is not part of SQL Express. There are a number of different ways to accomplish this depending upon your need including Access. Since you are going from SQL to SQL, I would recomend the following: ...Show All

• Visual J# Create Class Designer values

  I’ve created a class in the Class Designer (VS200 beta 2) that contains four parameters.   Three of them are strings and one is a date. When I click on Create Instance and go to enter the parameters I can’t find a date format that it will accept.   What is the format it requires No for Whidbey, even in next release this would be supported rather we will provide quick way of creating new object(s). Note that OTB is v1 product and we are expecting more feedback from our valued customers and users to enhance this feature. Please feel free to send your inputs on this. Thanks, ...Show All

• Windows Forms Datetimepciker

  Hi I am setting up a form in VB.net that uses a Datetimepicker control to select the date which is then entered into a SQL Database along with the data from the other controls If I select a different date using the control the date is entered correctly into the database. My problem is if I dont select a date and run the insert no value&n ...Show All

• Software Development for Windows Vista Attribute 'Class' not found error when debugging on Beta 1.2

  Hello, I am getting the error "Attribute 'Class' not found on the Root Activity" when trying to run a workflow in debug mode using VS2005 RTM, WF Beta 1.2. It happens on all workflows I have tried including the SimpleSequentialWorkflow. Also, after getting the above error, the workflow will no longer successfully complete but instead gets a Workflow not found exception. Finally, I am finding a ton of temp files being orphaned in the Temp directory (*.tmp, *.xoml, *.dll) Don Barber Hi Don, Unfortunately the viewer for workflow debugging is broken in Beta 1 and Beta 1.2. Expect this to work in Beta 2 which will be released in the US ...Show All

• Windows Forms ISA firewall issue

  I am trying to set up a terrarium server on an extra machine here at work.  Inside the office it works great and everyone connects to the server.  We can all send and get bugs. When I try to connect from outside the firewall, I get a message saying that the terrarium has detected I am behind a NAT/Firewall.  I can click the NAT ...Show All

• SQL Server dbms_lob conversion

  hi, am interested in porting some of my oracle quries to sqlserver. Here is a sample oracle procedure: create procedure sp1(ac_clob clob) as n number; position number; begin position := 4; n := dbms_lob.instr(ac_clob,'test', position); --returns the location of the substring n: = dbms_lob.getlength(ac_clob); --returns the length of the clob object end; As the clob object comes as a parameter let me know if it can be converted in sql server. Also I some other functions to dbms_lob packages like: dbms_lob.copy, dbms_lob.write, dbms_lob.trim, In addition to what Clifford says, you can take a look at the CHA ...Show All

• Visual Studio VSS 2005 And VB6

  Hello, I have VB6 and VS2005 installed on the same machine, there is any way to use VSS2005 also from the VB6 IDE If not, can I install VSS6 and VSS2005 on the same machine thank Andrea Hi Andrea, Yes, it is possible to use VSS2005 from VB6. In VB6, select Add-ins/Add-in Manager menu, and in the dialog that opens select the "Source Code Control" add-in line, and check the "Loaded/Unloaded" and "Load on Startup" checkboxes, then Ok the dialog. The source control menu should be available under Tools/SourceSafe after that. Alin ...Show All