DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.

Share tech news, updates, or what's on your mind.

Sign up to Post

Hi experts,

I have a ASP.NET/VB.NET application and I need that It generate a Powerpoint presentation. It runs on a server that does not have the Office installed.

Basically, the function should create slides, fill them with some text and embed an Excel spreadsheet in a specific slide. Then, save the presentation in .PPTX format, and if possible in .PPSX format too.

Finally, as my budget is small, the suggested solution should be free or low price. Any suggestions?

Thanks in advance,

Marcelo Camarate
I know that the mscomct2.ocx was registered correctly, But vb6 Disagrees so I cant use the dtpicker control.

I'm trying to get values of a table that's in SQL server.   Currently we use

var selectproducts = new List<Product>();
 using (var newdb = new NorthWNDModel())
                  selectproducts = newdb.Products.SqlQuery("dbo.GetProductsByCategory @p0", selectedCategoryID).ToList();

Open in new window

We would like to get the tables without using SQL.   Is this possible?  We are using Entity Frame 6.1 Code First from Database.  If so, could you provide an example?  Thanks.

I have an application that is installed using Install Shield 2012 (SP1). I need to install a new version of the app so I built another setup using the previous one as a starting point and then I simply changed the version number. The only file that changed is the app exe. When I run the new setup it recognizes that it is an upgrade and runs through normally but my old exe file does not get overwritten by the new version exe. The old exe version shows as 4.6 and the new one is 5.2. I have tried setting the always overwrite option on the new exe component file but it still does not overwrite. Any suggestions?
It is said that there is an improved list of diagnostic tools in vSphere 5.5. I have not found a complete list describing these. Anyone here know which these are?
File comparison tool which can count whitespace mismatchings.
I used meld, winmerge, but there is not such thing.
Also it's good to say how many non-whitespace changing requires to become original source code.
Do you know some good tools that can format a pl/sql program in a text file?

I used Quest toad and sql navigator but found the formatting function to be confusing.

I have some old legacy code and i want to try reformat before some code delivery.
I have school project developing app using galaxy gear 2, and I can't find good and easy tutorial on this.
Does anyone know good Tutorial explaining from Setting IDE to Communicating with Android and calling Android side services.
I would like to be able to set breakpoints in a large classic ASP application originally developed with Visual Studio 6 (interdev). To date I have put in several days and numerous hours following suggestions all over the web on how to configure my environment to accomplish this. And I have had on and off success...mostly off. The extent of my success was that I was able to set and hit a breakpoint in both a simple one page test script (see below) and in the full application. So I thought my problems were behind me and I could get on with the debugging. However on the following day I could no longer debug.

I have set up two different dev environments:
1. Visual Studio 2010 Pro on Windows XP Pro  (with IIS 5.1 on dev machine)
2. Visual Studio 2013 Pro on Windows 7 Pro (with IIS 7.5 on dev machine)

(I set up two environments b/c there was a lot more info available about debugging ASP with vs 2010 than with vs 2013):

I successfully set breakpoints in both environments and was able to have them fire. But as I said above, now they are not working.  For the same simple test script, each of the two environments is exhibiting a different problem.

In VS 2013, I can no longer set a breakpoint. Instead I get the message "A breakpoint cannot be inserted at this location." It's as if visual studio all of a sudden doesn't recognize the code as vbscript.

In VS 2010, I can set all the breakpoints I want, but after I attach to the appropriate dllhost, the breakpoints are …
What i need:
How can i view the executed T-SQL statement from Visual Studio 2008 R2 at run time from within the Visual Studio Designer???

Problem Statement:
For unknown reasons the report i am designing is not returning any rows for the dataset. I am using a number of parameters and filters with my report. I want to see what the actual SQL statement is being passed from VS to MSSQL so that i can more quickly debug the issue.

I know that T-SQL i am using for the dataset works in SQL if i manually plug in the parameter values. But i have been unable to fathom why it is not working in VS.

Thank you in advance for your help
What syntax should be used to specify the default value for a date field (not a datetime field) in SQL Server 2014.

