Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

odbc error:[microsoft][odbc sql server driver] numeric value out of ra

Status
Not open for further replies.
Zaboo

Zaboo

Programmer
Oct 4, 2001
11
CA
How do I fix this error - I am using Crystal reports 8.5 that is trying to report from an 11 digit number to report from the database eg: 12345678901.

Help?

Zaboo
 
Sort by date Sort by votes
Check your data types, make sure the column can accept a number that large and vice versa. ----------------------------------------
Is George Lucas Kidding...
 
Upvote 0 Downvote
Thanks for the help - I found the error - there were changes made to the database that affected the reports - just reset the location - seem to be ok now.

Zaboo
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

V
  • Locked
  • Question
xp_cmdshell vs psexec - this SQL server forgets credential to an W10 share
Replies
0
Views
514
Volvere
V
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
392
bharons
bharons
gbaughma
  • Locked
  • Question
SQL Performance
Replies
11
Views
529
pjw001
pjw001
gussy81
  • Locked
  • Question
Decimal Datatype with negative value
Replies
5
Views
957
Chris Miller
Chris Miller
elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
320
Mike Lewis
Mike Lewis

Part and Inventory Search

Sponsor

Back
Top