General error in the command StorageImport

[kc64]

I get the subject error while trying to import some data from a view in a MySQL database ODBC data source.  The view and structure looks fine in the External Data pane but when I drag it to the Data Portal, the popup shows this error.  Some views work while others do not.  Has anyone else seen this error?

[StefanR]

Well, this is a kind of internal error message - the sense is (or should be):

"Only some, but not all requested, data was loaded by StorageImport"

[kc64]

Also known as a "bug"?

[Brad_Turpin]

Hi kc64,

Have you tried querying the troublesome MySQL views with a VBScript that uses ADO objects, or even the old SQL_...() commands?  Do you really want to load the entire table or selected columns in their entirety-- that would be unusual for data stored in a data base...

It may be that a VBScript approach will give you the functionality you really want AND bypass this issue with the drag&drop loading.  I would be happy to help with the scripting.  There's also an "SQL Wizard" application I could send you or point you to that would handle everything except the ADO connection string, if you're really looking for an interactive approach to data base querying.

Brad Turpin

DIAdem Product Support Engineer

National Instruments

[Hotcold]

Hi Brad

PLease can you me the sql add-in. Iam also experiencing the same problem.

Look forward to hearing from you.

Regards

David

+44 07919 897 973

[Brad_Turpin]

Hi David,

Here is the version of the SQL Wizard that is posted externally.

http://zone.ni.com/devzone/cda/epd/p/id/4590

Brad Turpin

DIAdem Product Support Engineer

National Instruments