Cannot find datatype bigint

[Dorte]

I have moved an asp.net application from windows 2000 to
windows xp. The application gets data from an sql server
2000. Some of the queries declare some variables with the
BIGINT datatype to hold the results of some calculations.
When I run the application I get the error "Cannot find
datatype bigint" - is it because I have moved the
application from win 2000 to win xp? What can I do to
solve the problem? The int datatype will not be
sufficient to hold the calculated values so this is not a
solution.

I would appreciate any answer that gives me an idea of
what to do.

Thanks,
Dorte

 

[Miha Markic]

Hi,

When do you get the exception?

 

[Guest]

Hi,

It happens when I call the Fill method on the DataAdapter
object. I have the queries in separate text files, and it
seems that Visual Studio does not recognize the BIGINT
(no colouring).

Dorte

 

[Miha Markic]

Hi,

How is your dataset configured?
How does your select look like?
How does your SQL table look like?