Toad World® Forums

New version - first glance at


#1

I checked main issues that previously ‘disturbed me’

  1. Exporting to Excel Instance /Excel linked query: fails

13:15:18 Thread (22) Export Started [2011-04-18 13:15:18]
13:15:18 Thread (22) Export Wizard: Building object list
13:15:19 Thread (22) Exporting Data (1 of 1)
13:15:19 Thread (22) Object SQL Query started.
13:15:21 Thread (22) User cancelled
13:15:21 Thread (21) DoneReadTreadWriter
13:15:21 Thread (21) DoneReadThreadWriter finally - adapter null
13:15:21 Thread (22) Object SQL Query finished with error: Typ obiektu nie jest
zgodny z typem docelowym.


#2

Hello Marcin,

Thank you for your investigation, here is some answers for you:
image001.jpeg


#3

Hello Marcin,

Thank you for your investigation, here is some answers for you:
image005.jpeg


#4

Hello Marcin,

Thank you for your investigation, here is some answers for you:
image001.jpeg


#5

Hi Anastasia,
see answers below.

[…]

  1. Exporting to Excel Instance /Excel linked query: fails
    On our side Export Linked Query functional works ok. I saw, that TSS display
    error message “translation: Object type is not compatible with the type of
    target”. I think that you export specific data that could not be
    converted. Could you send us the object that you are trying to export,
    we’ll look at it.

I cannot export any data.
sample query: select top 10 * from sys.objects

  1. Support for XML : fails - result is treated as ‘normal recordset’
    Could you please describe this problem in detailed way?

I’ve already wrote about it
Toad result:

SQL Management Studio result:

  1. Export of XML results: fails

On our side Export functional works ok, please send us your xml.

topic was also already described -
try to export to xml [using tools / Export / Export Wizard ]
such query:

select top 10 *
from sys.objects for xml auto

  1. ‘asymmetric approach’ to verify sql vs run script [in both cases nothing is
    selected]
    First checks only statement that contains cursor, second - runs whole script
    Can you please be more specific here, I’m afraid I can’t fully
    understand this item.

when query contains few statements, and I press F5 [run] all statements are
executed.
But if I ‘verify sql’, to check all statement I have to select them. If not -
only ‘current will be checked’

  1. I cannot switch output to text mode [I know it is not an error]
    Right-click and uncheck Text Output option

this way you can change format of messages. I’ve been talking about results.


Butter
int_3.jpeg


#6

Hi Anastasia,
see answers below.

[…]

  1. Exporting to Excel Instance /Excel linked query: fails
    On our side Export Linked Query functional works ok. I saw, that TSS display
    error message “translation: Object type is not compatible with the type of
    target”. I think that you export specific data that could not be
    converted. Could you send us the object that you are trying to export,
    we’ll look at it.

I cannot export any data.
sample query: select top 10 * from sys.objects

  1. Support for XML : fails - result is treated as ‘normal recordset’
    Could you please describe this problem in detailed way?

I’ve already wrote about it
Toad result:

SQL Management Studio result:

  1. Export of XML results: fails

On our side Export functional works ok, please send us your xml.

topic was also already described -
try to export to xml [using tools / Export / Export Wizard ]
such query:

select top 10 *
from sys.objects for xml auto

  1. ‘asymmetric approach’ to verify sql vs run script [in both cases nothing is
    selected]
    First checks only statement that contains cursor, second - runs whole script
    Can you please be more specific here, I’m afraid I can’t fully
    understand this item.

when query contains few statements, and I press F5 [run] all statements are
executed.
But if I ‘verify sql’, to check all statement I have to select them. If not -
only ‘current will be checked’

  1. I cannot switch output to text mode [I know it is not an error]
    Right-click and uncheck Text Output option

this way you can change format of messages. I’ve been talking about results.


Butter
int_1.jpeg


#7

Hi Anastasia,
see answers below.

[…]

  1. Exporting to Excel Instance /Excel linked query: fails
    On our side Export Linked Query functional works ok. I saw, that TSS display
    error message “translation: Object type is not compatible with the type of
    target”. I think that you export specific data that could not be
    converted. Could you send us the object that you are trying to export,
    we’ll look at it.

I cannot export any data.
sample query: select top 10 * from sys.objects

  1. Support for XML : fails - result is treated as ‘normal recordset’
    Could you please describe this problem in detailed way?

I’ve already wrote about it
Toad result:

SQL Management Studio result:

  1. Export of XML results: fails

On our side Export functional works ok, please send us your xml.

topic was also already described -
try to export to xml [using tools / Export / Export Wizard ]
such query:

select top 10 *
from sys.objects for xml auto

  1. ‘asymmetric approach’ to verify sql vs run script [in both cases nothing is
    selected]
    First checks only statement that contains cursor, second - runs whole script
    Can you please be more specific here, I’m afraid I can’t fully
    understand this item.

when query contains few statements, and I press F5 [run] all statements are
executed.
But if I ‘verify sql’, to check all statement I have to select them. If not -
only ‘current will be checked’

  1. I cannot switch output to text mode [I know it is not an error]
    Right-click and uncheck Text Output option

this way you can change format of messages. I’ve been talking about results.


Butter
int_2.jpeg