LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

SQL tool kit

I am having trouble with SQL toolkit. I can consistently read integers and
floating point numbers from the database but I have been unable to read
text. I receive the following error

Fetch Next Record - [Microsoft][ODBC Driver Manager] Program type out of
range

I have tried two different field types, nvarchar and nchar.

The code I am using works consistently with Acess 2000
Does anyone have a suggestion?

best
Kris
0 Kudos
Message 1 of 3
(1,552 Views)
You did not mention what database you are talking to? If you are talking to SQL Server 7, then nvarchar will NOT work and only nchar will work.
Can you change the datatype to "text" and see if that works? Also try with character numbers of less than 255. I have worked with it and it works just fine unless you are using some other database.

Abdullah
0 Kudos
Message 2 of 3
(1,552 Views)
kris mukherjee wrote in message
news:96aqpf$mco$1@nntp9.atl.mindspring.net...
> I am having trouble with SQL toolkit. I can consistently read integers and
> floating point numbers from the database but I have been unable to read
> text. I receive the following error
>
> Fetch Next Record - [Microsoft][ODBC Driver Manager] Program type out of
> range
>
> I have tried two different field types, nvarchar and nchar.
>
> The code I am using works consistently with Acess 2000
> Does anyone have a suggestion?
>
> best
> Kris
>
>
What database are you using?
0 Kudos
Message 3 of 3
(1,552 Views)