None of the ways to specify a default for a datetime or smalldatetime field works, they all end up with a validation error.


We are renaming one of our locations.  Instead of adding a new one, the organization wants to edit all existing reports that contain a hard coded value.  So we have about 400 of  Crystal Reports.  Other then opening each one and searching the formula for the hard coded value is there an easier way.   To minimize the steps, I thought maybe I could create a report definition and use a program windows grep.

Is there a better way.

Where I work we log onto our computers with non-privileged accounts, then use "Run as Administrator" when necessary to do work that requires elevated privileges.  I use mapped network drives to access my Delphi projects, however, when I run RAD Studio as Administrator, there are no mapped drives.  I have written a program that will map the necessary drives and added it to the RAD Studio tools menu, so I can run that once Studio is up and running.  I would really like this step automated in some way.  A way to make the mappings persistent (which I have tried, but did not have success) would be the best solution.  Barring that, having a way to autorun my program after Studio is up would be acceptable.

Anyone have any ideas about how I could accomplish this?

Perhaps you can help.

I am trying to capture Active Directory information such as "title" via ASP.NET page when one enters a valid "NT username" in a textbox and hits a button.

Curiously, this works in the development environment of Visual Studio 2010 when I run the project but not when I deploy to IIS(V6). I have Integrated Windows Security ticked and Enable Anonymous Access unticked. (Windows Server 2003 SP2)

My knowledge of issues such as Active Directory is scanty.

I enclose the relevant files.

Many thanks,

I am working on VB.NET 2010. I have some working data reporting using DataGridView and want to print the same. I am realizing that that Microsoft does not support direct printing of DataGridView. I was looking for some easy steps to create a quick report.

Alternatively I am ready to get started with Data Report if I get some quick tips

I have a stored procedure that will pass 3 variables to an SSIS task.  The task should accept the 3 variables/parameters and insert into two tables.  The two tables are fairly large tables which is why I'm using ssis to insert the records.  The count of records range from 1K to 600K to 1 millions records at any given time.

What is the most efficient way to execute the task in SSIS? SSIS Execute SQL Task or Data Flow Task with ADO.Net or OLEDB or ODBC?
I have been using access for many years now, but would like to program an application that displays a client directory, and there associated orders, and print them as needed.  

Self-pace training is best for me, or through books with examples.  

Note:  I am not looking to create a web based app, just a program in-house stored on our server in a split database.

Thank you!
I have already asked a similar question here: Regex

I have this regex working within VI which replaces the 3rd occurrence of ',' with 'Unique,'

Open in new window

I can't seem to get it to work within Sublime Text Editor. I have tried the following regex, but it doesn't replace the 3rd comma, it instead captures it and places it into my replacement string.

Sample Data: echo "clientRequests#300#raw,$EPOCH_TIME,$_importExternalEmailData,proj_ott,ottcore
Regex Find: (,.*?,.*?,)
Replace Str: $1Unique

I want to find the 3rd comma so I can append to the name $_importExternalEmailData so the result is $_importExternalEmailDataUnique. Right now it will put 'Unique' after the 3rd comma.
I have 4 SQL servers in my company. I can launch Activity Monitor locally from my desktop and connect to 3 of the 4. When I remote on to the problem server, I am unable to launch Activity Monitor that way, either. Now, I have checked all permissions (local and SQL). Nothing changed, but this started happening just yesterday. Any help would be appreciated.
I am working on editing a Jasper report. When I assign a double value to a variable which is of type double, I am getting the following error during compilation:

The left-hand side of an assignment must be a variable             (((java.lang.Double)variable_slabSum.getValue())=new Double(0.0) && (((java.lang.Double)field_percent.getValue()) + " of first " + ((java.lang.Double)field_slab_end.getValue()))

"slabSum" is a variable created of type double and I am trying to assign a value of "0" to it, when certain condition is met, in a conditional statement.
$V{slabSum}==0 ?
    ($F{percent} + " of first " + $F{slab_end}) :
            ($V{slabSum}=new Double(0.0) && ($F{percent} + " of first " + $F{slab_end})))

