The given value of type string from the data source can not be converted to type real of the specified column

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Hi all,
I am getting error as "The given value of type string from the data source can not be converted to type real of the specified column" while migrating a all row data of table(MS-access) to another destination table( SQL table).
I am using WriteToServer(DataTable)function to do above job.
Earlier we never faced any issue,recently we added a new column in MS-access table named as "Value" also eqivalent column with the same name was added in SQL database also.

"Value" colum property in MS-access:
Name: Value
Type: long integer
Required: No
Indexed: No

"Value" colum property in SQL:

Name:Value
Type:int, not null
Identity: false
Length: 4

Any idea as to why i am getting this error???

Is it because of Required property in Access if No???
OR is it because of assigning not null constraint for newly added colum in SQL??

Or any other reason??

Please help.

Regards,
Joy

Posted 5-Sep-12 21:36pm

joyjhonson

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Santhosh Kumar Jayaraman · Answer 1 · 2012-09-05T21:41:00

Solution 1

Change the length of your column and make it as long as well. You are trying to save long into integer column of length 4.

Increase the length and change the column data type

Posted 5-Sep-12 21:41pm

Santhosh Kumar Jayaraman

Comments

joyjhonson 6-Sep-12 7:00am

Hey! santosh, thank you for responce, but why it is working for other colum whose type in access is long integer whereas int in SQL??? any other solution?

Santhosh Kumar Jayaraman 6-Sep-12 7:04am

here your column length is 4..It will work fine till you have value less than or equal to 4 digits. But for this column you have a value with more than 4 digits, thats why. Check and let me know whether you have any value greater than 9999 in your access db column

joyjhonson 7-Sep-12 8:36am

Hey! santosh,i checked,value for above newly added column is alwayes zero.
what else could be the reason?