SQL Anywhere + Visual Studio 2010 Beta 2

[Zote]

Hi,

I'm migrating some applications to VS2010 / .NET 4.
It's building fine, but at run time, I got an error that
DbProviderFactory isn't installed.

I need to reinstall SQL Anywhere or do you have another option?

Regards

[Zote]

I tried to edit machine.config and add all SQL Anywhere references
that are in machine.config of .net 2.0 version.

Didn't work.

Any idea?

Zote

[Jim Graham]

Use c:\Program Files\SQL Anywhere 11\Assembly\V2\SetupVSPackage.exe to
uninstall and reinstall the SQL Anywhere .NET assemblies. It often
works just as well and uninstalling and reinstalling. I confess I
haven't tried Visual Studio 2010 myself, so your issue may be beyond
this simple solution.

[Zote]

I did:

C:\Program Files\SQL Anywhere 11\Assembly\V2>SetupVSPackage.exe

iAnywhere Solutions (R) SQL Anywhere Package for Visual Studio .NET
Setup Utilit
y Version 11.0.1.23082
Copyright (C) iAnywhere Solutions 2008. All rights reserved

Options:

/help Display this usage message (Short form: /?)
/install Install (Short form: /i)
/language <lang> Language (Short form: /lang)
/silent Suppress display of all output (Short form: /s)
/uninstall Uninstall (Short form: /u)

Option key: '/' or '-'

Example: SetupVSPackage /i, SetupVSPackage /u

C:\Program Files\SQL Anywhere 11\Assembly\V2>SetupVSPackage.exe /u

iAnywhere Solutions (R) SQL Anywhere Package for Visual Studio .NET
Setup Utilit
y Version 11.0.1.23082
Copyright (C) iAnywhere Solutions 2008. All rights reserved


Creating an instance of the COM component with CLSID
{1A5AC6AE-7B95-478C-B422-0E
994FD727D6} from the IClassFactory failed due to the following error:
80010001.
Uninstalling SQL Anywhere Package for Visual Studio 2010
Succeeded


C:\Program Files\SQL Anywhere 11\Assembly\V2>SetupVSPackage.exe /i

iAnywhere Solutions (R) SQL Anywhere Package for Visual Studio .NET
Setup Utilit
y Version 11.0.1.23082
Copyright (C) iAnywhere Solutions 2008. All rights reserved


Creating an instance of the COM component with CLSID
{1A5AC6AE-7B95-478C-B422-0E
994FD727D6} from the IClassFactory failed due to the following error:
80010001.
Installing SQL Anywhere Package for Visual Studio 2010
Succeeded

Now, integration with VS2008 is broken:

"---------------------------
Microsoft Visual Studio
---------------------------
An unexpected error occurred in the .NET Framework Data Provider for
SQL Anywhere 11. Please contact the provider vendor to resolve this
problem.
---------------------------
OK
---------------------------
"

What can I do? To fix 2008 and try to get 2010 working?

Zote

[Jim Graham]

Argh. I should never suggest something I haven't tried myself. I
apologize for leading you astray.

> What can I do? To fix 2008 and try to get 2010 working?

The simplest way to get 2008 working again is to uninstall VS 2010 and
re-run SetupVSPackage. I hadn't realized you were running both on the
same machine. I tend to use VMware virtual machines when trying new
software, especially beta software.

I don't know how to make 2010 work. A colleague who is using VS 2010
said copying lines between machine.config files should have worked. I
won't know more until I try it myself sometime.