Visual studio integration

[Former Member]

Hi, I'm hoping some one has encountered this before. We are running Sybase 12 (installed in c:asa12) we have both 64 and 32 bit versions installed. When opening the server explorer tab in visual studio we get an error stating that the Sybase package failed to load, it then suggests checkingbthe activity log.XML file for VS which gives us the guid of the package and not much else.

Until now this has not been much of an issue as we just avoided usingbthat dialogue, however now we need to do some work with EF and could really do with getting in this working.

Please note when I say we, there are 4 of us with the same issue... So its not just something that I have screwed up!

Hoping that some one may have some ideas as to what could cause this, or some way that we can shed some more light on what the issue is?

Thanks in advance.

[jeff_albion]

When opening the server explorer tab in visual studio we get an error stating that the Sybase package failed to load

Can you be more specific about the error/exception message displayed when you get to this point? Did Visual Studio offer a stack trace of the problem with the loading of the assembly? If so, was the error message one of:

• System.TypeInitializationException: "The type initializer for 'iAnywhere.Data.SQLAnywhere.SAConnection' threw an exception."

• System.ArgumentException: "Unable to find the requested .NET framework data provider. It may not be installed."

• System.ArgumentException: "Failed to find or load the registered .Net Framework Data Provider"

• iAnywhere.Data.SQLAnywhere.SAException: Cannot find the language resource file (dblgen12.dll)

?

Have you tried re-running the SQL Anywhere .NET Installation Utility (i.e. %SQLANY12%\\\\Assembly\\\\V4\\SetupVSPackage.exe /install) to see if this resolves the issue?

[Former Member]

Hi, Thanks for the reply.

There is no stack trace literally the only feedback I get is the image here : http://1drv.ms/1eopLyD (Sorry not enough reputation points to upload direct to this forum)

Having a dig further into the actvitylog.xml the error in there is "CreateInstance failed for package [SQL Anywhere explorer]" - "80070057 - E_INVALIDARG"

I have tried rerunning the .net installation utility, Reinstalling sybase and most recently reinstalling windows, visual studio and sybase (The screen shot provided is from this fresh install of everything)

If you have any ideas what could be causing this Id be grateful, because I'm out of ideas now (the fresh install was my last hope!)

[Former Member]

Hi,

Neither my laptop or the virtual machine that I set up for this test have ever had v11 installed, the VM that was set up was literally done by pressing next on every step of the VS and Sybase installers without changing anything and no previous settings were imported into VS after the install, so what I am seeing seems to be the default behaviour out of the box.

Details of the MSI that I have installed here : http://1drv.ms/1esVlva and as you can see here it does not show in the tools - extensions & updates : http://1drv.ms/1cRRgWG

Anyway, if this is correct and it should not be available in 12 thats fine, do you know if it has been replaced with anything? We would like to use EF to provide the DAL for our application and would like to use some of the built in tools in VS which all share this dialogue so dont work!

If you have any insights into this it would be greatly appreciated!

Thanks David