Toad World® Forums

HANA Connection error

Hi Experts,

I got an error to connect to HANA server.

What is the problem??

System.TypeInitializationException The type initializer for ‘Sap.Data.Hana.HanaConnection’ threw an exception. Stack Trace: at Sap.Data.Hana.HanaConnection…ctor(String connectionString) at Quest.Toad.SAPHana.SAPHanaConnection.CreateConnection() at Quest.Toad.Db.Connection.AllocConnection() at Quest.Toad.Db.Connection.Connect(Boolean notify) at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

System.IO.FileLoadException DLL version mismatch - cannot load libSQLDBCHDB.dll. Stack Trace: at Sap.Data.Hana.HanaUnmanagedDll.CheckDllVersion(Version verAssembly, FileVersionInfo verDll, String dllName) at Sap.Data.Hana.HanaUnmanagedDll.CheckDllVersion() at Sap.Data.Hana.HanaUnmanagedDll…ctor() at Sap.Data.Hana.HanaUnmanagedDll.get_Instance() at Sap.Data.Hana.HanaConnection…cctor()

Hi yacusa,

See: “cannot load libSQLDBCHDB.dll” - this can be fixed by installing the HANA client.

See HANA documentation for more information.

Best regards,

Hi Daniel,

Thank you for your reply.

But I already Installed HANA Client ver.82.

I checked the dlls(libSQLDBCHDB.dll" and so on) in my HANA Client program folder.

HANA DB is also ver.82.

Is there any other reason?

Hi yacusa,

we opened issue TSY-964 for this. Please, watch our release notes for solutions.

Thank you,

If you were using a current freeware or commercial version, HANA connectivity is not yet supported. HANA support has just been added with the v3.0 Beta version which can be downloaded here: www.toadworld.com/.../default.aspx

Thank you Steve,

This error occurred on Toad for SAP v3.0 Beta(Rev.349), let me try again with Rev.496 .

By the way, does anybody know when the Toad for SAP v3.0 Beta will be certified for SAP HANA?

Unfortunately, I got the same error message.

System.TypeInitializationException

The type initializer for ‘Sap.Data.Hana.HanaConnection’ threw an exception.

Stack Trace:

at Sap.Data.Hana.HanaConnection…ctor(String connectionString)

at Quest.Toad.SAPHana.SAPHanaConnection.CreateConnection()

at Quest.Toad.Db.Connection.AllocConnection()

at Quest.Toad.Db.Connection.Connect(Boolean notify)

at Quest.Toad.Db.Provider.BackgroundConnector.CreateBackgroundConnection()

System.IO.FileLoadException

DLL version mismatch - cannot load libSQLDBCHDB.dll.

Stack Trace:

at Sap.Data.Hana.HanaUnmanagedDll.CheckDllVersion(Version verAssembly, FileVersionInfo verDll, String dllName)

at Sap.Data.Hana.HanaUnmanagedDll.CheckDllVersion()

at Sap.Data.Hana.HanaUnmanagedDll…ctor()

at Sap.Data.Hana.HanaUnmanagedDll.get_Instance()

at Sap.Data.Hana.HanaConnection…cctor()

Hi yacusa,

you’re right it is still the same DLL mismatch.

Right now Toad for SAP Beta works with SAP HANA client ver. 80. It may work with other versions and will in the future but now I’m afraid only 80 is sure today.

If trying out a client ver. 80 is not an option for you, please, stay tuned for new Betas. The team has been working on this.

Thanks!