Has any one had any luck with reading from a Sybase SQL Anywhere Database?

[wilvil2000]

I am using LV 6.1, ADO, and I am trying to read or perform a query on a sybase database. I can connect to it but the variant returned is reads like so:

OLE Variant

Variant Type -> VT_ARRAY|VT_VARIANT
Value -> Array(Non Displayable)

I am using the example at this link;

http://exchange.ni.com/servlet/ProcessRequest?RHIVEID=101&RPAGEID=135&HOID=50650000000800000027370000&UCATEGORY_0=_49_%24_6_&UCATEGORY_S=0&USEARCHCONTEXT_QUESTION_0=ADO&USEARCHCONTEXT_QUESTION_S=0

Please Help if you can.

Wil

[Jeremy Braden]

Are you getting an error with any type of data? NI sells a Database connectivity toolkit. It might save you time and effort. Goto the following link for more info:
http://sine.ni.com/apps/we/nioc.vp?cid=6429〈=US

[wilvil2000]

I found that I have to use the "Get String Method" instead of the "Get Row Method". This is only for the Sybase Database I am quering. On a MS Access database the "Get Row Method" works fine. I don't know why but what ever works is fine with me.

I am now using the Get String Method and then parse the string using "spreadsheet string to array.vi [tab delimited]" to get the individual values. This seems to work fine.

Wil