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!)

[jeff_albion]

Hi David,

CreateInstance failed for package [SQL Anywhere explorer]

Ahhh, that's somewhat more clear. Although, this is a component from SQL Anywhere 11 not 12 (as the SQL Anywhere Explorer was removed in 12.0.0). Did you also have SQL Anywhere 11 installed previously (or was it installed as a component as part of your fresh install)?

The SQL Anywhere Explorer was actually a component that was slowly deprecated throughout the course of 11.0.1. It was only briefly supported in Visual Studio 2010, and then 2010 support was dropped as of 11.0.1.2257 and higher (see: CR #576252). Visual Studio 2005 and 2008 support was also eventually dropped as of 11.0.1.2456 (see: CR #637453). The component was never considered for Visual Studio 2012 though, so I'm not 100% why you're seeing it even loaded here... particularly if this is a clean install. Are you loading previous Visual Studio settings when you're migrating...?

I believe you should just be able to disable/remove the SQL Anywhere Explorer extension by going to "Tools" → "Extensions and Updates...", click on the extension "SQL Anywhere Explorer" and click "Disable" or "Uninstall".