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]

One other update, this is the details for the DLL in the Assemblies directory in the SQL Anywhere 12 folder: http://1drv.ms/1esZ3ou

So it all looks like its v12, further to that when I run the set up it explicitly states that its installed for VS 2010 & 2012:

Console Output:

C:Program Files (x86)SQL Anywhere 12Assemblyv4>SetupVSPackage.exe -i iAnywhere Solutions (R) SQL Anywhere Package for Visual Studio .NET Setup Utility Version 12.0.1.38402 Copyright (C) iAnywhere Solutions 2008. All rights reserved Installing SQL Anywhere Package for Visual Studio 2010...... Succeeded Installing SQL Anywhere Package for Visual Studio 2012...... Succeeded C:Program Files (x86)SQL Anywhere 12Assemblyv4>

---

Of course I have to now uninstall it again if I want to use VS Server explorer to connect to any other databases... 🙂

[Former Member]

albeit quite a late but one could try microsoft odbc instead in server explorer using user of system dataset. I know it worked for for me with vs2017, 2013