I repost my problem because nobody answered till now.

I'm using Visual Studio 2005 express editions including VB,
VC# and Web Developer. I downloaded the SQL Anywhere
Developer Edition 10 and installed it.
Actually I'm working on a WEB solution which will use
database and I would like to use the native .NET provider.
So I'm speaking about the Visual Studio WEB Developer at the
moment, but in other Visual Studio products I faced with the
same issue.
Based on the documentation I should see the SQL Anywhere
Explorer in the menu, but it is missing. Also I should
configure a data source for my application, but the SQL
Anywhere provider is missing from the available provider's
list.

Based on the documentation to solve the problem I have to
try to uninstall and reinstall the .NET provider using the
"install-dir\Assembly\v2\setupVSPackage.exe". When I'm
trying that I received the error message:

c:\Program Files\SQL Anywhere 10\Assembly\v2>setupvspackage
/u

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


Value cannot be null.
Parameter name: type

c:\Program Files\SQL Anywhere 10\Assembly\v2>

I checked the GAC and I found that all assemplies already
installed, so I not know why I can't use the SQL Anywhere
provider in the application.

If I created a connection entry in the config settings
manually the Visual Studio not recognized that. Without a
connection I can't create any SQL DataSource object and I
can't create any data related control.

I would like to ask somebody to help me, because I have to
start the process of development.

Thank you in advance!

Best regards,

Laszlo Mamrovits
Dendrite Hungary Ltd.
email: laszlo.mamrovits (AT) dendrite (DOT) hu

Your subject line hides the fact that you are using an Express edition
of that tool.

According to the MSoft and Wikipedia:

The idea of express editions, according to Microsoft,
is to provide a streamlined, easy-to-use and easy-to-learn
IDEs
* * * * for less serious users,
such as hobbyists and students. * * * *

and the limitations fo that may simply be getting in the
way ... for example with VB Express this one limitation
jumped out at me immediately:

- No IDE support for databases other than SQL Server Express and
Access

not to mention the EULA clause it is restricted to
'Personal and non-commercial use' only and the
list of 'you may not's is pretty comprehensive.

As such I am sure we do not even test with this.


<Laszlo Mamrovits> wrote

We've reproduced your problem here, and are looking into what the exact
problem is. At first glance, it looks to be specific to the Express
Edition(s) of Visual Studio, and there are no problem with the full version.
I'll post back when we have something more concrete to say.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swd/base.do
-> Choose SQL Anywhere Studio
-> Set filter to "Display ALL platforms IN ALL MONTHS"


<Laszlo Mamrovits> wrote

Dear Reg, Nick,

Thank you for your responses. At first I would like to put
here a FAQ entry from Microsoft Visual Studio Express
Editions webpage
(http://www.microsoft.com/express/2005/faq/Default.aspx)

4. Can I use Express Editions for commercial use?
Yes, there are no licensing restrictions for applications
built using the Express Editions.

Nick, you are right there is a IDE limitation about the
database provider, but I found a workaround solution. Till
now it is working correctly in my solution.
I started the process with the ODBC .NET provider and
created all SQLDataSource or DataSet using the connection
string with System.Data.Odbc provider:

<add name="ConnectionString" connectionString="DSN=SQL
Anywhere 10 Demo;UID=dba;pwd=sql"
providerName="System.Data.Odbc" />

Finally I changed the connection string to use
iAnywhere.Data.SQLAnywhere provider:

<add name="ConnectionString" connectionString="Dsn=SQL
Anywhere 10 Demo;uid=dba;pwd=sql"
providerName="iAnywhere.Data.SQLAnywhere" />

It is working till now. At the moment I'm testing the
complex queries and procedure calls.

Thank you for your answers.

Best regards,

Laszlo Mamrovits