.Net Entity Framework to DB2

Sarika k

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

'.'.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

matt cupryk15y ago
this can be because of the dateformat in windows. check it out. I've seen this before.
Sarika k15y ago
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.
Sarika k15y ago
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.
Suthish Nair15y ago
how you retreiving the table data, using stored procedure?
Sarika k15y ago
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.
Suthish Nair15y ago
Because your method name (RETURNDATETIMEPRECISION) is too long. The error 42622 explains that. Use a shorter name for the object.