Toad Data Point 3.3 Read Only Install

Toad Data Point & Toad Intelligence Central
1

Is there a better source of information on what constitutes a “Read only” install for Toad Data Point - specifically what actions are allowed, and what aren’t?

I had an automation script fail over the weekend that connects to SQL Server 2008 R2 because one of the variable activities used a DECLARE statement to create and set a SQL-server session parameter - apparently DECLARE isn’t allowed when the install is Read-only (which doesn’t make much sense to me).

Also, is there an easier way to switch between “Read only” and “Full” without having to uninstall and reinstall?

2

I think we check only for DML statements (update/delete/insert) in read-only mode. Could you please send us the script so we could look at the issue?

Unfortunately you should re-install the product to turn off the “Read only”.

3

There isn’t much to show - this was the exact piece that it was rejecting:

DECLARE @F_DATE AS DATE = DATEADD(D, -8, CAST(GETDATE() AS DATE))

4

Is there somewhere in the Data Point installation file somewhere to show how it was packaged/installed?

5

Please ignore. There is something wrong with the forum. I got a notification that someone had added something to another thread I opened, so I clicked on it, which opened this one (I didn’t even realize), I read the question before this post and replied assuming it was in reference to my thread. And now, I cannot delete my post, so I am editing with an explanation.