iAnywhere.Data.SqlAnywhere.dll

[Steve]

We have a .NET program that access Sybase Anywhere 9 database using
iAnywhere.Data.SQLAnywhere that works fine in any Windows 32 bit
Operating System. When we try to use it in Windows 64 bit Operating
System, we get the following exception when it tries to open a
connection to the database using Connection.Open() command -

'The type initializer for 'iAnywhere.Data.AsaClient.AsaConnection'
threw an exception

Is there any problem with the iAnywhere.Data.SQLAnywhere.DLL when used
in Windows 64 bit Operating System? We did add to the GAC the
iAnywhere.Data.SQLAnywhere.DLL successfully, but that did not resolved
our exception error.

-Steve

[Jeff Albion [Sybase iAnywhere]]

Hi Steve,

Which processor architecture is your .NET application targeting? Ensure
that it's set to the x64 architecture when building for the x64 system.

Regards,

Steve wrote:
> Is there any problem with the iAnywhere.Data.SQLAnywhere.DLL when used
> in Windows 64 bit Operating System? We did add to the GAC the
> iAnywhere.Data.SQLAnywhere.DLL successfully, but that did not resolved
> our exception error.

--
Jeff Albion, Sybase iAnywhere

iAnywhere Developer Community :
http://www.sybase.com/developer/library/sql-anywhere-techcorner
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
SQL Anywhere Patches and EBFs :
http://downloads.sybase.com/swd/summary.do?baseprod=144&client=ianywhere&timeframe=0
Report a Bug/Open a Case : http://case-express.sybase.com/cx/

[Unknown]

According to http://www.sybase.com/detail?id=1026234#SA
there was no support for 64bit with ADO.NET.

There is for ODBC, OLE/DB, E/SQL, JDBC, and OpenClient
but ADO.Net did not provide this until V10

http://www.sybase.com/detail?id=1051965#SA

along with the 2.0 framework support

http://dcx.sybase.com/html/dbwnen10/wn-newjasper-s-3641153.html

and name changes and a few new features.

I suspect that is because x86_64 mode came late to 9.0.2
and the .Net stuff just didn't make it in.

"Steve" <watsu...@gmail.com> wrote in message
news:e897130f-bd29-4196...@w6g2000yqw.googlegroups.com...

[Chris Keating [Sybase iAnywhere]]

If your SQL Anywhere software is 32 bit, you will need to compile your
application to target x86. By default, .NET applications compile as 'Any
CPU' and run to match the bitness of the operating system. This works
only if there is no unmanaged code - which is not the case with the SQL
Anywhere .NET driver.

[Steve]

That's it. I recompiled my application with target set to only x86 and
that fixed my problem. Thanks.