.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

You'd need to replace "\\" with @"\" :

ConfigurationSettings.AppSettings["Location"] + @"\" + Format_Date + @"\" + custName + "(" + pId + ")" + @"\";

Not really worth doing.

Answer 2

You are saying to have the value as: C:\ntemp\ntestt1\ncustomer? This will cause my value to

be C:\temp\testt1\customer in the database?

Answer 3

How would a verbatim work for the following: ConfigurationSettings.AppSettings["Location"] + "\\" + Format_Date + "\\" + custName + "(" + pId + ")" + "\\";

Answer 4

No. I'm saying to pass this C# string:

    "C:\\temp\\testt1\\customer"

to the database i.e. with doubled backslashes.

You could also use a 'verbatim' string (preceded by @) with single backslashes:

    @"C:\temp\testt1\customer"

Both of these represent the same string in C#.

 

Answer 5

Just save the string inclusive of the doubled backslashes which are needed in C# to distinguish the use of the backslash in escape sequences (such as \n, \t etc).

It should then save in the database as a path with single backslashes