From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.
We appreciate your patience as we improve our online experience.
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?
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.
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?