James Owens's Q&A profile

• SQL Server How do I force new databases to be created on another drive on same server?

  I successfuly installed SQL Server 2005 Enterprise Edition today (on the first shot!) but can't figure out how to force new databases, etc to be created on another drive on the server. SQL installed on the c: drive (I had no choice!) but it is a very small partition. I need to install Sharepoint Portal 2003 next (on a different server) and want to make sure everything goes on the other drive. Help me, please!! Thanks :-) ...Show All

• SQL Server template.ini differences, typos, possible superfluous/omitted content

  The SQL Server 2005 Enterprise and Developer editions have identical template.ini files. SQL Server 2005 Express with Advanced Features has a template.ini with additional entries. These entries do not appear appropriate for Express and thus would be superfluous. Notice that the Note in the Express template.ini says an upgrade to SQL Server Express requires NT authentication, so it doesn't make sense to include SQL login parameters ( UPGR ...Show All

• Visual C# C# TO Excel HEADER ROW

  I have a project that requires the user to be able to download a dataset from a Web application. I have all that seems to be operating properly except I seem to be missing the Header row from the downloaded file. When I populate objSheet the first row is not the Header row but the first row of data. How can I get the Header row from the DataTable //Convert Dataset DataTable dtExcelExport = dsBPMExcelExportIn.Tables[s1]; //Populate t ...Show All

• SQL Server changing timeframes with stock data

  I have stock data in 1 min intervals and would like to convert it into other timeframes (e.g., 10 min, daily, monthly). Here's is some sample data and my final goal: [DateTime] [Open] [High] [Low] [Close] [Volume] 10-Feb-05 12:10:00 3.88 3.88 3.87 3.87 10 10-Feb-05 12:11:00 3.87 3.87 3.87 3.87 2 10-Feb-05 12:12:00 3.86 3.86 3.86 3.86 1 10-Feb-05 12:13:00 3.85 3.87 3.84 3.85 23 10-Feb-05 12:14:00 3.85 ...Show All

• Visual Basic Error when trying to update a database.

  I have this code: Dim RowValues(2) As String RowValues(0) = AdUser.Text RowValues(1) = AdPass.Text RowValues(2) = AdTimes.Text UserPassDS.Users.Rows.Add(RowValues) UsersTableAdapter.Update(UserPassDS.Users) When I try to update (the last row), It says an error. The error is: System.Data.SqlClient.SqlException was unhandled   Class=14   ErrorCode=-2146232060   LineNumber=65536   Message="An att ...Show All

• Windows Forms MainMenu Control with Color Properties

  Hi, I wish they would make the next version of Visual Studio.NET with a ManinMenu Control that can have it's color property changed to match, well, whatever you want it to match.  For instance, if the background of my form is red, the curr ...Show All

• Visual C++ Can you give me an example of declare and allocting arrays (double type)

  Can you give me an example to declare managed array in Visual C++.Net Thank you very much!  As i follow a book to decalare and allocate an double managed array (accroding to a book) as follows: double Q _gc[] = new double _gc[3];//line (a) Q[] = {0.0225, 0.01, 0.0025};//Line (b) But i get the follwing errors at line (a): error C2146: syntax error : missing ';' before identifier '_gc' error C2501: '_gc' : missing storag ...Show All

• Visual C++ Shellexecute error

  HI, string cmd = ""; cmd = " -l "; cmd.append(user); cmd.append(" -pw "); cmd.append(pwd); cmd.append(" "); cmd.append(host); ShellExecute(NULL,TEXT( "open" ),TEXT( "putty.exe" ),TEXT(cmd),NULL,SW_NORMAL); I constructed a string that contains parameters for my .exe file. But when i try to insert the string into the ShellExecute command i got this: error C2664: 'ShellExecuteW' : cannot convert parameter 4 from 'std::string' to 'LPCWSTR' No u ...Show All

• SQL Server Issue with launching report builder from client

  I cannot get report builder to launch remotely in a brower on the client side. It works fine on the server where reporting services is installed. .Net 2.0 framework is installed on the client machine. It seems to be a security issue, I get an error in the log 401 unauthorized. I have checked the rights on IIS and everything seems to be in order. Any thoughts ...Show All

• Software Development for Windows Vista Serialization error and SQL persistence service

  Recently, I've been tearing my hair out because of strange serialization errors being reported when I start my workflow which is hosted to use the services of the SQL persistence service. In trying to track down the issue I deleted most of my code but still got the errors - which reported references to deleted code! I tried deleting any cached DLLs, clean rebuilds etc to no avail and then seemed to stumble on the answer - which is unfotuna ...Show All

• Visual Studio Express Editions Menu Item Access Key (underline) won't display

  Just installed VB Express 2005 and tried a simple application. I cannot get a menu item (using designer) to display the underline when I run the project. I am creating a menu item of  "File", and I want an access key for ALT-F I entered text of:  &File In the forms designer, the "F" in "File" WAS underlined. When I run the project, the underline is NOT displayed, although the ALT-F access key DOES work. Anyone else able to reproduc ...Show All

• Visual C++ Opening files from explorer.

  I have associated the extention .vip to my program Viper.exe. However, I have no idea how to make the program open the .vip file that has been opened in explorer! How do you find out which file was double clicked to open the filw. Thanks in advance. Hiya wrote: I have associated the extention .vip to my program Viper.exe. However, I have no idea how to make the program open the .vip file that has been opened in explorer! How d ...Show All

• Windows Forms Keeping selected rows when sorting a DataGridView?

  How do I keep my selected rows in a DataGridView (SelectionMode = FullRowSelect) when sorting the content Let's say I've got 3 rows (with 2 columns): Char  No B     1 A     2     <- Selected C     3 Above the rows are sorted using the No-column. If I selected row "A 2" and sort using the Char-column I get this: Char  No A    ...Show All

• Visual Studio Available fields when Charting

  Hi Crystal Experts I have a crystal report which works fine in reporting the data from the dataset The data is grouped by EmployeeDepartment and Weeks where we can see the salaries per week within each parent department However I got a unusual request from my boss to report on a statistic. The way we calculate this statistic is value  = Sum(IndividualSalary)/DistinctNumberOfEmployees I have created a field called DistinctNumberOfEmployees I ...Show All

• SQL Server Migrating from Oracle to SQL Server 2005

  I am migrating a database from Oracle to SQL Server 2005. I have a problem when migrating code from PL-SQL (oracle labguage) to T-SQL (sql server language). My problem is: there is pseudo-column in oracle called level that return the level from a register in a tree view of a select (a parent-child relationship). I would want to know how to translate that level column to T-SQL. Thanks! You can write the Oracle version of SELECT statement wi ...Show All