SqlAnywhere data provider without GAC

[Former Member]

Hi all, Here's my issue. I've been tasked to take a .Net 2.1 web site off of the server that also hosts the SqlAnywhere database and move it to a new web server that does not have the database.

My problem is that the new server does not have the SqlAnywhere client on it. I can copy the iAnywhere.Data.SQLAnywhere.dll assembly on to the new web server and instantiate the SAConnection object successfully, but cannot connect to the database. I don't get an error message, just an exception with a blank message.

I think this is because the DLL is not in the GAC (Global Assembly Cache) on the new server(?).

So, is it possible to use the SqlAnywhere client dll(s) from ASP.Net without putting them into the GAC, running an EXE or registering anything in the system registry? If so, what other assemblies do I need and how do I get them?

If not, is it possible to connect some other way to connect? Thanks for any help. --kevin

[MCMartin]

In ASP.Net you could add the assemblies to the bin dir of your website. But don't be afraid of the GAC, placing assemblies there is most of the time the better choice.