UPGRADE (v4.0)TRIAL (v4.0)
Toad Intelligence Central
FREE Toad Data Point Viewer
Toad Data Point v4.0 is now available. Learn what's new in this release
What's better than data sharing, SQL sharing and workflow sharing? Getting it for FREE.Find out how you could get a FREE perpetual TOAD INTELLIGENCE CENTRAL ... $5000 value. Offer valid only until September 30th.
Toad™ Data Point is a multi-platform database query tool that’s built for anyone who needs to access data from multiple sources, quickly integrate and prepare it all, and produce datasets and reports for analysis. It dramatically simplifies data access, writing SQL queries and data preparation – all from a single tool and without needing to be a SQL expert. With Toad, you can:
Use these links below to learn more about the most popular Toad Data Point topics!
We’re seeing many organizations move toward agile methodologies. But with the transition from manual change-and-release management to an automated approach of continuous integration comes new challenges ...
Are you struggling to manage an increasingly complex database environment? If so, you’re not alone. Research shows that data growth is doubling every 18 months. And it’s not...
I am using version 126.96.36.1994 and having issues with the pivot grid. When I run a query and right click in the results I can choose send to pivot grid but nothing happens. My result set is small. Also, when I try and open a tpg file created in a prior version nothing happens--I don't get an error message. It just doesn't open. Is there a known bug about this?
When I schedule this automation script, it errors out and I get this message in the log. "Rpt_99.log: Export_1 - Could not find a part of the path 'M:\East\05. Respite Cost Plans Per person'."
The path and file is not associated with this script anywhere.
Here is a copy of the log file.
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Setting up environment
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Script run by Toad Data Point 188.8.131.523 as DD01150 on DD0119WN21996
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Build started
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Compiling script
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Start CompileWorkflow
-- 7/25/2016 5:00:06 AM: Rpt_99.log: Before Compile
-- 7/25/2016 5:00:10 AM: Rpt_99.log: Return from CompileWorkflow
-- 7/25/2016 5:00:10 AM: Rpt_99.log: Workflow Compiled without Errors
-- 7/25/2016 5:00:10 AM: Rpt_99.log: Build completed
-- 7/25/2016 5:00:10 AM: Rpt_99.log: Create Workflow instance
-- 7/25/2016 5:00:11 AM: Rpt_99.log: Started workflow instance
-- 7/25/2016 5:00:11 AM: Rpt_99.log: Begin execution script activities
-- 7/25/2016 5:00:11 AM: Rpt_99.log: Variable "ROOT_PATH" set to ''
-- 7/25/2016 5:00:11 AM: Rpt_99.log: Running export template C:\TOAD Data\Template\99. Costplan Activity.txp
-- 7/25/2016 5:00:12 AM: Rpt_99.log: Executing export using connection in template is not XQuery Connection
-- 7/25/2016 5:00:14 AM: Rpt_99.log: Export_1 - Could not find a part of the path 'M:\East\05. Respite Cost Plans Per person'.
-- 7/25/2016 5:00:14 AM: Rpt_99.log: This file was not available at runtime. The location and user authentication may be different at runtime.
-- 7/25/2016 5:00:14 AM: Rpt_99.log: Start error email
I have other scripts that are failing with the same error message.
Any ideas about what is causing this?
I work in a large Microsoft SQL Server data warehouse that unfortunately uses the Money datatype in many places. For years I have been exporting data to excel and sending off to whoever. Recently though, since I upgraded to TDP 184.108.40.2064, when I quick export a dataset to an excel file, the money datatype columns are stored as text. BUT, if I do a quick export to an excel instance, the money columns are stored as numbers and it works fine. So this issue only occurs when exporting straight to a file.
If it makes any difference, we are on office 2007.