.Net Entity Framework to DB2

Question

Hi,

I am trying to connect to the DB2 from entity frame work (.Net 3.5. using Db2 add-ins). But it throws the following error: Does any one know how to fix this.


---------------------------
Microsoft Visual Studio
---------------------------
An error occurred while connecting to the database. The database might be unavailable. An exception of type 'System.Data.EntityCommandExecutionException' occurred. The error message is: 'An error occurred while executing the command definition. See the inner exception for details.

The inner exception caught was of type 'IBM.Data.DB2.DB2Exception', with this error message: 'ERROR [42622] [IBM][DB2] SQL0107N  The name "RETURNDATETIMEPRECISION" is too long.  The maximum length is "18".  SQLSTATE=42622

'.'.

Answer 1

this can be because of the dateformat in windows. check it out. I've seen this before.

Answer 2

I found the problem, I am trying to connect to the older version of DB2 on Mainframe, which is not supported by entity frame work.

anyway thanks for your help Suthish.

Answer 3

I just checked the Tables check box  in the wizard to connect to the db, to get all the tables in that database. but it fails t retreive the table with that error.

Answer 4

how you retreiving the table data, using stored procedure?

Answer 5

I haven't created any methods yet, I am just trying to connect to the existing DB2 database, throught Entity frame work, on the wizard I enetered the connection string, connection was successful but it fails before retreiving the tables from DB2 with that error.

Answer 6

Because your method name (RETURNDATETIMEPRECISION) is too long. The error 42622 explains that. Use a shorter name for the object.