Global Data Management Forum

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert

Hi Robert,

I have created a C# 7 Web API with EF using Net.IBM.Data.Db2 and IBM.EntityFrameworkCore.  It appears to be connecting to the iSeries and then returns :

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [08004] [IBM] SQL30061N  The database alias or database name "filename    " was not found at the remote node.  SQLSTATE=08004

Connection string :

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert

Hi Robert,

I have created a C# 7 Web API with EF using Net.IBM.Data.Db2 and IBM.EntityFrameworkCore.  It appears to be connecting to the iSeries and then returns :

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [08004] [IBM] SQL30061N  The database alias or database name "filename    " was not found at the remote node.  SQLSTATE=08004

Connection string :

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert

Hey Richard,

I use the same assemblies as you are using, so that looks good.

The connection string in my app looks like this:
"Server=xxx.xxx.com:446;Pooling=true;Connection Lifetime=300;Connection Reset=false;CurrentSchema=SchemaName;Database=DbName;UserID=xxxxxx;password=xxxxxx;IsolationLevel=Chaos"

Contact your administrator for the proper databasename and schemaname.
The IsolationLevel I have to use it that way, but I'm looking for a better solution.

Regards,

Robert

Hi Robert,

I have created a C# 7 Web API with EF using Net.IBM.Data.Db2 and IBM.EntityFrameworkCore.  It appears to be connecting to the iSeries and then returns :

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [08004] [IBM] SQL30061N  The database alias or database name "filename    " was not found at the remote node.  SQLSTATE=08004

Connection string :

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert

I think I am using the correct values in the connection string because now I am getting the error about a license being required.

I understand there may be a trial license available, but not sure how to request one.

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968

Hey Richard,

I use the same assemblies as you are using, so that looks good.

The connection string in my app looks like this:
"Server=xxx.xxx.com:446;Pooling=true;Connection Lifetime=300;Connection Reset=false;CurrentSchema=SchemaName;Database=DbName;UserID=xxxxxx;password=xxxxxx;IsolationLevel=Chaos"

Contact your administrator for the proper databasename and schemaname.
The IsolationLevel I have to use it that way, but I'm looking for a better solution.

Regards,

Robert

Hi Robert,

I have created a C# 7 Web API with EF using Net.IBM.Data.Db2 and IBM.EntityFrameworkCore.  It appears to be connecting to the iSeries and then returns :

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [08004] [IBM] SQL30061N  The database alias or database name "filename    " was not found at the remote node.  SQLSTATE=08004

Connection string :

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert

Hi Richard,

You are using the correct connection string properties.

Now you have to get a proper license, see for example https://stackoverflow.com/questions/70446909/license-error-while-making-connection-ibm-db2-using-python-and-ibm-db-library.

Contact your DBA how to get one. 

I think I am using the correct values in the connection string because now I am getting the error about a license being required.

I understand there may be a trial license available, but not sure how to request one.

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [42968] [IBM] SQL1598N  An attempt to connect to the database server failed because of a licensing problem.  SQLSTATE=42968

Hey Richard,

I use the same assemblies as you are using, so that looks good.

The connection string in my app looks like this:
"Server=xxx.xxx.com:446;Pooling=true;Connection Lifetime=300;Connection Reset=false;CurrentSchema=SchemaName;Database=DbName;UserID=xxxxxx;password=xxxxxx;IsolationLevel=Chaos"

Contact your administrator for the proper databasename and schemaname.
The IsolationLevel I have to use it that way, but I'm looking for a better solution.

Regards,

Robert

Hi Robert,

I have created a C# 7 Web API with EF using Net.IBM.Data.Db2 and IBM.EntityFrameworkCore.  It appears to be connecting to the iSeries and then returns :

IBM.Data.Db2.DB2Exception (0x80004005): ERROR [08004] [IBM] SQL30061N  The database alias or database name "filename    " was not found at the remote node.  SQLSTATE=08004

Connection string :

Hi,

I have implemented IBM.EntityFrameworkCore in .Net 7.0 apllication.

Created a DbContext and implemented OnConfiguring:

I experience a delay of approximately 15 second when the connection opens the first time.

Is this a known problem? Or has it something to do with de settings of the server.

Best regards,

Robert