Any suggestions would be helpful.

Thank you
I am trying to run forms 10g (for the first time) installed on windows7 but all the browsers say  "a plugin is needed to display the content".
I have done the following so far:
1. enabled java in the java control panel
2. installed jinitiator by running  jinit.exe
3. Installed the latest version of java

Any idea where I may be going wrong?
Apologies in advance for the long post.  I’m hoping someone can help me get my head around properly designing a TFS folder structure.   We’re a special needs school and we create and maintain a number applications that are used internally by staff primarily for data collection and reporting.  Many of our Visual Studio 2010 solutions reuse common projects.  All solutions use project references where possible and file references in the case of 3rd party libraries where we don’t have the source code.  Up until a couple of weeks ago, our dev team consist of one guy; me.  Source control consisted of zipping projects and using assembly name and version as a file naming convention.  Implementing a real source control system has been on my to do list forever but is something I simply didn’t have the resources, time, or urgent need to do on in a one man shop.

We’ve added a second dev and have been focusing on a TFS 2010 implementation.  We’ve spent the past week+ sifting through the best practices guides including the CodePlex patterns and practices guide, reading countless blogs and StackOverflow posts about recommended folder layouts but there seems to be no simple answer or recommendations about how we should organize our folder structure.  

Most of our VS Solutions use many of the same projects such as those listed in “Common Projects” below. Here’s an example of how our Visual Studio Solutions are laid out.

Common Projects (each of these projects is self-contained in
This is the code - when I run it with or without both the files open, it always goes to "debug" when it tries to find the data file.
The data file may have 1 to 50 records and each data file is to be copied to a "summary  called HistoryFileData"

Sub Macro50()
' Macro50 Macro
Dim wbkMaster As Workbook
Dim shtMaster As Worksheet
Dim rngMaster As Range
Dim wbkData As Workbook
Dim shtData As Worksheet
Dim rngData As Range
Dim rstFilename As Workbook

     ' change path and file name to suit
    Set wbkMaster = Workbooks.Open("C:\Users\pcrockett\Documents\BSM\Development\Jared\ScaleWts\HistoryFileData.xlsm")
    Set shtMaster = wbkMaster.Worksheets(1)
    'Set rstFilename = "Capturexx.xlsm"

     ' change path and file name to suit
    Set wbkData = Workbooks.Open("C:\Users\prockett\Documents\BSM\Development\Jared\ScaleWts\RAWWeightFiles\Capturexx.xlsx")
    Set shtData = wbkData.Worksheets(1)
     ' get end of master
    Set rngMaster = shtMaster.Range("A65536").End(xlUp)
     ' get all data cells
    Set rngData = shtData.UsedRange
     ' copy data across
    rngData.Copy rngMaster
    MsgBox "Appended " & rngData.Rows.Count & " rows of data to Master data", vbInformation
     ' simply close data
    wbkData.Close False
     ' save and close master
    wbkMaster.Close True
     '  release objects
    Set rngData = Nothing
    Set shtData = Nothing
    Set wbkData = Nothing
I am a .net developer and I want to switch to Ruby on rails, I have following queries on this context:
How can I learn it in the most quickest possible way ?
What all OS, softwares and tool I need to use for development purpose?
What IDE I need to use for development
How to do code debugging
How to configure web app like I do in IIS on windows
So I've worked on several agile/scrum development teams. It looks like now I'm starting in a waterfall place that is going to look to move toward agile/scrum processes. I'd like to be as useful as I can at this company and was wondering if there's any good book or online resource about how to organize an agile software development team. I'm really looking for practical application, maybe some examples, scenarios.

Any thoughts?

DB Dev Tools

Development in most programming languages is done with an editor or integrated development environment (IDE). Dev Tools covers issues with the use of that software, rather than the actual programming being written. XCode, Visual Studio and Eclipse are some of the more popular development tools.

Top Experts In
DB Dev Tools