Connection to SAP HANA Database

0
0

Hello,

 

I’m testing this program in detail, and 1 off the main requirements is to make connection towards SAP HANA DB

In my vb.net tool it’s working ok, but when I create the same connection in a Wisej web application I receive an error

 

>> An exception of type ‘System.TypeInitializationException’ occurred in Sap.Data.Hana.v4.5.dll but was not handled in user code

 

the application hangs/stops on the line “Dim MyConn As New Sap.Data.Hana.HanaConnection(SAPConnStr)” with the above error.

I think (I’m sure) it has something todo with 32bit/64bit as for sure the application has to run in 64bit for SAP HANA connection, I have test the tool in 64bit and it open with a lot of errors (see attachment). so please confirm Wisej is only working in 32bit mode. is their a solution to run Wisej also in 64bit?

 

Regards,

Bjorn

  • You must to post comments
0
0

Hello,

 

thanks for your reply, I’ve test your proposal and now it’s working perfectly +++

thank you very much you’ve made my day.

 

regards,

Bjorn

  • You must to post comments
0
0

Hi Bjorn,

Once you get error 0x8007000B and message Could not lod file or assembly ‘<assembly_name>’ or one of its dependencies. An attempt was made to load a program with an incorrect format. it’s a 32/64 bit issue for sure.

I could reproduce the issue on an ordinary Wisej project (in fact the MDIExample.VB I attached yesterday on another thread).

  1. Set Target CPU to x64.
  2. On Visual Studio, go to Tools => Options => Prtojects and Solutions => Web Projects
  3. To get the same issue, uncheck Use the 64 bit version of IIS Express for web sites and projects

So to solve the issue you should check the check box referred above.

HTH

  • You must to post comments
Showing 2 results
Your Answer

Please first to submit.